Hi,
I am trying to find a way to setup TTL in foundationdb to auto expire the documents. Can someone please help if you have implemented this feature. Appreciate your help.
Thanks
Hi,
I am trying to find a way to setup TTL in foundationdb to auto expire the documents. Can someone please help if you have implemented this feature. Appreciate your help.
Thanks
FWIW, I also needed this, and I’m doing this manually.
I would do it this way:
If you have a very large number of documents, instead of the index (expires_at, document_id) you can create a (logical_partition, expires_at, document_id) so that frequent writes of the index will hit different storage nodes and also you can parallelize the background batch process.
Wouldn’t it be possible to add the possibility to delete data from a key range if said data has a version older than a threshold? This would make it easy to implement a TTL mechanism.
A scan could also benefit from the possibility to only read data within a given version range.