Re: [PERFORM] does VACUUM ANALYZE complete with this error?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: [PERFORM] does VACUUM ANALYZE complete with this error?
Дата
в 10:01:07
Msg-id
ff03c62a2ef967d1980905fb1fbebc45
Список
Susan Russo  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 по дате отправления
От: Gregory Stark
Дата:
Сообщение: Re: Postgres Benchmark Results
От: Susan Russo
Дата:
FAQ