When to run Vacuum in postgres 9.0.4

From: Anjali Arora <anjali_524(at)yahoo(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: When to run Vacuum in postgres 9.0.4
Date: 2013-01-08 12:45:15
Message-ID: 1357649115.2538.YahooMailClassic@web192205.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

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.

Regards,
Anjali

Browse pgsql-general by date

  From Date Subject
Next Message ac@hsk.hk 2013-01-08 12:56:20 Questions about 9.2 unique constraints
Previous Message ac@hsk.hk 2013-01-08 11:52:52 Re: PostgreSQL 9.2 and PGBOUNCER