Re: Vacuum verbose output? - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum verbose output?
Date
Msg-id 16295.1042560630@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum verbose output?  (Julian Scarfe <julian.scarfe@ntlworld.com>)
Responses Re: Vacuum verbose output?
List pgsql-general
Julian Scarfe <julian.scarfe@ntlworld.com> writes:
> On 14/1/03 15:42, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>> What do you have the FSM parameters in postgresql.conf set to?  My guess
>> is you need to increase 'em.

> Currently set at the defaults, max_fsm_relations is 100, max_fsm_pages is
> 10000.

100 is definitely too small for max_fsm_relations; we've bumped that
default to 1000 for the next release.  Given that you've got a
nearly-100k-page table, 10000 for max_fsm_pages is probably much too
small also.

> What are the implications/effects of increasing them?

Shared memory usage gets bigger.  I think the max_fsm_pages multiplier
is 6 bytes per slot, so you could make it a million, or ten, without
stressing modern machines.  I'd try 1000/1000000 for starters.

Don't forget you need a postmaster restart to make these changes take
effect.

            regards, tom lane

pgsql-general by date:

Previous
From: Julian Scarfe
Date:
Subject: Re: Vacuum verbose output?
Next
From: Tom Lane
Date:
Subject: Re: Vacuum verbose output?