[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