summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTomas Vondra2017-07-07 23:17:29 +0000
committerTomas Vondra2017-07-07 23:17:29 +0000
commit8c88742b734862e3422e5de555448e2f48fc6347 (patch)
tree3e6bd145c7c7cc1ffd7af3d56e6cc3b3e942699d
parent2752383bf70e9a915308a53d55357c26d5e9ecb3 (diff)
Accept trivial plan changes in brin regression test
Those are new plans in upstream, and the only that happened to them is adding "Remote Fast Query Execution" to the top of the plan.
-rw-r--r--src/test/regress/expected/brin.out28
1 files changed, 16 insertions, 12 deletions
diff --git a/src/test/regress/expected/brin.out b/src/test/regress/expected/brin.out
index 3d500369a5..13233c238c 100644
--- a/src/test/regress/expected/brin.out
+++ b/src/test/regress/expected/brin.out
@@ -500,19 +500,23 @@ CREATE INDEX brin_test_b_idx ON brin_test USING brin (b) WITH (pages_per_range =
VACUUM ANALYZE brin_test;
-- Ensure brin index is used when columns are perfectly correlated
EXPLAIN (COSTS OFF) SELECT * FROM brin_test WHERE a = 1;
- QUERY PLAN
---------------------------------------------
- Bitmap Heap Scan on brin_test
- Recheck Cond: (a = 1)
- -> Bitmap Index Scan on brin_test_a_idx
- Index Cond: (a = 1)
-(4 rows)
+ QUERY PLAN
+--------------------------------------------------
+ Remote Fast Query Execution
+ Node/s: datanode_1
+ -> Bitmap Heap Scan on brin_test
+ Recheck Cond: (a = 1)
+ -> Bitmap Index Scan on brin_test_a_idx
+ Index Cond: (a = 1)
+(6 rows)
-- Ensure brin index is not used when values are not correlated
EXPLAIN (COSTS OFF) SELECT * FROM brin_test WHERE b = 1;
- QUERY PLAN
------------------------
- Seq Scan on brin_test
- Filter: (b = 1)
-(2 rows)
+ QUERY PLAN
+----------------------------------
+ Remote Fast Query Execution
+ Node/s: datanode_1, datanode_2
+ -> Seq Scan on brin_test
+ Filter: (b = 1)
+(4 rows)