CODEWITHSUNDEEP
postgresqlpostgresql-10
Shagoon
Shagoon

Reputation: 9

Data retention in PostgreSQL

Is there a way to add retention on PostgreSQL? I've tried partitioning but seems to be a problem when querying between multiple partitioning regarding performance. This seemed to be a better way because you can delete one partition in a fast way then deleting few years of data.

Upvotes: 0

Views: 12582

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247765

Partitioning is the king's way for getting rid of old data.

Most of your queries will get slightly slower, but that shouldn't be too bad if you use a moderate number of partitions.

Upvotes: -1

Related Questions