Re: Performance problem using V3 protocol in jdbc driver

From: Tom Lane
Subject: Re: Performance problem using V3 protocol in jdbc driver
Date: ,
Msg-id: 12037.1124254905@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Performance problem using V3 protocol in jdbc driver  ("Barry Lind")
List: pgsql-jdbc


"Barry Lind" <> 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:

From: "Mahesh Shinde"
Date:
Subject: Data Selection Slow From VB 6.0
From: Oliver Jowett
Date:
Subject: Re: Data Selection Slow From VB 6.0