chore: enhance time retention policy in Postgres

[Ivansete-status]

Background

The current retention policy in Postgres just deletes old rows and therefore, the disk space occupied by the database remains the same. In this task, we are going to also remove older partitions so that we can effectively reduce the database size in disk.

Nowadays the dataset is split into 1-hour partitions and by removing them we achieve the actual disk size to be reduced.

Enhance retention policy in Postgres

Acceptance criteria

The database size should get reduced when the "time" retention policy is applied