diff options
author | Tomas Vondra | 2017-07-15 16:50:20 +0000 |
---|---|---|
committer | Tomas Vondra | 2017-07-15 16:50:20 +0000 |
commit | 5218ae2994516f6b73697266d4baf7c76290292d (patch) | |
tree | 505ae08bc2b056027a8b55be7eab797d5b94ccc1 | |
parent | 9f4a54d1c433f95a91a29dc417b52d563ee851b5 (diff) |
i# Summary (one line, 50 chars or less) ===========
Accept simple plan changes in tsearch regression test
The accepted plan changes are fairly simple, switching plain aggregation
to a distributed one.
-rw-r--r-- | src/test/regress/expected/tsearch.out | 50 |
1 files changed, 28 insertions, 22 deletions
diff --git a/src/test/regress/expected/tsearch.out b/src/test/regress/expected/tsearch.out index 32291c2096..57e71cb83b 100644 --- a/src/test/regress/expected/tsearch.out +++ b/src/test/regress/expected/tsearch.out @@ -121,12 +121,14 @@ SET enable_seqscan=OFF; SET enable_indexscan=ON; SET enable_bitmapscan=OFF; explain (costs off) SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh'; - QUERY PLAN -------------------------------------------------------- - Aggregate - -> Index Scan using wowidx on test_tsvector - Index Cond: (a @@ '''wr'' | ''qh'''::tsquery) -(3 rows) + QUERY PLAN +------------------------------------------------------------------- + Finalize Aggregate + -> Remote Subquery Scan on all (datanode_1,datanode_2) + -> Partial Aggregate + -> Index Scan using wowidx on test_tsvector + Index Cond: (a @@ '''wr'' | ''qh'''::tsquery) +(5 rows) SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh'; count @@ -191,14 +193,16 @@ SELECT count(*) FROM test_tsvector WHERE a @@ '!no_such_lexeme'; SET enable_indexscan=OFF; SET enable_bitmapscan=ON; explain (costs off) SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh'; - QUERY PLAN -------------------------------------------------------------- - Aggregate - -> Bitmap Heap Scan on test_tsvector - Recheck Cond: (a @@ '''wr'' | ''qh'''::tsquery) - -> Bitmap Index Scan on wowidx - Index Cond: (a @@ '''wr'' | ''qh'''::tsquery) -(5 rows) + QUERY PLAN +------------------------------------------------------------------------- + Finalize Aggregate + -> Remote Subquery Scan on all (datanode_1,datanode_2) + -> Partial Aggregate + -> Bitmap Heap Scan on test_tsvector + Recheck Cond: (a @@ '''wr'' | ''qh'''::tsquery) + -> Bitmap Index Scan on wowidx + Index Cond: (a @@ '''wr'' | ''qh'''::tsquery) +(7 rows) SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh'; count @@ -268,14 +272,16 @@ CREATE INDEX wowidx ON test_tsvector USING gin (a); SET enable_seqscan=OFF; -- GIN only supports bitmapscan, so no need to test plain indexscan explain (costs off) SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh'; - QUERY PLAN -------------------------------------------------------------- - Aggregate - -> Bitmap Heap Scan on test_tsvector - Recheck Cond: (a @@ '''wr'' | ''qh'''::tsquery) - -> Bitmap Index Scan on wowidx - Index Cond: (a @@ '''wr'' | ''qh'''::tsquery) -(5 rows) + QUERY PLAN +------------------------------------------------------------------------- + Finalize Aggregate + -> Remote Subquery Scan on all (datanode_1,datanode_2) + -> Partial Aggregate + -> Bitmap Heap Scan on test_tsvector + Recheck Cond: (a @@ '''wr'' | ''qh'''::tsquery) + -> Bitmap Index Scan on wowidx + Index Cond: (a @@ '''wr'' | ''qh'''::tsquery) +(7 rows) SELECT count(*) FROM test_tsvector WHERE a @@ 'wr|qh'; count |