Lars Feistner <feistner(at)uni-heidelberg(dot)de> wrote:
> On 03/29/2011 09:28 PM, Kevin Grittner wrote:
>> Lars Feistner<feistner(at)uni-heidelberg(dot)de> wrote:
>>
>>> The log tells me that certain update statements take sometimes
>>> about 3-10 minutes. But we are talking about updates on tables
>>> with 1000 to 10000 rows and updates that are supposed to update
>>> 1 row.
>>
>> The top possibilities that come to my mind are:
> [all eliminated as possibilities]
If you haven't already done so, you should probably turn on
checkpoint logging to see if this corresponds to checkpoint
activity. If it does, you can try cranking up how aggressive your
background writer is, and perhaps limiting your shared_buffers to
something around the size of your RAID controller's BBU cache. (I
hope you have a RAID controller with BBU cache configured for
write-back, anyway.)
-Kevin