← Back to context Comment by chuckadams 1 month ago Shorter:* VACUUM does not compact your indexes (much).* VACUUM FULL does. It's slow though. 2 comments chuckadams Reply kccqzy 1 month ago You also missed the main recommendation of REINDEX INDEX CONCURRENTLY along with optionally pg_squeeze. karolinepauls 1 month 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 1 month ago You also missed the main recommendation of REINDEX INDEX CONCURRENTLY along with optionally pg_squeeze.
karolinepauls 1 month 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.