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

excluding tables from VACUUM ANALYZE

From: "Igor Neyman" <ineyman(at)perceptron(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: excluding tables from VACUUM ANALYZE
Date: 2008-10-30 13:17:00
Message-ID: F4C27E77F7A33E4CA98C19A9DC6722A203A8FB83@EXCHANGE.corp.perceptron.com (view raw or flat)
Thread:
Lists: pgsql-general
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
I exclude specific tables from being analyzed?
Is there any place in system dictionary, where the table could be marked
, so it's not processed (skipped) by "vacuum analyze"?
 
Igor 

Responses

pgsql-general by date

Next:From: Teodor SigaevDate: 2008-10-30 13:37:40
Subject: Re: Weird problem concerning tsearch functions built into postgres 8.3, assistance requested
Previous:From: David FetterDate: 2008-10-30 13:09:06
Subject: Re: Schema Upgrade Howto

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