Re: performance question: protocol v2 vs v3

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: performance question: protocol v2 vs v3
Дата
Msg-id 547F13B5.8080504@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: performance question: protocol v2 vs v3  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список 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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: performance question: protocol v2 vs v3
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Trying to get SSPI/JDBC working