TimescaleDB deleting data

TimescaleDB and PostgreSQL
1

Hello, can TimescaleDB delete by itself old data?

Or should that be done intentionally by an application or with a delete command, like regular PostgreSQL?

Thanks

2

Anyone can please reply?

3

Hi @Jack !

You can use one of the following:

  1. Create a data retention policy.
  2. Use a job to create a generic retention policy.

The first approach drops whole chunks.

The second approach also drops whole chunks. But you can rewrite this approach to suit your needs.