Re: foreign table batch inserts - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: foreign table batch inserts
Date
Msg-id CAMsr+YG=dCNjcbt0RJQGNaobOzg8acTQTEM0w=9xmxd-x5p=GA@mail.gmail.com
Whole thread Raw
In response to Re: foreign table batch inserts  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Responses Re: foreign table batch inserts  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
On 20 May 2016 at 08:47, Tsunakawa, Takayuki <tsunakawa.takay@jp.fujitsu.com> wrote:

From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-owner@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

pgsql-hackers by date:

Previous
From: Hao Lee
Date:
Subject: It's seems that the function "do_text_output_multiline" does not suit for format "line1\nline2\n...lineN".
Next
From: Amit Langote
Date:
Subject: Re: Declarative partitioning