Re: Trying to track down weird query stalls

From: dan(at)sidhe(dot)org
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Robert Haas" <robertmhaas(at)gmail(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Trying to track down weird query stalls
Date: 2009-03-30 19:42:25
Message-ID: 57654.199.172.169.17.1238442145.squirrel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> On Mon, Mar 30, 2009 at 12:42 PM, <dan(at)sidhe(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-03-30 19:47:17 Re: Trying to track down weird query stalls
Previous Message Scott Marlowe 2009-03-30 19:38:03 Re: Trying to track down weird query stalls