Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ADCE09FB22A for ; Fri, 29 Sep 2006 01:22:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 57604-02 for ; Fri, 29 Sep 2006 01:22:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by postgresql.org (Postfix) with ESMTP id 91CD09FA5DC for ; Fri, 29 Sep 2006 01:22:06 -0300 (ADT) Received: from pool-72-88-194-29.nwrknj.fios.verizon.net ([72.88.194.29] helo=[192.168.4.67]) by outbound.mailhop.org with esmtpa (Exim 4.51) id 1GT9sz-000LT9-IR; Fri, 29 Sep 2006 00:22:05 -0400 X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 72.88.194.29 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: tocr Message-ID: <451C9F7D.30304@zeut.net> Date: Fri, 29 Sep 2006 00:22:21 -0400 From: "Matthew T. O'Connor" User-Agent: Thunderbird 2.0a1 (Windows/20060724) MIME-Version: 1.0 To: Sriram Dandapani CC: pgsql-admin@postgresql.org Subject: Re: autovacuum ignore tables References: <6992E470F12A444BB787B5C937B9D4DF060E5AE1@ca-mail1.cis.local> In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF060E5AE1@ca-mail1.cis.local> Content-Type: text/plain; charset=Big5 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.057 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200609/359 X-Sequence-Number: 23273 Sriram Dandapani wrote: > > If I were to specify in the pg_autovacuum catalog that certain high > volume partitioned tables(that get dropped daily) be ignored, then > when autovacuum finishes, will it update the transaction id wraparound > counter (this way, I can get autovacuum to finish quickly ) > > OR > > Will I still need to periodically do vacuumdb ¡Va to take care of the > wraparound problem. > You don't need to do a manual vacuumdb -a since autovacuum will do this once it decides you are getting too close to the wraparound point. I believe this has been improved in the upcoming 8.2 release where autovacuum no longer need to vacuum the whole database at once, rather XID wraparound is now tracked on a per table basis.