Re: JDBC, prepared queries, and partitioning

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.

Kris Jurka