Kouhei Sutou
null+****@clear*****
Mon Nov 14 00:32:12 JST 2016
Kouhei Sutou 2016-11-14 00:32:12 +0900 (Mon, 14 Nov 2016) New Revision: e5755503007b60392b7a15858ea2571c5d94d79e https://github.com/groonga/wikipedia-search/commit/e5755503007b60392b7a15858ea2571c5d94d79e Message: Remove substring It may be needless. Modified files: benchmark/centos7/postgresql.sh config/sql/indexes.textsearch.sql Modified: benchmark/centos7/postgresql.sh (+1 -1) =================================================================== --- benchmark/centos7/postgresql.sh 2016-11-14 00:31:14 +0900 (420d401) +++ benchmark/centos7/postgresql.sh 2016-11-14 00:32:12 +0900 (e08176c) @@ -489,7 +489,7 @@ benchmark_search_textsearch() commands+=("--command" "${enable_seqscan}") commands+=("--command" "\\timing") for i in $(seq ${n_search_tries}); do - target="to_tsvector('english', substring(text from 0 for 1000000))" + target="to_tsvector('english', text)" query="to_tsquery('english', '$(echo ${search_word} | sed -e 's/ OR / | /g')')" where="${target} @@ ${query}" commands+=("--command" "SELECT COUNT(*) FROM wikipedia WHERE ${where}") Modified: config/sql/indexes.textsearch.sql (+1 -1) =================================================================== --- config/sql/indexes.textsearch.sql 2016-11-14 00:31:14 +0900 (4b81caf) +++ config/sql/indexes.textsearch.sql 2016-11-14 00:32:12 +0900 (a7ba14d) @@ -1,3 +1,3 @@ CREATE INDEX wikipedia_index_textsearch ON wikipedia USING GIN (to_tsvector('english', title), - to_tsvector('english', substring(text from 0 for 1000000))); + to_tsvector('english', text)); -------------- next part -------------- HTML����������������������������...下載
