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