Re: Vacuum explained

This is a rough description, should anyone see a need to correct it
please do so.

On Sat, 2003-01-04 at 09:42, Gaetano Mendola wrote:
> NOTICE:  Pages 2518: Changed 38, Empty 0; Tup 75489: Vac 447, Keep 68661,
> UnUsed 144574.
>         Total CPU 1.31s/0.25u sec elapsed 48.23 sec.

Pages = the # of pages being used to store your data.

Changed = the # of pages that have been modified as a result of your
most recent vacuum.

Empty = pages containing no "live" tuples

Tup = # of "rows" in your table

Vac = # of dead tuples recovered

Keep = # of tuples that the db did not feel it could safely mark/remove
(probably envolved in some type of transaction)

Unused = # of tuples awaiting being reused

elapsed time is the amount of time it took to deal with the given table

Robert Treat