Hi Team CockroachDB,
I would like to purge some of the old data in my table. I have some date column in my table and I need to retain only 6 months of data and rest of them can be purged. What is the best option in CockroachDB to avail this feature. Can we implement the range Partitioning in this Context ? Is it possible to schedule any automation jobs in CockroachDB to perform the Purging Activity? Also I would like to know is there any TTL concepts available in CockroachDB so that after certain interval particular rows in the table got expired?
Thanks and Regards,