> Lets assume I have: > * single 100GB SSTable file > * min compaction threshold is set to 2 > If I delete rows which are located in this file. Is the only way to "clean" > the deleted rows is by inserting another 100GB of data or by triggering a > painful major compaction?
Major compaction does it, but only if GCGraceSeconds has elapsed. See: http://spyced.blogspot.com/2010/02/distributed-deletes-in-cassandra.html -- / Peter Schuller
