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 91DD3476285
	for <pgsql-sql@postgresql.org>; Wed, 19 Mar 2003 09:29:30 -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 h2JETUub006528;
	Wed, 19 Mar 2003 09:29:30 -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: <20030319083846.GB14195@pirmabanka.lv> 
References: <20030319083846.GB14195@pirmabanka.lv>
Comments: In-reply-to "Victor Yegorov" <viy@pirmabanka.lv>
	message dated "Wed, 19 Mar 2003 10:38:46 +0200"
Date: Wed, 19 Mar 2003 09:29:30 -0500
Message-ID: <6527.1048084170@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200303/457
X-Sequence-Number: 12496

"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