Instantly share code, notes, and snippets.

@naoa /size.sh
Last active Aug 29, 2015

Embed
What would you like to do?
% 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment