2 ms·
Vacuum does more than removing dead tuples though, there is still a need to update statistics and summarize BRINs.
by ruuda 3y ago
Vacuum does more than removing dead tuples though, there is still a need to update statistics and summarize BRINs.
- javajosh 3y agoYes. The (psql 15) docs are well written: https://www.postgresql.org/docs/15/routine-vacuuming.html https://www.postgresql.org/docs/15/routine-vacuuming.html
- wild_egg 3y agoYou're thinking of ANALYZE which is a separate operation that's commonly run during vacuuming but can be invoked independently