pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedVACUUM not mentioned in administrator's guide!?
5+ messages / 4 participants
[nested] [flat]
* VACUUM not mentioned in administrator's guide!?
@ 2001-05-05 00:31 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 5+ messages in thread
From: Tom Lane @ 2001-05-05 00:31 UTC (permalink / raw)
To: pgsql-docs
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: VACUUM not mentioned in administrator's guide!?
@ 2001-05-05 21:19 Peter Eisentraut <peter_e@gmx.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 5+ messages in thread
From: Peter Eisentraut @ 2001-05-05 21:19 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: VACUUM not mentioned in administrator's guide!?
@ 2001-05-06 00:50 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2001-05-06 00:50 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: VACUUM not mentioned in administrator's guide!?
@ 2001-05-08 19:01 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2001-05-08 19:01 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: VACUUM not mentioned in administrator's guide!?
@ 2001-05-09 01:44 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Christopher Kings-Lynne @ 2001-05-09 01:44 UTC (permalink / raw)
To: pgsql-docs
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-05-09 01:44 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-05 00:31 VACUUM not mentioned in administrator's guide!? Tom Lane <tgl@sss.pgh.pa.us>
2001-05-05 21:19 ` Peter Eisentraut <peter_e@gmx.net>
2001-05-06 00:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-05-08 19:01 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-05-09 01:44 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox