Hi, I must have missed something, because I get really slow performance from PG 7.3.4-RH. This is my situation: I have a table (jms_messages), which contains 500.000 records. select count(*) from jms_messages is understandable quite slow. Then I delete all of the records and add 1000 new ones. I run vacuumdb on this database and run select count(*) from jms_messages again. It takes 80 seconds!?! While before, with 1000 records, it took only a fraction of a second.
Thanks for any tips, Jeroen Baekelandt ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]