vacuuming

From: Brian <signal(at)shreve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuuming
Date: 1998-06-28 16:33:24
Message-ID: Pine.LNX.3.96.980628113136.6732A-100000@mercury.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

psql my_db < vacuum

in cron? I was reading about administration and it talked about how
vacuuming is such a good idea and all.

If i am going to cron vacuum, is there anything else I should be doing, or
is just "psql my_db < vacuum" all that needs done on a nightly basis.

Brian

/-------------------------- signal(at)shreve(dot)net -----------------------------\
| Brian Feeny | USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting, online stores, |
| ShreveNet Inc. | USR Pilot | Dial-Up 14.4-56k, ISDN & LANs |
| 89 CRX DX w/MPFI, lots of |-=*:Quake:*=-| http://www.shreve.net/ |
| mods/Homepage coming soon |LordSignal/SN| Quake server: 208.206.76.47 |
\-------------------------- 318-222-2638 x109 -----------------------------/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roman Volkoff 1998-06-29 09:57:32 unsubscribe
Previous Message Peter Mount 1998-06-28 08:32:47 Re: [GENERAL] Large objects