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

Re: excluding tables from VACUUM ANALYZE

From: "Nikolas Everett" <nik9000(at)gmail(dot)com>
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 13:40:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I generally write bash one liners for this kind of thing:

for table in $(psql -U postgres --tuples-only -c "SELECT schemaname || '.'
|| tablename FROM pg_tables WHERE tablename NOT IN ('table1', 'table2')") ;
do psql -U postgres -c "VACUUM ANALYZE $table"; done

This is nice because you can bring all kinds of awk/sed/grep to bear on your

On Thu, Oct 30, 2008 at 9:17 AM, Igor Neyman <ineyman(at)perceptron(dot)com> 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 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

In response to

pgsql-general by date

Next:From: David FetterDate: 2008-10-30 14:02:45
Subject: Re: Schema Upgrade Howto
Previous:From: Thomas GuettlerDate: 2008-10-30 13:37:43
Subject: Re: Schema Upgrade Howto

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