[pgpool-committers: 6798] pgpool: Allow to SELECT load balance in snapshot isolation mode.

Tatsuo Ishii ishii at sraoss.co.jp
Mon Jun 22 20:08:07 JST 2020


Allow to SELECT load balance in snapshot isolation mode.

- In an read only explicit transaction
- If outside transaction, transaction mode is read only
- In other case, check if the query is really read only SELECT.

Also modify 001.load_balance test to check snapshot isolation mode.

Branch
------
master

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

Modified Files
--------------
src/context/pool_query_context.c                   | 115 +++++++++++++++++----
src/context/pool_session_context.c                 |   3 +
src/include/context/pool_session_context.h         |   3 +
src/include/protocol/pool_pg_utils.h               |   1 +
src/protocol/pool_pg_utils.c                       |  11 ++
src/protocol/pool_proto_modules.c                  |  27 +++--
src/test/regression/tests/001.load_balance/test.sh |   2 +-
7 files changed, 134 insertions(+), 28 deletions(-)



More information about the pgpool-committers mailing list