Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM ANALYZE--how often? - Mailing list pgsql-admin

From Tom Lane
Subject Re: VACUUM ANALYZE--how often?
Date
Msg-id 7559.1011159772@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM ANALYZE--how often?  (jboes@nexcerpt.com (Jeff Boes))
Responses Re: VACUUM ANALYZE--how often?
List pgsql-admin
Tree view 
jboes@nexcerpt.com (Jeff Boes) writes:
> Our database has about 70 tables.  Only a half-dozen or so have more
> than 100K rows, and all of these change (99% inserts, 10K-50K rows)
> during an average day.

> VACUUM ANALYZE takes over an hour, and it's edging up by a couple
> minutes per day.

Care to try 7.2?

            regards, tom lane

pgsql-admin by date:

Previous
From: jboes@nexcerpt.com (Jeff Boes)
Date:
Subject: VACUUM ANALYZE--how often?
Next
From: juerg.rietmann@pup.ch
Date:
Subject: postgreSQL Version 7.2 for SuSE Linux