Re: Very strange performance decrease when reusing a PreparedStatement - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Very strange performance decrease when reusing a PreparedStatement
Date
Msg-id 49FE2D45.2070308@opencloud.com
Whole thread Raw
In response to Re: Very strange performance decrease when reusing a PreparedStatement  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Very strange performance decrease when reusing a PreparedStatement  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Tom Lane wrote:

> There are certainly cases where lack of parameter type information could
> lead to a poor plan, but they are corner cases.

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

(This might be a reflection that applications using JDBC are often
web-facing apps with simple, index-heavy queries)

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Very strange performance decrease when reusing a PreparedStatement
Next
From: Oliver Jowett
Date:
Subject: Re: Very strange performance decrease when reusing a PreparedStatement