X-Original-To: pgsql-sql@postgresql.org Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 074E7476311 for ; Wed, 19 Mar 2003 09:52:48 -0500 (EST) Received: from klaster.net (pa160.krakow.cvx.ppp.tpnet.pl [213.76.36.160]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 511026A200; Wed, 19 Mar 2003 15:52:47 +0100 (CET) Message-ID: <3E788484.9050604@klaster.net> Date: Wed, 19 Mar 2003 15:53:56 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL; rv:1.3) Gecko/20030312 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Victor Yegorov Cc: Postgres SQL Subject: Re: vacuum all but system tables References: <20030319083846.GB14195@pirmabanka.lv> <6527.1048084170@sss.pgh.pa.us> <20030319143954.GD14195@pirmabanka.lv> In-Reply-To: <20030319143954.GD14195@pirmabanka.lv> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Archive-Number: 200303/460 X-Sequence-Number: 12499 Użytkownik Victor Yegorov napisał: > * Tom Lane [19.03.2003 16:32]: > >>"Victor Yegorov" writes: >> >>>I'd like to make a script to automatically vacuum all my DBs nightly. And >>>I'd like to skip system tables, starting with pg_*. >> >>Um ... what in the world makes you think that's a good idea? System >>tables need maintenance too. >> >> regards, tom lane > > > Yes, of course they need. > > May be I'll put my question in a different manner: > > System tables are location-wide (I mean one set of tables for PostgreSQL > location) or each database has it's own set of system tables? > > If second, I apologies for noising. If first, I'd like to have a separate > script for them. They are location-wide. What's wrong with default vacuuming all databases at once nightly? Or maybe you better need to vacuume only specific tables? Regards, Tomasz Myrta