| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Guillaume Cottenceau *EXTERN* <gc(at)mnc(dot)ch>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: performance question: protocol v2 vs v3 |
| Date: | 2014-12-03 13:44:21 |
| Message-ID: | 547F13B5.8080504@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On 12/03/2014 07:41 PM, Albe Laurenz wrote:
> I didn't know that, thanks for the clarification.
Neither did I until I did some performance analysis work recently.
It's not always strictly true - in particular, if you're using binary
parameters, PgJDBC does a parse and describe, then waits for a response
before sending a bind. So there's an extra round trip there. Same if
you're doing a batch returning generated keys.
In general though, the v3 protocol doesn't add roundtrips.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2014-12-03 14:28:54 | Re: Trying to get SSPI/JDBC working |
| Previous Message | Albe Laurenz | 2014-12-03 11:41:39 | Re: performance question: protocol v2 vs v3 |