4 ms·
What 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?
by malisper 2mo ago
What 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