Data Retention Policies: Automating Cleanup in TimescaleDB

Stop Using DELETE for Time-Series Cleanup: TimescaleDB Retention Policies If you are running DELETE FROM metrics WHERE timestamp < now() - INTERVAL '30 days' on a cron job, you are doing it the hard way. That single statement on a 500 GB table create...