Postgres Pro
Downloads
Home   >   mailing lists

Re: V3 protocol is slower than V2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: V3 protocol is slower than V2
Date
Msg-id 3942.1192509937@sss.pgh.pa.us
Whole thread Raw
In response to V3 protocol is slower than V2  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: V3 protocol is slower than V2
List pgsql-hackers
Tree view 
ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
>   [V2]  PQsendQuery (V2; original)
>   [V3]  PQsendQueryParams (V3)
>   [V3P] PQsendQueryPrepared (V3 with prepared statements)

> V3 was 12% slower than V2, and V3P was 40% faster than V2.

Those aren't really comparable, because the functionality is different.
Did you check plain PQSendQuery on both V2 and V3?
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Brendan Jurd"
Date:
Subject: plpgsql: Plan type mismatch error
Next
From: Tom Lane
Date:
Subject: Re: plpgsql: Plan type mismatch error