Kouhei Sutou
null+****@clear*****
Sun May 24 11:15:47 JST 2015
Kouhei Sutou 2015-05-24 11:15:47 +0900 (Sun, 24 May 2015) New Revision: e6b6ce7cea859cd7484214c1a1fb30319e5a192a https://github.com/groonga/wikipedia-search/commit/e6b6ce7cea859cd7484214c1a1fb30319e5a192a Message: Increase work_mem Modified files: benchmark/centos6/pgroonga.sh Modified: benchmark/centos6/pgroonga.sh (+15 -0) =================================================================== --- benchmark/centos6/pgroonga.sh 2015-05-24 11:15:27 +0900 (1e8a678) +++ benchmark/centos6/pgroonga.sh 2015-05-24 11:15:47 +0900 (dd6949f) @@ -191,6 +191,20 @@ benchmark_search_pgroonga() done } +benchmark_search_pgroonga_large_work_mem() +{ + work_mem_size='10MB' + work_mem="SET work_mem = '${work_mem_size}';" + cat "${benchmark_dir}/search-words.list" | while read search_word; do + for i in $(seq ${n_search_tries}); do + where="text @@ '${search_word}'" + echo "PGroonga: search: large work_mem(${work_mem_size}): ${where}: ${i}:" + time run sudo -u postgres -H psql -d ${pgroonga_db} \ + --command "${work_mem} SELECT COUNT(*) FROM wikipedia WHERE ${where}" + done + done +} + benchmark_search_pgroonga_force_index_scan() { force_index_scan="SET enable_seqscan = off; SET enable_bitmapscan = off;" @@ -234,5 +248,6 @@ benchmark_create_index_pgroonga benchmark_create_index_pg_bigm benchmark_search_pgroonga +benchmark_search_pgroonga_large_work_mem benchmark_search_pgroonga_force_index_scan benchmark_search_pg_bigm -------------- next part -------------- HTML����������������������������...Download