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 9160611F66E7 for ; Mon, 3 Apr 2006 21:08:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71927-10 for ; Mon, 3 Apr 2006 21:08:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5A57211F66E0 for ; Mon, 3 Apr 2006 21:08:43 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3408aVY007620; Mon, 3 Apr 2006 20:08:36 -0400 (EDT) To: John DeSoi cc: Alvaro Herrera , "Jim C. Nasby" , Gourish Singbal , elein , "pgsql-admin@postgresql.org" Subject: Re: auto vacuuming In-reply-to: <05255888-38A1-4967-AD6F-2467B2ED65C6@pgedit.com> References: <674d1f8a0603290206u55f114e1y7bfc2f83696fbada@mail.gmail.com> <20060331174802.GS49405@pervasive.com> <20060331185037.GF14204@surnet.cl> <6933.1143861467@sss.pgh.pa.us> <20060403030536.GA6701@surnet.cl> <27699.1144035580@sss.pgh.pa.us> <05255888-38A1-4967-AD6F-2467B2ED65C6@pgedit.com> Comments: In-reply-to John DeSoi message dated "Mon, 03 Apr 2006 19:58:23 -0400" Date: Mon, 03 Apr 2006 20:08:36 -0400 Message-ID: <7619.1144109316@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.114 required=5 tests=[AWL=0.114] X-Spam-Score: 0.114 X-Spam-Level: X-Archive-Number: 200604/40 X-Sequence-Number: 21209 John DeSoi writes: > My reason for wanting to turn it off is that every time it would run > the fans on my development system would rev up. Well, I have an equally lame reason for wanting to not run autovac: it'll interfere with profiling because the autovac daemon will drop a gmon.out file once a minute or so, and maybe overwrite a profiling run's results before you can print them out. But AFAICS both of these wishes can be served pretty well just by increasing autovacuum_naptime to some large value, once a day maybe. They don't strike me as compelling reasons why autovac should be turned off entirely. regards, tom lane