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

Re: Very strange performance decrease when reusing a PreparedStatement

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: John Lister <john(dot)lister-ps(at)kickstone(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Very strange performance decrease when reusing a PreparedStatement
Date: 2009-05-03 23:51:10
Message-ID: 49FE2DEE.809@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Oliver Jowett wrote:
> Tom Lane wrote:
> 
>> There are certainly cases where lack of parameter type information could
>> lead to a poor plan, but they are corner cases.

Sorry, I read that as "lack of parameter information" which is what this
comment is about:

> I fear they are less of a corner case than you believe - they seem to
> pop up regularly here on the JDBC list.

The parameter type issues themselves are mostly resolved AFAIK.

-O

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2009-05-04 00:00:01
Subject: Re: Very strange performance decrease when reusing a PreparedStatement
Previous:From: Oliver JowettDate: 2009-05-03 23:48:21
Subject: Re: Very strange performance decrease when reusing a PreparedStatement

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