On Fri, 15 Nov 2002, Shridhar Daithankar wrote:
> On 14 Nov 2002 at 21:36, Henrik Steffen wrote:
>
> > do you seriously think that I should vacuum frequently updated/inserted
> > tables every 120 seconds ?
>
> Its not about 120 seconds. Its about how many new and dead tuples your server
> is generating.
>
> Here is a quick summary
>
> insert: New tuple:vacuum analyse updates that statistics.
> update: Causes a dead tuple: Vacuum analyse marks dead tuple for reuse saving
> buffer space.
> delete: Causes a dead unusable tuple: Vacuum full is required to reclaim the
> space on the disk.
AFAIK, the delete line above is wrong. Deleted heap space should be able
to be reclaimed with normal vacuums within the limitations of the free
space map, etc...