| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: OUTER JOIN performance regression remains in 8.3beta4 |
| Date: | 2008-01-07 01:20:10 |
| Message-ID: | 29913.1199668810@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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 | Content-Type | Size |
|---|---|---|
| const-propagation-8.3.patch.gz | application/octet-stream | 5.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-07 02:22:09 | Re: Index trouble with 8.3b4 |
| Previous Message | Tom Lane | 2008-01-06 19:44:47 | Re: BUG #3852: Could not create complex aggregate |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2008-01-07 15:01:50 | Re: OUTER JOIN performance regression remains in 8.3beta4 |
| Previous Message | Clodoaldo | 2008-01-06 11:48:44 | Re: 8.3-beta4, analyze and db owner |