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

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: pghackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ERROR: out of free buffers: time to abort !
Date: 2000-01-08 07:14:52
Message-ID: 3876E3EC.AFB8353@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-01-08 07:17:38 Another index "buglet"?
Previous Message Ed Loehr 2000-01-08 07:04:38 ERROR: out of free buffers: time to abort !