Thread: Vacuum info clarification
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
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