Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E7B4D2E003C for ; Tue, 20 Nov 2007 06:30:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88340-04 for ; Tue, 20 Nov 2007 06:30:18 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id A54372E003A for ; Tue, 20 Nov 2007 06:30:17 -0400 (AST) Received: from perhan.alvh.no-ip.org (190-95-31-112.bk17-dsl.surnet.cl [190.95.31.112]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lAKAUAQo024099 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 20 Nov 2007 02:30:13 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 2AAE247C0D; Tue, 20 Nov 2007 07:30:20 -0300 (CLST) Date: Tue, 20 Nov 2007 07:30:20 -0300 From: Alvaro Herrera To: Kevin Kempter Cc: pgsql-admin@postgresql.org Subject: Re: Get a list of ALL tables Message-ID: <20071120103020.GA5167@alvh.no-ip.org> References: <200711191524.47852.kevin@kevinkempterllc.com> <8053.1195514955@sss.pgh.pa.us> <200711191641.10792.kevin@kevinkempterllc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200711191641.10792.kevin@kevinkempterllc.com> User-Agent: Mutt/1.5.16 (2007-06-11) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 20 Nov 2007 02:30:13 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/184 X-Sequence-Number: 27427 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?"