Search Postgresql Archives

lock contention, need profiling idea

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux