Speculare
Search…
Data retention
By default (and until configuration is implemented) the data retention is set to 10 days. If you've configured everything and each service are running correctly, you don't have to do anything.
TimescaleDB usesPARTITION instead of regular DELETE ... WHERE created_at ... to avoid any performance impact when deleting a large chunk of data. DELETE on a table with millions of rows can take several minutes and block incoming transactions, whereas DROPing a TABLE (partition) is faster and should not block incoming transactions.
If you want to configure it yourself, you can do so by referring to the TimescaleDB doc about Data retention and here is where we defined the default policy.
Last modified 2mo ago
Copy link