[pgpool-hackers: 3233] Re: pgbench: Flamegraph

Tatsuo Ishii ishii at sraoss.co.jp
Thu Feb 7 15:25:13 JST 2019


Hi Jesper,

Here's an another attempt to enhance Pgpool-II performance in
extended query + streaming replication case. The idea is to minimize
the necessity to call pool_flush(), which in turn calls write(2) to
the frontend socket. Attached is the patch and quick result of
pgbench. In pgbench -S case, I got up to 10.6% improvement over stock
master branch HEAD.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: extended_query_performance.diff
Type: text/x-patch
Size: 1768 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20190207/667bb87f/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: extended-query-performance.ods
Type: application/vnd.oasis.opendocument.spreadsheet
Size: 19683 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20190207/667bb87f/attachment-0001.ods>


More information about the pgpool-hackers mailing list