Re:Feature Casualties of Large Databases
by Uberphallus on Wednesday December 02, 2020 @06:21AM
(#25275397)
Deletes leave tombstones and performance plummets pretty much like in Cassandra. If your app doesn't do many deletes (<2-3% of operations in my experience) it can work fine. You can lower gc_ttl but that will limit having consistent/complete backups.
For example, CockroachDB (https://www.cockroachlabs.com/) aims to support extremely large databases in a distributed fashion, and does not compromise on any of the points the author raises.