[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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
