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

Tom Lane wrote:
> Joseph Shraibman <jks@selectacast.net> writes:
>
>>To get rid of this message, do I increase shared_buffers?
>>ERROR:  out of free buffers: time to abort!
>
>
> [blinks]  Yeah, you do ... but I'd be interested to see how you caused
> that to happen.  Even at the rock-bottom setting for shared_buffers,
> I think you must have been doing something out of the ordinary ...
>
>             regards, tom lane

Here is what I'm doing:

begin;
intarray = select intfield from table1; (11480 entries right now)

for(i = 0; i < intarray.length; i++){
  select some data for that int value
  if (come condition){
    add int to list;
  }
}

chunks = split list into chunks; (to avoid an in() with too many things in it, max of 2000
per chunk)
for each chunk{
   //this update causes the error
   update table2 set status = newstatus where id in (chunk[0], chunk[1]...);
}
delete from table1;
end;