Quick Links

Re: [PATCHES] Clarifying Autovacuum docs in the release notes

Lists:	pgsql-docspgsql-patches

From:	David Fetter <david(at)fetter(dot)org>
To:	PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject:	Clarifying Autovacuum docs in the release notes
Date:	2005-09-12 03:32:40
Message-ID:	20050912033240.GB8194@fetter.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-docs pgsql-patches

Folks,

Please find attached a patch which tells about what the spiffy,
integrated autovacuum now does :)

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

Attachment	Content-Type	Size
autovacuum.diff	text/plain	1.2 KB

From:	Neil Conway <neilc(at)samurai(dot)com>
To:	David Fetter <david(at)fetter(dot)org>
Cc:	PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject:	Re: [PATCHES] Clarifying Autovacuum docs in the release notes
Date:	2005-09-12 18:23:22
Message-ID:	4325C79A.9070300@samurai.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-docs pgsql-patches

David Fetter wrote:
> ***************
> *** 173,179 ****
> Integrating autovacuum into the server allows it to be
> automatically started and stopped in sync with the database
> server, and allows autovacuum to be configured from
> ! <filename>postgresql.conf</>.
> </para>
> </listitem>
> </varlistentry>
> --- 173,181 ----
> Integrating autovacuum into the server allows it to be
> automatically started and stopped in sync with the database
> server, and allows autovacuum to be configured from
> ! <filename>postgresql.conf</>. Autovacuum now checks to see if
> ! the database is in danger of xid wraparound and
> ! <command>VACUUM</command>s the whole database if needed.
> </para>
> </listitem>
> </varlistentry>

AFAIK contrib/pg_autovacuum in 8.0 also checked for XID wraparound (or
at least its documentation claims that it does), so I don't see how this
is new functionality.

-Neil

From:	Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To:	David Fetter <david(at)fetter(dot)org>
Cc:	PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject:	Re: Clarifying Autovacuum docs in the release notes
Date:	2005-09-23 02:25:45
Message-ID:	200509230225.j8N2PjC21857@candle.pha.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-docs pgsql-patches

Patch applied. Thanks.

---------------------------------------------------------------------------

David Fetter wrote:
> Folks,
>
> Please find attached a patch which tells about what the spiffy,
> integrated autovacuum now does :)
>
> Cheers,
> D
> --
> David Fetter david(at)fetter(dot)org http://fetter.org/
> phone: +1 510 893 6100 mobile: +1 415 235 3778
>
> Remember to vote!

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

From:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To:	Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc:	David Fetter <david(at)fetter(dot)org>, PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject:	Re: [PATCHES] Clarifying Autovacuum docs in the release notes
Date:	2005-09-23 02:39:35
Message-ID:	20050923023935.GJ31459@surnet.cl
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-docs pgsql-patches

Bruce Momjian wrote:

> David Fetter wrote:
> >
> > Please find attached a patch which tells about what the spiffy,
> > integrated autovacuum now does :)
>
> Patch applied. Thanks.

I think somebody has complained in the past that "verb-ification" of
command names is not good style, so the " ... and <command>VACUUM</>s
the whole ..." should not be used. Maybe "... and executes
<command>VACUUM</> on the whole ..." is better?

--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
FOO MANE PADME HUM

From:	Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc:	David Fetter <david(at)fetter(dot)org>, PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject:	Re: [PATCHES] Clarifying Autovacuum docs in the release notes
Date:	2005-09-23 02:43:03
Message-ID:	200509230243.j8N2h3F23803@candle.pha.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-docs pgsql-patches

Cleaned up:

Also autovacuum now checks
if the database is in danger of xid wraparound and
vacuums the database if needed.

---------------------------------------------------------------------------

Alvaro Herrera wrote:
> Bruce Momjian wrote:
>
> > David Fetter wrote:
> > >
> > > Please find attached a patch which tells about what the spiffy,
> > > integrated autovacuum now does :)
> >
> > Patch applied. Thanks.
>
> I think somebody has complained in the past that "verb-ification" of
> command names is not good style, so the " ... and <command>VACUUM</>s
> the whole ..." should not be used. Maybe "... and executes
> <command>VACUUM</> on the whole ..." is better?
>
> --
> Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
> FOO MANE PADME HUM
>