<div dir="ltr"><div class="gmail_default" style="font-size:small">Hi all,</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">we setup a 3 nodes cluster with PGPool-II version 4.2.3 on 3 physical servers with CentOS 7 and PostgreSQL 12.7, like described here:</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><a href="https://www.pgpool.net/docs/latest/en/html/example-cluster.html" target="_blank">https://www.pgpool.net/docs/latest/en/html/example-cluster.html</a></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">Cluster status:</div><div class="gmail_default" style="font-size:small"><span style="font-family:monospace">[postgres@server14 ~]$ psql -h PGPOOL-VIP -p 9999 -U pgpool postgres -c "show pool_nodes"<br> node_id |    hostname    | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change  <br>---------+----------------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------<br> 0       | server10       | 5432 | up     | 0.333333  | standby | 1          | false             | 0                 | streaming         | async                  | 2021-09-07 17:01:29<br> 1       | server14       | 5432 | up     | 0.333333  | primary | 55832      | false             | 0                 |                   |                        | 2021-09-07 16:43:37<br> 2       | server15       | 5432 | up     | 0.333333  | standby | 1          | true              | 0                 | streaming         | async                  | 2021-09-07 16:43:37<br>(3 rows)</span></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">Performing some stress test with pgbench we noted a great difference connecting directly to the Priamry DB versus connecting to the PGPool VIP:</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">Direct Connection on the Primary PostgreSQL:</div><div class="gmail_default" style="font-size:small">[postgres@server14 ~]$ pgbench -h server14 -p5432  test -T60<br>Password: <br>starting vacuum...end.<br>transaction type: <builtin: TPC-B (sort of)><br>scaling factor: 1<br>query mode: simple<br>number of clients: 1<br>number of threads: 1<br>duration: 60 s<br>number of transactions actually processed: 54441<br><b>latency average = 1.102 ms</b><br>tps = 907.336709 (including connections establishing)<br>tps = 907.584536 (excluding connections establishing)</div><br><div class="gmail_default" style="font-size:small">Connection to the PGPool VIP:</div><div class="gmail_default" style="font-size:small">[postgres@server14 ~]$ pgbench -h PGPOOL-VIP -p9999  test -T60<br>Password: <br>starting vacuum...end.<br>transaction type: <builtin: TPC-B (sort of)><br>scaling factor: 1<br>query mode: simple<br>number of clients: 1<br>number of threads: 1<br>duration: 60 s<br>number of transactions actually processed: 21244<br><b>latency average = 2.824 ms</b><br>tps = 354.065350 (including connections establishing)<br>tps = 354.562738 (excluding connections establishing)</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">Yes, it's a simple test, but the difference is *huge* IMHO. Repeating several times the same test get same results.<br></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">I'd like to know your experience and comments and what could be the problem.</div><div class="gmail_default" style="font-size:small">Is there any specific tuning to do in PGPool-II ?</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">Thanks in advance.</div><div class="gmail_default" style="font-size:small">Regards,</div><div class="gmail_default" style="font-size:small">Luca</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small"><br></div></div>