Re: Trying to track down weird query stalls - Mailing list pgsql-performance

From dan@sidhe.org
Subject Re: Trying to track down weird query stalls
Date
Msg-id 57654.199.172.169.17.1238442145.squirrel@localhost
Whole thread Raw
In response to Trying to track down weird query stalls  (dan@sidhe.org)
Responses Re: Trying to track down weird query stalls  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance
> On Mon, Mar 30, 2009 at 12:42 PM,  <dan@sidhe.org> wrote:
>> Arguably in this case the actual query should run faster than the
>> EXPLAIN
>> ANALYZE version, since the cache is hot. (Though that'd only likely
>> shave
>> a few dozen ms off the runtime)
>
> Joining a lot of tables together?  Could be GEQO kicking in.

Only if I get different query plans for the query depending on whether
it's being EXPLAIN ANALYZEd or not. That seems unlikely...

-Dan

pgsql-performance by date:

Previous
From: dan@sidhe.org
Date:
Subject: Re: Trying to track down weird query stalls
Next
From: Scott Marlowe
Date:
Subject: Re: Trying to track down weird query stalls