Postgresql-8.4 auto vacuum is enabled to get the best performance [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

This question does not appear to be about a specific programmi开发者_Python百科ng problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.

Closed 6 years ago.

Improve this question

I want know which one is good to follow whether auto vacuum or vacuum manually. Right now we are following manually in cron jobs, but sometimes it gets struck to vaccum on particular tables. so we are thinking about the auto vacuum. does it give good performance to production server? please suggest. Lot of thanks in advance.

---

Performance tuning is a difficult subject. Auto vacuum works in most cases very well. In certain cases however "manual" vacuum using cron might work better because for instance you know the database has nothing to do at night while during the day the vacuum might be to disruptive.

A good book on postgres performance and tuning is PostgreSQL 9.0 High performance