>>> On Wed, Mar 5, 2008 at 4:39 AM, in message <20080305103945.GA3673@xxxxxx>, "Steinar H. Gunderson" <sgunderson@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance
