diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2018-01-04 01:06:58 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2018-01-04 01:06:58 -0500 |
| commit | 934c7986f4a0a6a3b606301d84b784a27c0c324b (patch) | |
| tree | decc803d74743e9ecd96f5f16ba537a0ecacd260 | |
| parent | 47c6772eb7222dbfa200db4bbeba8002b96b7976 (diff) | |
| download | postgresql-934c7986f4a0a6a3b606301d84b784a27c0c324b.tar.gz postgresql-934c7986f4a0a6a3b606301d84b784a27c0c324b.zip | |
Tweak parallel hash join test case in hopes of improving stability.
This seems to make things better on gaur, let's see what the rest
of the buildfarm thinks.
Thomas Munro
Discussion: https://postgr.es/m/CAEepm=1uuT8iJxMEsR=jL+3zEi87DB2v0+0H9o_rUXXCZPZT3A@mail.gmail.com
| -rw-r--r-- | src/test/regress/expected/join.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/join.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/join.out b/src/test/regress/expected/join.out index a7cfdf1f443..02e7d56e550 100644 --- a/src/test/regress/expected/join.out +++ b/src/test/regress/expected/join.out @@ -6073,7 +6073,7 @@ rollback to settings; -- parallel with parallel-aware hash join savepoint settings; set local max_parallel_workers_per_gather = 2; -set local work_mem = '128kB'; +set local work_mem = '192kB'; set local enable_parallel_hash = on; explain (costs off) select count(*) from simple r join simple s using (id); diff --git a/src/test/regress/sql/join.sql b/src/test/regress/sql/join.sql index a6a452f9609..dd62c38c15e 100644 --- a/src/test/regress/sql/join.sql +++ b/src/test/regress/sql/join.sql @@ -2116,7 +2116,7 @@ rollback to settings; -- parallel with parallel-aware hash join savepoint settings; set local max_parallel_workers_per_gather = 2; -set local work_mem = '128kB'; +set local work_mem = '192kB'; set local enable_parallel_hash = on; explain (costs off) select count(*) from simple r join simple s using (id); |