Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problem using V3 protocol in jdbc driver - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Performance problem using V3 protocol in jdbc driver
Date
Msg-id 12037.1124254905@sss.pgh.pa.us
Whole thread Raw
In response to Performance problem using V3 protocol in jdbc driver  ("Barry Lind" <blind@xythos.com>)
List pgsql-jdbc
Tree view 
"Barry Lind" <blind@xythos.com> writes:
> ...  On a hunch I switched the jdbc driver to using the V2 protocol
> and the load on the machine dropped down to what it was when using
> Oracle and everything was fine.

First knee-jerk reaction is that it's an optimization problem stemming
from V3 protocol feeding parameterized queries to the backend where V2
did not, and the planner being unable to cope :-(

Can you identify the specific queries causing the problem?

            regards, tom lane

pgsql-jdbc by date:

Previous
From: "Barry Lind"
Date:
Subject: Performance problem using V3 protocol in jdbc driver
Next
From: "Barry Lind"
Date:
Subject: Re: Performance problem using V3 protocol in jdbc driver