>>> On Wed, Mar 5, 2008 at  4:39 AM, in message <[EMAIL PROTECTED]>,
"Steinar H. Gunderson" <[EMAIL PROTECTED]> wrote: 
 
> it's pretty obvious that you
> haven't vacuumed in a very long time. Run VACUUM FULL on your tables
 
If you use VACUUM FULL, you should probably throw in ANALYZE with
it, and REINDEX, too.  An alternative that is probably faster, but
which requires that you have enough free space for a temporary
additional copy of the data, is to CLUSTER the bloated tables,
which automatically takes care of the indexes, but requires a
subsequent ANALYZE.
 
> regular (non-FULL) VACUUMs or enable autovacuum.
 
Absolutely!
 
-Kevin
 



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance

Reply via email to