Re: V3 protocol is slower than V2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: V3 protocol is slower than V2
Date: 2007-10-16 04:45:37
Message-ID: 3942.1192509937@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-10-16 04:52:47 Re: plpgsql: Plan type mismatch error
Previous Message Brendan Jurd 2007-10-16 04:31:32 plpgsql: Plan type mismatch error

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2007-10-16 04:55:35 Re: Avoid needless copy in nodeMaterial
Previous Message Tom Lane 2007-10-16 04:34:12 Re: Avoid needless copy in nodeMaterial