Re: postgresql performance

>>> On Wed, Mar 5, 2008 at  4:39 AM, in message <20080305103945.GA3673@uio.no>,
"Steinar H. Gunderson" <sgunderson@bigfoot.com> 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