>>> On Mon, Jan 7, 2008 at 9:01 AM, in message <[EMAIL PROTECTED]>, "Kevin Grittner" <[EMAIL PROTECTED]> wrote: >>>> On Sun, Jan 6, 2008 at 7:20 PM, in message <[EMAIL PROTECTED]>, > Tom Lane <[EMAIL PROTECTED]> wrote: >> "Kevin Grittner" <[EMAIL PROTECTED]> 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. > > Applied and built cleanly. Check found no errors. Startup clean. > > Query returns expected rows. Plan looks good. Thanks! I see this didn't make it into 8.3RC1. Will it be in the 8.3.0 release? For us, 8.3RC1 performance looks great with the patch, horrible without. -Kevin
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
