Re: ERROR: out of free buffers: time to abort !

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема Re: ERROR: out of free buffers: time to abort !
Дата
Msg-id 3876E3EC.AFB8353@austin.rr.com
обсуждение исходный текст
Ответ на ERROR: out of free buffers: time to abort !  (Ed Loehr <eloehr@austin.rr.com>)
Ответы Re: [HACKERS] Re: ERROR: out of free buffers: time to abort !  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> I am seeing the following error during a DB rebuild.  It is
> occuring during the execution of a PL/pgSQL procedure which is
> called from a trigger procedure on an AFTER INSERT trigger...
>
>     ERROR:  out of free buffers: time to abort !
>
> The insert fails.  This is under pgsql 6.5.2, redhat 6.1, built
> from tgz, running under "postmaster -i -N 15 -o -F -S 4096"...
>
> Any ideas?

This problem disappears when I up the number of shared mem buffers
with the -B flag from default of 64 to 256.

Cheers,
Ed Loehr



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

Предыдущее
От: Ed Loehr
Дата:
Сообщение: ERROR: out of free buffers: time to abort !
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Another index "buglet"?