Re: Queries intermittently slow

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