Comment by chuckadams 2 months ago Shorter:* VACUUM does not compact your indexes (much).* VACUUM FULL does. It's slow though. 2 comments chuckadams Reply kccqzy 2 months ago You also missed the main recommendation of REINDEX INDEX CONCURRENTLY along with optionally pg_squeeze. karolinepauls 2 months ago That's too reductive. Vacuum full isn't just slow, it exclusively locks the table for the duration of the vacuum and is basically a no-go when the database is in use.
kccqzy 2 months ago You also missed the main recommendation of REINDEX INDEX CONCURRENTLY along with optionally pg_squeeze.
karolinepauls 2 months ago That's too reductive. Vacuum full isn't just slow, it exclusively locks the table for the duration of the vacuum and is basically a no-go when the database is in use.
You also missed the main recommendation of REINDEX INDEX CONCURRENTLY along with optionally pg_squeeze.
That's too reductive. Vacuum full isn't just slow, it exclusively locks the table for the duration of the vacuum and is basically a no-go when the database is in use.