Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4
Дата
Msg-id 29913.1199668810@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> There was a serious performance regression in OUTER JOIN planning
> going from 8.2.4 to 8.2.5.  I know Tom came up with some patches to
> mitigate the issues in 8.2.5, but my testing shows that problems
> remain in 8.3beta4.

Please try the attached proposed patch.  It seems to fix my simplified
test case, but I'm not sure if there are any additional considerations
involved in your real queries.

This is against CVS HEAD but I think it will apply cleanly to beta4.

Haven't looked closely at how to fix 8.2, yet.

            regards, tom lane


Вложения

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [HACKERS] Archiver behavior at shutdown
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4