Re: Improving planning of outer joins - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Improving planning of outer joins
Date
Msg-id 1134762113.2964.53.camel@localhost.localdomain
Whole thread Raw
In response to Improving planning of outer joins  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 2005-12-14 at 21:27 -0500, Tom Lane wrote:
> I've spent some time looking into how we can improve our planning of outer
> joins.  

Sounds good.

> I'm not sure whether we'd need any additional planner knobs to control
> this.  I think that the existing join_collapse_limit GUC variable should
> continue to exist, but its effect on left/right joins will be the same as
> for inner joins.  If anyone wants to force join order for outer joins more
> than for inner joins, we'd need some other control setting, but I don't
> currently see why that would be very useful.

Agreed. No additional GUCs required.

> Does this seem like a reasonable agenda

Yup - tis good.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Web archive issue?
Next
From: Simon Riggs
Date:
Subject: Re: Improving planning of outer joins