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.