On 20 May 2016 at 23:18, Craig Ringer <cr...@2ndquadrant.com> wrote: > On 20 May 2016 at 15:35, Craig Ringer <cr...@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. http://www.postgresql.org/message-id/flat/CAMsr+YFUjJytRyV4J-16bEoiZyH=4nj+sQ7JP9ajwz=b4dm...@mail.gmail.com#CAMsr+YFUjJytRyV4J-16bEoiZyH=4nj+sQ7JP9ajwz=b4dm...@mail.gmail.com https://commitfest.postgresql.org/10/634/ I'll use the other thread for the patch from now on. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services