Postgres Pro
Downloads
Home   >   mailing lists

lock contention, need profiling idea - Mailing list pgsql-general

From AI Rumman
Subject lock contention, need profiling idea
Date
Msg-id CAGoODpcEp6rBz0Bi4bMB1en1ZOo0D4h21OdammHB8-1cQWxxeg@mail.gmail.com
Whole thread Raw
Responses Re: lock contention, need profiling idea
Re: lock contention, need profiling idea
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Alexander Reichstadt
Date:
Subject: Cannot query views with WHERE clause on renamed columns
Next
From: David G Johnston
Date:
Subject: Re: Cannot query views with WHERE clause on renamed columns