Re: When to run Vacuum in postgres 9.0.4

Anjali Arora wrote:

> I have a large dataset and I have crawled it two and three times; hence reltuples has increased. So I need some way
tofind out vacuum is needed on the system.  
>
> Please help me in finding out some parameter or statistics which will tell me vacuum is required on the database.

You might want to read through this page carefully, especially the section on autovacuum:

http://www.postgresql.org/docs/current/interactive/routine-vacuuming.html

If this doesn't answer your questions, please review this page and post again:



-Kevin