Kouhei Sutou
null+****@clear*****
Mon May 1 19:06:38 JST 2017
Kouhei Sutou 2017-05-01 19:06:38 +0900 (Mon, 01 May 2017) New Revision: 4b415262ac1a61b9d44bf35fa71850c0345cd728 https://github.com/pgroonga/pgroonga/commit/4b415262ac1a61b9d44bf35fa71850c0345cd728 Message: test: add tests for index is really used Modified files: expected/full-text-search/text/single/compatibility/v1/match-v2/bitmapscan.out expected/full-text-search/text/single/compatibility/v1/match-v2/indexscan.out expected/full-text-search/text/single/compatibility/v1/query-v2/bitmapscan.out expected/full-text-search/text/single/compatibility/v1/query-v2/indexscan.out sql/full-text-search/text/single/compatibility/v1/match-v2/bitmapscan.sql sql/full-text-search/text/single/compatibility/v1/match-v2/indexscan.sql sql/full-text-search/text/single/compatibility/v1/query-v2/bitmapscan.sql sql/full-text-search/text/single/compatibility/v1/query-v2/indexscan.sql Modified: expected/full-text-search/text/single/compatibility/v1/match-v2/bitmapscan.out (+12 -0) =================================================================== --- expected/full-text-search/text/single/compatibility/v1/match-v2/bitmapscan.out 2017-05-01 18:53:27 +0900 (d045ca5) +++ expected/full-text-search/text/single/compatibility/v1/match-v2/bitmapscan.out 2017-05-01 19:06:38 +0900 (88ea35b) @@ -10,6 +10,18 @@ CREATE INDEX grnindex ON memos SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; +EXPLAIN +SELECT id, content + FROM memos + WHERE content &@ 'Groonga'; + QUERY PLAN +----------------------------------------------------------------------- + Bitmap Heap Scan on memos (cost=0.00..4.01 rows=2 width=36) + Recheck Cond: (content &@ 'Groonga'::text) + -> Bitmap Index Scan on grnindex (cost=0.00..0.00 rows=1 width=0) + Index Cond: (content &@ 'Groonga'::text) +(4 rows) + SELECT id, content FROM memos WHERE content &@ 'Groonga'; Modified: expected/full-text-search/text/single/compatibility/v1/match-v2/indexscan.out (+10 -0) =================================================================== --- expected/full-text-search/text/single/compatibility/v1/match-v2/indexscan.out 2017-05-01 18:53:27 +0900 (ac7d824) +++ expected/full-text-search/text/single/compatibility/v1/match-v2/indexscan.out 2017-05-01 19:06:38 +0900 (de4734f) @@ -10,6 +10,16 @@ CREATE INDEX grnindex ON memos SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; +EXPLAIN +SELECT id, content + FROM memos + WHERE content &@ 'Groonga'; + QUERY PLAN +----------------------------------------------------------------------- + Index Scan using grnindex on memos (cost=0.00..4.01 rows=2 width=36) + Index Cond: (content &@ 'Groonga'::text) +(2 rows) + SELECT id, content FROM memos WHERE content &@ 'Groonga'; Modified: expected/full-text-search/text/single/compatibility/v1/query-v2/bitmapscan.out (+12 -0) =================================================================== --- expected/full-text-search/text/single/compatibility/v1/query-v2/bitmapscan.out 2017-05-01 18:53:27 +0900 (3e09e45) +++ expected/full-text-search/text/single/compatibility/v1/query-v2/bitmapscan.out 2017-05-01 19:06:38 +0900 (28e3c88) @@ -10,6 +10,18 @@ CREATE INDEX grnindex ON memos SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; +EXPLAIN +SELECT id, content + FROM memos + WHERE content &? 'rdbms OR engine'; + QUERY PLAN +----------------------------------------------------------------------- + Bitmap Heap Scan on memos (cost=0.00..4.01 rows=2 width=36) + Recheck Cond: (content &? 'rdbms OR engine'::text) + -> Bitmap Index Scan on grnindex (cost=0.00..0.00 rows=1 width=0) + Index Cond: (content &? 'rdbms OR engine'::text) +(4 rows) + SELECT id, content FROM memos WHERE content &? 'rdbms OR engine'; Modified: expected/full-text-search/text/single/compatibility/v1/query-v2/indexscan.out (+10 -0) =================================================================== --- expected/full-text-search/text/single/compatibility/v1/query-v2/indexscan.out 2017-05-01 18:53:27 +0900 (4361ac7) +++ expected/full-text-search/text/single/compatibility/v1/query-v2/indexscan.out 2017-05-01 19:06:38 +0900 (15436e3) @@ -10,6 +10,16 @@ CREATE INDEX grnindex ON memos SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; +EXPLAIN +SELECT id, content + FROM memos + WHERE content &? 'rdbms OR engine'; + QUERY PLAN +----------------------------------------------------------------------- + Index Scan using grnindex on memos (cost=0.00..4.01 rows=2 width=36) + Index Cond: (content &? 'rdbms OR engine'::text) +(2 rows) + SELECT id, content FROM memos WHERE content &? 'rdbms OR engine'; Modified: sql/full-text-search/text/single/compatibility/v1/match-v2/bitmapscan.sql (+5 -0) =================================================================== --- sql/full-text-search/text/single/compatibility/v1/match-v2/bitmapscan.sql 2017-05-01 18:53:27 +0900 (2fee88c) +++ sql/full-text-search/text/single/compatibility/v1/match-v2/bitmapscan.sql 2017-05-01 19:06:38 +0900 (3567350) @@ -14,6 +14,11 @@ SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; +EXPLAIN +SELECT id, content + FROM memos + WHERE content &@ 'Groonga'; + SELECT id, content FROM memos WHERE content &@ 'Groonga'; Modified: sql/full-text-search/text/single/compatibility/v1/match-v2/indexscan.sql (+5 -0) =================================================================== --- sql/full-text-search/text/single/compatibility/v1/match-v2/indexscan.sql 2017-05-01 18:53:27 +0900 (74843a6) +++ sql/full-text-search/text/single/compatibility/v1/match-v2/indexscan.sql 2017-05-01 19:06:38 +0900 (55537d5) @@ -14,6 +14,11 @@ SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; +EXPLAIN +SELECT id, content + FROM memos + WHERE content &@ 'Groonga'; + SELECT id, content FROM memos WHERE content &@ 'Groonga'; Modified: sql/full-text-search/text/single/compatibility/v1/query-v2/bitmapscan.sql (+5 -0) =================================================================== --- sql/full-text-search/text/single/compatibility/v1/query-v2/bitmapscan.sql 2017-05-01 18:53:27 +0900 (b0a2d71) +++ sql/full-text-search/text/single/compatibility/v1/query-v2/bitmapscan.sql 2017-05-01 19:06:38 +0900 (2c5b744) @@ -14,6 +14,11 @@ SET enable_seqscan = off; SET enable_indexscan = off; SET enable_bitmapscan = on; +EXPLAIN +SELECT id, content + FROM memos + WHERE content &? 'rdbms OR engine'; + SELECT id, content FROM memos WHERE content &? 'rdbms OR engine'; Modified: sql/full-text-search/text/single/compatibility/v1/query-v2/indexscan.sql (+5 -0) =================================================================== --- sql/full-text-search/text/single/compatibility/v1/query-v2/indexscan.sql 2017-05-01 18:53:27 +0900 (e4dfb5a) +++ sql/full-text-search/text/single/compatibility/v1/query-v2/indexscan.sql 2017-05-01 19:06:38 +0900 (01fadf5) @@ -14,6 +14,11 @@ SET enable_seqscan = off; SET enable_indexscan = on; SET enable_bitmapscan = off; +EXPLAIN +SELECT id, content + FROM memos + WHERE content &? 'rdbms OR engine'; + SELECT id, content FROM memos WHERE content &? 'rdbms OR engine'; -------------- next part -------------- HTML����������������������������...Descargar
