5 ms·
With a partitioned table you can painlessly remove old rows. Of course, you then have to maintain your partitions, but that's trivial.
by felixyz 2y ago
With a partitioned table you can painlessly remove old rows. Of course, you then have to maintain your partitions, but that's trivial.
- jashmatthews 2y agoIt's far from trivial. Autoanalyze doesn't work on partitioned tables, only on the partitions themselves. Partitioning a busy job queue table is a nightmare in itself.