Re: How to avoid vacuuming a huge logging table

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.