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
Список
Дерево обсуждения
Re: [HACKERS] Re: 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>
> 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
Дата:
От: The Hermit Hacker
Дата:
Сообщение: Another index "buglet"?
FAQ