diff options
| author | David Rowley <drowley@postgresql.org> | 2023-01-23 21:31:46 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2023-01-23 21:31:46 +1300 |
| commit | 67c5b8840fcad07eeecd9af517b9b1ff09a3cf8e (patch) | |
| tree | bbc1e1f296e0d6e80e15242f913fcc004945d4d5 | |
| parent | c31cf1c03d01ce86f20bef8c980fe56a257b3b4b (diff) | |
| download | postgresql-67c5b8840fcad07eeecd9af517b9b1ff09a3cf8e.tar.gz postgresql-67c5b8840fcad07eeecd9af517b9b1ff09a3cf8e.zip | |
Harden new parallel string_agg/array_agg regression test
Per buildfarm member mandrill, it seems that
max_parallel_workers_per_gather may not always be set to the default value
of 2 when the new test added in 16fd03e95 is executed. Here let's just
explicitly set that to 2 so that the planner never opts to use more than
that many parallel workers.
| -rw-r--r-- | src/test/regress/expected/aggregates.out | 1 | ||||
| -rw-r--r-- | src/test/regress/sql/aggregates.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index 2a806be3277..8f96c4ed534 100644 --- a/src/test/regress/expected/aggregates.out +++ b/src/test/regress/expected/aggregates.out @@ -1872,6 +1872,7 @@ set parallel_tuple_cost TO 0; set parallel_leader_participation TO 0; set min_parallel_table_scan_size = 0; set bytea_output = 'escape'; +set max_parallel_workers_per_gather = 2; -- create a view as we otherwise have to repeat this query a few times. create view v_pagg_test AS select diff --git a/src/test/regress/sql/aggregates.sql b/src/test/regress/sql/aggregates.sql index 12e24a0dfad..f6815a1784d 100644 --- a/src/test/regress/sql/aggregates.sql +++ b/src/test/regress/sql/aggregates.sql @@ -728,6 +728,7 @@ set parallel_tuple_cost TO 0; set parallel_leader_participation TO 0; set min_parallel_table_scan_size = 0; set bytea_output = 'escape'; +set max_parallel_workers_per_gather = 2; -- create a view as we otherwise have to repeat this query a few times. create view v_pagg_test AS |