Would you run this database maintenance? — ProReview
Would you run this database maintenance?
Situation
A DBA suggests running maintenance on the orders table after a bulk archive.
Environment
Production PostgreSQL with active order traffic.
Select suspicious lines in the terminal to flag them before submitting your verdict.
pending review
-- Maintenance after bulk archive of old ordersSET statement_timeout ='30min';SETlock_timeout='5s';VACUUM FULL orders;REINDEX TABLE CONCURRENTLY orders;ANALYZE orders;SELECT pg_size_pretty(pg_total_relation_size('orders'));