Skip site navigation (1) Skip section navigation (2)

JDBC, prepared queries, and partitioning

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL - JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: JDBC, prepared queries, and partitioning
Date: 2008-02-13 18:05:30
Message-ID: (view raw or whole thread)
Lists: pgsql-jdbc

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.

Is there any workaround for this, either on 8.2 or 8.3?

Josh Berkus
PostgreSQL @ Sun
San Francisco


pgsql-jdbc by date

Next:From: Kris JurkaDate: 2008-02-13 18:51:24
Subject: Re: JDBC, prepared queries, and partitioning
Previous:From: Kris JurkaDate: 2008-02-12 23:45:16
Subject: Re: 8.3 build 603 build error on Fedora 8

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group