the right time to vacuum database?

From: "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: the right time to vacuum database?
Date: 2007-06-05 10:33:09
Message-ID: 1181039589.643323.59660@r19g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2007-06-05 12:47:12 Re: Auto Vacuum question?
Previous Message Kristo Kaiv 2007-06-05 10:13:10 Re: get the array content whis the select clause

Browse pgsql-sql by date

  From Date Subject
Next Message Loredana Curugiu 2007-06-05 11:26:13 Re: JOIN
Previous Message Loredana Curugiu 2007-06-05 08:11:12 JOIN