[pgpool-committers: 5408] pgpool: Enhance performance of CopyData message handling.

Tatsuo Ishii ishii at sraoss.co.jp
Wed Dec 26 15:04:38 JST 2018


Enhance performance of CopyData message handling.

When COPY XX FROM STDIN gets executed (typical client is pg_dump),
each copy row data is sent from Pgpool-II to frontend using CopyData
message. Previously, one CopyData message was followed by a flush,
which costed a lot. Instead, now flush is done in subsequent Command
Complete, Notice message or Error message.  A quick test reveals that
this change brings x2.5 speed up.

Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2018-December/003199.html

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=702f7c86f9b8f82f61e47235505715891ffe1b23

Modified Files
--------------
src/protocol/pool_process_query.c | 17 +++++++++++------
1 file changed, 11 insertions(+), 6 deletions(-)



More information about the pgpool-committers mailing list