Postgres Pro
Downloads
Home   >   mailing lists

Really slow even after vacuum - Mailing list pgsql-performance

From Jeroen Baekelandt
Subject Really slow even after vacuum
Date
Msg-id 1074677650.2060.26.camel@jbaekelandt.dev.kiala.com
Whole thread Raw
Responses Re: Really slow even after vacuum  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: database profiling
Next
From: Thierry Missimilly
Date:
Subject: Re: PostgreSQL vs. Oracle disk space usage