pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Daniel Gustafsson <dgustafsson@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Speed up pg_regress server readiness testing.
Date: Tue, 24 Oct 2023 19:54:30 +0000
Message-ID: <E1qvNTy-0029lr-2l@gemulon.postgresql.org> (raw)

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



Message-ID: <E1qvNTy-0029lr-2l@gemulon.postgresql.org>
Permalink:  ../E1qvNTy-0029lr-2l@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1qvNTy-0029lr-2l@gemulon.postgresql.org

 · 

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: dgustafsson@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Speed up pg_regress server readiness testing.
  In-Reply-To: <E1qvNTy-0029lr-2l@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