Re: Vacuum info clarification

While we are at it

An explanation of what

DETAIL:  0 dead row versions cannot be removed yet
There were 1 unused item pointers.

mean would be useful.


Dave

Bruce Momjian wrote:

>The last two lines of VACUUM VERBOSE are:
>
>  INFO:  free space map: 49 relations, 32 pages stored; 784 total pages needed
>  DETAIL:  Allocated FSM size: 1000 relations + 20000 pages = 182 kB shared memory.
>
>I think "total pages needed" should be "total pages used" or "total
>pages requested".
>
>I am confused about the difference between "stored" and "requested".  I
>read the comments in freespace.c but am still confused.
>
>  
>

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561