Re: [HACKERS] V3 protocol is slower than V2

2007-10-15 Thread ITAGAKI Takahiro
Tom Lane <[EMAIL PROTECTED]> wrote: > ITAGAKI Takahiro <[EMAIL PROTECTED]> 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 a

Re: [HACKERS] V3 protocol is slower than V2

2007-10-15 Thread Tom Lane
ITAGAKI Takahiro <[EMAIL PROTECTED]> 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

[HACKERS] V3 protocol is slower than V2

2007-10-15 Thread ITAGAKI Takahiro
Hi, V3 protocol seems to be slower than V2 if we don't use prepared statement together. I measured performance of protocols on 8.3beta using pgbench -S with modification to use PQsendQueryParams and PQsendQueryPrepared instead of PQsendQuery. (I'll send the patch to -patches shortly.) [V2] PQs