X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1E55A5E4774 for ; Tue, 7 Sep 2004 04:46:15 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23263-02 for ; Tue, 7 Sep 2004 03:46:10 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1D2A05E4711 for ; Tue, 7 Sep 2004 04:46:09 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i873k9JR024794; Mon, 6 Sep 2004 23:46:09 -0400 (EDT) To: NH Lau Cc: pgsql-admin@postgresql.org Subject: Re: database vacuum In-reply-to: <20040907033318.8580.qmail@web53503.mail.yahoo.com> References: <20040907033318.8580.qmail@web53503.mail.yahoo.com> Comments: In-reply-to NH Lau message dated "Mon, 06 Sep 2004 20:33:18 -0700" Date: Mon, 06 Sep 2004 23:46:09 -0400 Message-ID: <24793.1094528769@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/58 X-Sequence-Number: 14761 NH Lau writes: > I would like to know > whether we should vacuum the template1 and template0 > database as well, in addition to the normal database > we created. template0 no --- in fact you wouldn't even be able to connect to it to do so (and I do not recommend overriding the check that prevents that). template1 yes. You could skip this if you know that template1 has never been modified since it was frozen ... but why assume that? The vacuumdb script gets this right btw. regards, tom lane