Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit3955c50

Browse files
committed
Force hash joins to be enabled in the hash join regression tests.
Otherwise the regressplans.sh tests generate extremely slow nestedloop joins. Back-patch to 11 where the hash join tests came in.Reported-by: Michael PaquierDiscussion:https://postgr.es/m/20190708055256.GB2709%40paquier.xyz
1 parent1b6c2b9 commit3955c50

File tree

2 files changed

+2
-0
lines changed

2 files changed

+2
-0
lines changed

‎src/test/regress/expected/join.out

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -5998,6 +5998,7 @@ drop table j3;
59985998
begin;
59995999
set local min_parallel_table_scan_size = 0;
60006000
set local parallel_setup_cost = 0;
6001+
set local enable_hashjoin = on;
60016002
-- Extract bucket and batch counts from an explain analyze plan. In
60026003
-- general we can't make assertions about how many batches (or
60036004
-- buckets) will be required because it can vary, but we can in some

‎src/test/regress/sql/join.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2032,6 +2032,7 @@ begin;
20322032

20332033
set local min_parallel_table_scan_size=0;
20342034
set local parallel_setup_cost=0;
2035+
set local enable_hashjoin=on;
20352036

20362037
-- Extract bucket and batch counts from an explain analyze plan. In
20372038
-- general we can't make assertions about how many batches (or

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp