| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: the right time to vacuum database? |
| Date: | 2007-06-05 13:12:47 |
| Message-ID: | 1181049167.27654.55.camel@dba5.int.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2007-06-05 13:25:46 | Re: the right time to vacuum database? |
| Previous Message | Chander Ganesan | 2007-06-05 13:12:21 | Re: the right time to vacuum database? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliveiros Cristina | 2007-06-05 13:19:06 | Re: [SQL] JOIN |
| Previous Message | Chander Ganesan | 2007-06-05 13:12:21 | Re: the right time to vacuum database? |