Postgres Pro
Downloads
Home   >   mailing lists

excluding tables from VACUUM ANALYZE - Mailing list pgsql-general

From Igor Neyman
Subject excluding tables from VACUUM ANALYZE
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A203A8FB83@EXCHANGE.corp.perceptron.com
Whole thread Raw
Responses Re: excluding tables from VACUUM ANALYZE  ("Nikolas Everett" <nik9000@gmail.com>)
Re: excluding tables from VACUUM ANALYZE  (David Fetter <david@fetter.org>)
List pgsql-general
Tree view
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 

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Schema Upgrade Howto
Next
From: "Roberts, Jon"
Date:
Subject: Re: Piping CSV data to psql when executing COPY .. FROM STDIN (Solved)