Re: plan forcing in postgresql - Mailing list pgsql-novice

From Merlin Moncure
Subject Re: plan forcing in postgresql
Date
Msg-id CAHyXU0zXCuSbpLtiVmZo-5VvVT_9+7MrRy=q4z+8jRjkvpXDyA@mail.gmail.com
Whole thread Raw
In response to plan forcing in postgresql  (Rajmohan C <csrajmohan@gmail.com>)
List pgsql-novice
On Mon, Mar 17, 2014 at 10:53 AM, Rajmohan C <csrajmohan@gmail.com> wrote:
> 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?

This thread is cross posted with -hackers.  (the main discussion is there).

merlin


pgsql-novice by date:

Previous
From: Rajmohan C
Date:
Subject: plan forcing in postgresql
Next
From: Thomas Drebert
Date:
Subject: Re: joining 2 Tables.