Re: Why am I getting this error in DB

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Why am I getting this error in DB
Дата
Msg-id FECAC439-E068-45F6-A79B-EC9D7CC91661@silentmedia.com
обсуждение исходный текст
Ответ на Why am I getting this error in DB  (AI Rumman <rummandba@gmail.com>)
Ответы Re: Why am I getting this error in DB  (AI Rumman <rummandba@gmail.com>)
Список pgsql-general
On Feb 16, 2010, at 9:17 PM, AI Rumman wrote:

> Why am I getting this error in DB?
>
> -  number of page slots needed (858976) exceeds max_fsm_pages (356656)


Because you have more pages that need to be cleaned during the vacuum than you have room for in your configured free
spacemap (max_fsm_pages). To fix, vacuum more frequently, increase your max_fsm_pages and restart postgres, or upgrade
to8.4, which automatically adjusts the FSM as needed under the covers. 

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

Предыдущее
От: AI Rumman
Дата:
Сообщение: Why am I getting this error in DB
Следующее
От: AI Rumman
Дата:
Сообщение: Re: Why am I getting this error in DB