Re: vacuum verbose relations reporting

On Tue, 26 Aug 2008, Carol Walter wrote:

> On Aug 26, 2008, at 3:09 PM, Jeff Frost wrote:
>
>> Looks like vacuum verbose doesn't report the number of relations necessary
>> on version 8.2.7.  It just reports the max_fsm_relations value instead:
>>
>> INFO:  free space map contains 113311 pages in 10000 relations
>> DETAIL:  A total of 252816 page slots are in use (including overhead).
>> 252816 page slots are required to track all free space.
>> Current limits are:  600000 page slots, 10000 relations, using 4587 kB.
>> NOTICE:  max_fsm_relations(10000) equals the number of relations checked
>> HINT:  You have at least 10000 relations.  Consider increasing the
>> configuration parameter "max_fsm_relations".
>> VACUUM
>>
>> postgres=# show server_version;
>> server_version
>> ----------------
>> 8.2.7
>>
>> Does it do this in more recent versions of 8.2 or 8.3?

> If I understand your question, you might need to turn up log_min_messages to
> debug1 otherwise you won't see the relations.  I had the system set to
> autovacuum and I couldn't see that it was doing it until I made this change.
>

Hi Carol,

No I actually mean that this part:
>> Current limits are:  600000 page slots, 10000 relations, using 4587 kB.
>> NOTICE:  max_fsm_relations(10000) equals the number of relations checked
>> HINT:  You have at least 10000 relations.  Consider increasing the

Just tells me that I'm equal or greater than max_fsm_relations.  But vacuum
verbose does tell me how many page_slots are in use even when it's greater
than max_fsm_pages, so you know what value to use in postgresql.conf for the
fsm settings.

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 916-647-6411    FAX: 916-405-4032