I know that.
What I don't understand is why each time I decide to vacuum, I need more
than one vacuum to clean out lots of accumulated cruft.
Why do I need to issue two or three or even more vacuums before the tables
reach their fully cleaned sizes and states?
Regards,
Link.
At 06:34 PM 25-02-2002 +1100, Martijn van Oosterhout wrote:
>On Mon, Feb 25, 2002 at 03:28:20PM +0800, Lincoln Yeoh wrote:
> > Hi,
> >
> > I'm using v7.1.3 and somehow when some tables get very bloated (many
> > inserts over weeks) I seem to need to vacuum repeatedly before the table
> > really gets cleaned up and postmaster starts using less CPU.
>
>It is generally recommended to run VACUUM ANALYZE every day. The reason is
>that new rows are put on the end of the table and yet need VACUUM to clean
>out the cruft.