Re: When to run Vacuum in postgres 9.0.4

[resending after completion -- the prior send was accidental]

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 to find 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:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin