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...
postgresdba.hashnode.dev4 min read