Comment by felixyz
1 year ago
With a partitioned table you can painlessly remove old rows. Of course, you then have to maintain your partitions, but that's trivial.
1 year ago
With a partitioned table you can painlessly remove old rows. Of course, you then have to maintain your partitions, but that's trivial.
It'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.