RE: [GENERAL] vacuuming

Hi,

> -----Original Message-----
> From: owner-pgsql-general@hub.org [mailto:owner-pgsql-general@hub.org]On
> Behalf Of Brian
> Sent: zondag 28 juni 1998 18:33
> To: pgsql-general@postgreSQL.org
> Subject: [GENERAL] vacuuming

> Is it common practice to setup a cron job to vacuum your databases
> nightly?  Do you just do something like:


Every night I dump my database, and vacuum it afterwards.
One thing to keep in mind that you don't want to do as root
since pgsql doesn't like this.
So you have to run cron as a db admin user. (give this user permission to
use cron)

regards
Rob den Boer