Hi folks, this is my first post to this emailing list. We are using postgres-7.4 in a Server based application which requires frequent updates and inserts of the database. We have observed a substantial fall in the performance of database server over the time. It works fine for some initial days and then its performace falls... and goes on falling as the days passes by ( there is not much increase in the size of the database) I have heard that updates and deletes in any DB bring in some sort of fregmentation in the database, and we are using vaccum feature ot the postgres to defragment. We have also tweaked the performance parameters in postgresql.conf ... but its not helping. So i was wondering , how can be maintain the performace of postgres over the time ? Will taking the dump of database and then deleting all tables and then restoring it will help ?? I am just clueless, any help/pointers to some useful link would be appriciated. thanks in advance, -sunil ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
