Re: Bind message

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bind message
Date: 2006-09-26 10:21:10
Message-ID: 4518FF16.3050804@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Markus Schaber wrote:

> Ah. But usually, the other parameter values for the same prepared
> statement produce similar query plans, because they're the same use case
> on similar data.

For the "wrong" values though the plan might be pathologically bad.

> Maybe this behaviour should be configurable via some session
> configuration variable?

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

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Marc Herbert 2006-09-26 10:53:34 Re: Bind message
Previous Message Luis Vilar Flores 2006-09-26 10:09:10 Re: bytea memory improvement