Hiya. I was cruising around inside PGAdmin this morning. I happened to click on the card_types table and a dialog popped up advising the table should be vacuumed because the estimated row count does not seem to match the actual row count. Same thing with a couple of other tables.
I have installed Mingle standalone to learn it, begin entering my project's cards, begin planning, and may move it to a web server some day soon. But I'm not a pg dbadmin ... should these tables be "vacuumed"?
UPDATE: Just to clarify, I *am* a pg administrator on my own computer, of course. What I meant was I don't know much about proper maintenance of Postgres databases. Hence the question, Should I click the button to say, Ok, Vacuum this table. And should I do that as a regular task -- if so, how often?
thanks
kazar
Comments
2 comments
Hi -
You should configure Postgres for autovacuum and we also highly recommend that you schedule a weekly manual vacuum task. See http://www.postgresql.org/docs/8.4/static/maintenance.html for help.
thanks, David. My learning curve keeps stretching out ahead of me!
Please sign in to leave a comment.