Re: hashjoin chosen over 1000x faster plan

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: hashjoin chosen over 1000x faster plan
Дата
Msg-id 1191997904.4233.125.camel@ebony.site
обсуждение исходный текст
Ответ на hashjoin chosen over 1000x faster plan  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: hashjoin chosen over 1000x faster plan  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
On Tue, 2007-10-09 at 15:09 -0500, Kevin Grittner wrote:

> I have a situation where a query is running much slower than I would
> expect.  The ANALYZE showed that it is hashing some information which
> is rarely needed.  When I set enable_hashjoin = off for the
> connection the query run in 1/1000 the time.

Can you confirm the two queries give identical outputs? It isn't clear
to me why the second sort is (never executed) in your second plan, which
I would only expect to see for an inner merge join.

Can you show the details for ControlRecord also.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Marcin Stępnicki"
Дата:
Сообщение: Re: Shared Buffer setting in postgresql.conf
Следующее
От: Tomáš Vondra
Дата:
Сообщение: Re: SQL Monitoring