Re: Planner hints in Postgresql

<div dir="ltr"><br /><div class="gmail_extra"><br /><br /><div class="gmail_quote">On Mon, Mar 17, 2014 at 9:22 PM,
RajmohanC <span dir="ltr"><<a href="mailto:csrajmohan@gmail.com" target="_blank">csrajmohan@gmail.com</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div
dir="ltr">Iam implementing Planner hints in Postgresql to force the optimizer to select a particular plan for a query
onrequest from sql input. I am having trouble in modifying the planner code. I want to create a path node of hint plan
andmake it the plan to be used by executor. How do I enforce this ? Should I create a new Plan for this ..how to create
aplan node which can be then given directly to executor for a particular query?</div></blockquote></div><br /><br
clear="all"/><br /></div><div class="gmail_extra">Planner hints have been discussed a lot before as well and AFAIK
thereis a wiki page that says why we shouldnt implement them. Have you referred to them?<br /><br /></div><div
class="gmail_extra">Pleaseshare if you have any new points on the same.<br /><br /></div><div
class="gmail_extra">Regards,<br/><br />Atri<br /></div></div>