Which type of tombstone occupies less memory?

Question

question

vinoth asked Jun 30, '22 smadhavan edited Jul 11, '22

Which type of tombstone occupies less memory?

A) Which type of tombstone occupies less memory

B) Which type of tombstone will have high performance issue

Types of tombstones

Cell
Row
Range
Partition
TTL
ComplexColumn

tombstones

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

DataStax Enterprise is powered by the best distribution of Apache Cassandra ™

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Privacy Policy Terms of Use

Answer 1 · 2022-07-09T13:45:56Z

Erick Ramirez answered Jul 9, '22

I have to admit your question doesn't make sense to me. Tombstones are deletion markers -- they mark a cell, row, range or partition as deleted.

Tombstones don't have an intrinsic "size" so one type does not occupy more memory compared to another. What matters is how many tombstones there are.

For details, see What are tombstones in Cassandra?. Cheers!

Share

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Answer 2 · 2022-07-11T21:04:34Z

smadhavan answered Jul 11, '22 smadhavan edited Jul 11, '22

If you're asking about what is the preferred way to perform a delete operation, a Partition level delete/tombstone is always recommended. In case, you want to delete an entire table, simply perform the TRUNCATE operation and you don't have to worry about the tombstone generation at all.

Share

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

question