X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id ACBA4D1B8EA for ; Wed, 10 Mar 2004 15:24:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08801-08 for ; Wed, 10 Mar 2004 11:24:06 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 776CED1B897 for ; Wed, 10 Mar 2004 11:24:04 -0400 (AST) 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 i2AFO0fA006732; Wed, 10 Mar 2004 10:24:00 -0500 (EST) To: "Shea,Dan [CIS]" Cc: pgsql-performance@postgresql.org Subject: Re: Cluster failure due to space In-reply-to: References: Comments: In-reply-to "Shea,Dan [CIS]" message dated "Wed, 10 Mar 2004 08:56:57 -0500" Date: Wed, 10 Mar 2004 10:24:00 -0500 Message-ID: <6731.1078932240@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/130 X-Sequence-Number: 5986 "Shea,Dan [CIS]" writes: > The problem is that it did not clean itself up properly. Hm. It should have done so. What were the exact filenames and sizes of the not-deleted files? > I can not find any reference to 361716097 in the pg_class table. You are looking at pg_class.relfilenode, I hope, not pg_class.oid. regards, tom lane