3 ms·
One could use a trigger for this. All we need is to setup a trigger that would delete all expired records looking at some timestamp column on update. That would
by neoden 1y ago
One could use a trigger for this. All we need is to setup a trigger that would delete all expired records looking at some timestamp column on update. That would eat up some latency but as was said, most projects would find it good enough anyway.
- nhumrich 1y agoI use pg cron for this. But I don't have a need for TTL to be to the minute accurate, or even to the hour.
- dmitry-vsl 1y agoProbably better to use partitioned table and drop old partitions.