> On Jan 31, 2023, at 07:40, Dimitrios Apostolou <jimis@xxxxxxx> wrote: > Is this bloat even affecting queries that do not use the index? No, but a bloated index often (although not always) goes along with a bloated table. > It seems I have to add VACUUM FULL to nightly maintainance. I wouldn't go that far; that's basically changing your oil every time you get gas. However, monitoring bloat and either rebuilding the indexes (if they're all that's bloated) or using pg_repack [1] periodically is a good practice. [1] https://github.com/reorg/pg_repack
