X-Original-To: pgsql-sql@postgresql.org
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 6A9B2476311
	for <pgsql-sql@postgresql.org>; Wed, 19 Mar 2003 09:47:17 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2JElIub006729;
	Wed, 19 Mar 2003 09:47:19 -0500 (EST)
To: "Victor Yegorov" <viy@pirmabanka.lv>
Cc: "Postgres SQL" <pgsql-sql@postgresql.org>
Subject: Re: vacuum all but system tables 
In-reply-to: <20030319143954.GD14195@pirmabanka.lv> 
References: <20030319083846.GB14195@pirmabanka.lv>
	<6527.1048084170@sss.pgh.pa.us>
	<20030319143954.GD14195@pirmabanka.lv>
Comments: In-reply-to "Victor Yegorov" <viy@pirmabanka.lv>
	message dated "Wed, 19 Mar 2003 16:39:54 +0200"
Date: Wed, 19 Mar 2003 09:47:18 -0500
Message-ID: <6728.1048085238@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200303/459
X-Sequence-Number: 12498

"Victor Yegorov" <viy@pirmabanka.lv> writes:
> 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?

pg_database, pg_shadow, pg_group are shared, the rest are per-database.

These three are generally not so large that it's worth worrying about
vacuuming them extra times ...

			regards, tom lane