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

Tom Lane wrote:
> Joseph Shraibman <jks(at)selectacast(dot)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.