vacuuming - Mailing list pgsql-general

From Brian
Subject vacuuming
Date
Msg-id Pine.LNX.3.96.980628113136.6732A-100000@mercury.shreve.net
Whole thread Raw
Responses RE: [GENERAL] vacuuming  ("Rob den Boer" <rdboer@hrs-rotterdam.nl>)
List 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@shreve.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 -----------------------------/



pgsql-general by date:

Previous
From: Peter Mount
Date:
Subject: Re: [GENERAL] Large objects
Next
From: James Olin Oden
Date:
Subject: Re: [GENERAL] Error message