Postgres Professional
   

Re: Trying to track down weird query stalls

From: dan@sidhe.org
Subject: Re: Trying to track down weird query stalls
Date: ,
Msg-id: 57654.199.172.169.17.1238442145.squirrel@localhost
(view: Whole thread, Raw)
In response to: Trying to track down weird query stalls  ()
Responses: Re: Trying to track down weird query stalls  (Scott Marlowe)
List: pgsql-performance

Tree view

Trying to track down weird query stalls  (, )
 Re: Trying to track down weird query stalls  (Robert Haas, )
  Re: Trying to track down weird query stalls  (, )
   Re: Trying to track down weird query stalls  (Robert Haas, )
    Re: Trying to track down weird query stalls  (, )
   Re: Trying to track down weird query stalls  (Scott Marlowe, )
 Re: Trying to track down weird query stalls  (, )
  Re: Trying to track down weird query stalls  (Scott Marlowe, )
   Re: Trying to track down weird query stalls  (, )
    Re: Trying to track down weird query stalls  (Robert Haas, )
     Re: Trying to track down weird query stalls  (, )
      Re: Trying to track down weird query stalls  (Alvaro Herrera, )
       Re: Trying to track down weird query stalls  (, )
        Re: Trying to track down weird query stalls  (Alvaro Herrera, )
         Re: Trying to track down weird query stalls  (, )
          Re: Trying to track down weird query stalls  (Alvaro Herrera, )
           Re: Trying to track down weird query stalls  (, )
            Re: Trying to track down weird query stalls  (Alvaro Herrera, )
            Re: Trying to track down weird query stalls  (Scott Carey, ) 
> On Mon, Mar 30, 2009 at 12:42 PM,  <> 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: Scott Carey
Date:
Subject: Re: Trying to track down weird query stalls
Next:
From: Matthew Wakeling
Date:
Subject: Re: Very specialised query