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

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.