Re: Queries intermittently slow - Mailing list pgsql-performance

From Jim Nasby
Subject Re: Queries intermittently slow
Date
Msg-id 568DE640.5070508@BlueTreble.com
Whole thread Raw
In response to Re: Queries intermittently slow  (Scott Rankin <srankin@motus.com>)
Responses Re: Queries intermittently slow  (Scott Rankin <srankin@motus.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Scott Rankin
Date:
Subject: Re: Queries intermittently slow
Next
From: Almir de Oliveira Duarte Junior
Date:
Subject: Slow query help