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: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
This question didn't get any "traction on "admin" list, so I'll try

I want to analyze the entire database with the exception of several
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"?


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-2017 The PostgreSQL Global Development Group