RocksDB added SingleDelete() support (https://reviews.facebook.net/D43179). This is very useful feature to reduce the number of tombstones, but it has to be used carefully.
In MyRocks, SingleDelete() can be used in the following conditions.
All secondary indexes
Primary indexes if tables have primary key columns only
Read-Modify-Write has to be done (blind write is not allowed)
RocksDB added SingleDelete() support (https://reviews.facebook.net/D43179). This is very useful feature to reduce the number of tombstones, but it has to be used carefully.
In MyRocks, SingleDelete() can be used in the following conditions.
I'll start working on this task after https://reviews.facebook.net/D45873 is committed.