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 macaddr8 tstypes
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 misc_sanity comments expressions
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
51 test: copy copyselect copydml
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 create_am hash_func
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 init_privs security_label collate matview lock replica_identity rowsecurity object_address tablesample groupingsets drop_operator password
90 # Another group of parallel tests
92 test: alter_generic alter_operator misc psql async dbsize misc_functions sysviews tsrf tidscan stats_ext
94 # rules cannot run concurrently with any test that creates a view
95 test: rules psql_crosstab amutils
97 # run by itself so it can run parallel workers
101 # no relation related tests can be put in this group
102 test: publication subscription
105 # Another group of parallel tests
107 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
110 # Another group of parallel tests
111 # NB: temp.sql does a reconnect which transiently uses 2 connections,
112 # so keep this parallel group to at most 19 tests
114 test: plancache limit plpgsql copy2 temp domain rangefuncs prepare without_oid conversion truncate alter_table sequence polymorphism rowtypes returning largeobject with xml
117 # Another group of parallel tests
119 test: identity partition_join reloptions
121 # event triggers cannot run concurrently with any test that runs DDL
124 # run stats by itself because its delay may be insufficient under heavy load