Need guidance on setting FSM parameters
Need guidance on setting FSM parameters
От:
Jeff Boes <jboes@nexcerpt.com>
Дата:
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
Re: Need guidance on setting FSM parameters
От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
On Fri, Sep 06, 2002 at 05:07:32PM -0400, Jeff Boes wrote:
> Can anyone point me to a "recipe" for setting the max_fsm_* parameters?
It doesn't seem so. I think the problem is that the FSM was new in
7.2, and so people don't have enough experience with it yet. The
advice you usually see is "experiment; and if you do, please post
some results".
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
M2P 2A8
+1 416 646 3304 x110