Re: VACUUM VERBOSE 8.1dev - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: VACUUM VERBOSE 8.1dev
Date
Msg-id 4327A10F.8020708@commandprompt.com
Whole thread Raw
In response to Re: VACUUM VERBOSE 8.1dev  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>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/



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: VACUUM VERBOSE 8.1dev
Next
From: Neil Conway
Date:
Subject: Re: 8.1 system info / admin functions