The issue with major / manual compaction is that it creates a one file. One big old file.
That one file will not be compacted unless there are (min_compaction_threshold -1) other files of a similar size. So thombstones and overwrites in that file may not be purged for a long time. If you go down the manual compaction path you need to keep doing it. If you feel you need to do it do it, otherwise let automatic compaction do it's thing. Cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/01/2012, at 12:47 PM, Roshan wrote: > Thanks for the reply. Is the major compaction not recommended for Cassandra > 1.0.6? > > -- > View this message in context: > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Different-size-of-SSTable-are-remain-in-the-system-without-compact-tp7218239p7222322.html > Sent from the cassandra-u...@incubator.apache.org mailing list archive at > Nabble.com.