X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4AB869FA5B5 for ; Mon, 5 Jun 2006 17:42:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 75186-06 for ; Mon, 5 Jun 2006 17:41:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id F3AA79FA30C for ; Mon, 5 Jun 2006 17:41:57 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1FnLxU-0007Jb-Ai for pgsql-performance@postgresql.org; Mon, 05 Jun 2006 16:45:56 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 8B4164051; Mon, 5 Jun 2006 16:41:51 -0400 (EDT) Date: Mon, 5 Jun 2006 16:41:51 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: vacuuming problems continued Message-ID: <20060605204151.GC7071@phlogiston.dyndns.org> References: <92d3a4950606010454y67293765o56001e8996975b45@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <92d3a4950606010454y67293765o56001e8996975b45@mail.gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/44 X-Sequence-Number: 19401 On Thu, Jun 01, 2006 at 01:54:08PM +0200, Antoine wrote: > Hi, > We just don't seem to be getting much benefit from autovacuum. Running > a manual vacuum seems to still be doing a LOT, which suggests to me > that I should either run a cron job and disable autovacuum, or just > run a cron job on top of autovacuum. What the others said; but also, which version of autovacuum (== which version of the database) is this? Because the early versions had a number of missing bits to them that tended to mean the whole thing didn't hang together very well. > I have been thinking about strategies and am still a bit lost. Our > apps are up 24/7 and we didn't code for the eventuality of having the > db going offline for maintenance... we live and learn! You shouldn't need to, with anything after 7.4, if your vacuum regimen is right. There's something of a black art to it, though. A -- Andrew Sullivan | ajs@crankycanuck.ca This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie