Re: plan forcing in postgresql

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Rajmohan C <csrajmohan(at)gmail(dot)com>
Cc: pgsql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: plan forcing in postgresql
Date: 2014-03-17 17:52:52
Message-ID: CAHyXU0zXCuSbpLtiVmZo-5VvVT_9+7MrRy=q4z+8jRjkvpXDyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Mar 17, 2014 at 10:53 AM, Rajmohan C <csrajmohan(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Drebert 2014-03-17 22:27:29 Re: joining 2 Tables.
Previous Message Rajmohan C 2014-03-17 15:53:01 plan forcing in postgresql