I read in some cassandra notes that each node should be allocated twice the storage capacity you wish it to contain. I think the reason was during compaction another copy of SSTables have to be made before the original ones are discarded.
Can someone confirm if that is actually true ? During compaction, don't just a few SSTables are involved. Why should it be twice the full storage ? If I keep some buffer, it really means that I can use 40% or so space only. Many thanks.