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, likeParse/Bind/Execute/Bind/Execute/Bind/Execute/Syncto 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.
В списке pgsql-hackers по дате отправления: