Re: Queries intermittently slow

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Scott Rankin <srankin(at)motus(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Queries intermittently slow
Date: 2016-01-07 04:14:56
Message-ID: 568DE640.5070508@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Almir de Oliveira Duarte Junior 2016-01-07 04:17:21 Slow query help
Previous Message Scott Rankin 2016-01-06 18:01:05 Re: Queries intermittently slow