Open sethfowler opened 11 years ago
Now that pygmalion has an idle timer, we can use it to improve database performance. The two most obvious ways to do this are:
VACUUM
ANALYZE
Now that pygmalion has an idle timer, we can use it to improve database performance. The two most obvious ways to do this are:
VACUUMthe database (perhaps weekly? perhaps monthly?) to reduce space wastage and improve performance.ANALYZEthe database (whenever we do aVACUUM? more often?) to ensure the query optimizer makes good decisions.