Re: Vacuum info clarification - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: Vacuum info clarification
Date
Msg-id 41938C4C.7040400@fastcrypt.com
Whole thread Raw
In response to Vacuum info clarification  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: ltree PostgreSQL Module
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] plperl Safe restrictions