Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 90E989FB28A; Sun, 13 May 2007 22:17:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 64379-01; Sun, 13 May 2007 22:17:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from fetter.org (start.fetter.org [66.92.188.65]) by postgresql.org (Postfix) with ESMTP id 4E82F9FB259; Sun, 13 May 2007 22:17:42 -0300 (ADT) Received: by fetter.org (Postfix, from userid 500) id 57170F3C486; Sun, 13 May 2007 18:17:40 -0700 (PDT) Date: Sun, 13 May 2007 18:17:40 -0700 From: David Fetter To: PostgreSQL Docs , PostgreSQL Patches Subject: Autovacuum and XID wraparound Message-ID: <20070514011740.GH14860@fetter.org> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="i9LlY+UWpKt15+FH" Content-Disposition: inline User-Agent: Mutt/1.4.2.2i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/18 X-Sequence-Number: 4247 --i9LlY+UWpKt15+FH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Folks, Per Neil Conway, here's some doc patches re: the autovacuum daemon's behavior. Should this be back-patched to 8.2x? Cheers, D -- David Fetter http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate --i9LlY+UWpKt15+FH Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="autovacuum_xid_wraparound.diff" Index: doc/src/sgml/config.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/config.sgml,v retrieving revision 1.122 diff -c -r1.122 config.sgml *** doc/src/sgml/config.sgml 20 Apr 2007 02:37:37 -0000 1.122 --- doc/src/sgml/config.sgml 14 May 2007 01:16:02 -0000 *************** *** 3172,3177 **** --- 3172,3185 ---- This parameter can only be set in the postgresql.conf file or on the server command line. + + + Even when this variable is set to off, the autovacuum daemon + will run periodically in order to prevent transaction_id + wraparound. See for + more information. + + Index: src/backend/utils/misc/postgresql.conf.sample =================================================================== RCS file: /projects/cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v retrieving revision 1.215 diff -c -r1.215 postgresql.conf.sample *** src/backend/utils/misc/postgresql.conf.sample 18 Apr 2007 16:44:18 -0000 1.215 --- src/backend/utils/misc/postgresql.conf.sample 14 May 2007 01:16:02 -0000 *************** *** 372,377 **** --- 372,379 ---- #--------------------------------------------------------------------------- # AUTOVACUUM PARAMETERS #--------------------------------------------------------------------------- + # Note: even when autovacuum is turned off, the autovacuum daemon will + # run in order to prevent transaction id wraparound. #autovacuum = on # enable autovacuum subprocess? # 'on' requires stats_start_collector --i9LlY+UWpKt15+FH--