3 ms·
If you are at that, add a native TTL feature as well. I think it’s been requested for decades.
by theplumber 2mo ago
If you are at that, add a native TTL feature as well. I think it’s been requested for decades.
- malisper 2mo agoWhat do you mean by native TTL? Would that be when rows are automatically deleted if they aren't touched after a certain period of time?
- hasyimibhar 2mo agoI'm guessing it's something like MongoDB TTL index[0]. It's useful for huge append-only tables where you want a row to be automatically removed after a period of time. The postgres approach is usually to partition your table by the event/insertion timestamp, and use something like pg_partman[1] to automatically drop entire partitions over time. [0] https://www.mongodb.com/docs/manual/core/index-ttl/ https://www.mongodb.com/docs/manual/core/index-ttl/ [1] https://github.com/pgpartman/pg_partman https://github.com/pgpartman/pg_partman
- theplumber 2mo agoYes, TTL like on redis for example