Re: Odd blocking (or massively latent) issue - even with EXPLAIN

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Jim Vanns <james(dot)vanns(at)framestore(dot)com>
Cc: Martin French <Martin(dot)French(at)romaxtech(dot)com>, pgsql-performance(at)postgresql(dot)org, pgsql-performance-owner(at)postgresql(dot)org
Subject: Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Date: 2012-07-24 00:30:22
Message-ID: 500DEC9E.90603@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 07/23/2012 10:46 PM, Jim Vanns wrote:
> Nothing obvious - and we log a fair amount. No tmp table creations,
> no locks held.
>
> To add to this EXPLAIN reports it took only 0.23ms to run (for example)
> whereas the wall clock time is more like 20-30 minutes (or up to n hours
> as I said where everything appears to click back into place at the same
> time).
How many concurrent connections do you have?

--
Craig Ringer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Martin French 2012-07-24 06:50:45 Re: Odd blocking (or massively latent) issue - even with EXPLAIN
Previous Message Kenneth Tilton 2012-07-23 22:12:54 Re: Efficiency of EXISTS?