Skip site navigation (1) Skip section navigation (2)

Re: Bind message

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Guy Rouillier <guyr(at)masergy(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bind message
Date: 2006-09-26 16:35:50
Message-ID: 1159288550.9657.1843.camel@archimedes (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2006-09-26 17:36:05
Subject: Re: Small problem with embedded comments in a statement
Previous:From: Guy RouillierDate: 2006-09-26 16:06:28
Subject: Re: Bind message

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group