I committed bottom-up index deletion today, which is slated for Postgres 14. See postgresql.org/docs/devel/btr for a detailed description. In short: it makes index bloat/VACUUM issues much less likely to get out of hand. Updaters are now *required* to clean up indexes after themselves.
Conversation
Replying to
You're welcome, Stefanie! I was very glad to have something to distract me from everything over the past year.