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

Re: Get a list of ALL tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Get a list of ALL tables
Date: 2007-11-19 23:29:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Kevin Kempter <kevin(at)kevinkempterllc(dot)com> writes:
> I'm working with a client with several highly active 8.1.4 servers. I want to 
> run a weekly cron that will vacuum ALL db tables except those with entries in 
> pg_autovacuum (where we've setup manual/cron vacuums) in order to eliminate 
> transaction ID wraparound failure warnings (which comes up fairly often).

> My question is:
> will a select from pg_tables for each database in the cluster provide me with 
> a full table listing for the purposes of ensuring that all tables in the db 
> have been vacuumed or are there others I'll need to account for as well ?

Why are you insisting on inventing your own wheel for this, when
"vacuum" without a parameter does that just fine?

			regards, tom lane

In response to


pgsql-admin by date

Next:From: Kevin KempterDate: 2007-11-19 23:41:10
Subject: Re: Get a list of ALL tables
Previous:From: Kevin KempterDate: 2007-11-19 22:24:47
Subject: Get a list of ALL tables

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