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?
PostgreSQL @ Sun
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2008-02-13 18:51:24|
|Subject: Re: JDBC, prepared queries, and partitioning|
|Previous:||From: Kris Jurka||Date: 2008-02-12 23:45:16|
|Subject: Re: 8.3 build 603 build error on Fedora 8 |