Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"
Дата
Msg-id 4489.1042045096@sss.pgh.pa.us
обсуждение исходный текст
Ответ на vaccumdb is giving "ERROR: out of free buffers: time to abort !"  (Raja Kumar Thatte <trajakumar@yahoo.com>)
Ответы Re: vaccumdb is giving "ERROR: out of free buffers: time to abort !"  (Raja Kumar Thatte <trajakumar@yahoo.com>)
Список pgsql-admin
Дерево обсуждения 
Raja Kumar Thatte <trajakumar@yahoo.com> writes:
> After 7 to 8 hours I am getting
> ERROR:  out of free buffers: time to abort !
> vacuumdb: vacuum  xyzdb failed

What do you have shared_buffers set to?

If it's still the default (64), that's way too small for a production
installation.  Try a few thousand instead.

            regards, tom lane

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

Предыдущее
От: David Gilbert
Дата:
Сообщение: repair table? database? how ? neccessary?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Increase max_connections