X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E88949FB286 for ; Thu, 24 Aug 2006 12:03:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 75932-09 for ; Thu, 24 Aug 2006 12:03:29 -0300 (ADT) X-Greylist: delayed 00:52:01.103763 by SQLgrey- Received: from mail.livedatagroup.com (mail.livedatagroup.com [64.139.134.201]) by postgresql.org (Postfix) with ESMTP id 0435C9FA6B1 for ; Thu, 24 Aug 2006 12:03:28 -0300 (ADT) Received: by mail.livedatagroup.com (Postfix, from userid 10003) id 69C9223D39B; Thu, 24 Aug 2006 11:03:28 -0400 (EDT) Received: from [192.168.2.134] (adsl-074-228-048-194.sip.bct.bellsouth.net [74.228.48.194]) by mail.livedatagroup.com (Postfix) with ESMTP id 41F5D23A18C for ; Thu, 24 Aug 2006 11:03:27 -0400 (EDT) Message-ID: <44EDBFBE.5070206@livedatagroup.com> Date: Thu, 24 Aug 2006 11:03:26 -0400 From: Pallav Kalva User-Agent: Thunderbird 1.5.0.5 (X11/20060725) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: 7.4 PG_CLOG problems References: <44EDB393.2080101@livedatagroup.com> <4943.1156431150@sss.pgh.pa.us> In-Reply-To: <4943.1156431150@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/270 X-Sequence-Number: 22813 Hi Tom, Thanks! for the reply, I just realized that yesterday by mistake the vacuum script also included "template0" database and it vacuumed that one too. Would that cause any problems ? Pallav. Tom Lane wrote: > Pallav Kalva writes: > >> Does anybody know what this means ? "LOG: removing file >> "/var/lib/pgsql/data/pg_clog/0000", >> > > Routine maintenance; don't worry about it. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >