X-Original-To: pgsql-sql@postgresql.org
Received: from shield.pirmabanka.lv (unknown [195.114.57.4])
	by postgresql.org (Postfix) with ESMTP id EFA7C474E4F
	for <pgsql-sql@postgresql.org>; Wed, 19 Mar 2003 10:01:45 -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 h2JF1ntw009189
	for <pgsql-sql@postgresql.org>; Wed, 19 Mar 2003 17:01:49 +0200
Received: from share.pirmabanka.lv ([10.0.0.10]) by wall2.pirmabanka.lv;
	Wed, 19 Mar 2003 17:01:48 +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 h2JF1mG15064
	for <pgsql-sql@postgresql.org>; Wed, 19 Mar 2003 17:01:48 +0200
Received: (qmail 15490 invoked by uid 100); 19 Mar 2003 15:02:42 -0000
Date: Wed, 19 Mar 2003 17:02:42 +0200
From: Victor Yegorov <viy@pirmabanka.lv>
To: Tomasz Myrta <jasiek@klaster.net>
Cc: Postgres SQL <pgsql-sql@postgresql.org>
Subject: Re: vacuum all but system tables
Message-ID: <20030319150242.GG14195@pirmabanka.lv>
Mail-Followup-To: Tomasz Myrta <jasiek@klaster.net>,
	Postgres SQL <pgsql-sql@postgresql.org>
References: <20030319083846.GB14195@pirmabanka.lv>
	<6527.1048084170@sss.pgh.pa.us>
	<20030319143954.GD14195@pirmabanka.lv>
	<3E788484.9050604@klaster.net>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="Sw7tCqrGA+HQ0/zt"
Content-Disposition: inline
In-Reply-To: <3E788484.9050604@klaster.net>
User-Agent: Mutt/1.4i
X-Archive-Number: 200303/462
X-Sequence-Number: 12501

--Sw7tCqrGA+HQ0/zt
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Tomasz Myrta <jasiek@klaster.net> [19.03.2003 16:57]:
> U?ytkownik Victor Yegorov napisa?:
> >* Tom Lane <tgl@sss.pgh.pa.us> [19.03.2003 16:32]:
> >
> >>"Victor Yegorov" <viy@pirmabanka.lv> 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.
>=20
> They are location-wide. What's wrong with default vacuuming all=20
> databases at once nightly? Or maybe you better need to vacuume only=20
> specific tables?

Tom Lane pointed, that only 3 tables are location-wide:
    pg_database, pg_shadow, pg_group.

Anyway, I understood, that there is more 'good' than 'bad' in vacuuming sys=
tem
tables ;)

Thanks everyone.

--=20

Victor Yegorov

--Sw7tCqrGA+HQ0/zt
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+eIaS2RKGLEykUDYRAm6CAJ9KWOjY/iLQP7mh/3eN2ZQBgu+U/ACgyu6e
J8vuubdqkgUYnLWiw/40ysk=
=u8OT
-----END PGP SIGNATURE-----

--Sw7tCqrGA+HQ0/zt--