Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1AFA79FA31E for ; Thu, 4 Jan 2007 21:15:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 68338-05 for ; Thu, 4 Jan 2007 21:15:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.235]) by postgresql.org (Postfix) with ESMTP id A356B9FA0B7 for ; Thu, 4 Jan 2007 21:15:14 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so3080034nzh for ; Thu, 04 Jan 2007 17:15:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sIG803VTizqeJDltta30i5iqxsOeqsrSlzN8mTiaCtQZw8Z8/HqwBroYg+NpB27pWxVAOY/7cPR9nvyoiGfo6qDUjXfOHtcZo++YzTiEekTpDJw/v04tOVO73twrMo34kriQ1/EfAn36HYl+TgWR//2tTIfCa/s0p5J2z5Fxk00= Received: by 10.65.251.1 with SMTP id d1mr378895qbs.1167959713421; Thu, 04 Jan 2007 17:15:13 -0800 (PST) Received: by 10.64.10.10 with HTTP; Thu, 4 Jan 2007 17:15:13 -0800 (PST) Message-ID: <4fc81d760701041715s28548ff0s763cbf05331b6c12@mail.gmail.com> Date: Fri, 5 Jan 2007 08:15:13 +0700 From: Ming To: pgsql-admin@postgresql.org Subject: Re: Autovacuum not running in 8.2.0 In-Reply-To: <4fc81d760701032030x383f7fd2m86af3449db27e189@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4fc81d760701032030x383f7fd2m86af3449db27e189@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/28 X-Sequence-Number: 24184 I already found the answer, sorry... my mistake for not checking the 8.2.0 release note first. It turns out that such behaviour is expected in 8.2.0, i.e. autovacuum process no longer add an entry to the server log. http://www.postgresql.org/docs/current/static/release-8-2.html But then, another question arises... how could I know whether it's working if it does not add any entry to the log? an excerpt from the above link: "pg_stat_activity now shows autovacuum activity." I expected to see a new process showing up in pgAdmin's Server Status window while autovacuum is running, but there was none.