@Gargron About index bloat, that could also be solved with a REINDEX / REINDEX CONCURRENTLY as well, correct?
REINDEX
REINDEX CONCURRENTLY