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.
发布评论
评论（1）
性能调优是一个困难的课题。自动真空吸尘器在大多数情况下工作得很好。然而，在某些情况下，使用 cron 的“手动”真空可能效果更好，因为例如您知道数据库在晚上无事可做，而白天真空可能会造成破坏。
关于 postgres 性能和调优的一本好书是 PostgreSQL 9.0 高性能
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