DB Tools: Vacuumdb
posted by Eliot @ 2:12pm, Sunday 25 May 2008.
I run Postgres for a few applications I have. Why did I run Postgres when I seen a lot of open source projects use MySQLω I am not sure. However, the lack of visibility for Postgres did not deter me to explorer this great database management system (DBMS).
Postgres is great, but like any other database, it must be maintained. The vacuumdb utility comes bundled, and it is great. With this tool you can gather statistics on the tables and empty the garabage in the database. Yes, databases have garbage. It can be created from how data is retrieve and cached to and from storage.
If you run a postgres database, use this tools. It will keep your database clean and your queries optimized. Personally, I added a scheduled job (CRON job) to vacuum all my database everyday at 4 am.
Comments
Submit Your Comment
You are not logged in.