| 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: | Whole Thread | Raw Message | 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
| 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 |