Re: Vacuum verbose output?

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