From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Kevin Kempter <kevin@kevinkempterllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Get a list of ALL tables
Date: Tue, 20 Nov 2007 07:30:20 -0300
Message-ID: <20071120103020.GA5167@alvh.no-ip.org> (raw)
In-Reply-To: <200711191641.10792.kevin@kevinkempterllc.com>
References: <200711191524.47852.kevin@kevinkempterllc.com>
<8053.1195514955@sss.pgh.pa.us>
<200711191641.10792.kevin@kevinkempterllc.com>
Kevin Kempter wrote:
> Sorry, I meant to send this to the list:
>
>
> We have a handful of tables that are quite large and take several hours to
> vacuum. We're managing these large tables by using cron via a schedule that
> accounts for system load. I want to pull the list of all tables and exclude
> these large tables from the list, then run the vacuum on the remaining tables
> once a week to avoid transaction ID wraparound failures.
You can't do this in 8.1 -- in that release, the only way to advance the
wraparound safety point is to execute a database-wide vacuum. You can't
exclude tables. If you want to be able to do that you'll need to jump
to 8.2.
--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@alvh.no-ip.org, kevin@kevinkempterllc.com
Subject: Re: Get a list of ALL tables
In-Reply-To: <20071120103020.GA5167@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox