Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group