4 ms·
Shorter: * VACUUM does not compact your indexes (much). * VACUUM FULL does. It's slow though.
by chuckadams 11mo ago
Shorter:
* VACUUM does not compact your indexes (much).
* VACUUM FULL does. It's slow though.
- karolinepauls 11mo agoThat'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 11mo agoYou also missed the main recommendation of REINDEX INDEX CONCURRENTLY along with optionally pg_squeeze.