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
How many concurrent connections do you have?
In response to
pgsql-performance by date
|Next:||From: Martin French||Date: 2012-07-24 06:50:45|
|Subject: Re: Odd blocking (or massively latent) issue - even with EXPLAIN|
|Previous:||From: Kenneth Tilton||Date: 2012-07-23 22:12:54|
|Subject: Re: Efficiency of EXISTS?|