On 20 May 2016 at 08:47, Tsunakawa, Takayuki <tsunakawa.ta...@jp.fujitsu.com
> wrote:
> From: pgsql-hackers-ow...@postgresql.org [mailto:
> pgsql-hackers-ow...@postgresql.org] On Behalf Of Craig Ringer
>
> Well, there's FE/BE level batching/pipelining already. Just no access to
> it from libpq.
>
>
>
> Oh, really. The Bind ('B') appears to take one set of parameter values,
> not multiple sets (array). Anyway, I had to say "I want batch update API
> in libpq" to use it in ODBC and ECPG.
>
>
Right, and there's no protocol level support for array-valued batches.
You can, however, omit Sync from between messages and send a series of
protocol messages, like
Parse/Bind/Execute/Bind/Execute/Bind/Execute/Sync
to avoid round-trip overheads.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
