From: Brad Nicholson <bnichols@ca.afilias.info>
To: Charles.Hou <ivan.hou@msa.hinet.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: the right time to vacuum database?
Date: Tue, 05 Jun 2007 09:12:47 -0400
Message-ID: <1181049167.27654.55.camel@dba5.int.libertyrms.com> (raw)
In-Reply-To: <1181039589.643323.59660@r19g2000prf.googlegroups.com>
References: <1181039589.643323.59660@r19g2000prf.googlegroups.com>
On Tue, 2007-06-05 at 03:33 -0700, Charles.Hou wrote:
> how can i know that it's the time to vacuumdb? i set the crontab to
> vacuumdb 3 times in one day. because my database size increase from
> 440MB to 460MB in 8 hours.
Have you looked at autovaccum? It can handle this for you.
If not, you need to examine the output of VACUUM VERBOSE or pg_stattuple
(in contrib) and set a policy based on the output.
It's entirely possible that some tables will need to get vacuumed
frequently, and others will not.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bnichols@ca.afilias.info, ivan.hou@msa.hinet.net, pgsql-admin@postgresql.org
Subject: Re: the right time to vacuum database?
In-Reply-To: <1181049167.27654.55.camel@dba5.int.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox