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.