Обсуждение: Clarifying Autovacuum docs in the release notes

Folks,

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

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

Remember to vote!

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

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@fetter.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

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
>

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