When to vacuum - Mailing list pgsql-general

From Medi Montaseri
Subject When to vacuum
Date
Msg-id 3E2C6D70.8010006@intransa.com
Whole thread Raw
Responses Re: When to vacuum
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Edit a dump file?
Next
From: Andrew Sullivan
Date:
Subject: Re: When to vacuum