diff options
| author | Tomas Vondra <tomas.vondra@postgresql.org> | 2020-04-06 23:58:10 +0200 |
|---|---|---|
| committer | Tomas Vondra <tomas.vondra@postgresql.org> | 2020-04-07 00:02:07 +0200 |
| commit | 23ba3b5ee278847e4fad913b80950edb2838fd35 (patch) | |
| tree | 1348e91edb52d44de869581d8a1cec4391e6e6cc /src | |
| parent | ce2cee0ade8a6a360322c51201fda1fc25be7773 (diff) | |
| download | postgresql-23ba3b5ee278847e4fad913b80950edb2838fd35.tar.gz postgresql-23ba3b5ee278847e4fad913b80950edb2838fd35.zip | |
Fix failures in incremental_sort due to number of workers
The last test in incremental_sort suite prints a parallel plan, but some
of the buildfarm animals have custom max_parallel_workers_per_gather
values, causing failures. Fixed by setting the GUC to an explicit value.
Discussion: https://postgr.es/m/CAPpHfds1waRZ=NOmueYq0sx1ZSCnt+5QJvizT8ndT2=etZEeAQ@mail.gmail.com
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/incremental_sort.out | 1 | ||||
| -rw-r--r-- | src/test/regress/sql/incremental_sort.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/expected/incremental_sort.out b/src/test/regress/expected/incremental_sort.out index f130c606c87..404de630949 100644 --- a/src/test/regress/expected/incremental_sort.out +++ b/src/test/regress/expected/incremental_sort.out @@ -1402,6 +1402,7 @@ set min_parallel_table_scan_size = '1kB'; set min_parallel_index_scan_size = '1kB'; set parallel_setup_cost = 0; set parallel_tuple_cost = 0; +set max_parallel_workers_per_gather = 2; create table t (a int, b int, c int); insert into t select mod(i,10),mod(i,10),i from generate_series(1,10000) s(i); create index on t (a); diff --git a/src/test/regress/sql/incremental_sort.sql b/src/test/regress/sql/incremental_sort.sql index 3b359efa29a..2ba5d7a67d1 100644 --- a/src/test/regress/sql/incremental_sort.sql +++ b/src/test/regress/sql/incremental_sort.sql @@ -198,6 +198,7 @@ set min_parallel_table_scan_size = '1kB'; set min_parallel_index_scan_size = '1kB'; set parallel_setup_cost = 0; set parallel_tuple_cost = 0; +set max_parallel_workers_per_gather = 2; create table t (a int, b int, c int); insert into t select mod(i,10),mod(i,10),i from generate_series(1,10000) s(i); |