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
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 |