Re: does VACUUM ANALYZE complete with this error?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: does VACUUM ANALYZE complete with this error?
Дата
Msg-id 19960.1179928866@sss.pgh.pa.us
обсуждение исходный текст
Ответ на does VACUUM ANALYZE complete with this error?  (Susan Russo <russo@morgan.harvard.edu>)
Список pgsql-performance
Susan Russo <russo@morgan.harvard.edu> writes:
> We're seeing these type of error messages:

> NOTICE:  number of page slots needed (237120) exceeds max_fsm_pages (120000)
> HINT:  Consider increasing the configuration parameter "max_fsm_pages" to a value over 237120.
> vacuumdb: vacuuming database "fb_2007_01_17"

> I've played 'catch up' wrt adjusting max_fsm_pages (seems to be a regular event),

What PG version is that?  I recall we fixed a problem recently that
caused the requested max_fsm_pages to increase some more when you'd
increased it to what the message said.

            regards, tom lane

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

Предыдущее
От: Susan Russo
Дата:
Сообщение: does VACUUM ANALYZE complete with this error?
Следующее
От: "Andy"
Дата:
Сообщение: LIKE search and performance