Re: foreign table batch inserts

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: foreign table batch inserts
Дата
Msg-id CAMsr+YG=dCNjcbt0RJQGNaobOzg8acTQTEM0w=9xmxd-x5p=GA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: foreign table batch inserts  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Ответы Re: foreign table batch inserts  (Craig Ringer <craig@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Hao Lee
Дата:
Сообщение: It's seems that the function "do_text_output_multiline" does not suit for format "line1\nline2\n...lineN".
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Declarative partitioning