pgsql: Re-order some regression test scripts for more parallelism.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Re-order some regression test scripts for more parallelism.
Date: 2019-04-11 22:16:58
Message-ID: E1hEi0A-0006Iz-E7@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Re-order some regression test scripts for more parallelism.

Move the strings, numerology, insert, insert_conflict, select and
errors tests to be parts of nearby parallel groups, instead of
executing by themselves. (Moving "select" required adjusting the
constraints test, which uses a table named "tmp" as select also
does. There don't seem to be any other conflicts.)

Move psql and stats_ext to the next parallel group, where the rules
test also has a long runtime. To make it safe to run stats_ext in
parallel with rules, I adjusted the latter to only dump views/rules
from the pg_catalog and public schemas, which was what it was doing
anyway. stats_ext makes some views in a transient schema, which now
will not affect rules.

Reorder serial_schedule to match parallel_schedule.

Discussion: https://postgr.es/m/735.1554935715@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/798070ec058fe75757587c9e9916cc35c623f427

Modified Files
--------------
src/test/regress/expected/rules.out | 7 ++++--
src/test/regress/expected/sanity_check.out | 1 +
src/test/regress/input/constraints.source | 2 +-
src/test/regress/output/constraints.source | 2 +-
src/test/regress/parallel_schedule | 36 +++++++++++-------------------
src/test/regress/serial_schedule | 20 ++++++++---------
src/test/regress/sql/rules.sql | 7 ++++--
7 files changed, 36 insertions(+), 39 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2019-04-12 01:28:25 pgsql: Fix more strcmp() calls using boolean-like comparisons for resul
Previous Message Tom Lane 2019-04-11 21:01:47 pgsql: Speed up sort-order-comparison tests in create_index_spgist.