RE: [GENERAL] vacuuming - Mailing list pgsql-general

From Rob den Boer
Subject RE: [GENERAL] vacuuming
Date
Msg-id 000e01bda418$8dc091e0$67032e9f@hrs_nt.hrs
Whole thread Raw
In response to vacuuming  (Brian <signal@shreve.net>)
Responses RE: [GENERAL] vacuuming
RE: [GENERAL] vacuuming
List pgsql-general
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



pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] LIKE (SQL operator)
Next
From: The Hermit Hacker
Date:
Subject: RE: [GENERAL] vacuuming