Postgres Pro
Downloads
Home   >   mailing lists

Thread: VACUUM not mentioned in administrator's guide!?

VACUUM not mentioned in administrator's guide!?

From
Tom Lane
Date:
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".

            regards, tom lane

Re: VACUUM not mentioned in administrator's guide!?

From
Peter Eisentraut
Date:
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

Re: VACUUM not mentioned in administrator's guide!?

From
Tom Lane
Date:
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

Re: VACUUM not mentioned in administrator's guide!?

From
Bruce Momjian
Date:
> 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

RE: VACUUM not mentioned in administrator's guide!?

From
"Christopher Kings-Lynne"
Date:
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

> -----Original Message-----
> From: pgsql-docs-owner@postgresql.org
> [mailto:pgsql-docs-owner@postgresql.org]On Behalf Of Bruce Momjian
> Sent: Wednesday, 9 May 2001 3:01 AM
> To: Tom Lane
> Cc: pgsql-docs@postgresql.org
> Subject: Re: [DOCS] VACUUM not mentioned in administrator's guide!?
>
>
> > 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>