X-Original-To: pgsql-sql@postgresql.org Received: from shield.pirmabanka.lv (unknown [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id D5622476315 for ; Wed, 19 Mar 2003 09:38:57 -0500 (EST) Received: from wall2.pirmabanka.lv (wall2-pub.pirmabanka.lv [195.114.57.14]) by shield.pirmabanka.lv (8.12.8/8.9.3) with SMTP id h2JEd0tw008830 for ; Wed, 19 Mar 2003 16:39:00 +0200 Received: from share.pirmabanka.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Wed, 19 Mar 2003 16:39:00 +0200 (EET) Received: from pc311x1.pirmabanka.lv (localhost.localdomain [127.0.0.1]) by pirmabanka.lv (8.11.6/8.11.6) with SMTP id h2JEcxi12549 for ; Wed, 19 Mar 2003 16:38:59 +0200 Received: (qmail 15376 invoked by uid 100); 19 Mar 2003 14:39:54 -0000 Date: Wed, 19 Mar 2003 16:39:54 +0200 From: "Victor Yegorov" To: Tom Lane Cc: "Postgres SQL" Subject: Re: vacuum all but system tables Message-ID: <20030319143954.GD14195@pirmabanka.lv> Mail-Followup-To: Tom Lane , "Postgres SQL" References: <20030319083846.GB14195@pirmabanka.lv> <6527.1048084170@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="IiVenqGWf+H9Y6IX" Content-Disposition: inline In-Reply-To: <6527.1048084170@sss.pgh.pa.us> User-Agent: Mutt/1.4i X-Archive-Number: 200303/458 X-Sequence-Number: 12497 --IiVenqGWf+H9Y6IX Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Tom Lane [19.03.2003 16:32]: > "Victor Yegorov" writes: > > I'd like to make a script to automatically vacuum all my DBs nightly. A= nd > > I'd like to skip system tables, starting with pg_*. >=20 > Um ... what in the world makes you think that's a good idea? System > tables need maintenance too. >=20 > 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. --=20 Victor Yegorov --IiVenqGWf+H9Y6IX Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+eIE62RKGLEykUDYRAphOAKCjKm1EOMrk5D8ir8MJyFFLg0Lj9gCgz/4M arMVfmlMK03fy9wc1Nz2RO0= =ceAb -----END PGP SIGNATURE----- --IiVenqGWf+H9Y6IX--