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(-)