kou
commented
9 years ago http://opscode-vm-bento.s3.amazonaws.com/vagrant/virtualbox/opscode_centos-6.6_chef-provisionerless.box にあるVirtualBoxのイメージを使い、1コアでメモリーを12GiB割り当てた状態で実行したベンチマーク結果。仮想マシンなので物理マシンとは傾向が違うかも。メモリーがもっとあると傾向が違うかも。ホストマシンのディスクはHDDなのでSSDだと傾向は違うかも。
https://github.com/kou/vagrant にあるVagrantfileを使って実行していて、Vagrantの（ホストマシンと仮想マシン間の）ファイル共有機能を使っているので少し手順が違う。
host% git clone https://github.com/kou/vagrant.git
host% git clone https://github.com/groonga/wikipedia-search.git
host% cd vagrant
host% VM_MEMORY=12288 VM_SYNCED_FOLDER=$PWD/../wikipedia-search:/wikipedia-search vagrant up centos-6-x86_64
host% vagrant ssh centos-6-x86_64
virtual-centos6% cd /wikipedia-search
virtual-centos6% benchmark/centos6/pgroonga.sh >& benchmark-log-raw.txt
virtual-centos6% grep -v '^\(DETAIL\|NOTICE\)' benchmark-log-raw.txt > benchmark-log-cleaned.txt
virtual-centos6% exitbenchmark-log-raw.txt（参考）: https://gist.github.com/kou/8071efaac23dfb9a7eac
benchmark-log-cleaned.txt:
CPU:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 58
model name : Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz
stepping : 9
cpu MHz : 3392.937
cache size : 6144 KB
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx rdtscp lm constant_tsc up rep_good pni monitor ssse3 lahf_lm
bogomips : 6785.87
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
Memory:
total used free shared buffers cached
Mem: 12196744 220668 11976076 0 5784 48396
-/+ buffers/cache: 166488 12030256
Swap: 950264 0 950264
警告: /var/tmp/rpm-tmp.fe6Aye: ヘッダ V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
http://yum.postgresql.org/9.4/redhat/rhel-6-x86_64/pgdg-centos94-9.4-1.noarch.rpm を取得中
準備中... ##################################################
pgdg-centos94 ##################################################
警告: /var/tmp/rpm-tmp.Ynm6mU: ヘッダ V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
http://packages.groonga.org/centos/groonga-release-1.1.0-1.noarch.rpm を取得中
準備中... ##################################################
groonga-release ##################################################
Loaded plugins: fastestmirror
Determining fastest mirrors
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Metadata Cache Created
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package postgresql94-pgroonga.x86_64 0:0.5.0-1.el6 will be installed
--> Processing Dependency: postgresql94-server for package: postgresql94-pgroonga-0.5.0-1.el6.x86_64
--> Processing Dependency: groonga-libs for package: postgresql94-pgroonga-0.5.0-1.el6.x86_64
--> Processing Dependency: libgroonga.so.0()(64bit) for package: postgresql94-pgroonga-0.5.0-1.el6.x86_64
--> Running transaction check
---> Package groonga-libs.x86_64 0:5.0.3-1.el6 will be installed
---> Package postgresql94-server.x86_64 0:9.4.2-1PGDG.rhel6 will be installed
--> Processing Dependency: postgresql94 = 9.4.2-1PGDG.rhel6 for package: postgresql94-server-9.4.2-1PGDG.rhel6.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: postgresql94-server-9.4.2-1PGDG.rhel6.x86_64
--> Running transaction check
---> Package postgresql94.x86_64 0:9.4.2-1PGDG.rhel6 will be installed
---> Package postgresql94-libs.x86_64 0:9.4.2-1PGDG.rhel6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
postgresql94-pgroonga x86_64 0.5.0-1.el6 groonga 32 k
Installing for dependencies:
groonga-libs x86_64 5.0.3-1.el6 groonga 1.7 M
postgresql94 x86_64 9.4.2-1PGDG.rhel6 pgdg94 1.0 M
postgresql94-libs x86_64 9.4.2-1PGDG.rhel6 pgdg94 193 k
postgresql94-server x86_64 9.4.2-1PGDG.rhel6 pgdg94 4.3 M
Transaction Summary
================================================================================
Install 5 Package(s)
Total download size: 7.2 M
Installed size: 28 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 85 kB/s | 7.2 MB 01:27
警告: rpmts_HdrFromFdno: ヘッダ V4 DSA/SHA1 Signature, key ID 45499429: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Importing GPG key 0x45499429:
Userid : groonga Key (groonga Official Signing Key) <packages@groonga.org>
Package: groonga-release-1.1.0-1.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-groonga
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : postgresql94-libs-9.4.2-1PGDG.rhel6.x86_64 1/5
Installing : postgresql94-9.4.2-1PGDG.rhel6.x86_64 2/5
Installing : postgresql94-server-9.4.2-1PGDG.rhel6.x86_64 3/5
Installing : groonga-libs-5.0.3-1.el6.x86_64 4/5
Installing : postgresql94-pgroonga-0.5.0-1.el6.x86_64 5/5
Verifying : groonga-libs-5.0.3-1.el6.x86_64 1/5
Verifying : postgresql94-pgroonga-0.5.0-1.el6.x86_64 2/5
Verifying : postgresql94-libs-9.4.2-1PGDG.rhel6.x86_64 3/5
Verifying : postgresql94-server-9.4.2-1PGDG.rhel6.x86_64 4/5
Verifying : postgresql94-9.4.2-1PGDG.rhel6.x86_64 5/5
Installed:
postgresql94-pgroonga.x86_64 0:0.5.0-1.el6
Dependency Installed:
groonga-libs.x86_64 0:5.0.3-1.el6
postgresql94.x86_64 0:9.4.2-1PGDG.rhel6
postgresql94-libs.x86_64 0:9.4.2-1PGDG.rhel6
postgresql94-server.x86_64 0:9.4.2-1PGDG.rhel6
Complete!
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: www.ftp.ne.jp
* extras: www.ftp.ne.jp
* updates: www.ftp.ne.jp
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package groonga-tokenizer-mecab.x86_64 0:5.0.3-1.el6 will be installed
--> Processing Dependency: mecab-dic for package: groonga-tokenizer-mecab-5.0.3-1.el6.x86_64
--> Processing Dependency: libmecab.so.2()(64bit) for package: groonga-tokenizer-mecab-5.0.3-1.el6.x86_64
--> Running transaction check
---> Package mecab.x86_64 0:0.996-1.el6.1 will be installed
---> Package mecab-ipadic.x86_64 0:2.7.0.20070801-10.el6.1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository
Size
================================================================================
Installing:
groonga-tokenizer-mecab x86_64 5.0.3-1.el6 groonga 14 k
Installing for dependencies:
mecab x86_64 0.996-1.el6.1 groonga 353 k
mecab-ipadic x86_64 2.7.0.20070801-10.el6.1 groonga 11 M
Transaction Summary
================================================================================
Install 3 Package(s)
Total download size: 11 M
Installed size: 53 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 1.2 MB/s | 11 MB 00:09
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mecab-0.996-1.el6.1.x86_64 1/3
Installing : mecab-ipadic-2.7.0.20070801-10.el6.1.x86_64 2/3
Installing : groonga-tokenizer-mecab-5.0.3-1.el6.x86_64 3/3
Verifying : groonga-tokenizer-mecab-5.0.3-1.el6.x86_64 1/3
Verifying : mecab-ipadic-2.7.0.20070801-10.el6.1.x86_64 2/3
Verifying : mecab-0.996-1.el6.1.x86_64 3/3
Installed:
groonga-tokenizer-mecab.x86_64 0:5.0.3-1.el6
Dependency Installed:
mecab.x86_64 0:0.996-1.el6.1 mecab-ipadic.x86_64 0:2.7.0.20070801-10.el6.1
Complete!
--2015-05-23 15:00:33-- http://packages.groonga.org/tmp/postgresql94-pgroonga-0.6.0-1.el6.x86_64.rpm
packages.groonga.org をDNSに問いあわせています... 157.7.238.131
packages.groonga.org|157.7.238.131|:80 に接続しています... 接続しました。
HTTP による接続要求を送信しました、応答を待っています... 200 OK
長さ: 32640 (32K) [application/x-redhat-package-manager]
`postgresql94-pgroonga-0.6.0-1.el6.x86_64.rpm' に保存中
0K .......... .......... .......... . 100% 132K=0.2s
2015-05-23 15:00:43 (132 KB/s) - `postgresql94-pgroonga-0.6.0-1.el6.x86_64.rpm' へ保存完了 [32640/32640]
準備中... ##################################################
postgresql94-pgroonga ##################################################
http://jaist.dl.sourceforge.jp/pgbigm/59914/pg_bigm-1.1.20131122-1.pg94.el6.x86_64.rpm を取得中
準備中... ##################################################
pg_bigm ##################################################
Initializing database: [60G[[0;32m OK [0;39m]
Starting postgresql-9.4 service: [60G[[0;32m OK [0;39m]
DROP DATABASE
CREATE DATABASE
CREATE EXTENSION
DROP DATABASE
CREATE DATABASE
CREATE EXTENSION
PGroonga: data: load:
DROP TABLE
CREATE TABLE
real 16m31.870s
user 0m1.393s
sys 1m51.796s
PGroonga: data: load: size:
128K /var/lib/pgsql/9.4/data/base/16384/12735
24K /var/lib/pgsql/9.4/data/base/16384/12735_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12735_vm
140K /var/lib/pgsql/9.4/data/base/16384/12737
24K /var/lib/pgsql/9.4/data/base/16384/12737_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12737_vm
16K /var/lib/pgsql/9.4/data/base/16384/12739
32K /var/lib/pgsql/9.4/data/base/16384/12740
64K /var/lib/pgsql/9.4/data/base/16384/12741
24K /var/lib/pgsql/9.4/data/base/16384/12741_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12741_vm
32K /var/lib/pgsql/9.4/data/base/16384/12743
32K /var/lib/pgsql/9.4/data/base/16384/12744
0 /var/lib/pgsql/9.4/data/base/16384/12749
8.0K /var/lib/pgsql/9.4/data/base/16384/12751
8.0K /var/lib/pgsql/9.4/data/base/16384/12752
344K /var/lib/pgsql/9.4/data/base/16384/12753
24K /var/lib/pgsql/9.4/data/base/16384/12753_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12753_vm
128K /var/lib/pgsql/9.4/data/base/16384/12755
88K /var/lib/pgsql/9.4/data/base/16384/12756
548K /var/lib/pgsql/9.4/data/base/16384/12757
24K /var/lib/pgsql/9.4/data/base/16384/12757_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12757_vm
0 /var/lib/pgsql/9.4/data/base/16384/12759
8.0K /var/lib/pgsql/9.4/data/base/16384/12761
80K /var/lib/pgsql/9.4/data/base/16384/12762
208K /var/lib/pgsql/9.4/data/base/16384/12763
64K /var/lib/pgsql/9.4/data/base/16384/12764
24K /var/lib/pgsql/9.4/data/base/16384/12764_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12764_vm
40K /var/lib/pgsql/9.4/data/base/16384/12766
56K /var/lib/pgsql/9.4/data/base/16384/12767
40K /var/lib/pgsql/9.4/data/base/16384/12768
0 /var/lib/pgsql/9.4/data/base/16384/12769
0 /var/lib/pgsql/9.4/data/base/16384/12771
8.0K /var/lib/pgsql/9.4/data/base/16384/12773
8.0K /var/lib/pgsql/9.4/data/base/16384/12774
8.0K /var/lib/pgsql/9.4/data/base/16384/12775
8.0K /var/lib/pgsql/9.4/data/base/16384/12776
24K /var/lib/pgsql/9.4/data/base/16384/12776_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12776_vm
0 /var/lib/pgsql/9.4/data/base/16384/12778
8.0K /var/lib/pgsql/9.4/data/base/16384/12780
16K /var/lib/pgsql/9.4/data/base/16384/12781
16K /var/lib/pgsql/9.4/data/base/16384/12782
16K /var/lib/pgsql/9.4/data/base/16384/12783
16K /var/lib/pgsql/9.4/data/base/16384/12784
0 /var/lib/pgsql/9.4/data/base/16384/12785
8.0K /var/lib/pgsql/9.4/data/base/16384/12787
8.0K /var/lib/pgsql/9.4/data/base/16384/12788
24K /var/lib/pgsql/9.4/data/base/16384/12789
24K /var/lib/pgsql/9.4/data/base/16384/12789_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12789_vm
16K /var/lib/pgsql/9.4/data/base/16384/12791
16K /var/lib/pgsql/9.4/data/base/16384/12792
120K /var/lib/pgsql/9.4/data/base/16384/12793
24K /var/lib/pgsql/9.4/data/base/16384/12793_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12793_vm
40K /var/lib/pgsql/9.4/data/base/16384/12795
40K /var/lib/pgsql/9.4/data/base/16384/12796
16K /var/lib/pgsql/9.4/data/base/16384/12797
24K /var/lib/pgsql/9.4/data/base/16384/12797_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12797_vm
16K /var/lib/pgsql/9.4/data/base/16384/12799
16K /var/lib/pgsql/9.4/data/base/16384/12800
24K /var/lib/pgsql/9.4/data/base/16384/12801
24K /var/lib/pgsql/9.4/data/base/16384/12801_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12801_vm
16K /var/lib/pgsql/9.4/data/base/16384/12803
16K /var/lib/pgsql/9.4/data/base/16384/12804
8.0K /var/lib/pgsql/9.4/data/base/16384/12805
24K /var/lib/pgsql/9.4/data/base/16384/12805_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12805_vm
16K /var/lib/pgsql/9.4/data/base/16384/12807
16K /var/lib/pgsql/9.4/data/base/16384/12808
40K /var/lib/pgsql/9.4/data/base/16384/12809
24K /var/lib/pgsql/9.4/data/base/16384/12809_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12809_vm
32K /var/lib/pgsql/9.4/data/base/16384/12811
40K /var/lib/pgsql/9.4/data/base/16384/12812
32K /var/lib/pgsql/9.4/data/base/16384/12813
24K /var/lib/pgsql/9.4/data/base/16384/12814
24K /var/lib/pgsql/9.4/data/base/16384/12814_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12814_vm
32K /var/lib/pgsql/9.4/data/base/16384/12816
16K /var/lib/pgsql/9.4/data/base/16384/12817
8.0K /var/lib/pgsql/9.4/data/base/16384/12818
24K /var/lib/pgsql/9.4/data/base/16384/12818_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12818_vm
16K /var/lib/pgsql/9.4/data/base/16384/12820
16K /var/lib/pgsql/9.4/data/base/16384/12821
0 /var/lib/pgsql/9.4/data/base/16384/12822
8.0K /var/lib/pgsql/9.4/data/base/16384/12824
16K /var/lib/pgsql/9.4/data/base/16384/12825
24K /var/lib/pgsql/9.4/data/base/16384/12825_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12825_vm
16K /var/lib/pgsql/9.4/data/base/16384/12827
88K /var/lib/pgsql/9.4/data/base/16384/12828
24K /var/lib/pgsql/9.4/data/base/16384/12828_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12828_vm
344K /var/lib/pgsql/9.4/data/base/16384/12830
24K /var/lib/pgsql/9.4/data/base/16384/12830_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12830_vm
16K /var/lib/pgsql/9.4/data/base/16384/12832
16K /var/lib/pgsql/9.4/data/base/16384/12833
16K /var/lib/pgsql/9.4/data/base/16384/12834
0 /var/lib/pgsql/9.4/data/base/16384/12835
0 /var/lib/pgsql/9.4/data/base/16384/12837
8.0K /var/lib/pgsql/9.4/data/base/16384/12839
8.0K /var/lib/pgsql/9.4/data/base/16384/12840
8.0K /var/lib/pgsql/9.4/data/base/16384/12841
8.0K /var/lib/pgsql/9.4/data/base/16384/12842
0 /var/lib/pgsql/9.4/data/base/16384/12843
8.0K /var/lib/pgsql/9.4/data/base/16384/12845
8.0K /var/lib/pgsql/9.4/data/base/16384/12846
256K /var/lib/pgsql/9.4/data/base/16384/12847
24K /var/lib/pgsql/9.4/data/base/16384/12847_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12847_vm
0 /var/lib/pgsql/9.4/data/base/16384/12849
8.0K /var/lib/pgsql/9.4/data/base/16384/12851
136K /var/lib/pgsql/9.4/data/base/16384/12852
16K /var/lib/pgsql/9.4/data/base/16384/12853
24K /var/lib/pgsql/9.4/data/base/16384/12853_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12853_vm
16K /var/lib/pgsql/9.4/data/base/16384/12855
16K /var/lib/pgsql/9.4/data/base/16384/12856
0 /var/lib/pgsql/9.4/data/base/16384/12857
8.0K /var/lib/pgsql/9.4/data/base/16384/12859
8.0K /var/lib/pgsql/9.4/data/base/16384/12860
8.0K /var/lib/pgsql/9.4/data/base/16384/12861
8.0K /var/lib/pgsql/9.4/data/base/16384/12862
24K /var/lib/pgsql/9.4/data/base/16384/12862_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12862_vm
16K /var/lib/pgsql/9.4/data/base/16384/12864
16K /var/lib/pgsql/9.4/data/base/16384/12865
24K /var/lib/pgsql/9.4/data/base/16384/12866
24K /var/lib/pgsql/9.4/data/base/16384/12866_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12866_vm
16K /var/lib/pgsql/9.4/data/base/16384/12868
16K /var/lib/pgsql/9.4/data/base/16384/12869
16K /var/lib/pgsql/9.4/data/base/16384/12870
400K /var/lib/pgsql/9.4/data/base/16384/12871
24K /var/lib/pgsql/9.4/data/base/16384/12871_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12871_vm
240K /var/lib/pgsql/9.4/data/base/16384/12873
240K /var/lib/pgsql/9.4/data/base/16384/12874
8.0K /var/lib/pgsql/9.4/data/base/16384/12906
24K /var/lib/pgsql/9.4/data/base/16384/12906_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12906_vm
16K /var/lib/pgsql/9.4/data/base/16384/12908
16K /var/lib/pgsql/9.4/data/base/16384/12909
16K /var/lib/pgsql/9.4/data/base/16384/12910
24K /var/lib/pgsql/9.4/data/base/16384/12910_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12910_vm
32K /var/lib/pgsql/9.4/data/base/16384/12912
8.0K /var/lib/pgsql/9.4/data/base/16384/12913
24K /var/lib/pgsql/9.4/data/base/16384/12913_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12913_vm
16K /var/lib/pgsql/9.4/data/base/16384/12915
16K /var/lib/pgsql/9.4/data/base/16384/12916
8.0K /var/lib/pgsql/9.4/data/base/16384/12917
24K /var/lib/pgsql/9.4/data/base/16384/12917_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12917_vm
16K /var/lib/pgsql/9.4/data/base/16384/12919
16K /var/lib/pgsql/9.4/data/base/16384/12920
8.0K /var/lib/pgsql/9.4/data/base/16384/12921
24K /var/lib/pgsql/9.4/data/base/16384/12921_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12921_vm
16K /var/lib/pgsql/9.4/data/base/16384/12923
16K /var/lib/pgsql/9.4/data/base/16384/12924
8.0K /var/lib/pgsql/9.4/data/base/16384/12925
24K /var/lib/pgsql/9.4/data/base/16384/12925_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12925_vm
16K /var/lib/pgsql/9.4/data/base/16384/12927
16K /var/lib/pgsql/9.4/data/base/16384/12928
0 /var/lib/pgsql/9.4/data/base/16384/12929
8.0K /var/lib/pgsql/9.4/data/base/16384/12931
8.0K /var/lib/pgsql/9.4/data/base/16384/12932
0 /var/lib/pgsql/9.4/data/base/16384/12933
8.0K /var/lib/pgsql/9.4/data/base/16384/12935
8.0K /var/lib/pgsql/9.4/data/base/16384/12936
0 /var/lib/pgsql/9.4/data/base/16384/12937
8.0K /var/lib/pgsql/9.4/data/base/16384/12939
0 /var/lib/pgsql/9.4/data/base/16384/12940
8.0K /var/lib/pgsql/9.4/data/base/16384/12942
8.0K /var/lib/pgsql/9.4/data/base/16384/12943
0 /var/lib/pgsql/9.4/data/base/16384/12944
0 /var/lib/pgsql/9.4/data/base/16384/12946
8.0K /var/lib/pgsql/9.4/data/base/16384/12948
8.0K /var/lib/pgsql/9.4/data/base/16384/12949
216K /var/lib/pgsql/9.4/data/base/16384/12953
24K /var/lib/pgsql/9.4/data/base/16384/12953_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12953_vm
40K /var/lib/pgsql/9.4/data/base/16384/12955
48K /var/lib/pgsql/9.4/data/base/16384/12956
8.0K /var/lib/pgsql/9.4/data/base/16384/12957
24K /var/lib/pgsql/9.4/data/base/16384/12957_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12957_vm
16K /var/lib/pgsql/9.4/data/base/16384/12959
0 /var/lib/pgsql/9.4/data/base/16384/12960
8.0K /var/lib/pgsql/9.4/data/base/16384/12962
56K /var/lib/pgsql/9.4/data/base/16384/12963
24K /var/lib/pgsql/9.4/data/base/16384/12963_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12963_vm
0 /var/lib/pgsql/9.4/data/base/16384/12965
8.0K /var/lib/pgsql/9.4/data/base/16384/12967
8.0K /var/lib/pgsql/9.4/data/base/16384/12968
24K /var/lib/pgsql/9.4/data/base/16384/12968_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12968_vm
0 /var/lib/pgsql/9.4/data/base/16384/12970
8.0K /var/lib/pgsql/9.4/data/base/16384/12972
8.0K /var/lib/pgsql/9.4/data/base/16384/12973
24K /var/lib/pgsql/9.4/data/base/16384/12973_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12973_vm
0 /var/lib/pgsql/9.4/data/base/16384/12975
8.0K /var/lib/pgsql/9.4/data/base/16384/12977
8.0K /var/lib/pgsql/9.4/data/base/16384/12978
24K /var/lib/pgsql/9.4/data/base/16384/12978_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12978_vm
0 /var/lib/pgsql/9.4/data/base/16384/12980
8.0K /var/lib/pgsql/9.4/data/base/16384/12982
8.0K /var/lib/pgsql/9.4/data/base/16384/12983
24K /var/lib/pgsql/9.4/data/base/16384/12983_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12983_vm
0 /var/lib/pgsql/9.4/data/base/16384/12985
8.0K /var/lib/pgsql/9.4/data/base/16384/12987
8.0K /var/lib/pgsql/9.4/data/base/16384/12988
24K /var/lib/pgsql/9.4/data/base/16384/12988_fsm
8.0K /var/lib/pgsql/9.4/data/base/16384/12988_vm
0 /var/lib/pgsql/9.4/data/base/16384/12990
8.0K /var/lib/pgsql/9.4/data/base/16384/12992
0 /var/lib/pgsql/9.4/data/base/16384/12993
0 /var/lib/pgsql/9.4/data/base/16384/12995
8.0K /var/lib/pgsql/9.4/data/base/16384/12997
919M /var/lib/pgsql/9.4/data/base/16384/16518
252K /var/lib/pgsql/9.4/data/base/16384/16518_fsm
1.1G /var/lib/pgsql/9.4/data/base/16384/16521
1.1G /var/lib/pgsql/9.4/data/base/16384/16521.1
1006M /var/lib/pgsql/9.4/data/base/16384/16521.2
796K /var/lib/pgsql/9.4/data/base/16384/16521_fsm
38M /var/lib/pgsql/9.4/data/base/16384/16523
40M /var/lib/pgsql/9.4/data/base/16384/16524
4.0K /var/lib/pgsql/9.4/data/base/16384/PG_VERSION
4.0K /var/lib/pgsql/9.4/data/base/16384/pg_filenode.map
116K /var/lib/pgsql/9.4/data/base/16384/pg_internal.init
4.0K /var/lib/pgsql/9.4/data/base/16384/pgrn
28K /var/lib/pgsql/9.4/data/base/16384/pgrn.0000000
24K /var/lib/pgsql/9.4/data/base/16384/pgrn.001
4.0G 合計
pg_bigm: data: load:
DROP TABLE
CREATE TABLE
real 16m24.310s
user 0m1.421s
sys 1m51.561s
pg_biggm: data: load: size:
136K /var/lib/pgsql/9.4/data/base/16496/12735
24K /var/lib/pgsql/9.4/data/base/16496/12735_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12735_vm
132K /var/lib/pgsql/9.4/data/base/16496/12737
24K /var/lib/pgsql/9.4/data/base/16496/12737_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12737_vm
16K /var/lib/pgsql/9.4/data/base/16496/12739
32K /var/lib/pgsql/9.4/data/base/16496/12740
64K /var/lib/pgsql/9.4/data/base/16496/12741
24K /var/lib/pgsql/9.4/data/base/16496/12741_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12741_vm
32K /var/lib/pgsql/9.4/data/base/16496/12743
32K /var/lib/pgsql/9.4/data/base/16496/12744
0 /var/lib/pgsql/9.4/data/base/16496/12749
8.0K /var/lib/pgsql/9.4/data/base/16496/12751
8.0K /var/lib/pgsql/9.4/data/base/16496/12752
344K /var/lib/pgsql/9.4/data/base/16496/12753
24K /var/lib/pgsql/9.4/data/base/16496/12753_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12753_vm
128K /var/lib/pgsql/9.4/data/base/16496/12755
88K /var/lib/pgsql/9.4/data/base/16496/12756
544K /var/lib/pgsql/9.4/data/base/16496/12757
24K /var/lib/pgsql/9.4/data/base/16496/12757_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12757_vm
0 /var/lib/pgsql/9.4/data/base/16496/12759
8.0K /var/lib/pgsql/9.4/data/base/16496/12761
80K /var/lib/pgsql/9.4/data/base/16496/12762
208K /var/lib/pgsql/9.4/data/base/16496/12763
64K /var/lib/pgsql/9.4/data/base/16496/12764
24K /var/lib/pgsql/9.4/data/base/16496/12764_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12764_vm
40K /var/lib/pgsql/9.4/data/base/16496/12766
56K /var/lib/pgsql/9.4/data/base/16496/12767
40K /var/lib/pgsql/9.4/data/base/16496/12768
0 /var/lib/pgsql/9.4/data/base/16496/12769
0 /var/lib/pgsql/9.4/data/base/16496/12771
8.0K /var/lib/pgsql/9.4/data/base/16496/12773
8.0K /var/lib/pgsql/9.4/data/base/16496/12774
8.0K /var/lib/pgsql/9.4/data/base/16496/12775
8.0K /var/lib/pgsql/9.4/data/base/16496/12776
24K /var/lib/pgsql/9.4/data/base/16496/12776_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12776_vm
0 /var/lib/pgsql/9.4/data/base/16496/12778
8.0K /var/lib/pgsql/9.4/data/base/16496/12780
16K /var/lib/pgsql/9.4/data/base/16496/12781
16K /var/lib/pgsql/9.4/data/base/16496/12782
16K /var/lib/pgsql/9.4/data/base/16496/12783
16K /var/lib/pgsql/9.4/data/base/16496/12784
0 /var/lib/pgsql/9.4/data/base/16496/12785
8.0K /var/lib/pgsql/9.4/data/base/16496/12787
8.0K /var/lib/pgsql/9.4/data/base/16496/12788
24K /var/lib/pgsql/9.4/data/base/16496/12789
24K /var/lib/pgsql/9.4/data/base/16496/12789_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12789_vm
16K /var/lib/pgsql/9.4/data/base/16496/12791
16K /var/lib/pgsql/9.4/data/base/16496/12792
112K /var/lib/pgsql/9.4/data/base/16496/12793
24K /var/lib/pgsql/9.4/data/base/16496/12793_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12793_vm
40K /var/lib/pgsql/9.4/data/base/16496/12795
40K /var/lib/pgsql/9.4/data/base/16496/12796
16K /var/lib/pgsql/9.4/data/base/16496/12797
24K /var/lib/pgsql/9.4/data/base/16496/12797_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12797_vm
16K /var/lib/pgsql/9.4/data/base/16496/12799
16K /var/lib/pgsql/9.4/data/base/16496/12800
24K /var/lib/pgsql/9.4/data/base/16496/12801
24K /var/lib/pgsql/9.4/data/base/16496/12801_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12801_vm
16K /var/lib/pgsql/9.4/data/base/16496/12803
16K /var/lib/pgsql/9.4/data/base/16496/12804
8.0K /var/lib/pgsql/9.4/data/base/16496/12805
24K /var/lib/pgsql/9.4/data/base/16496/12805_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12805_vm
16K /var/lib/pgsql/9.4/data/base/16496/12807
16K /var/lib/pgsql/9.4/data/base/16496/12808
32K /var/lib/pgsql/9.4/data/base/16496/12809
24K /var/lib/pgsql/9.4/data/base/16496/12809_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12809_vm
32K /var/lib/pgsql/9.4/data/base/16496/12811
32K /var/lib/pgsql/9.4/data/base/16496/12812
32K /var/lib/pgsql/9.4/data/base/16496/12813
24K /var/lib/pgsql/9.4/data/base/16496/12814
24K /var/lib/pgsql/9.4/data/base/16496/12814_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12814_vm
32K /var/lib/pgsql/9.4/data/base/16496/12816
16K /var/lib/pgsql/9.4/data/base/16496/12817
8.0K /var/lib/pgsql/9.4/data/base/16496/12818
24K /var/lib/pgsql/9.4/data/base/16496/12818_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12818_vm
16K /var/lib/pgsql/9.4/data/base/16496/12820
16K /var/lib/pgsql/9.4/data/base/16496/12821
0 /var/lib/pgsql/9.4/data/base/16496/12822
8.0K /var/lib/pgsql/9.4/data/base/16496/12824
16K /var/lib/pgsql/9.4/data/base/16496/12825
24K /var/lib/pgsql/9.4/data/base/16496/12825_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12825_vm
16K /var/lib/pgsql/9.4/data/base/16496/12827
88K /var/lib/pgsql/9.4/data/base/16496/12828
24K /var/lib/pgsql/9.4/data/base/16496/12828_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12828_vm
344K /var/lib/pgsql/9.4/data/base/16496/12830
24K /var/lib/pgsql/9.4/data/base/16496/12830_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12830_vm
16K /var/lib/pgsql/9.4/data/base/16496/12832
16K /var/lib/pgsql/9.4/data/base/16496/12833
16K /var/lib/pgsql/9.4/data/base/16496/12834
0 /var/lib/pgsql/9.4/data/base/16496/12835
0 /var/lib/pgsql/9.4/data/base/16496/12837
8.0K /var/lib/pgsql/9.4/data/base/16496/12839
8.0K /var/lib/pgsql/9.4/data/base/16496/12840
8.0K /var/lib/pgsql/9.4/data/base/16496/12841
8.0K /var/lib/pgsql/9.4/data/base/16496/12842
0 /var/lib/pgsql/9.4/data/base/16496/12843
8.0K /var/lib/pgsql/9.4/data/base/16496/12845
8.0K /var/lib/pgsql/9.4/data/base/16496/12846
256K /var/lib/pgsql/9.4/data/base/16496/12847
24K /var/lib/pgsql/9.4/data/base/16496/12847_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12847_vm
0 /var/lib/pgsql/9.4/data/base/16496/12849
8.0K /var/lib/pgsql/9.4/data/base/16496/12851
136K /var/lib/pgsql/9.4/data/base/16496/12852
16K /var/lib/pgsql/9.4/data/base/16496/12853
24K /var/lib/pgsql/9.4/data/base/16496/12853_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12853_vm
16K /var/lib/pgsql/9.4/data/base/16496/12855
16K /var/lib/pgsql/9.4/data/base/16496/12856
0 /var/lib/pgsql/9.4/data/base/16496/12857
8.0K /var/lib/pgsql/9.4/data/base/16496/12859
8.0K /var/lib/pgsql/9.4/data/base/16496/12860
8.0K /var/lib/pgsql/9.4/data/base/16496/12861
8.0K /var/lib/pgsql/9.4/data/base/16496/12862
24K /var/lib/pgsql/9.4/data/base/16496/12862_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12862_vm
16K /var/lib/pgsql/9.4/data/base/16496/12864
16K /var/lib/pgsql/9.4/data/base/16496/12865
24K /var/lib/pgsql/9.4/data/base/16496/12866
24K /var/lib/pgsql/9.4/data/base/16496/12866_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12866_vm
16K /var/lib/pgsql/9.4/data/base/16496/12868
16K /var/lib/pgsql/9.4/data/base/16496/12869
16K /var/lib/pgsql/9.4/data/base/16496/12870
392K /var/lib/pgsql/9.4/data/base/16496/12871
24K /var/lib/pgsql/9.4/data/base/16496/12871_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12871_vm
240K /var/lib/pgsql/9.4/data/base/16496/12873
232K /var/lib/pgsql/9.4/data/base/16496/12874
8.0K /var/lib/pgsql/9.4/data/base/16496/12906
24K /var/lib/pgsql/9.4/data/base/16496/12906_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12906_vm
16K /var/lib/pgsql/9.4/data/base/16496/12908
16K /var/lib/pgsql/9.4/data/base/16496/12909
16K /var/lib/pgsql/9.4/data/base/16496/12910
24K /var/lib/pgsql/9.4/data/base/16496/12910_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12910_vm
32K /var/lib/pgsql/9.4/data/base/16496/12912
8.0K /var/lib/pgsql/9.4/data/base/16496/12913
24K /var/lib/pgsql/9.4/data/base/16496/12913_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12913_vm
16K /var/lib/pgsql/9.4/data/base/16496/12915
16K /var/lib/pgsql/9.4/data/base/16496/12916
8.0K /var/lib/pgsql/9.4/data/base/16496/12917
24K /var/lib/pgsql/9.4/data/base/16496/12917_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12917_vm
16K /var/lib/pgsql/9.4/data/base/16496/12919
16K /var/lib/pgsql/9.4/data/base/16496/12920
8.0K /var/lib/pgsql/9.4/data/base/16496/12921
24K /var/lib/pgsql/9.4/data/base/16496/12921_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12921_vm
16K /var/lib/pgsql/9.4/data/base/16496/12923
16K /var/lib/pgsql/9.4/data/base/16496/12924
8.0K /var/lib/pgsql/9.4/data/base/16496/12925
24K /var/lib/pgsql/9.4/data/base/16496/12925_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12925_vm
16K /var/lib/pgsql/9.4/data/base/16496/12927
16K /var/lib/pgsql/9.4/data/base/16496/12928
0 /var/lib/pgsql/9.4/data/base/16496/12929
8.0K /var/lib/pgsql/9.4/data/base/16496/12931
8.0K /var/lib/pgsql/9.4/data/base/16496/12932
0 /var/lib/pgsql/9.4/data/base/16496/12933
8.0K /var/lib/pgsql/9.4/data/base/16496/12935
8.0K /var/lib/pgsql/9.4/data/base/16496/12936
0 /var/lib/pgsql/9.4/data/base/16496/12937
8.0K /var/lib/pgsql/9.4/data/base/16496/12939
0 /var/lib/pgsql/9.4/data/base/16496/12940
8.0K /var/lib/pgsql/9.4/data/base/16496/12942
8.0K /var/lib/pgsql/9.4/data/base/16496/12943
0 /var/lib/pgsql/9.4/data/base/16496/12944
0 /var/lib/pgsql/9.4/data/base/16496/12946
8.0K /var/lib/pgsql/9.4/data/base/16496/12948
8.0K /var/lib/pgsql/9.4/data/base/16496/12949
216K /var/lib/pgsql/9.4/data/base/16496/12953
24K /var/lib/pgsql/9.4/data/base/16496/12953_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12953_vm
40K /var/lib/pgsql/9.4/data/base/16496/12955
48K /var/lib/pgsql/9.4/data/base/16496/12956
8.0K /var/lib/pgsql/9.4/data/base/16496/12957
24K /var/lib/pgsql/9.4/data/base/16496/12957_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12957_vm
16K /var/lib/pgsql/9.4/data/base/16496/12959
0 /var/lib/pgsql/9.4/data/base/16496/12960
8.0K /var/lib/pgsql/9.4/data/base/16496/12962
56K /var/lib/pgsql/9.4/data/base/16496/12963
24K /var/lib/pgsql/9.4/data/base/16496/12963_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12963_vm
0 /var/lib/pgsql/9.4/data/base/16496/12965
8.0K /var/lib/pgsql/9.4/data/base/16496/12967
8.0K /var/lib/pgsql/9.4/data/base/16496/12968
24K /var/lib/pgsql/9.4/data/base/16496/12968_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12968_vm
0 /var/lib/pgsql/9.4/data/base/16496/12970
8.0K /var/lib/pgsql/9.4/data/base/16496/12972
8.0K /var/lib/pgsql/9.4/data/base/16496/12973
24K /var/lib/pgsql/9.4/data/base/16496/12973_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12973_vm
0 /var/lib/pgsql/9.4/data/base/16496/12975
8.0K /var/lib/pgsql/9.4/data/base/16496/12977
8.0K /var/lib/pgsql/9.4/data/base/16496/12978
24K /var/lib/pgsql/9.4/data/base/16496/12978_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12978_vm
0 /var/lib/pgsql/9.4/data/base/16496/12980
8.0K /var/lib/pgsql/9.4/data/base/16496/12982
8.0K /var/lib/pgsql/9.4/data/base/16496/12983
24K /var/lib/pgsql/9.4/data/base/16496/12983_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12983_vm
0 /var/lib/pgsql/9.4/data/base/16496/12985
8.0K /var/lib/pgsql/9.4/data/base/16496/12987
8.0K /var/lib/pgsql/9.4/data/base/16496/12988
24K /var/lib/pgsql/9.4/data/base/16496/12988_fsm
8.0K /var/lib/pgsql/9.4/data/base/16496/12988_vm
0 /var/lib/pgsql/9.4/data/base/16496/12990
8.0K /var/lib/pgsql/9.4/data/base/16496/12992
0 /var/lib/pgsql/9.4/data/base/16496/12993
0 /var/lib/pgsql/9.4/data/base/16496/12995
8.0K /var/lib/pgsql/9.4/data/base/16496/12997
919M /var/lib/pgsql/9.4/data/base/16496/543116
252K /var/lib/pgsql/9.4/data/base/16496/543116_fsm
1.1G /var/lib/pgsql/9.4/data/base/16496/543119
1.1G /var/lib/pgsql/9.4/data/base/16496/543119.1
1006M /var/lib/pgsql/9.4/data/base/16496/543119.2
796K /var/lib/pgsql/9.4/data/base/16496/543119_fsm
38M /var/lib/pgsql/9.4/data/base/16496/543121
40M /var/lib/pgsql/9.4/data/base/16496/543122
4.0K /var/lib/pgsql/9.4/data/base/16496/PG_VERSION
4.0K /var/lib/pgsql/9.4/data/base/16496/pg_filenode.map
116K /var/lib/pgsql/9.4/data/base/16496/pg_internal.init
4.0G 合計
PGroonga: create index: 1:
DROP INDEX
CREATE INDEX
real 25m37.365s
user 0m0.000s
sys 0m0.011s
PGroonga: create index: size:
4.0K /var/lib/pgsql/9.4/data/base/16384/pgrn
40K /var/lib/pgsql/9.4/data/base/16384/pgrn.0000000
232K /var/lib/pgsql/9.4/data/base/16384/pgrn.0000100
15M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000101
78M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000102
12M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000103
9.8M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000104
33M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000104.c
859M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105
861M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.001
888M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.002
910M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.003
921M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.004
922M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.005
923M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.006
921M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.007
907M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.008
159M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000105.009
131M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000106
84M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107
27M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107.001
792M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107.c
799M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107.c.001
773M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107.c.002
747M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107.c.003
786M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107.c.004
791M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107.c.005
103M /var/lib/pgsql/9.4/data/base/16384/pgrn.0000107.c.006
28K /var/lib/pgsql/9.4/data/base/16384/pgrn.001
14G 合計
pg_bigm: create index: 1:
DROP INDEX
CREATE INDEX
real 356m15.657s
user 0m0.003s
sys 0m0.014s
pg_bigm: create index: size:
1.1G /var/lib/pgsql/9.4/data/base/16496/1069723
1.1G /var/lib/pgsql/9.4/data/base/16496/1069723.1
1.1G /var/lib/pgsql/9.4/data/base/16496/1069723.2
589M /var/lib/pgsql/9.4/data/base/16496/1069723.3
3.6G 合計
PGroonga: search: text @@ 'テレビアニメ': 1:
count
-------
22885
(1 行)
real 0m32.063s
user 0m0.000s
sys 0m0.009s
PGroonga: search: text @@ 'テレビアニメ': 2:
count
-------
22885
(1 行)
real 0m0.252s
user 0m0.001s
sys 0m0.007s
PGroonga: search: text @@ 'テレビアニメ': 3:
count
-------
22885
(1 行)
real 0m0.197s
user 0m0.001s
sys 0m0.001s
PGroonga: search: text @@ 'テレビアニメ': 4:
count
-------
22885
(1 行)
real 0m0.207s
user 0m0.001s
sys 0m0.002s
PGroonga: search: text @@ 'テレビアニメ': 5:
count
-------
22885
(1 行)
real 0m0.214s
user 0m0.004s
sys 0m0.003s
PGroonga: search: text @@ 'テレビアニメ': 6:
count
-------
22885
(1 行)
real 0m0.218s
user 0m0.001s
sys 0m0.002s
PGroonga: search: text @@ 'テレビアニメ': 7:
count
-------
22885
(1 行)
real 0m0.223s
user 0m0.001s
sys 0m0.002s
PGroonga: search: text @@ 'テレビアニメ': 8:
count
-------
22885
(1 行)
real 0m0.225s
user 0m0.000s
sys 0m0.005s
PGroonga: search: text @@ 'テレビアニメ': 9:
count
-------
22885
(1 行)
real 0m0.330s
user 0m0.000s
sys 0m0.011s
PGroonga: search: text @@ 'テレビアニメ': 10:
count
-------
22885
(1 行)
real 0m0.233s
user 0m0.000s
sys 0m0.001s
PGroonga: search: text @@ 'データベース': 1:
count
-------
17172
(1 行)
real 0m27.463s
user 0m0.003s
sys 0m0.006s
PGroonga: search: text @@ 'データベース': 2:
count
-------
17172
(1 行)
real 0m0.191s
user 0m0.000s
sys 0m0.003s
PGroonga: search: text @@ 'データベース': 3:
count
-------
17172
(1 行)
real 0m0.134s
user 0m0.003s
sys 0m0.000s
PGroonga: search: text @@ 'データベース': 4:
count
-------
17172
(1 行)
real 0m0.129s
user 0m0.000s
sys 0m0.000s
PGroonga: search: text @@ 'データベース': 5:
count
-------
17172
(1 行)
real 0m0.127s
user 0m0.000s
sys 0m0.001s
PGroonga: search: text @@ 'データベース': 6:
count
-------
17172
(1 行)
real 0m0.126s
user 0m0.000s
sys 0m0.003s
PGroonga: search: text @@ 'データベース': 7:
count
-------
17172
(1 行)
real 0m0.128s
user 0m0.000s
sys 0m0.001s
PGroonga: search: text @@ 'データベース': 8:
count
-------
17172
(1 行)
real 0m0.128s
user 0m0.003s
sys 0m0.003s
PGroonga: search: text @@ 'データベース': 9:
count
-------
17172
(1 行)
real 0m0.126s
user 0m0.002s
sys 0m0.005s
PGroonga: search: text @@ 'データベース': 10:
count
-------
17172
(1 行)
real 0m0.128s
user 0m0.000s
sys 0m0.001s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 1:
count
-------
368
(1 行)
real 0m0.862s
user 0m0.000s
sys 0m0.000s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 2:
count
-------
368
(1 行)
real 0m0.066s
user 0m0.005s
sys 0m0.011s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 3:
count
-------
368
(1 行)
real 0m0.052s
user 0m0.015s
sys 0m0.003s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 4:
count
-------
368
(1 行)
real 0m0.042s
user 0m0.000s
sys 0m0.004s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 5:
count
-------
368
(1 行)
real 0m0.041s
user 0m0.007s
sys 0m0.005s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 6:
count
-------
368
(1 行)
real 0m0.034s
user 0m0.003s
sys 0m0.003s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 7:
count
-------
368
(1 行)
real 0m0.033s
user 0m0.000s
sys 0m0.001s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 8:
count
-------
368
(1 行)
real 0m0.034s
user 0m0.000s
sys 0m0.005s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 9:
count
-------
368
(1 行)
real 0m0.030s
user 0m0.000s
sys 0m0.003s
PGroonga: search: text @@ 'PostgreSQL OR MySQL': 10:
count
-------
368
(1 行)
real 0m0.031s
user 0m0.005s
sys 0m0.000s
PGroonga: search: text @@ '日本': 1:
count
--------
329043
(1 行)
real 9m22.154s
user 0m0.020s
sys 0m3.620s
PGroonga: search: text @@ '日本': 2:
count
--------
329043
(1 行)
real 7m17.811s
user 0m0.038s
sys 0m6.248s
PGroonga: search: text @@ '日本': 3:
count
--------
329043
(1 行)
real 7m11.520s
user 0m0.025s
sys 0m6.486s
PGroonga: search: text @@ '日本': 4:
count
--------
329043
(1 行)
real 7m14.401s
user 0m0.000s
sys 0m6.468s
PGroonga: search: text @@ '日本': 5:
count
--------
329043
(1 行)
real 7m14.736s
user 0m0.030s
sys 0m6.660s
PGroonga: search: text @@ '日本': 6:
count
--------
329043
(1 行)
real 7m12.325s
user 0m0.000s
sys 0m6.888s
PGroonga: search: text @@ '日本': 7:
count
--------
329043
(1 行)
real 7m12.095s
user 0m0.002s
sys 0m6.829s
PGroonga: search: text @@ '日本': 8:
count
--------
329043
(1 行)
real 7m11.560s
user 0m0.000s
sys 0m7.086s
PGroonga: search: text @@ '日本': 9:
count
--------
329043
(1 行)
real 7m14.173s
user 0m0.006s
sys 0m7.101s
PGroonga: search: text @@ '日本': 10:
count
--------
329043
(1 行)
real 7m12.047s
user 0m0.059s
sys 0m6.663s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 1:
count
-------
22885
(1 行)
real 0m0.295s
user 0m0.006s
sys 0m0.005s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 2:
count
-------
22885
(1 行)
real 0m0.186s
user 0m0.006s
sys 0m0.001s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 3:
count
-------
22885
(1 行)
real 0m0.182s
user 0m0.002s
sys 0m0.005s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 4:
count
-------
22885
(1 行)
real 0m0.182s
user 0m0.003s
sys 0m0.000s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 5:
count
-------
22885
(1 行)
real 0m0.179s
user 0m0.000s
sys 0m0.000s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 6:
count
-------
22885
(1 行)
real 0m0.184s
user 0m0.000s
sys 0m0.001s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 7:
count
-------
22885
(1 行)
real 0m0.181s
user 0m0.000s
sys 0m0.002s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 8:
count
-------
22885
(1 行)
real 0m0.181s
user 0m0.000s
sys 0m0.002s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 9:
count
-------
22885
(1 行)
real 0m0.187s
user 0m0.000s
sys 0m0.000s
PGroonga: search: force index scan: text @@ 'テレビアニメ': 10:
count
-------
22885
(1 行)
real 0m0.184s
user 0m0.000s
sys 0m0.003s
PGroonga: search: force index scan: text @@ 'データベース': 1:
count
-------
17172
(1 行)
real 0m0.391s
user 0m0.004s
sys 0m0.011s
PGroonga: search: force index scan: text @@ 'データベース': 2:
count
-------
17172
(1 行)
real 0m0.166s
user 0m0.000s
sys 0m0.001s
PGroonga: search: force index scan: text @@ 'データベース': 3:
count
-------
17172
(1 行)
real 0m0.130s
user 0m0.003s
sys 0m0.000s
PGroonga: search: force index scan: text @@ 'データベース': 4:
count
-------
17172
(1 行)
real 0m0.127s
user 0m0.002s
sys 0m0.002s
PGroonga: search: force index scan: text @@ 'データベース': 5:
count
-------
17172
(1 行)
real 0m0.129s
user 0m0.008s
sys 0m0.007s
PGroonga: search: force index scan: text @@ 'データベース': 6:
count
-------
17172
(1 行)
real 0m0.123s
user 0m0.002s
sys 0m0.003s
PGroonga: search: force index scan: text @@ 'データベース': 7:
count
-------
17172
(1 行)
real 0m0.126s
user 0m0.001s
sys 0m0.000s
PGroonga: search: force index scan: text @@ 'データベース': 8:
count
-------
17172
(1 行)
real 0m0.127s
user 0m0.000s
sys 0m0.003s
PGroonga: search: force index scan: text @@ 'データベース': 9:
count
-------
17172
(1 行)
real 0m0.121s
user 0m0.002s
sys 0m0.003s
PGroonga: search: force index scan: text @@ 'データベース': 10:
count
-------
17172
(1 行)
real 0m0.126s
user 0m0.000s
sys 0m0.006s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 1:
count
-------
368
(1 行)
real 0m0.031s
user 0m0.002s
sys 0m0.003s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 2:
count
-------
368
(1 行)
real 0m0.038s
user 0m0.007s
sys 0m0.010s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 3:
count
-------
368
(1 行)
real 0m0.030s
user 0m0.002s
sys 0m0.000s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 4:
count
-------
368
(1 行)
real 0m0.034s
user 0m0.000s
sys 0m0.001s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 5:
count
-------
368
(1 行)
real 0m0.032s
user 0m0.001s
sys 0m0.004s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 6:
count
-------
368
(1 行)
real 0m0.037s
user 0m0.000s
sys 0m0.012s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 7:
count
-------
368
(1 行)
real 0m0.031s
user 0m0.002s
sys 0m0.003s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 8:
count
-------
368
(1 行)
real 0m0.032s
user 0m0.001s
sys 0m0.000s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 9:
count
-------
368
(1 行)
real 0m0.032s
user 0m0.005s
sys 0m0.001s
PGroonga: search: force index scan: text @@ 'PostgreSQL OR MySQL': 10:
count
-------
368
(1 行)
real 0m0.032s
user 0m0.003s
sys 0m0.003s
PGroonga: search: force index scan: text @@ '日本': 1:
count
--------
625792
(1 行)
real 0m0.647s
user 0m0.005s
sys 0m0.001s
PGroonga: search: force index scan: text @@ '日本': 2:
count
--------
625792
(1 行)
real 0m0.655s
user 0m0.005s
sys 0m0.001s
PGroonga: search: force index scan: text @@ '日本': 3:
count
--------
625792
(1 行)
real 0m0.657s
user 0m0.000s
sys 0m0.001s
PGroonga: search: force index scan: text @@ '日本': 4:
count
--------
625792
(1 行)
real 0m0.652s
user 0m0.002s
sys 0m0.003s
PGroonga: search: force index scan: text @@ '日本': 5:
count
--------
625792
(1 行)
real 0m0.653s
user 0m0.000s
sys 0m0.001s
PGroonga: search: force index scan: text @@ '日本': 6:
count
--------
625792
(1 行)
real 0m0.648s
user 0m0.005s
sys 0m0.000s
PGroonga: search: force index scan: text @@ '日本': 7:
count
--------
625792
(1 行)
real 0m0.653s
user 0m0.000s
sys 0m0.002s
PGroonga: search: force index scan: text @@ '日本': 8:
count
--------
625792
(1 行)
real 0m0.658s
user 0m0.000s
sys 0m0.007s
PGroonga: search: force index scan: text @@ '日本': 9:
count
--------
625792
(1 行)
real 0m0.646s
user 0m0.000s
sys 0m0.002s
PGroonga: search: force index scan: text @@ '日本': 10:
count
--------
625792
(1 行)
real 0m0.653s
user 0m0.000s
sys 0m0.001s
pg_bigm: search: text LIKE '%テレビアニメ%': 1:
count
-------
22885
(1 行)
real 0m14.304s
user 0m0.002s
sys 0m0.002s
pg_bigm: search: text LIKE '%テレビアニメ%': 2:
count
-------
22885
(1 行)
real 0m2.539s
user 0m0.003s
sys 0m0.003s
pg_bigm: search: text LIKE '%テレビアニメ%': 3:
count
-------
22885
(1 行)
real 0m2.476s
user 0m0.003s
sys 0m0.001s
pg_bigm: search: text LIKE '%テレビアニメ%': 4:
count
-------
22885
(1 行)
real 0m2.497s
user 0m0.002s
sys 0m0.000s
pg_bigm: search: text LIKE '%テレビアニメ%': 5:
count
-------
22885
(1 行)
real 0m2.472s
user 0m0.002s
sys 0m0.001s
pg_bigm: search: text LIKE '%テレビアニメ%': 6:
count
-------
22885
(1 行)
real 0m2.479s
user 0m0.002s
sys 0m0.004s
pg_bigm: search: text LIKE '%テレビアニメ%': 7:
count
-------
22885
(1 行)
real 0m2.472s
user 0m0.002s
sys 0m0.000s
pg_bigm: search: text LIKE '%テレビアニメ%': 8:
count
-------
22885
(1 行)
real 0m2.494s
user 0m0.002s
sys 0m0.003s
pg_bigm: search: text LIKE '%テレビアニメ%': 9:
count
-------
22885
(1 行)
real 0m2.476s
user 0m0.003s
sys 0m0.001s
pg_bigm: search: text LIKE '%テレビアニメ%': 10:
count
-------
22885
(1 行)
real 0m2.483s
user 0m0.002s
sys 0m0.003s
pg_bigm: search: text LIKE '%データベース%': 1:
count
-------
17168
(1 行)
real 0m10.267s
user 0m0.004s
sys 0m0.001s
pg_bigm: search: text LIKE '%データベース%': 2:
count
-------
17168
(1 行)
real 0m1.271s
user 0m0.004s
sys 0m0.004s
pg_bigm: search: text LIKE '%データベース%': 3:
count
-------
17168
(1 行)
real 0m1.226s
user 0m0.002s
sys 0m0.003s
pg_bigm: search: text LIKE '%データベース%': 4:
count
-------
17168
(1 行)
real 0m1.232s
user 0m0.004s
sys 0m0.002s
pg_bigm: search: text LIKE '%データベース%': 5:
count
-------
17168
(1 行)
real 0m1.224s
user 0m0.000s
sys 0m0.002s
pg_bigm: search: text LIKE '%データベース%': 6:
count
-------
17168
(1 行)
real 0m1.231s
user 0m0.002s
sys 0m0.001s
pg_bigm: search: text LIKE '%データベース%': 7:
count
-------
17168
(1 行)
real 0m1.224s
user 0m0.000s
sys 0m0.002s
pg_bigm: search: text LIKE '%データベース%': 8:
count
-------
17168
(1 行)
real 0m1.236s
user 0m0.002s
sys 0m0.002s
pg_bigm: search: text LIKE '%データベース%': 9:
count
-------
17168
(1 行)
real 0m1.224s
user 0m0.002s
sys 0m0.002s
pg_bigm: search: text LIKE '%データベース%': 10:
count
-------
17168
(1 行)
real 0m1.224s
user 0m0.000s
sys 0m0.002s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 1:
count
-------
361
(1 行)
real 0m0.211s
user 0m0.002s
sys 0m0.002s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 2:
count
-------
361
(1 行)
real 0m0.124s
user 0m0.001s
sys 0m0.003s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 3:
count
-------
361
(1 行)
real 0m0.108s
user 0m0.002s
sys 0m0.002s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 4:
count
-------
361
(1 行)
real 0m0.108s
user 0m0.001s
sys 0m0.001s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 5:
count
-------
361
(1 行)
real 0m0.107s
user 0m0.003s
sys 0m0.000s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 6:
count
-------
361
(1 行)
real 0m0.109s
user 0m0.003s
sys 0m0.007s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 7:
count
-------
361
(1 行)
real 0m0.108s
user 0m0.004s
sys 0m0.006s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 8:
count
-------
361
(1 行)
real 0m0.108s
user 0m0.002s
sys 0m0.005s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 9:
count
-------
361
(1 行)
real 0m0.108s
user 0m0.002s
sys 0m0.003s
pg_bigm: search: text LIKE '%PostgreSQL%' OR text LIKE '%MySQL%': 10:
count
-------
361
(1 行)
real 0m0.112s
user 0m0.005s
sys 0m0.006s
pg_bigm: search: text LIKE '%日本%': 1:
count
--------
625792
(1 行)
real 0m56.948s
user 0m0.002s
sys 0m0.004s
pg_bigm: search: text LIKE '%日本%': 2:
count
--------
625792
(1 行)
real 0m15.349s
user 0m0.003s
sys 0m0.000s
pg_bigm: search: text LIKE '%日本%': 3:
count
--------
625792
(1 行)
real 0m15.228s
user 0m0.000s
sys 0m0.006s
pg_bigm: search: text LIKE '%日本%': 4:
count
--------
625792
(1 行)
real 0m15.217s
user 0m0.003s
sys 0m0.002s
pg_bigm: search: text LIKE '%日本%': 5:
count
--------
625792
(1 行)
real 0m15.201s
user 0m0.002s
sys 0m0.003s
pg_bigm: search: text LIKE '%日本%': 6:
count
--------
625792
(1 行)
real 0m15.195s
user 0m0.001s
sys 0m0.005s
pg_bigm: search: text LIKE '%日本%': 7:
count
--------
625792
(1 行)
real 0m15.219s
user 0m0.002s
sys 0m0.002s
pg_bigm: search: text LIKE '%日本%': 8:
count
--------
625792
(1 行)
real 0m15.248s
user 0m0.002s
sys 0m0.003s
pg_bigm: search: text LIKE '%日本%': 9:
count
--------
625792
(1 行)
real 0m15.222s
user 0m0.000s
sys 0m0.006s
pg_bigm: search: text LIKE '%日本%': 10:
count
--------
625792
(1 行)
real 0m15.202s
user 0m0.003s
sys 0m0.000s
hnakamur
naoa
このリポジトリーに含まれるベンチマークを実行してその結果を貼る。
ベンチマークを実行するためにはクリーンな（インストール直後）のCentOS 6 x86_64が必要。ベンチマークを実行するユーザーは
sudoでrootユーザーとpostgresユーザーになれること。ベンチマークの実行方法は次の通り。
最後にできる
benchmark-log-cleaned.txtをここに貼り付ける。なお、↑のベンチマークスクリプトの内容は次の通り。
実行するクエリーは https://github.com/groonga/wikipedia-search/blob/master/benchmark/search-words.list にある。
少ししかヒットしないクエリーとややヒット数が多いクエリーとかなりヒット数が多いクエリーがある。
日本語Wikipediaのデータなので、データは次の傾向がある。
テキストが長いレコードはpg_bigmは苦手（Recheckのコストが大きくなりやすい）なので、PGroongaに有利なベンチマークである。