Re: Trying to track down weird query stalls
От
dan@sidhe.org
Тема
Re: Trying to track down weird query stalls
Дата
Msg-id
57654.199.172.169.17.1238442145.squirrel@localhost
Ответ на
Re: Trying to track down weird query stalls (Scott Marlowe)
Список
Дерево обсуждения
Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Robert Haas <robertmhaas@gmail.com>
Re: Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Robert Haas <robertmhaas@gmail.com>
Re: Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Scott Marlowe <scott.marlowe@gmail.com>
Re: Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Scott Marlowe <scott.marlowe@gmail.com>
Re: Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Robert Haas <robertmhaas@gmail.com>
Re: Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Alvaro Herrera <alvherre@commandprompt.com>
Re: Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Alvaro Herrera <alvherre@commandprompt.com>
Re: Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Alvaro Herrera <alvherre@commandprompt.com>
Re: Trying to track down weird query stalls dan@sidhe.org
Re: Trying to track down weird query stalls Alvaro Herrera <alvherre@commandprompt.com>
Re: Trying to track down weird query stalls Scott Carey <scott@richrelevance.com>
> 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 по дате отправления