Re: JDBC, prepared queries, and partitioning - Mailing list pgsql-jdbc

From Simon Riggs
Subject Re: JDBC, prepared queries, and partitioning
Date
Msg-id 1202944406.16770.562.camel@ebony.site
Whole thread Raw
In response to JDBC, prepared queries, and partitioning  (Josh Berkus <josh@agliodbs.com>)
List pgsql-jdbc
On Wed, 2008-02-13 at 17:47 -0500, Kris Jurka wrote:
>
> On Wed, 13 Feb 2008, Simon Riggs wrote:
>
> > But the code example shows explicit use of
> >
> > pgconn.setPrepareThreshold(5);
> >
> > which clearly does nothing, given the default setting of protocol V3.
> >
> > So the program shown only works as stated with 7.3, the last time the
> > default connection protocol was v2.
>
> No, you've got it all backwards.  prepareThreshold only does something
> with V3.

OK. I was confused by your statement that "in V3 all prepared statements
are prepared regardless of the threshold". I took that to mean that the
prepareThreshold did nothing at all in V3, which threw everything I
understood on its head.

Many thanks for clarifications from yourself and Oliver.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


pgsql-jdbc by date:

Previous
From: "Stephen Denne"
Date:
Subject: Re: JDBC, prepared queries, and partitioning
Next
From: Kris Jurka
Date:
Subject: Re: JDBC, prepared queries, and partitioning