On Wed, 2008-02-13 at 13:51 -0500, Kris Jurka wrote:
>
> On Wed, 13 Feb 2008, Josh Berkus wrote:
>
> > Since JDBC always prepares and plan-caches queries, it makes it hard to use
> > partitioning with a database connected to a JDBC connection pool; successive
> > queries in the same session will select the wrong partition, or scan the
> > whole partition set.
> >
>
> It will never scan the wrong partition. It will always scan all
> partitions. The server is smart enough to not generate a plan that is not
> valid for only one parameter set.
>
> Using protocol version 2 will not prepare queries so constraint exclusion
> can be used. Just append protocolVersion=2 to your URL.
What about the prepare threshold?
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com