Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 487109FB4F5 for ; Wed, 20 Jun 2007 14:19:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 90417-01 for ; Wed, 20 Jun 2007 14:19:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by postgresql.org (Postfix) with ESMTP id 695F89FB3FE for ; Wed, 20 Jun 2007 14:19:26 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id k40so240253wah for ; Wed, 20 Jun 2007 10:19:25 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=nz+VcdHVOgqHKaCa09mexkTCtzulgjGqAk5ubJ7LHGcH5/pucp61R4X0XcMLo/Miv6WcFbLHD12CTt5pdc7AX6Ss85RMqWMts3v7bnUiBB11eVusyoCSmgbzpmXlo6OuQJ4zYtaUf9ojlrvMdJvdbCEeJd1f2UGpeCeuiN2dHRg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XWZpFWDlw4xYFd8S/r8FbhWQjEG7dNcs/0xQb4V0n4UrwWbgWbLdmtvlr4XiChrCcJLzDqzK7Bbfle3Hd6+Drl5ulOkprWLRx1MPYsgNbaXf+MHWYuUVZN83+I5By6b/NrGf2wGloPNnBCNfU21/OUWPkvfDq7tvenVMBQFcpa8= Received: by 10.114.254.1 with SMTP id b1mr532257wai.1182359964919; Wed, 20 Jun 2007 10:19:24 -0700 (PDT) Received: by 10.114.111.12 with HTTP; Wed, 20 Jun 2007 10:19:24 -0700 (PDT) Message-ID: Date: Wed, 20 Jun 2007 13:19:24 -0400 From: "Sibte Abbas" To: "Ireneusz Pluta" Subject: Re: Logging autovacuum activity Cc: pgsql-admin@postgresql.org In-Reply-To: <46795EA3.8030703@wp.pl> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46795EA3.8030703@wp.pl> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/203 X-Sequence-Number: 25871 On 6/20/07, Ireneusz Pluta wrote: > Hello, > > How can I make sure that autovacuum is running, beyond believing that all autovacuum_ settings in > postgresql.conf are set correctly? > > In the 8.1 I could see: > LOG: autovacuum: processing database "test" > in the log. > > But I can't find it in the 8.2.4. > > I could see some developers discussions about making changes to logging autovacuum activity, however > could not track the discussion tight enough to find what the final solution is. > > Thanks > > Ireneusz Pluta > > ps -ef | grep autovacuum. -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com