pgsql: Speed up TAP tests of pg_receivewal

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема pgsql: Speed up TAP tests of pg_receivewal
Дата
Msg-id E1mgGxa-0003pX-8A@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Speed up printing of integers in snprintf.c.
Следующее
От: Amit Kapila
Дата:
Сообщение: pgsql: Add tap tests for the schema publications.