Re: Warning about max_fsm_pages: what's that?

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: Warning about max_fsm_pages: what's that?
Дата
Msg-id 20071109125350.GD4326@merkur.hilbert.loc
обсуждение исходный текст
Ответ на Warning about max_fsm_pages: what's that?  (Reg Me Please <regmeplease@gmail.com>)
Список pgsql-general
On Fri, Nov 09, 2007 at 11:26:21AM +0100, Reg Me Please wrote:

> WARNING:  relation "public.t_dati" contains more than "max_fsm_pages" pages
> with useful free space
> HINT:  Consider compacting this relation or increasing the configuration
> parameter "max_fsm_pages".
>
> Would it be possible to get some reference or suggestion in order to
> understand better the provided hint?

It's right there in the fine manual:

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

Google has it, too:

http://www.google.de/search?hl=de&ie=ISO-8859-1&q=postgresql+max_fsm_pages&btnG=Google-Suche&meta=
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

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

Предыдущее
От: "Márcio Geovani Jasinski"
Дата:
Сообщение: Re: INSERT performance deteriorates quickly during a large import
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Warning about max_fsm_pages: what's that?