Lars Feistner <feistner@xxxxxxxxxxxxxxxxx> wrote: > On 03/29/2011 09:28 PM, Kevin Grittner wrote: >> Lars Feistner<feistner@xxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
