Re: Blocking excessively in FOR UPDATE

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Blocking excessively in FOR UPDATE
Date: 2011-11-03 17:55:52
Message-ID: CAGTBQpb9E-OGuGQ9vKaSCOhYPuJHfx1+UAgOT2pVWRa2scPUBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Nov 3, 2011 at 2:51 PM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
> What other information should I provide?

Forgot all the usual details:

Server is postgresql 9.0.3, running in linux, quite loaded (load
average ~7), WAL on raid 1 2 spindles, data on raid 10 4 spindles, 16G
RAM.

Could it be high contention between the worker processes? (because of
the high load)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2011-11-03 18:32:48 Re: Optimization required for multiple insertions in PostgreSQL
Previous Message Claudio Freire 2011-11-03 17:51:24 Blocking excessively in FOR UPDATE