Locking or Something Else?

From: Ian Harding <harding(dot)ian(at)gmail(dot)com>
To: General PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Locking or Something Else?
Date: 2012-05-20 07:26:26
Message-ID: CAMR4UwEWYKAmvC7923T4O72jmhcd_h+fKJ7DBYPsrBnoJZ8bUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a situation where an increase in volume of inserts into the
main transaction table causes a huge slowdown. The table has lots of
indexes and foreign keys and a trigger.

Clearly, something is causing a resource contention issue, but here's
my main question:

I have log_lock_waits = on and deadlock_timeout = 250ms. Is there
any way I could have delays of tens of seconds caused by a write
conflict in a table accessed by a trigger that would not result in the
wait being logged?

Thanks!

Ian
PostgreSQL 9.0.6 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Kupershmidt 2012-05-20 08:35:22 Re: Why are pg_restore taking that long ?
Previous Message Gabriele Bartolini 2012-05-20 07:13:44 Re: suggestion for backup