From: Craig Ringer <craig.rin...@enterprisedb.com> > But in the libpq pipelining patch I demonstrated a 300 times (3000%) > performance improvement on a test workload...
Wow, impressive number. I've just seen it in the beginning of the libpq pipelining thread (oh, already four years ago..!) Could you share the workload and the network latency (ping time)? I'm sorry I'm just overlooking it. Thank you for your (always) concise explanation. I'd like to check other DBMSs and your rich references for the FDW interface. (My first intuition is that many major DBMSs might not have client C APIs that can be used to implement an async pipelining FDW interface. Also, I'm afraid it requires major surgery or reform of executor. I don't want it to delay the release of reasonably good (10x) improvement with the synchronous interface.) (It'd be kind of you to send emails in text format. I've changed the format of this reply from HTML to text.) Regards Takayuki Tsunakawa
