X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BD6193A6022 for ; Mon, 6 Dec 2004 21:20:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87689-05 for ; Mon, 6 Dec 2004 21:20:17 +0000 (GMT) Received: from smtp102.rog.mail.re2.yahoo.com (smtp102.rog.mail.re2.yahoo.com [206.190.36.80]) by svr1.postgresql.org (Postfix) with SMTP id 270B23A6004 for ; Mon, 6 Dec 2004 21:20:16 +0000 (GMT) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@65.49.125.184 with login) by smtp102.rog.mail.re2.yahoo.com with SMTP; 6 Dec 2004 21:20:16 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id E425840DC; Mon, 6 Dec 2004 16:20:08 -0500 (EST) Date: Mon, 6 Dec 2004 16:20:08 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Very busy 24x7 databases and VACUUM Message-ID: <20041206212008.GL22712@phlogiston.dyndns.org> Mail-Followup-To: pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6+20040722i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.034 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/45 X-Sequence-Number: 15631 On Sun, Dec 05, 2004 at 11:18:47PM -0500, Christopher Browne wrote: > One thing that would be somewhat helpful would be to be sure that each > of the tables that you are vacuuming is handled in a separate > transaction. What Chris said. In particular, I've found that pg_autovacuum has the ability really to kill performance if it starts at the wrong moment. You need something much more hand-crafted at the moment. I'll bet, however, that vacuuming some tables more often than once a day will still be a net win for you. 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