Kouhei Sutou
null+****@clear*****
Mon May 25 12:15:31 JST 2015
Kouhei Sutou 2015-05-25 12:15:31 +0900 (Mon, 25 May 2015) New Revision: 960aedf9eefcbd9d7647898771dbb357251cc415 https://github.com/groonga/wikipedia-search/commit/960aedf9eefcbd9d7647898771dbb357251cc415 Message: Add large work_mem case to pg_bigm Modified files: benchmark/centos6/pgroonga.sh Modified: benchmark/centos6/pgroonga.sh (+16 -0) =================================================================== --- benchmark/centos6/pgroonga.sh 2015-05-24 11:15:47 +0900 (dd6949f) +++ benchmark/centos6/pgroonga.sh 2015-05-25 12:15:31 +0900 (8702354) @@ -231,6 +231,21 @@ benchmark_search_pg_bigm() done } +benchmark_search_pg_bigm_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 LIKE '%${search_word}%'" + where=$(echo $where | sed -e "s/ OR /%' OR text LIKE '%/g") + echo "pg_bigm: search: large work_mem(${work_mem_size}): ${where}: ${i}:" + time run sudo -u postgres -H psql -d ${pg_bigm_db} \ + --command "${work_mem} SELECT COUNT(*) FROM wikipedia WHERE ${where}" + done + done +} + show_environment ensure_data @@ -251,3 +266,4 @@ benchmark_search_pgroonga benchmark_search_pgroonga_large_work_mem benchmark_search_pgroonga_force_index_scan benchmark_search_pg_bigm +benchmark_search_pg_bigm_large_work_mem -------------- next part -------------- HTML����������������������������...Download