Re: Planner hints in Postgresql
От | Atri Sharma |
---|---|
Тема | Re: Planner hints in Postgresql |
Дата | |
Msg-id | CAOeZVieK0JT4tDZr8wTxEZHwD0byvTTP4J7n+CJ-6R-MU+m4wg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Planner hints in Postgresql (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Planner hints in Postgresql
Re: Planner hints in Postgresql Re: Planner hints in Postgresql |
Список | pgsql-hackers |
On Mon, Mar 17, 2014 at 9:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
-- David Johnston <polobo@yahoo.com> writes:Possibly worth noting is that in past discussions, we've concluded that
> Need to discuss the general "why" before any meaningful help on the "how" is
> going to be considered by hackers.
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.
Isnt using a user given value for selectivity a pretty risky situation as it can horribly screw up the plan selection?
Why not allow the user to specify an alternate plan and have the planner assign a higher preference to it during plan evaluation? This shall allow us to still have a fair evaluation of all possible plans as we do right now and yet have a higher preference for the user given plan during evaluation?
Regards,
Regards,
Atri
Regards,
Atri
l'apprenant
В списке pgsql-hackers по дате отправления: