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

From Craig Ringer
Subject Re: foreign table batch inserts
Date
Msg-id CAMsr+YE0xFKd+L8rBH26g5=Mo1H-xiCm9fT0H_hYk_3JQ+hyvg@mail.gmail.com
Whole thread Raw
In response to Re: foreign table batch inserts  (Craig Ringer <craig@2ndquadrant.com>)
List 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 by date:

Previous
From: Craig Ringer
Date:
Subject: PATCH: Batch/pipelining support for libpq
Next
From: Amit Langote
Date:
Subject: Re: Declarative partitioning