Need guidance on setting FSM parameters

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Need guidance on setting FSM parameters
Date: 2002-09-06 21:07:32
Message-ID: alb5d8$h16$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can anyone point me to a "recipe" for setting the max_fsm_* parameters?
Something at the level of

Run 'VACUUM VERBOSE your-biggest-table-here'
Look at the nice number
Calculate a value
Stick it in for max_fsm_*

I'm running with the default values, which I know aren't good, but I
don't want to just stick '100000' in (as many have recommended) without
knowing why that number is better than, say, '150000'.

--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Madigan 2002-09-06 22:25:07 Re: Multiple Postmasters
Previous Message Andrew Sullivan 2002-09-06 20:51:59 Re: VACUUM on multi-CPU systems?