size.sh

% du -hc /share/all/post/base/36915/ #PGroonga 実際利用しているサイズ
518M    /share/all/post/base/36915/
518M    合計

% ls -sl /share/all/post/base/36915/ |awk '{i+=$1} END{print i/1024}' #スパースを考慮して実際利用しているサイズ
517.461

% ls -sl /share/all/post/base/36915/pgrn* |awk '{i+=$1} END{print i/1024}' # Groongaのみが実際に利用しているサイズ
425.984

% ls -l /share/all/post/base/36915/ |awk '{i+=$5} END{print i/1024/1024}' #領域確保した全部
672.625
% groonga-database-inspect /share/all/post/base/36915/pgrn
Database
  Path:             </share/all/post/base/36915/pgrn>
  Total disk usage: 581.160MiB
  Disk usage:       21.266MiB (3.659%)
  N records:        760167
  N tables:         2
  N columns:        2
  Plugins:
    None
  Tables:
    IDs37088:
      ID:               256
      Type:             patricia trie
      Key type:         UInt64
      Tokenizer:        (no tokenizer)
      Normalizer:       (no normalizer)
      Path:             </share/all/post/base/36915/pgrn.0000100>
      Total disk usage: 256.309MiB (44.103%)
      Disk usage:       8.047MiB (1.385%)
      N records:        10000
      N columns:        1
      Columns:
        text:
          ID:         257
          Type:       scalar
          Path:       </share/all/post/base/36915/pgrn.0000101>
          Disk usage: 248.262MiB (42.718%)
    Lexicon37088:
      ID:               258
      Type:             patricia trie
      Key type:         ShortText
      Tokenizer:        TokenBigram
      Normalizer:       NormalizerAuto
      Path:             </share/all/post/base/36915/pgrn.0000102>
      Total disk usage: 303.586MiB (52.238%)
      Disk usage:       20.047MiB (3.449%)
      N records:        750167
      N columns:        1
      Columns:
        index:
          ID:         259
          Type:       index
          Path:       </share/all/post/base/36915/pgrn.0000103>
          Disk usage: 283.539MiB (48.788%)

% du -hc /share/all/post/base/39308/ # pg_bigm
650M    /share/all/post/base/39308/
650M    合計
% ls -sl /share/all/post/base/39308/ |awk '{i+=$1} END{print i/1024}'
649.586
% ls -l /share/all/post/base/39308/ |awk '{i+=$5} END{print i/1024/1024}'
649.566
% du -hc /share/all/post/base/51833/ # indexなし
92M     /share/all/post/base/51833/
92M     合計
%  ls -sl /share/all/post/base/51833/ |awk '{i+=$1} END{print i/1024}'
91.4062
% ls -l /share/all/post/base/51833/ |awk '{i+=$5} END{print i/1024/1024}'
91.3943