pgsql: Speed up pg_regress server readiness testing.

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