PostgreSQL Vacuum Analyze vs VACUUM FULL: Locks and Stats
Four commands, four different jobs. Measured on PostgreSQL 17.10:
VACUUM t; — marks dead row versions reusable inside the table. Takes a SHARE UPDATE EXCLUSIVE lock, so reads and writes keep working. Does not collect planner statistics.ANALYZE t; — coll…
2026/11/4 7:17:34 阅读全文 →