From 934c7986f4a0a6a3b606301d84b784a27c0c324b Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 4 Jan 2018 01:06:58 -0500 Subject: [PATCH] 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 --- src/test/regress/expected/join.out | 2 +- 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 a7cfdf1f44..02e7d56e55 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 a6a452f960..dd62c38c15 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); -- 2.40.0