Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches

[Christophe Pettus]

> On Jan 31, 2023, at 07:40, Dimitrios Apostolou <ji...@gmx.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