Vacuum info clarification - Mailing list pgsql-hackers

From Bruce Momjian
Subject Vacuum info clarification
Date
Msg-id 200411110503.iAB53PP12891@candle.pha.pa.us
Whole thread Raw
Responses Re: Vacuum info clarification  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-hackers
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.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Increasing the length of pg_stat_activity.current_query...
Next
From: Bruno Wolff III
Date:
Subject: Re: MAX/MIN optimization via rewrite (plus query rewrites