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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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