plan forcing in postgresql

From: Rajmohan C <csrajmohan(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: plan forcing in postgresql
Date: 2014-03-17 15:53:01
Message-ID: CAHaqV0iysUVCHROFQP=DdA6RJn8k5dEk7xuv=kUJS9WMzPsG1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am implementing Planner hints in Postgresql to force the optimizer to
select a particular plan for a query on request from sql input. I am having
trouble in modifying the planner code. I want to create a path node of hint
plan and make it the plan to be used by executor. How do I enforce this ?
Should I create a new Plan for this ..how to create a plan node which can
be then given directly to executor for a particular query?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Merlin Moncure 2014-03-17 17:52:52 Re: plan forcing in postgresql
Previous Message David Johnston 2014-03-17 15:36:44 Re: Multiple occurence