pgsql: Speed up TAP tests of pg_receivewal

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Speed up TAP tests of pg_receivewal
Date: 2021-10-29 01:45:34
Message-ID: E1mgGxa-0003pX-8A@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2021-10-29 02:29:19 pgsql: Add tap tests for the schema publications.
Previous Message Tom Lane 2021-10-28 17:40:03 pgsql: Speed up printing of integers in snprintf.c.