Re: Bind message - Mailing list pgsql-jdbc

From Mark Lewis
Subject Re: Bind message
Date
Msg-id 1159288550.9657.1843.camel@archimedes
Whole thread Raw
In response to Re: Bind message  ("Guy Rouillier" <guyr@masergy.com>)
List pgsql-jdbc
On Tue, 2006-09-26 at 11:06 -0500, Guy Rouillier wrote:
> Oliver Jowett wrote:
> > Isn't this just a very roundabout way of overriding the planner? i.e.
> > what you are really doing is saying "ignore your statistics, I know
> > more about the parameter values I'm going to give you than I'm
> > actually telling you"..
>
> Is there a non-roundabout way of overriding the planner?  Oracle has
> hints.  Sometimes the query analyzer benefits from a helping hand.

The PG core doesn't support hints.  I believe the general feeling among
the PG developers is that their time is better spent making the planner
smarter than in supporting a hints system which would introduce its own
maintenance headaches.

-- Mark

pgsql-jdbc by date:

Previous
From: "Guy Rouillier"
Date:
Subject: Re: Bind message
Next
From: Kris Jurka
Date:
Subject: Re: Small problem with embedded comments in a statement