RE: [GENERAL] vacuuming

From: "Rob den Boer" <rdboer(at)hrs-rotterdam(dot)nl>
To: "Brian" <signal(at)shreve(dot)net>
Cc: <pgsql-general(at)hub(dot)org>
Subject: RE: [GENERAL] vacuuming
Date: 1998-06-30 11:16:40
Message-ID: 000e01bda418$8dc091e0$67032e9f@hrs_nt.hrs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

> -----Original Message-----
> From: owner-pgsql-general(at)hub(dot)org [mailto:owner-pgsql-general(at)hub(dot)org]On
> Behalf Of Brian
> Sent: zondag 28 juni 1998 18:33
> To: pgsql-general(at)postgreSQL(dot)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

In response to

  • vacuuming at 1998-06-28 16:33:24 from Brian

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1998-06-30 12:19:56 RE: [GENERAL] vacuuming
Previous Message Rob den Boer 1998-06-30 11:16:38 RE: [GENERAL] Updating multiple fields