Re: Planner hints in Postgresql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Planner hints in Postgresql
Date
Msg-id 18192.1395072907@sss.pgh.pa.us
Whole thread Raw
In response to Re: Planner hints in Postgresql  (David Johnston <polobo@yahoo.com>)
Responses Re: Planner hints in Postgresql  (Atri Sharma <atri.jiit@gmail.com>)
Re: Planner hints in Postgresql  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
David Johnston <polobo@yahoo.com> writes:
> Need to discuss the general "why" before any meaningful help on the "how" is
> going to be considered by hackers.

Possibly worth noting is that in past discussions, we've concluded that
the most sensible type of hint would not be "use this plan" at all, but
"here's what to assume about the selectivity of this WHERE clause".
That seems considerably less likely to break than any attempt to directly
specify plan details.
        regards, tom lane



pgsql-hackers by date:

Previous
From: David Johnston
Date:
Subject: Re: Planner hints in Postgresql
Next
From: Alvaro Herrera
Date:
Subject: warning when compiling utils/tqual.h