aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndres Freund <andres@anarazel.de>2017-04-06 14:21:39 -0700
committerAndres Freund <andres@anarazel.de>2017-04-06 14:22:27 -0700
commitd611517fc44ebbf7e0d563de6d4cd98fd342a762 (patch)
treef36fea48eb0226afbb3c6dc7ad21204072d7b1ea
parent7e534adcdc70866e7be74d626b0ed067c890a251 (diff)
downloadpostgresql-d611517fc44ebbf7e0d563de6d4cd98fd342a762.tar.gz
postgresql-d611517fc44ebbf7e0d563de6d4cd98fd342a762.zip
Fix parallel bitmapscan tests on builds without USE_PREFETCH.
This was broken in 5a5931533edd2.
-rw-r--r--src/test/regress/expected/select_parallel.out7
-rw-r--r--src/test/regress/sql/select_parallel.sql7
2 files changed, 12 insertions, 2 deletions
diff --git a/src/test/regress/expected/select_parallel.out b/src/test/regress/expected/select_parallel.out
index d65c2b93a8c..0e9bc1a7078 100644
--- a/src/test/regress/expected/select_parallel.out
+++ b/src/test/regress/expected/select_parallel.out
@@ -175,7 +175,12 @@ set enable_indexscan to off;
set enable_hashjoin to off;
set enable_mergejoin to off;
set enable_material to off;
-set effective_io_concurrency=50;
+-- test prefetching, if the platform allows it
+DO $$
+BEGIN
+ SET effective_io_concurrency = 50;
+EXCEPTION WHEN invalid_parameter_value THEN
+END $$;
set work_mem='64kB'; --set small work mem to force lossy pages
explain (costs off)
select count(*) from tenk1, tenk2 where tenk1.hundred > 1 and tenk2.thousand=0;
diff --git a/src/test/regress/sql/select_parallel.sql b/src/test/regress/sql/select_parallel.sql
index b2a0bd5d94a..67bc82e8347 100644
--- a/src/test/regress/sql/select_parallel.sql
+++ b/src/test/regress/sql/select_parallel.sql
@@ -70,7 +70,12 @@ set enable_indexscan to off;
set enable_hashjoin to off;
set enable_mergejoin to off;
set enable_material to off;
-set effective_io_concurrency=50;
+-- test prefetching, if the platform allows it
+DO $$
+BEGIN
+ SET effective_io_concurrency = 50;
+EXCEPTION WHEN invalid_parameter_value THEN
+END $$;
set work_mem='64kB'; --set small work mem to force lossy pages
explain (costs off)
select count(*) from tenk1, tenk2 where tenk1.hundred > 1 and tenk2.thousand=0;