On 1/6/16 12:01 PM, Scott Rankin wrote:
I guess we’re back to lock contention?

Is there by chance an anti-wraparound vacuum happening on that table?

Actually, for that matter... if autovacuum is hitting that table it's locking could be causing problems, and it won't release it's locks until the deadlock detector kicks in.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to