Re: Planner creating ineffective plans on LEFT OUTER joins - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Planner creating ineffective plans on LEFT OUTER joins
Date
Msg-id 17868.1214499458@sss.pgh.pa.us
Whole thread Raw
In response to Re: Planner creating ineffective plans on LEFT OUTER joins  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Planner creating ineffective plans on LEFT OUTER joins  (Simon Riggs <simon@2ndquadrant.com>)
Re: Planner creating ineffective plans on LEFT OUTER joins  (Florian Pflug <fgp.phlo.org@gmail.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Thu, 2008-06-26 at 12:36 -0400, Robert Haas wrote:
>> It's my understanding that the philosophy of the PGDG in the past has
>> been to avoid putting any kind of hints into the system, focusing
>> rather an improving the planning of queries.

> It's not a specific hint, its a general goal setting.

Right.  There are definitely places where we've made engineering
judgements to not attempt a particular type of optimization because it'd
be too expensive compared to the typical payoff.  Simon's idea has some
merit for providing a framework to deal with that type of situation.
However, just adding a GUC variable isn't going to make anything happen
--- we'd need some concrete plans about what we'd do with it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: get_relation_stats_hook()
Next
From: Tom Lane
Date:
Subject: Re: Latest on CITEXT 2.0