Kouhei Sutou
null+****@clear*****
Sat Nov 5 17:53:13 JST 2016
Kouhei Sutou 2016-11-05 17:53:13 +0900 (Sat, 05 Nov 2016) New Revision: 7f7a8f7fbb6677296ad80bd538f37199fd47f7f6 https://github.com/groonga/wikipedia-search/commit/7f7a8f7fbb6677296ad80bd538f37199fd47f7f6 Message: Add index definition for pg_trgm Added files: config/sql/indexes.pg_trgm.sql Modified files: config/sql/indexes.pg_bigm.sql config/sql/indexes.textsearch.sql Modified: config/sql/indexes.pg_bigm.sql (+1 -1) =================================================================== --- config/sql/indexes.pg_bigm.sql 2016-11-05 17:51:56 +0900 (90d49f3) +++ config/sql/indexes.pg_bigm.sql 2016-11-05 17:53:13 +0900 (5a7a1c9) @@ -1,2 +1,2 @@ CREATE INDEX wikipedia_index_pg_bigm ON wikipedia - USING gin (title gin_bigm_ops, text gin_bigm_ops); + USING GIN (title gin_bigm_ops, text gin_bigm_ops); Added: config/sql/indexes.pg_trgm.sql (+2 -0) 100644 =================================================================== --- /dev/null +++ config/sql/indexes.pg_trgm.sql 2016-11-05 17:53:13 +0900 (229b8d1) @@ -0,0 +1,2 @@ +CREATE INDEX wikipedia_index_pg_trgm ON wikipedia + USING GIN (title gin_trgm_ops, text gin_trgm_ops); Modified: config/sql/indexes.textsearch.sql (+1 -1) =================================================================== --- config/sql/indexes.textsearch.sql 2016-11-05 17:51:56 +0900 (09ff80f) +++ config/sql/indexes.textsearch.sql 2016-11-05 17:53:13 +0900 (f1f3eab) @@ -1,2 +1,2 @@ CREATE INDEX wikipedia_index_textsearch ON wikipedia - USING gin (to_tsvector('english', title), to_tsvector('english', text)); + USING GIN (to_tsvector('english', title), to_tsvector('english', text)); -------------- next part -------------- HTML����������������������������...Download