pgsql: Speed up pg_regress server readiness testing. - Mailing list pgsql-committers

From Daniel Gustafsson
Subject pgsql: Speed up pg_regress server readiness testing.
Date
Msg-id E1qvNTy-0029lr-2l@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Speed up pg_regress server readiness testing.

Instead of connecting to the server with psql to check if it is ready
for running tests, this changes pg_regress to use PQPing which avoids
performing system() calls which are expensive on some platforms, like
Windows. The frequency of tests is also increased in order to connect
to the server faster.

This patch is part of a larger effort to make testing consume fewer
resources in order to be able to fit more tests into the available
CI system constraints.

Reviewed-by: Andres Freund <andres@anarazel.de>
Discussion: https://postgr.es/m/20230823192239.jxew5s3sjru63lio@awork3.anarazel.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/66d6086cbcbfc8dee789a69bf56d967bf9607902

Modified Files
--------------
src/interfaces/ecpg/test/Makefile    |  3 +-
src/interfaces/ecpg/test/meson.build |  2 +-
src/test/isolation/Makefile          |  2 +-
src/test/isolation/meson.build       |  2 +-
src/test/regress/GNUmakefile         |  4 +-
src/test/regress/meson.build         |  2 +-
src/test/regress/pg_regress.c        | 76 ++++++++++++++++++++++++------------
7 files changed, 59 insertions(+), 32 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix problems when a plain-inheritance parent table is excluded.
Next
From: Daniel Gustafsson
Date:
Subject: pgsql: Reword memory terminology for PQresultMemorySize