Re: foreign table batch inserts

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: foreign table batch inserts
Дата
Msg-id CAMsr+YE0xFKd+L8rBH26g5=Mo1H-xiCm9fT0H_hYk_3JQ+hyvg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: foreign table batch inserts  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers


On 20 May 2016 at 23:18, Craig Ringer <craig@2ndquadrant.com> wrote:
On 20 May 2016 at 15:35, Craig Ringer <craig@2ndquadrant.com> wrote:
 

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.


I implemented what I think is a pretty solid proof of concept of this for kicks this evening. Attached, including basic test program. Patch attached. The performance difference over higher latency links is huge, see below.

I finished it off and submitted it.



I'll use the other thread for the patch from now on.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: PATCH: Batch/pipelining support for libpq
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Declarative partitioning