[pgpool-hackers: 3289] Re: [pgpool-committers: 5615] pgpool: New feature "statement_level_load_balancing".

[Tatsuo Ishii]

Congratulations Peng!

It is one the largest features in upcoming Pgpool-II 4.1 and has been
expected for many years.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

From: Bo Peng <pengbo at sraoss.co.jp>
Subject: [pgpool-committers: 5615] pgpool: New feature "statement_level_load_balancing".
Date: Tue, 02 Apr 2019 01:16:54 +0000
Message-ID: <E1hB82o-0006ra-3a at gothos.postgresql.org>

> New feature "statement_level_load_balancing".
> 
> This feature enables selecting load balancing node per statement.
> 
> The current feature for load balancing, the load balancing node is decided
> at the session start time and will not be changed until the session ends.
> 
> When set to statement_level_load_balancing = on, the load balancing node
> is decided for each read query.
> 
> For example, in applications that use connection pooling remain connections
> open to the backend server, because the session may be held for a long time,
> the load balancing node does not change until the session ends.
> In such applications, when statement_level_load_balance is enabled,
> it is possible to decide load balancing node per query, not per session.
> 
> Branch
> ------
> master
> 
> Details
> -------
> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=1099ba610eef06a9dab6f89486cc52de55ff3ebb
> 
> Modified Files
> --------------
> doc.ja/src/sgml/loadbalance.sgml                   |  37 +++
> doc/src/sgml/loadbalance.sgml                      |  23 ++
> src/config/pool_config_variables.c                 |  10 +
> src/context/pool_query_context.c                   |  21 +-
> src/context/pool_session_context.c                 |  52 ++--
> src/include/context/pool_query_context.h           |   2 +-
> src/include/context/pool_session_context.h         |   6 +-
> src/include/pool_config.h                          |   2 +
> src/protocol/child.c                               |   4 +-
> src/protocol/pool_proto_modules.c                  |   1 +
> src/sample/pgpool.conf.sample                      |   3 +
> src/sample/pgpool.conf.sample-logical              |   3 +
> src/sample/pgpool.conf.sample-master-slave         |   3 +
> src/sample/pgpool.conf.sample-replication          |   3 +
> src/sample/pgpool.conf.sample-stream               |   3 +
> .../expected/statement_level_load_balance.data     |  37 +++
> .../statement_level_load_balance.data              |  39 +++
> src/test/extended-query-test/test.sh               | 261 +++++++++++++++------
> .../tests_n3/statement_level_load_balance.data     |  27 +++
> src/test/regression/tests/001.load_balance/test.sh |  23 ++
> src/utils/pool_process_reporting.c                 |   5 +
> 21 files changed, 454 insertions(+), 111 deletions(-)
>