On Mon, Sep 10, 2018 at 10:03 PM Jeff Jirsa <jji...@gmail.com> wrote:
> How much free space do you have, and how big is the table? > So there are 2 tables, one is around 120GB and the other is around 250GB on every node. On the node with the most free disk space we still have around 500GB available and on the node with the least free space: 300GB. So if I understand it correctly, we could still do major compaction while keeping STCS and we should not hit 100% disk space, if we first compact one of the tables, and then the other (we expect quite some free space to become available due to to all those TTL tombstones being removed in the process). Is there any real drawback of having a single big SSTable in our case where we never going to append more data to the table? Switching to LCS is another option. > Hm, this is interesting idea. The expectation should be that even if we don't remove 100% of the tombstones, we should be able to get rid of 90% them on the highest level, right? And if we would have less space available, using LCS could make progress by re-organizing the partitions in smaller increments, so we could still do it if we had less free space than the smallest table? Cheers, -- Alex