Re: generalizing the planner knobs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: generalizing the planner knobs
Date
Msg-id 11805.1133455782@sss.pgh.pa.us
Whole thread Raw
In response to generalizing the planner knobs  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Neil Conway <neilc@samurai.com> writes:
> ... ISTM that a simple improvement to what we have now
> would allow for a wider range of planner hints with only minor changes:
> we could replace the enable_XXX variables with a set of variables that
> would add an arbitrary constant to the estimated cost of each type of
> query node. (Alternatively, an arbitrary multiplier could be specified;
> I'm not sure which would be better.)

I think the multiplier would be better, because it'd avoid the problem
you mention later that useful values would be dependent on the planner's
cost units.  Also, one could sanely allow a multiplier less than one,
so as to favor instead of penalize a particular plan type.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: generalizing the planner knobs
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [pgsql-www] Upcoming PG re-releases