Re: Interpreting vacuum verbosity - Mailing list pgsql-general

At some point in time, tgl@sss.pgh.pa.us (Tom Lane) wrote:

>
>> max_fsm_relations = 1000 and max_fsm_pages = 10000.
>
>Also you doubtless need max_fsm_pages a lot higher than that.  A
>conservative setting would make it as big as your whole database,
>eg for a 10Gb disk footprint use 10Gb/8K (something upwards of
>a million) FSM page slots.

At some point, someone was going to write a "white paper" detailing how one
might go about setting these parameters. If that someone has done so, I'd love
to hear about it. If that someone hasn't ... well, how much beer would we have
to provide to get you to talk?  8-)

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