Re: Abnormal storage consumption with autovacuum enabled

Поиск
Список
Период
Сортировка
От Nicola Mauri
Тема Re: Abnormal storage consumption with autovacuum enabled
Дата
Msg-id 46569EF1.1080106@saga.it
обсуждение исходный текст
Ответ на Abnormal storage consumption with autovacuum enabled  (Nicola Mauri <nicola.mauri@saga.it>)
Ответы Re: Abnormal storage consumption with autovacuum enabled
Список pgsql-admin
> What do you have max_fsm_pages set to?

Currently, max_fsm_pages=20000

Running VACUUM VERBOSE reports:
  NOTICE:  number of page slots needed (237312) exceeds max_fsm_pages (20000)
  HINT:  Consider increasing the configuration parameter "max_fsm_pages" to a value over 237312.

Is this measurement reliable?
We are considering to set:   max_fsm_pages=400000
Could this have some sort of impact?

thanks




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

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Loader
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Abnormal storage consumption with autovacuum enabled