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