2 # src/test/regress/parallel_schedule
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.
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.
14 # The first group of parallel tests
16 test: boolean char name varchar text int2 int4 int8 oid float4 float8 bit numeric txid uuid enum money rangetypes pg_lsn regproc
18 # Depends on things setup during char, varchar and text
20 # Depends on int2, int4, int8, float4, float8
24 # The second group of parallel tests
26 test: point lseg line box path polygon circle date time timetz timestamp timestamptz interval abstime reltime tinterval inet macaddr tstypes comments
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
33 test: geometry horology regex oidjoins type_sanity opr_sanity
36 # These four each depend on the previous one
40 test: create_function_1
43 test: create_function_2
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
54 # More groups of parallel tests
56 test: create_misc create_operator
57 # These depend on the above two
58 test: create_index create_view
61 # Another group of parallel tests
63 test: create_aggregate create_function_3 create_cast constraints triggers inherit create_table_like typed_table vacuum drop_if_exists updatable_views rolenames roleattributes
66 # sanity_check does a vacuum, affecting the sort order of SELECT *
67 # results. So it should not run parallel to other tests.
72 # Believe it or not, select creates a table, subsequent
80 # Another group of parallel tests
82 test: 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
85 # Another group of parallel tests
87 test: brin gin gist spgist privileges security_label collate matview lock replica_identity rowsecurity object_address tablesample groupingsets
90 # Another group of parallel tests
92 test: alter_generic alter_operator misc psql async
94 # rules cannot run concurrently with any test that creates a view
98 # Another group of parallel tests
100 test: 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
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
106 test: plancache limit plpgsql copy2 temp domain rangefuncs prepare without_oid conversion truncate alter_table sequence polymorphism rowtypes returning largeobject with xml
108 # event triggers cannot run concurrently with any test that runs DDL
111 # run stats by itself because its delay may be insufficient under heavy load