database indexes

33 views
Skip to first unread message

bernhard

unread,
Jun 12, 2012, 8:24:18 AM6/12/12
to yourtwap...@googlegroups.com
hi,

half (or sometimes one third) of disk space used by each archive table seems to be used by indexes. especially the fulltext index on the table column 'full' uses considerable disk space.
do you think that removing the index for column 'full' would increase performance when tweets are inserted and decrease disk usage or has adverse effects on performance?

regards,
bernhard
Reply all
Reply to author
Forward
0 new messages