Kouhei Sutou
null+****@clear*****
Sat Feb 14 19:20:42 JST 2015
Kouhei Sutou 2015-02-14 19:20:42 +0900 (Sat, 14 Feb 2015) New Revision: 4f5fcf56628cfe1fd80da39ca1942c3d5bd86403 https://github.com/pgroonga/pgroonga/commit/4f5fcf56628cfe1fd80da39ca1942c3d5bd86403 Message: Use bitmap scan for OR Modified files: expected/full-text-search/text/single/score/or.out sql/full-text-search/text/single/score/or.sql Modified: expected/full-text-search/text/single/score/or.out (+4 -4) =================================================================== --- expected/full-text-search/text/single/score/or.out 2015-02-14 18:59:10 +0900 (1a02e6f) +++ expected/full-text-search/text/single/score/or.out 2015-02-14 19:20:42 +0900 (fe0b3e8) @@ -7,15 +7,15 @@ INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.'); INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.'); CREATE INDEX grnindex ON memos USING pgroonga (content); SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; SELECT id, content, pgroonga.score(memos) FROM memos - WHERE content @@ 'PGroonga OR Groonga'; + WHERE content %% 'PGroonga' OR content %% 'Groonga'; id | content | score ----+-------------------------------------------------------+------- - 3 | PGroonga is a PostgreSQL extension that uses Groonga. | 2 2 | Groonga is fast full text search engine. | 1 + 3 | PGroonga is a PostgreSQL extension that uses Groonga. | 2 (2 rows) DROP TABLE memos; Modified: sql/full-text-search/text/single/score/or.sql (+3 -3) =================================================================== --- sql/full-text-search/text/single/score/or.sql 2015-02-14 18:59:10 +0900 (1324524) +++ sql/full-text-search/text/single/score/or.sql 2015-02-14 19:20:42 +0900 (3ed7173) @@ -10,11 +10,11 @@ INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groon CREATE INDEX grnindex ON memos USING pgroonga (content); SET enable_seqscan = off; -SET enable_indexscan = on; -SET enable_bitmapscan = off; +SET enable_indexscan = off; +SET enable_bitmapscan = on; SELECT id, content, pgroonga.score(memos) FROM memos - WHERE content @@ 'PGroonga OR Groonga'; + WHERE content %% 'PGroonga' OR content %% 'Groonga'; DROP TABLE memos; -------------- next part -------------- HTML����������������������������...Download
