diff options
| author | Thomas Munro <tmunro@postgresql.org> | 2019-07-09 18:11:01 +1200 |
|---|---|---|
| committer | Thomas Munro <tmunro@postgresql.org> | 2019-07-09 18:30:37 +1200 |
| commit | 5526baf54902a56c5bc1b4abe625acb33d7357bf (patch) | |
| tree | ba988446b552be6c4ee311f01152a53019bb0c2d /src | |
| parent | d0217d5ef2b8c44fa786f7f96c514684a0a04b28 (diff) | |
| download | postgresql-5526baf54902a56c5bc1b4abe625acb33d7357bf.tar.gz postgresql-5526baf54902a56c5bc1b4abe625acb33d7357bf.zip | |
Force hash joins to be enabled in the hash join regression tests.
Otherwise the regressplans.sh tests generate extremely slow nested
loop joins. Back-patch to 11 where the hash join tests came in.
Reported-by: Michael Paquier
Discussion: https://postgr.es/m/20190708055256.GB2709%40paquier.xyz
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/join_hash.out | 1 | ||||
| -rw-r--r-- | src/test/regress/sql/join_hash.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/expected/join_hash.out b/src/test/regress/expected/join_hash.out index 9eee39bdd32..6080ebb961d 100644 --- a/src/test/regress/expected/join_hash.out +++ b/src/test/regress/expected/join_hash.out @@ -4,6 +4,7 @@ begin; set local min_parallel_table_scan_size = 0; set local parallel_setup_cost = 0; +set local enable_hashjoin = on; -- Extract bucket and batch counts from an explain analyze plan. In -- general we can't make assertions about how many batches (or -- buckets) will be required because it can vary, but we can in some diff --git a/src/test/regress/sql/join_hash.sql b/src/test/regress/sql/join_hash.sql index ae352e9b0b8..5b41d01a245 100644 --- a/src/test/regress/sql/join_hash.sql +++ b/src/test/regress/sql/join_hash.sql @@ -6,6 +6,7 @@ begin; set local min_parallel_table_scan_size = 0; set local parallel_setup_cost = 0; +set local enable_hashjoin = on; -- Extract bucket and batch counts from an explain analyze plan. In -- general we can't make assertions about how many batches (or |