pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: D'Arcy J.M. Cain <darcy@druid.net>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to avoid vacuuming a huge logging table
Date: Wed, 21 Feb 2007 17:04:06 -0500
Message-ID: <20070221170406.97b9b4cc.darcy@druid.net> (raw)
In-Reply-To: <cfa4aeda403c8884312dadae31ba07d7@biglumber.com>
References: <eri1gd$29bq$1@news.hub.org>
	<cfa4aeda403c8884312dadae31ba07d7@biglumber.com>

On Wed, 21 Feb 2007 21:58:33 -0000
"Greg Sabino Mullane" <greg@turnstep.com> 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 <darcy@druid.net>         |  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.

view thread (4+ messages)

Message-ID: <20070221170406.97b9b4cc.darcy@druid.net>
Permalink:  ../20070221170406.97b9b4cc.darcy@druid.net/
Also on:    postgresql.org/message-id/20070221170406.97b9b4cc.darcy@druid.net

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: darcy@druid.net, greg@turnstep.com
  Subject: Re: How to avoid vacuuming a huge logging table
  In-Reply-To: <20070221170406.97b9b4cc.darcy@druid.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox