1# ----------
2# src/test/regress/parallel_schedule
3#
4# By convention, we put no more than twenty tests in any one parallel group;
5# this limits the number of connections needed to run the tests.
6# ----------
7
8# run tablespace by itself, and first, because it forces a checkpoint;
9# we'd prefer not to have checkpoints later in the tests because that
10# interferes with crash-recovery testing.
11test: tablespace
12
13# ----------
14# The first group of parallel tests
15# ----------
16test: boolean char name varchar text int2 int4 int8 oid float4 float8 bit numeric txid uuid enum money rangetypes pg_lsn regproc
17
18# Depends on things setup during char, varchar and text
19test: strings
20# Depends on int2, int4, int8, float4, float8
21test: numerology
22
23# ----------
24# The second group of parallel tests
25# ----------
26test: point lseg line box path polygon circle date time timetz timestamp timestamptz interval abstime reltime tinterval inet macaddr tstypes comments
27
28# ----------
29# Another group of parallel tests
30# geometry depends on point, lseg, box, path, polygon and circle
31# horology depends on interval, timetz, timestamp, timestamptz, reltime and abstime
32# ----------
33test: geometry horology regex oidjoins type_sanity opr_sanity
34
35# ----------
36# These four each depend on the previous one
37# ----------
38test: insert
39test: insert_conflict
40test: create_function_1
41test: create_type
42test: create_table
43test: create_function_2
44
45# ----------
46# Load huge amounts of data
47# We should split the data files into single files and then
48# execute two copy tests parallel, to check that copy itself
49# is concurrent safe.
50# ----------
51test: copy copyselect copydml
52
53# ----------
54# More groups of parallel tests
55# ----------
56test: create_misc create_operator
57# These depend on the above two
58test: create_index create_view
59
60# ----------
61# Another group of parallel tests
62# ----------
63test: create_aggregate create_function_3 create_cast constraints triggers inherit create_table_like typed_table vacuum drop_if_exists updatable_views rolenames roleattributes create_am
64
65# ----------
66# sanity_check does a vacuum, affecting the sort order of SELECT *
67# results. So it should not run parallel to other tests.
68# ----------
69test: sanity_check
70
71# ----------
72# Believe it or not, select creates a table, subsequent
73# tests need.
74# ----------
75test: errors
76test: select
77ignore: random
78
79# ----------
80# Another group of parallel tests
81# ----------
82test: select_into select_distinct select_distinct_on select_implicit select_having subselect union case join aggregates transactions random portals arrays btree_index hash_index update namespace prepared_xacts delete
83
84# ----------
85# Another group of parallel tests
86# ----------
87test: brin gin gist spgist privileges init_privs security_label collate matview lock replica_identity rowsecurity object_address tablesample groupingsets drop_operator
88
89# ----------
90# Another group of parallel tests
91# ----------
92test: alter_generic alter_operator misc psql async dbsize misc_functions
93
94# rules cannot run concurrently with any test that creates a view
95test: rules psql_crosstab select_parallel amutils
96
97# ----------
98# Another group of parallel tests
99# ----------
100test: select_views portals_p2 foreign_key cluster dependency guc bitmapops combocid tsearch tsdicts foreign_data window xmlmap functional_deps advisory_lock json jsonb json_encoding indirect_toast equivclass
101# ----------
102# Another group of parallel tests
103# NB: temp.sql does a reconnect which transiently uses 2 connections,
104# so keep this parallel group to at most 19 tests
105# ----------
106test: plancache limit plpgsql copy2 temp domain rangefuncs prepare without_oid conversion truncate alter_table sequence polymorphism rowtypes returning largeobject with xml
107
108# event triggers cannot run concurrently with any test that runs DDL
109test: event_trigger
110
111# run stats by itself because its delay may be insufficient under heavy load
112test: stats
113