Re: max_fsm_pages question

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: max_fsm_pages question
Дата
Msg-id 4B5D4746020000250002EB59@gw.wicourts.gov
обсуждение исходный текст
Ответ на max_fsm_pages question  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Ответы Re: max_fsm_pages question  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Список pgsql-admin
Michael Monnerie  wrote:

> why did postgres suddenly decide to remove the old cruft suddenly?

Have you read through this yet?:

http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-FSM

> Autovacuum is on, the nightly backups do an extra "vacuum analyze",
> and once a week a CLUSTER is done for the big tables.

You should probably make that a "vacuum analyze verbose" to get a
good idea of where you should set max_fsm_pages, and to look for
where you are accumumlating free space to track.

-Kevin



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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: how to speed ilike
Следующее
От: Michael Monnerie
Дата:
Сообщение: Re: max_fsm_pages question