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 1C3323A3E04; Fri, 5 Nov 2004 17:20:27 +0000 (GMT) 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 92051-08; Fri, 5 Nov 2004 17:20:24 +0000 (GMT) Received: from hotmail.com (bay16-f10.bay16.hotmail.com [65.54.186.60]) by svr1.postgresql.org (Postfix) with ESMTP id 128053A3D5B; Fri, 5 Nov 2004 17:20:24 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 5 Nov 2004 09:20:06 -0800 Received: from 65.242.105.130 by by16fd.bay16.hotmail.msn.com with HTTP; Fri, 05 Nov 2004 17:19:15 GMT X-Originating-IP: [65.242.105.130] X-Originating-Email: [salemb4@hotmail.com] X-Sender: salemb4@hotmail.com From: "Salem Berhanu" To: tgl@sss.pgh.pa.us, dedeb17@hotmail.com Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: VACUUM failing ??!! Date: Fri, 05 Nov 2004 17:19:15 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 05 Nov 2004 17:20:06.0331 (UTC) FILETIME=[B1A928B0:01C4C35B] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=MAILTO_TO_SPAM_ADDR, PLING_QUERY X-Spam-Level: * X-Archive-Number: 200411/43 X-Sequence-Number: 15428 Version 7.4 (I just re-indexed and I'm running vacuum again) >From: Tom Lane >To: "Sally Sally" >CC: pgsql-admin@postgresql.org, pgsql-general@postgresql.org >Subject: Re: [ADMIN] VACUUM failing ??!! Date: Fri, 05 Nov 2004 11:04:00 >-0500 > >"Sally Sally" writes: > > After running for more than 24 hrs (I have a large db), vacuum failed >with > > this message: > > ERROR: failed to re-find parent key in "pg_type_typname_nsp_index" > >What PG version? > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 8: explain analyze is your friend _________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement