VACUUM not mentioned in administrator's guide!?

Tom Lane writes:

Seems like we need a chapter about "routine maintenance tasks".

Right. What are the routine maintenance tasks?

* Vacuum

* Log rotation

Seems like it's "low maintenance". ;-)

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

Peter Eisentraut <peter_e@gmx.net> writes:

Tom Lane writes:

Seems like we need a chapter about "routine maintenance tasks".

Right. What are the routine maintenance tasks?
* Vacuum
* Log rotation
Seems like it's "low maintenance". ;-)

I didn't say it needed to be a long chapter ;-). But I think we need
one.

regards, tom lane

I was bemused to discover just now that nowhere in the Administrator's
Guide is there any discussion of VACUUM and the need for it to be run
routinely. No wonder people don't do it :-(

Seems like we need a chapter about "routine maintenance tasks".

Added to TODO:

* Add mention of VACUUM, log rotation to Administrator's Guide

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

I also notice that ALTER TABLE xxx ADD CONSTRAINT xxx CHECK (...) is not
documented in the ALTER TABLE section of the docs. I only realised it was
possible to add CHECK constraints after table creation because I noticed it
in the source code!

Chris