Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 21EB2632B40 for ; Tue, 7 Sep 2010 19:51:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 92077-08 for ; Tue, 7 Sep 2010 22:51:15 +0000 (UTC) X-Greylist: delayed 00:12:05.105849 by SQLgrey-1.7.6 Received: from nrccenexf1.nrc.ca (nrccenexf1.nrc.ca [132.246.15.80]) by mail.postgresql.org (Postfix) with ESMTP id 15CF5633484 for ; Tue, 7 Sep 2010 19:51:15 -0300 (ADT) Received: from nrccenexf1.nrc.ca ([132.246.15.80]) by nrccenexf1.nrc.ca with Microsoft SMTPSVC(6.0.3790.4675); Tue, 7 Sep 2010 18:39:07 -0400 Received: from [132.246.194.17] ([132.246.11.2]) by nrccenexf1.nrc.ca over TLS secured channel with Microsoft SMTPSVC(6.0.3790.4675); Tue, 7 Sep 2010 18:39:06 -0400 Message-ID: <4C86BF09.60003@nrc-cnrc.gc.ca> Date: Tue, 07 Sep 2010 15:39:05 -0700 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: vacuumdb for schema only Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 07 Sep 2010 22:39:06.0975 (UTC) FILETIME=[7B12A6F0:01CB4EDD] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201009/61 X-Sequence-Number: 35605 Hi List, I would like to know if there is an option to run full vacuumdb for a specific schema only, I see there is option for tables or whole db . Thank you Isabella -- ----------------------------------------------------------- Isabella A. Ghiurea Isabella.Ghiurea@nrc-cnrc.gc.ca Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Astrophysics 5071 West Saanich Road, Victoria BC V9E 2E7, Canada Phone: 250 363-3446 fax: 250 363-0045