[pgpool-committers: 5837] pgpool: feature: Disable load balance after a SELECT having functions s

Bo Peng pengbo at sraoss.co.jp
Mon Jul 1 12:58:07 JST 2019


feature: Disable load balance after a SELECT having functions specified in black/white function list.

In Pgpool-II 4.0 or earlier, if we set "disable_load_balance_on_write = transaction",
when a write query is issued inside an explicit truncation,
subsequent queries should be sent to primary only until the
end of this transactionin in order to avoid the replication
delay.

However, the SELECTs having write functions specified in black_function_list
are not regarded as a write query and the subsequent read queries are still load balanced.

This commit will disable load balance after a SELECT having functions
specified in black/white function list.

Branch
------
master

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

Modified Files
--------------
doc.ja/src/sgml/loadbalance.sgml                   | 10 +--
doc/src/sgml/loadbalance.sgml                      |  6 +-
src/protocol/pool_proto_modules.c                  |  7 +-
...disable-load-balance-always-black-function.data | 83 +++++++++++++++++++++
...isable-load-balance-default-black-function.data | 83 +++++++++++++++++++++
.../disable-load-balance-off-black-function.data   | 83 +++++++++++++++++++++
...disable-load-balance-simple-black-function.data | 48 ++++++++++++
.../disable-load-balance-trans-black-function.data | 83 +++++++++++++++++++++
.../disable-load-balance-white-function.data       | 83 +++++++++++++++++++++
...disable-load-balance-always-black-function.data | 23 ++++++
...isable-load-balance-default-black-function.data | 24 ++++++
.../disable-load-balance-off-black-function.data   | 24 ++++++
...disable-load-balance-simple-black-function.data | 22 ++++++
.../disable-load-balance-trans-black-function.data | 24 ++++++
.../disable-load-balance-white-function.data       | 24 ++++++
...disable-load-balance-always-black-function.data | 85 +++++++++++++++++++++
...isable-load-balance-default-black-function.data | 83 +++++++++++++++++++++
.../disable-load-balance-off-black-function.data   | 86 ++++++++++++++++++++++
...disable-load-balance-simple-black-function.data | 59 +++++++++++++++
.../disable-load-balance-trans-black-function.data | 86 ++++++++++++++++++++++
.../tests/disable-load-balance-white-function.data | 81 ++++++++++++++++++++
21 files changed, 1096 insertions(+), 11 deletions(-)



More information about the pgpool-committers mailing list