Need guidance on setting FSM parameters

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема Need guidance on setting FSM parameters
Дата
Msg-id alb5d8$h16$1@news.hub.org
обсуждение исходный текст
Ответы Re: Need guidance on setting FSM parameters  (Andrew Sullivan <andrew@libertyrms.info>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: VACUUM on multi-CPU systems?
Следующее
От: "Ray Madigan"
Дата:
Сообщение: Re: Multiple Postmasters