Re: ERROR: out of free buffers: time to abort ! - Mailing list pgsql-hackers

From Ed Loehr
Subject Re: ERROR: out of free buffers: time to abort !
Date
Msg-id 3876E3EC.AFB8353@austin.rr.com
Whole thread Raw
In response to ERROR: out of free buffers: time to abort !  (Ed Loehr <eloehr@austin.rr.com>)
Responses Re: [HACKERS] Re: ERROR: out of free buffers: time to abort !
List 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 by date:

Previous
From: Ed Loehr
Date:
Subject: ERROR: out of free buffers: time to abort !
Next
From: The Hermit Hacker
Date:
Subject: Another index "buglet"?