On 2018-01-08 14:38:20 +1300, Thomas Munro wrote: > Just an idea, not sure if it's worth looking into; maybe we already > spend enough time filling those buffers that a 50% syscall markup > won't hurt.
Yea, I suspect that won't make a huge difference - copying an 8kb buffer is typically a lot more than the overhead. The big problem for the demonstrated slowness is really that we send a lot of tiny packets back and forth and wait for them, and that's obviously going to be performance sensitive to syscall speed. Pipelining helps a lot, but isn't that generally applicable... TBH, I don't really see that much we can do from our side for readonly OLTP with prepared statements. Greetings, Andres Freund
