Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4 - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4
Date
Msg-id 29913.1199668810@sss.pgh.pa.us
Whole thread Raw
Responses 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>)
List pgsql-patches
Tree view 
"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
Attachment

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Archiver behavior at shutdown
Next
From: "Kevin Grittner"
Date:
Subject: Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4