Re: How to avoid vacuuming a huge logging table

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to avoid vacuuming a huge logging table
Date: 2007-02-21 22:04:06
Message-ID: 20070221170406.97b9b4cc.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 21 Feb 2007 21:58:33 -0000
"Greg Sabino Mullane" <greg(at)turnstep(dot)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(at)druid(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Konstantinos Krikellas 2007-02-22 11:02:50 Disable result buffering to frontend clients
Previous Message Greg Sabino Mullane 2007-02-21 21:58:33 Re: How to avoid vacuuming a huge logging table