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

From Joseph Shraibman
Subject Re: ERROR: out of free buffers: time to abort!
Date
Msg-id 3E7647C8.4000807@selectacast.net
Whole thread Raw
In response to Re: ERROR: out of free buffers: time to abort!  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ERROR: out of free buffers: time to abort!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Joseph Shraibman <jks@selectacast.net> writes:
>
>>I upped the shared_buffers from 128 to 256 and I'm still getting the error.
>
>
> Hmph.  I wonder if you've got a bug there.  What PG version is this?

select version();
                                                  version

---------------------------------------------------------------------------------------------------------
  PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat
Linux 8.0 3.2-7)
(1 row)


> Is it possible that the update is hitting rows that have been recently
> updated in concurrent transactions?

Unlikely.  I run this cron job every day, and every day I get the same error.  The whole
thing should be pretty quick.



pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: copying between Postgres databases
Next
From: Kurt Overberg
Date:
Subject: Tomcat/Struts/Pooling?/Memory Sizes