Clarifying Autovacuum docs in the release notes

Started by David Fetterover 20 years ago5 messagesdocs
Jump to latest
#1David Fetter
david@fetter.org

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!

Attachments:

autovacuum.difftext/plain; charset=us-asciiDownload+4-4
#2Neil Conway
neilc@samurai.com
In reply to: David Fetter (#1)
Re: [PATCHES] Clarifying Autovacuum docs in the release notes

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

#3Bruce Momjian
bruce@momjian.us
In reply to: David Fetter (#1)
Re: Clarifying Autovacuum docs in the release notes

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
#4Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Bruce Momjian (#3)
Re: [PATCHES] Clarifying Autovacuum docs in the release notes

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

#5Bruce Momjian
bruce@momjian.us
In reply to: Alvaro Herrera (#4)
Re: [PATCHES] Clarifying Autovacuum docs in the release notes

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