[pgpool-committers: 7851] pgpool: New feature "prefer_lower_delay_standby"

Masaya Kawamoto kawamoto at sraoss.co.jp
Mon Jun 21 14:12:13 JST 2021


New feature "prefer_lower_delay_standby"

Currently on streaming replication mode, when the node selected as the load
balancing node has streaming delay over delay_threshold, pgpool sends the
query to the primary regardless of other standbys.

When this parameter is set to on, if the delayed load balancing node is the
standby, pgpool selects the new load balancing node from the lowest delay standbys.

If all standbys are delayed or the primary is chosen as the load balancing node,
pgpool sends the query to the primary.

Branch
------
master

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

Modified Files
--------------
.../tests/033.prefer_lower_standby_delay/test.sh   | 103 +++++++++++++++++++++
1 file changed, 103 insertions(+)



More information about the pgpool-committers mailing list