I am using postgesql 8.1.9 version on Linux and 64 bit platform. My database size is around 25 GB. Lot of updates, inserted and views transactions are happening through my application. After few days database query execution taking lot of times. Its affect my application.
If I take a DB dump and drop the db and restore it back then for a few days database speed has increases but then after some days database query execution speed is going down.