[pgpool-committers: 6791] pgpool: Add regression test for snapshot isolation mode.

Tatsuo Ishii ishii at sraoss.co.jp
Sat Jun 20 10:07:24 JST 2020


Add regression test for snapshot isolation mode.

To test the mode, we use two concurrent transactions generated by 2
pgbench instances. Tx A updates a row of table t1. Tx B retrieves the
row in t1 and INSERT INTO log table. If atomic visibilty is kept,
after Tx A and B finishes rows of log on node 0 and node 1 should be
identical. In fact in the snapshot isolation mode, they are
identical. On the other hand, in the existing native replication mode,
they are not identical.

Also add missing sample configuration file for the snapshot isolation
mode.

Branch
------
master

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

Modified Files
--------------
src/Makefile.am                                    |   1 +
src/Makefile.in                                    |  56 +-
src/sample/pgpool.conf.sample-snapshot             | 856 +++++++++++++++++++++
.../030.snapshot_isolation/inconsistency1.sql      |   3 +
.../030.snapshot_isolation/inconsistency2.sql      |   3 +
.../tests/030.snapshot_isolation/test.sh           |  66 ++
6 files changed, 964 insertions(+), 21 deletions(-)



More information about the pgpool-committers mailing list