Re: Very strange performance decrease when reusing a PreparedStatement

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