pgsql: Avoid idle WAL waits in checksum tests - Mailing list pgsql-committers

From Daniel Gustafsson
Subject pgsql: Avoid idle WAL waits in checksum tests
Date
Msg-id E1xBDbG-00000001d1D-1CrQ@gemulon.postgresql.org
Whole thread
List pgsql-committers
Avoid idle WAL waits in checksum tests

Switch to wait_for_replay_catchup in checksum tests to explicitly
wait for the upstream flush LSN and not the write LSN.  The write
LSN can include unrelated unflushed WAL which isn't available for
streaming on an idle primary.

In the test for using a rewound node as standby of a new primary in
the 013_rewind suite; also switch WAL on the source before starting
the target.  This flushes through the minimum recovery point chosen
to avoid a startup delay while an unflushed full_page_writes change
waits for the background writer to log its next snapshot.

This reduces test times significantly without changing the semantics
of the tests.

Author: Nazir Bilal Yavuz <byavuz81@gmail.com>
Reviewed-by: Zsolt Parragi <zsolt.parragi@percona.com>
Reviewed-by: Daniel Gustafsson <daniel@yesql.se>
Discussion: https://postgr.es/m/CAN55FZ1Yak_xBqMaDQsD7atpBkGLEkF-DKXcs3nLHM1Uq4YRew%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5f76ed5d6baa9bfa9ebd2f1d97eaf6dcbfe76b5f

Modified Files
--------------
src/test/modules/test_checksums/t/003_standby_restarts.pl | 12 ++++--------
src/test/modules/test_checksums/t/011_standby_straddle.pl | 15 +++++----------
src/test/modules/test_checksums/t/013_rewind.pl           | 12 +++++++++---
.../test_checksums/t/021_rewind_divergent_transitions.pl  |  8 ++++----
4 files changed, 22 insertions(+), 25 deletions(-)


pgsql-committers by date:

Previous
From: Álvaro Herrera
Date:
Subject: pgsql: Turn "check" into assertion
Next
From: Andrew Dunstan
Date:
Subject: pgsql: Fire create_upper_paths_hook for UPPERREL_PARTIAL_GROUP_AGG