pgsql: Speed up TAP tests of pg_receivewal - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Speed up TAP tests of pg_receivewal
Date
Msg-id E1mgGxa-0003pX-8A@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Speed up TAP tests of pg_receivewal

This commit improves the speed of those tests by 25~30%, using some
simple ideas to reduce the amount of data written by pg_receivewal:
- Use a segment size of 1MB.  While reducing the amount of data zeroed
by pg_receivewal for the new segments, this improves the code coverage
with a non-default segment size.
- In the last test involving a slot's restart_lsn, generate a checkpoint
to advance the redo LSN and the WAL retained by the slot created,
reducing the number of segments that need to be archived.  This counts
for most of the gain.
- Minimize the amount of data inserted into the dummy table.

Reviewed-by: Ronan Dunklau
Discussion: https://postgr.es/m/YXqYKAdVEqmyTltK@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d680992af5406245f769b697fbb4e130e6220664

Modified Files
--------------
src/bin/pg_basebackup/t/020_pg_receivewal.pl | 24 +++++++++++++-----------
1 file changed, 13 insertions(+), 11 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Speed up printing of integers in snprintf.c.
Next
From: Amit Kapila
Date:
Subject: pgsql: Add tap tests for the schema publications.