When to vacuum

From: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: When to vacuum
Date: 2003-01-20 21:43:12
Message-ID: 3E2C6D70.8010006@intransa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was wondering if I can use any of the pg_stat* related tables to
determine if I
need to vacuum or not.

More specifically, instead of assuming a period (based on one's usage),
if I was
to vacuum more adaptively, I could have a cron job to check certain
statistics table
every 10 minutes (or hour) and if a threashold is reached a vauum be
performed.

If this is possible, please specifiy the condition for vacuum and vacuum
full please.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-01-20 22:30:40 Re: When to vacuum
Previous Message Tom Lane 2003-01-20 21:23:00 Re: Edit a dump file?