On Mon, 2008-04-28 at 19:35 +0530, Gauri Kanekar wrote: > Peter, > > We are doing vacuum full every alternate day. We also do vacuum > analyze very often. > We are currently using 8.1.3 version. > Auto vacuum is already on. But the table1 is so busy that auto vacuum > don't get sufficient chance to vacuum it :(.
You should seriously consider upgrading to PG 8.3. There have been substantial improvements to VACUUM since 8.1 Brad. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance