Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8EF9B9FB509 for ; Wed, 9 May 2007 19:00:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 21879-08 for ; Wed, 9 May 2007 19:00:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by postgresql.org (Postfix) with ESMTP id F24039FB4E7 for ; Wed, 9 May 2007 19:00:23 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id d17so90683and for ; Wed, 09 May 2007 15:00:23 -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:mime-version:content-type; b=XmhNBpp79IFEStqCK8wC9JYu/xlDguEazYhUQ2Wj1iqcTbvMwZIRjRjTJxgfim2DmdqktE/hLtmtB/Qy+5GB7fULnYOx3nLNjqV4J3beGJwKyd8e7Ny12teeqZcXIKdQJBkIhs7uDIhrEXCC7Hc9GNQbr6mxuy9ha7TZ27/tRBo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=KEx2rYSRnfS9zIto8EYXZIArzGPhn6MP2tOXpdudaAEorVMPr2aBUpypiNY14VQ1BuWybcwPukBVmpdw6fB3rIMhNfSvmrBCj06arBNltx1S/7CGliH1Ryw6ZPQbuI9iE65fLFgq/BD5lS59UesB1AJRLtTXtr3E0Sdf2SiiuPU= Received: by 10.100.135.16 with SMTP id i16mr720402and.1178748022500; Wed, 09 May 2007 15:00:22 -0700 (PDT) Received: by 10.100.143.16 with HTTP; Wed, 9 May 2007 15:00:22 -0700 (PDT) Message-ID: Date: Wed, 9 May 2007 15:00:22 -0700 From: "Y Sidhu" To: pgsql-performance@postgresql.org Subject: Vacuum Times - Verbose and maintenance_work_mem MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_139968_21812032.1178748022447" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/209 X-Sequence-Number: 24599 ------=_Part_139968_21812032.1178748022447 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline How do you specify a log file for vacuum verbose to send info to? I have verbose turned on but cannot see any log messages. I have upped maintenance_work_mem setting from 32768 to 98304. This is on a 4 GB, 3.2 GHz Xeon, dual core, dual cpu with HTT turned on. I hope that helps with vacuum times. PG 8.0.9 on a UFS2 FreeBSD 6.2 prerelease. -- Yudhvir Singh Sidhu 408 375 3134 cell ------=_Part_139968_21812032.1178748022447 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline How do you specify a log file for vacuum verbose to send info to? I have verbose turned on but cannot see any log messages.

I have upped maintenance_work_mem setting from 32768 to 98304. This is on a 4 GB, 3.2 GHz Xeon, dual core, dual cpu with HTT turned on. I hope that helps with vacuum times. PG 8.0.9 on a UFS2 FreeBSD 6.2 prerelease.

--
Yudhvir Singh Sidhu
408 375 3134 cell ------=_Part_139968_21812032.1178748022447--