Re: parametrized statements, but always replan?

On Wed, 2006-12-20 at 16:28 -0500, Kevin Murphy wrote:
> Mark Lewis wrote:
> > Set the prepareThreshold to 0, meaning that it will never create a
> > "real" server-side prepared statement.
> Hmm, even by default (without specifying prepareThreshold), it seems
> that the planner looks at the parameter values for the first execution
> of the query.  (See my post a couple minutes ago*).  Am I mistaken?
>
> If I'm not mistaken, then for one-shot queries, is there any any
> additional advantage to setting prepareThreshold to 0?

With the current driver version, there is no advantage if you only use
the PreparedStatement once.

> BTW, is the default value of prepareThreshold is 1?

The default value in the driver version I've got handy (forget exactly
which version this is) is 5.  I don't think that's changed recently.

-- Mark Lewis