> On Jan 31, 2023, at 07:40, Dimitrios Apostolou <jimis(at)gmx(dot)net> 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