| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Barry Lind" <blind(at)xythos(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Performance problem using V3 protocol in jdbc driver |
| Date: | 2005-08-17 05:01:45 |
| Message-ID: | 12037.1124254905@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-performance |
"Barry Lind" <blind(at)xythos(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2005-08-17 05:43:40 | Re: Performance problem using V3 protocol in jdbc driver |
| Previous Message | Barry Lind | 2005-08-17 04:42:29 | Performance problem using V3 protocol in jdbc driver |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2005-08-17 05:43:40 | Re: Performance problem using V3 protocol in jdbc driver |
| Previous Message | Ron | 2005-08-17 04:48:26 | Re: Finding bottleneck |