Skip site navigation (1) Skip section navigation (2)

Re: excluding tables from VACUUM ANALYZE

From: David Fetter <david(at)fetter(dot)org>
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: excluding tables from VACUUM ANALYZE
Date: 2008-10-30 14:04:17
Message-ID: 20081030140417.GQ18097@fetter.org (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, Oct 30, 2008 at 09:17:00AM -0400, Igor Neyman wrote:
> This question didn't get any "traction on "admin" list, so I'll try
> here: 
> 
> I want to analyze the entire database with the exception of several
> tables.  When I run "VACUUM ANALYZE" (or "vacuumdb -z") on the
> database, how can

Why are you doing this in the first place?  Autovacuum works just
great for modern PostgreSQL versions, and if you're not using one of
those, you should be planning your migration, not propping up the old
one :)

Cheers,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

In response to

pgsql-general by date

Next:From: Andrew SullivanDate: 2008-10-30 14:11:13
Subject: Re: Are there plans to add data compression feature topostgresql?
Previous:From: David FetterDate: 2008-10-30 14:02:45
Subject: Re: Schema Upgrade Howto

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group