From: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Speed up TAP tests of pg_receivewal
Date: Fri, 29 Oct 2021 01:45:34 +0000
Message-ID: <E1mgGxa-0003pX-8A@gemulon.postgresql.org> (raw)
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(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-committers@postgresql.org
Cc: michael@paquier.xyz
Subject: Re: pgsql: Speed up TAP tests of pg_receivewal
In-Reply-To: <E1mgGxa-0003pX-8A@gemulon.postgresql.org>
References: <E1mgGxa-0003pX-8A@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox