Groonga - fulltext search engine.

[Groonga-commit] pgroonga/pgroonga at ceee75e [master] test: check explain too

Kouhei Sutou null+****@clear*****
Tue May 2 15:16:15 JST 2017

• Previous message: [Groonga-commit] pgroonga/pgroonga at f7fe15f [master] Add pgroonga.varchar_full_text_search_ops_v2
• Next message: [Groonga-commit] Fixed: pgroonga/pgroonga#859 (master - f7fe15f)
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Kouhei Sutou	2017-05-02 15:16:15 +0900 (Tue, 02 May 2017)

  New Revision: ceee75e0608fb16c13b5260d8d4e401d2f74445d
  https://github.com/pgroonga/pgroonga/commit/ceee75e0608fb16c13b5260d8d4e401d2f74445d

  Message:
    test: check explain too

  Renamed files:
    expected/full-text-search/text/single/match-in-v2/bitmapscan.out
      (from expected/full-text-search/text/single/match-contain/bitmapscan.out)
    expected/full-text-search/text/single/match-in-v2/indexscan.out
      (from expected/full-text-search/text/single/match-contain/indexscan.out)
    expected/full-text-search/text/single/match-in-v2/seqscan.out
      (from expected/full-text-search/text/single/match-contain/seqscan.out)
    expected/full-text-search/text/single/query-in-v2/bitmapscan.out
      (from expected/full-text-search/text/single/query-contain/bitmapscan.out)
    expected/full-text-search/text/single/query-in-v2/indexscan.out
      (from expected/full-text-search/text/single/query-contain/indexscan.out)
    expected/full-text-search/text/single/query-in-v2/seqscan.out
      (from expected/full-text-search/text/single/query-contain/seqscan.out)
    sql/full-text-search/text/single/match-in-v2/bitmapscan.sql
      (from sql/full-text-search/text/single/match-contain/bitmapscan.sql)
    sql/full-text-search/text/single/match-in-v2/indexscan.sql
      (from sql/full-text-search/text/single/match-contain/indexscan.sql)
    sql/full-text-search/text/single/match-in-v2/seqscan.sql
      (from sql/full-text-search/text/single/match-contain/seqscan.sql)
    sql/full-text-search/text/single/query-in-v2/bitmapscan.sql
      (from sql/full-text-search/text/single/query-contain/bitmapscan.sql)
    sql/full-text-search/text/single/query-in-v2/indexscan.sql
      (from sql/full-text-search/text/single/query-contain/indexscan.sql)
    sql/full-text-search/text/single/query-in-v2/seqscan.sql
      (from sql/full-text-search/text/single/query-contain/seqscan.sql)

  Renamed: expected/full-text-search/text/single/match-in-v2/bitmapscan.out (+12 -0) 63%
===================================================================
--- expected/full-text-search/text/single/match-contain/bitmapscan.out    2017-05-02 15:12:39 +0900 (097ac75)
+++ expected/full-text-search/text/single/match-in-v2/bitmapscan.out    2017-05-02 15:16:15 +0900 (17f3783)
@@ -10,6 +10,18 @@ CREATE INDEX pgrn_index ON memos
 SET enable_seqscan = off;
 SET enable_indexscan = off;
 SET enable_bitmapscan = on;
+EXPLAIN (COSTS OFF)
+SELECT id, content
+  FROM memos
+ WHERE content &@> Array['rdbms', 'engine'];
+                         QUERY PLAN                         
+------------------------------------------------------------
+ Bitmap Heap Scan on memos
+   Recheck Cond: (content &@> '{rdbms,engine}'::text[])
+   ->  Bitmap Index Scan on pgrn_index
+         Index Cond: (content &@> '{rdbms,engine}'::text[])
+(4 rows)
+
 SELECT id, content
   FROM memos
  WHERE content &@> Array['rdbms', 'engine'];

  Renamed: expected/full-text-search/text/single/match-in-v2/indexscan.out (+10 -0) 70%
===================================================================
--- expected/full-text-search/text/single/match-contain/indexscan.out    2017-05-02 15:12:39 +0900 (af38fc9)
+++ expected/full-text-search/text/single/match-in-v2/indexscan.out    2017-05-02 15:16:15 +0900 (c5ebcc1)
@@ -10,6 +10,16 @@ CREATE INDEX pgrn_index ON memos
 SET enable_seqscan = off;
 SET enable_indexscan = on;
 SET enable_bitmapscan = off;
+EXPLAIN (COSTS OFF)
+SELECT id, content
+  FROM memos
+ WHERE content &@> Array['rdbms', 'engine'];
+                      QUERY PLAN                      
+------------------------------------------------------
+ Index Scan using pgrn_index on memos
+   Index Cond: (content &@> '{rdbms,engine}'::text[])
+(2 rows)
+
 SELECT id, content
   FROM memos
  WHERE content &@> Array['rdbms', 'engine'];

  Renamed: expected/full-text-search/text/single/match-in-v2/seqscan.out (+0 -0) 100%
===================================================================

  Renamed: expected/full-text-search/text/single/query-in-v2/bitmapscan.out (+12 -0) 61%
===================================================================
--- expected/full-text-search/text/single/query-contain/bitmapscan.out    2017-05-02 15:12:39 +0900 (d027b11)
+++ expected/full-text-search/text/single/query-in-v2/bitmapscan.out    2017-05-02 15:16:15 +0900 (e96c2d4)
@@ -10,6 +10,18 @@ CREATE INDEX pgrn_index ON memos
 SET enable_seqscan = off;
 SET enable_indexscan = off;
 SET enable_bitmapscan = on;
+EXPLAIN (COSTS OFF)
+SELECT id, content
+  FROM memos
+ WHERE content &?> Array['rdbms', 'groonga engine'];
+                              QUERY PLAN                              
+----------------------------------------------------------------------
+ Bitmap Heap Scan on memos
+   Recheck Cond: (content &?> '{rdbms,"groonga engine"}'::text[])
+   ->  Bitmap Index Scan on pgrn_index
+         Index Cond: (content &?> '{rdbms,"groonga engine"}'::text[])
+(4 rows)
+
 SELECT id, content
   FROM memos
  WHERE content &?> Array['rdbms', 'groonga engine'];

  Renamed: expected/full-text-search/text/single/query-in-v2/indexscan.out (+10 -0) 67%
===================================================================
--- expected/full-text-search/text/single/query-contain/indexscan.out    2017-05-02 15:12:39 +0900 (953c8ac)
+++ expected/full-text-search/text/single/query-in-v2/indexscan.out    2017-05-02 15:16:15 +0900 (245ae2c)
@@ -10,6 +10,16 @@ CREATE INDEX pgrn_index ON memos
 SET enable_seqscan = off;
 SET enable_indexscan = on;
 SET enable_bitmapscan = off;
+EXPLAIN (COSTS OFF)
+SELECT id, content
+  FROM memos
+ WHERE content &?> Array['rdbms', 'groonga engine'];
+                           QUERY PLAN                           
+----------------------------------------------------------------
+ Index Scan using pgrn_index on memos
+   Index Cond: (content &?> '{rdbms,"groonga engine"}'::text[])
+(2 rows)
+
 SELECT id, content
   FROM memos
  WHERE content &?> Array['rdbms', 'groonga engine'];

  Renamed: expected/full-text-search/text/single/query-in-v2/seqscan.out (+0 -0) 100%
===================================================================

  Renamed: sql/full-text-search/text/single/match-in-v2/bitmapscan.sql (+5 -0) 84%
===================================================================
--- sql/full-text-search/text/single/match-contain/bitmapscan.sql    2017-05-02 15:12:39 +0900 (d2bfdb1)
+++ sql/full-text-search/text/single/match-in-v2/bitmapscan.sql    2017-05-02 15:16:15 +0900 (8a634f8)
@@ -14,6 +14,11 @@ SET enable_seqscan = off;
 SET enable_indexscan = off;
 SET enable_bitmapscan = on;
 
+EXPLAIN (COSTS OFF)
+SELECT id, content
+  FROM memos
+ WHERE content &@> Array['rdbms', 'engine'];
+
 SELECT id, content
   FROM memos
  WHERE content &@> Array['rdbms', 'engine'];

  Renamed: sql/full-text-search/text/single/match-in-v2/indexscan.sql (+5 -0) 84%
===================================================================
--- sql/full-text-search/text/single/match-contain/indexscan.sql    2017-05-02 15:12:39 +0900 (60fed74)
+++ sql/full-text-search/text/single/match-in-v2/indexscan.sql    2017-05-02 15:16:15 +0900 (30194e6)
@@ -14,6 +14,11 @@ SET enable_seqscan = off;
 SET enable_indexscan = on;
 SET enable_bitmapscan = off;
 
+EXPLAIN (COSTS OFF)
+SELECT id, content
+  FROM memos
+ WHERE content &@> Array['rdbms', 'engine'];
+
 SELECT id, content
   FROM memos
  WHERE content &@> Array['rdbms', 'engine'];

  Renamed: sql/full-text-search/text/single/match-in-v2/seqscan.sql (+0 -0) 100%
===================================================================

  Renamed: sql/full-text-search/text/single/query-in-v2/bitmapscan.sql (+5 -0) 84%
===================================================================
--- sql/full-text-search/text/single/query-contain/bitmapscan.sql    2017-05-02 15:12:39 +0900 (2a83918)
+++ sql/full-text-search/text/single/query-in-v2/bitmapscan.sql    2017-05-02 15:16:15 +0900 (d8a732a)
@@ -14,6 +14,11 @@ SET enable_seqscan = off;
 SET enable_indexscan = off;
 SET enable_bitmapscan = on;
 
+EXPLAIN (COSTS OFF)
+SELECT id, content
+  FROM memos
+ WHERE content &?> Array['rdbms', 'groonga engine'];
+
 SELECT id, content
   FROM memos
  WHERE content &?> Array['rdbms', 'groonga engine'];

  Renamed: sql/full-text-search/text/single/query-in-v2/indexscan.sql (+5 -0) 84%
===================================================================
--- sql/full-text-search/text/single/query-contain/indexscan.sql    2017-05-02 15:12:39 +0900 (d682334)
+++ sql/full-text-search/text/single/query-in-v2/indexscan.sql    2017-05-02 15:16:15 +0900 (9e867c2)
@@ -14,6 +14,11 @@ SET enable_seqscan = off;
 SET enable_indexscan = on;
 SET enable_bitmapscan = off;
 
+EXPLAIN (COSTS OFF)
+SELECT id, content
+  FROM memos
+ WHERE content &?> Array['rdbms', 'groonga engine'];
+
 SELECT id, content
   FROM memos
  WHERE content &?> Array['rdbms', 'groonga engine'];

  Renamed: sql/full-text-search/text/single/query-in-v2/seqscan.sql (+0 -0) 100%
===================================================================
-------------- next part --------------
HTML����������������������������...
Download 

• Previous message: [Groonga-commit] pgroonga/pgroonga at f7fe15f [master] Add pgroonga.varchar_full_text_search_ops_v2
• Next message: [Groonga-commit] Fixed: pgroonga/pgroonga#859 (master - f7fe15f)
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]