X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 817AD9DCAB7 for ; Sun, 4 Dec 2005 00:03:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56042-04 for ; Sun, 4 Dec 2005 00:03:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from candle.pha.pa.us (candle.pha.pa.us [64.139.89.126]) by postgresql.org (Postfix) with ESMTP id C932B9DCC85 for ; Sun, 4 Dec 2005 00:03:10 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id jB4435Z09628; Sat, 3 Dec 2005 23:03:05 -0500 (EST) From: Bruce Momjian Message-Id: <200512040403.jB4435Z09628@candle.pha.pa.us> Subject: Re: autovacuum daemon question... In-Reply-To: To: Jeff Bohmer Date: Sat, 3 Dec 2005 23:03:05 -0500 (EST) CC: "Matthew T. O'Connor" , Scott Marlowe , Joe Maldonado , pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.005 required=5 tests=[AWL=0.005] X-Spam-Score: 0.005 X-Spam-Level: X-Archive-Number: 200512/26 X-Sequence-Number: 19746 Added to TODO for autovacuum: o Consider logging activity either to the logs or a system view --------------------------------------------------------------------------- Jeff Bohmer wrote: > > >>Unless I misunderstand, if stats_reset_on_server_start=off, these > >>(currently nonexistent autovacuum) stats would only be relevant for > >>autovacuum's VACUUM activity and not it's ANALYZE activity. In > >>which case, it seems ideal to keep autovacuum VACUUM stats > >>regardless of the GUC setting, while autovacuum ANALYZE stats > >>should follow it. But if the ideal is impractical, making both > >>ANALYZE and VACUUM stats follow the GUC would still be real nice. > > > >I'm confused... the GUC var stats_reset_on_server_start dictates if > >the stats system dumps its data on DB restart. If we added a new > >table to the stats system kept track of autovacuum activity, then > >that data would also be dumped on restart if > >stats_reset_on_server_start=true. > > > Yep. I was thinking of a way to muck up the stats system by keeping > autovacuum's VACUUM activity irregardless of > stats_reset_on_server_start. Because autovacuum's VACUUM activity > data would be relevant across restarts, even if > stats_reset_on_server_start=true. But I see now that my idea is ugly > and just confuses things. I agree that having it work the way you > suggest is preferable. > > - Jeff > > > -- > > Jeff Bohmer > VisionLink, Inc. > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- 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