Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 061C59FBAA1 for ; Wed, 21 Feb 2007 18:04:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 12667-07 for ; Wed, 21 Feb 2007 18:04:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from druid.net (druid.net [66.96.28.249]) by postgresql.org (Postfix) with ESMTP id C97449FB7FB for ; Wed, 21 Feb 2007 18:04:07 -0400 (AST) Received: from dilbert.druid.net (H245.C18.B96.tor.eicat.ca [66.96.18.245]) by druid.net (Postfix) with SMTP id 4ACCAB598; Wed, 21 Feb 2007 17:04:33 -0500 (EST) Date: Wed, 21 Feb 2007 17:04:06 -0500 From: "D'Arcy J.M. Cain" To: "Greg Sabino Mullane" Cc: pgsql-performance@postgresql.org Subject: Re: How to avoid vacuuming a huge logging table Message-Id: <20070221170406.97b9b4cc.darcy@druid.net> In-Reply-To: References: X-Mailer: Sylpheed version 2.2.0 (GTK+ 2.8.12; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.228 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/227 X-Sequence-Number: 23281 On Wed, 21 Feb 2007 21:58:33 -0000 "Greg Sabino Mullane" wrote: > SELECT 'vacuum verbose analyze '||quote_ident(nspname)||'.'||quote_ident(relname)||';' > FROM pg_class c, pg_namespace n > WHERE relkind = 'r' > AND relnamespace = n.oid > AND nspname = 'novac' > ORDER BY 1; I assume you meant "AND nspname != 'novac'" -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.