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