Minimum suggested value for gc.ttlseconds?

I have a database that has many heavy-duty tables (e.g. lots of writes and the deletes). I don’t need the historical data to be available, and I’d like to reclaim the used space as soon as possible. What is the minimum value I could use for gc.ttlseconds that is still considered safe for a longer time? <1 minute? <5 minute? even more?

Hi @syntern,

According to the this page in the documentation, the minimum value for gc.ttlseconds that is recommended is 600 seconds (10 minutes). Setting it below 10 minutes will cause problems for long-running queries.

Regards,
Florence
Technical Support Engineer