Re: excluding tables from VACUUM ANALYZE - Mailing list pgsql-general

From David Fetter
Subject Re: excluding tables from VACUUM ANALYZE
Date
Msg-id 20081030140417.GQ18097@fetter.org
Whole thread Raw
In response to excluding tables from VACUUM ANALYZE  ("Igor Neyman" <ineyman@perceptron.com>)
List 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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

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

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Schema Upgrade Howto
Next
From: Andrew Sullivan
Date:
Subject: Re: Are there plans to add data compression feature to postgresql?