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

From Tom Lane
Subject Re: ERROR: out of free buffers: time to abort!
Date
Msg-id 11443.1047415961@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: out of free buffers: time to abort!  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: ERROR: out of free buffers: time to abort!  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Joseph Shraibman <jks@selectacast.net> writes:
>    //this update causes the error
>    update table2 set status = newstatus where id in (chunk[0], chunk[1]...);

Hmm.  Do you have a particularly large number of indexes on that table?
Are you running a whole bunch of these operations in parallel?

            regards, tom lane

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: General Performance questions
Next
From: Joseph Shraibman
Date:
Subject: Re: ERROR: out of free buffers: time to abort!