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

Joseph Shraibman <jks@selectacast.net> writes:
> My update looks like:
> UPDATE tablename SET intfield = 2 WHERE keyfield IN( ... )

> If I lowered the number of items in the IN() then I didn't get the error, but what that
> number is is a moving target.  205 used to work a few minutes ago, but now 200 doesn't
> work.  A vaccuum seems to help matters.  In previous versions of postgres I was able to do
> up to 10000.

Can we see the EXPLAIN plan for the failing update?

Also, I've forgotten exactly which PG version you're using?

            regards, tom lane