On Mon, 26 Feb 2007, Gene wrote:
I've been having some serious performance issues with
postgresql8.2/hibernate/jdbc due to postgres reusing bad cached query
plans. It doesn't look at the parameter values and therefore does not
use any partial indexes.
After trying to set prepareThreshold=0
On 26-Feb-07, at 11:12 AM, Gene wrote:
hi!
I've been having some serious performance issues with
postgresql8.2/hibernate/jdbc due to postgres reusing bad cached query
plans. It doesn't look at the parameter values and therefore does not
use any partial indexes.
After trying to set
Thank you! setting the protocolVersion=2 works with the newer driver.
I'm still puzzled as to why the prepareThreshold=0 doesn't force the
replan though.
On 2/26/07, Dave Cramer [EMAIL PROTECTED] wrote:
On 26-Feb-07, at 11:12 AM, Gene wrote:
hi!
I've been having some serious performance