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!
Attachments:
autovacuum.difftext/plain; charset=us-asciiDownload+4-4
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 3778Remember 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