2 # $PostgreSQL: pgsql/src/test/regress/parallel_schedule,v 1.57 2009/08/24 03:10:16 tgl Exp $
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
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 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 oidjoins type_sanity opr_sanity
36 # These four each depend on the previous one
39 test: create_function_1
42 test: create_function_2
45 # Load huge amounts of data
46 # We should split the data files into single files and then
47 # execute two copy tests parallel, to check that copy itself
53 # Another group of parallel tests
55 test: constraints triggers create_misc create_aggregate create_operator inherit vacuum drop_if_exists create_cast
57 # Depends on the above
58 test: create_index create_view
61 # sanity_check does a vacuum, affecting the sort order of SELECT *
62 # results. So it should not run parallel to other tests.
67 # Believe it or not, select creates a table, subsequent
75 # Another group of parallel tests
77 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
83 # Another group of parallel tests
85 test: select_views portals_p2 rules foreign_key cluster dependency guc bitmapops combocid tsearch tsdicts foreign_data window xmlmap
88 # Another group of parallel tests
89 # NB: temp.sql does a reconnect which transiently uses 2 connections,
90 # so keep this parallel group to at most 19 tests
92 # "plpgsql" cannot run concurrently with "rules", nor can "plancache"
93 test: plancache limit plpgsql copy2 temp domain rangefuncs prepare without_oid conversion truncate alter_table sequence polymorphism rowtypes returning largeobject with xml
95 # run stats by itself because its delay may be insufficient under heavy load