Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B36AF9FB599 for ; Tue, 12 Jun 2007 13:42:05 -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 45099-04 for ; Tue, 12 Jun 2007 13:42:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id E22C59FB58C for ; Tue, 12 Jun 2007 13:42:01 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 00A493144C; Tue, 12 Jun 2007 18:42:00 +0200 (MET DST) From: "Sabin Coanda" X-Newsgroups: pgsql.performance Subject: Re: VACUUM vs auto-vacuum daemon Date: Tue, 12 Jun 2007 19:42:10 +0300 Organization: Hub.Org Networking Services Lines: 17 Message-ID: References: <20070612122555.2b0f4fa0.wmoran@collaborativefusion.com> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/218 X-Sequence-Number: 25251 Hi Bill, ... > > However, you can get some measure of tracking my running VACUUM VERBOSE > on a regular basis to see how well autovacuum is keeping up. There's > no problem with running manual vacuum and autovacuum together, and you'll > be able to gather _some_ information about how well autovacuum is > keeping up. Well, I think it is useful just if I am able to synchronize the autovacuum to run always after I run vacuum verbose. But I don't know how to do that. Do you ? Sabin