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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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