lock contention, need profiling idea

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: lock contention, need profiling idea
Date: 2014-06-30 22:36:48
Message-ID: CAGoODpcEp6rBz0Bi4bMB1en1ZOo0D4h21OdammHB8-1cQWxxeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I see lots of similar log message at a certain time in a day on Postgresql
9,.1:

LOG: process 18855 still waiting for ShareLock on transaction 2856146023
after 1001.209 ms
STATEMENT: UPDATE table1 SET time = $1 WHERE id = $2

The table1 size is 17 G.

What could be the reason for this lock contention?
autovacuum?

Please give some idea.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-06-30 22:59:24 Re: Cannot query views with WHERE clause on renamed columns
Previous Message Alexander Reichstadt 2014-06-30 21:41:30 Cannot query views with WHERE clause on renamed columns