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: | 8053.1195514955@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Kempter | 2007-11-19 23:41:10 | Re: Get a list of ALL tables |
Previous Message | Kevin Kempter | 2007-11-19 22:24:47 | Get a list of ALL tables |