[felixyz]

With a partitioned table you can painlessly remove old rows. Of course, you then have to maintain your partitions, but that's trivial.

[jashmatthews]

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.