Re: VACUUM VERBOSE 8.1dev

>>INFO:  free space map: 1377 relations, 22478 pages stored; 44112 total 
>>pages needed
>>DETAIL:  Allocated FSM size: 100000 relations + 2000000 pages = 17702 kB 
>>shared memory.
>>    
>>
>
>AFAIR, in both 8.0 and 8.1 that info appears only at the end of a
>database-wide vacuum.  Your example is a single-table vacuum, which
>certainly doesn't show that info in 8.0 ...
>  
>
You are absolutely (as usual) correct. Thank you. I was just
writing a retraction as I read your post.

Sincerely,

Josuha D. Drake


>            regards, tom lane
>  
>


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/