Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 403252E00AF for ; Wed, 7 May 2008 17:11:26 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 19088-02-2 for ; Wed, 7 May 2008 17:11:15 -0300 (ADT) X-Greylist: delayed 00:32:06.323986 by SQLgrey-1.7.6 Received: from Mercury.turbocorp.com (mercury.turbocorp.com [198.212.166.40]) by developer.postgresql.org (Postfix) with ESMTP id DBDF22E0059 for ; Wed, 7 May 2008 17:11:14 -0300 (ADT) Received: from titania.turbocorp.com ([198.212.166.208]) by Mercury.turbocorp.com (8.13.1/8.13.1) with ESMTP id m47Jd79j015898 for ; Wed, 7 May 2008 15:39:07 -0400 From: Barbara Stephenson To: pgsql-admin@postgresql.org Subject: Converting from 7.4.19 To 8.3.1 & want to use autovacuum Date: Wed, 7 May 2008 15:38:42 -0400 User-Agent: KMail/1.7.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200805071538.42882.barbara@turbocorp.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200805/55 X-Sequence-Number: 29139 Hello, We are new about autovacuum launcher on 8.3.1 and we are not sure what the parameters should be set to. Is setting them to default ok until we can monitor if it's vacumming too much? Below are the parameters that we think are the only params we need to do a basic vacuum and analyze to our entire database. autovacuum=true track_counts=ture log_autovacuum_min_duration=1000ms autovacuum_max_workers=3(default) autovacuum_naptime=60 autovacuum_vacuum_threshold=50(default) Are the above settings all we need to start auto vacuuming? -- Regards, Barbara Stephenson EDI Specialist/Programmer Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30507 tel: (678)989-3020 fax: (404)935-6171 barbara@turbocorp.com www.ohlogistics.com