Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 354909FC0F6 for ; Tue, 23 Oct 2007 15:04:57 -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 59953-03 for ; Tue, 23 Oct 2007 15:04:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail136082.authsmtp.co.uk (outmail136082.authsmtp.co.uk [62.13.136.82]) by postgresql.org (Postfix) with ESMTP id 3D4739FBF36 for ; Tue, 23 Oct 2007 15:04:47 -0300 (ADT) Received: from outmail128181.authsmtp.net (outmail128181.authsmtp.net [62.13.128.181]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l9NI4k1Z008089; Tue, 23 Oct 2007 19:04:46 +0100 (BST) Received: from [192.168.0.3] (62-3-250-177.dyn.gotadsl.co.uk [62.3.250.177]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l9NI4hIU067882; Tue, 23 Oct 2007 19:04:43 +0100 (BST) Subject: Re: 12 hour table vacuums From: Simon Riggs To: Ron St-Pierre Cc: pgsql-performance@postgresql.org In-Reply-To: <471E18ED.3090704@shaw.ca> References: <471E18ED.3090704@shaw.ca> Content-Type: text/plain Date: Tue, 23 Oct 2007 19:03:14 +0100 Message-Id: <1193162594.4242.61.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 6eea7dc3-8192-11dc-b86a-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagZbYlpF HGQLW1NEUVR7WWd/ bw4fawdDYVRMWgV0 UU9OXVBXCwUmXRV/ fxpGK3xycQJOcHw+ bUBgEHYOCRV9IRV+ X0ZVHG8bZGY0O31N WEYJagNUcQJCe0tG bVcsBT1vNG8XDRoV JSEUBRUEdWwFYCRS XxtFMVsYRUtDADc3 Wg0HBl1z X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200710/263 X-Sequence-Number: 27285 On Tue, 2007-10-23 at 08:53 -0700, Ron St-Pierre wrote: > The table gets updated only > about 10 times a day. So why are you VACUUMing it nightly? You should do this at the weekend every 3 months... 8.1 is slower at VACUUMing indexes than later releases, so 60 indexes are going to hurt quite a lot. The default maintenance_work_mem is sufficient for this table. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com