Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id ACD4A9FB98C for ; Tue, 31 Jul 2007 02:20:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 09274-01 for ; Tue, 31 Jul 2007 02:20:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id CB2B69FBB13 for ; Tue, 31 Jul 2007 02:19:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l6V5JGwS006792; Tue, 31 Jul 2007 01:19:16 -0400 (EDT) To: "Merlin Moncure" cc: "Joshua D. Drake" , "Brandon Shalton" , pgsql-performance@postgresql.org Subject: Re: disk filling up In-reply-to: References: <009c01c7cfa0$ab526810$fc01a8c0@blaptop> <46A8B3EC.1090807@commandprompt.com> Comments: In-reply-to "Merlin Moncure" message dated "Fri, 27 Jul 2007 09:44:31 -0400" Date: Tue, 31 Jul 2007 01:19:16 -0400 Message-ID: <6791.1185859156@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/434 X-Sequence-Number: 26118 "Merlin Moncure" writes: > third (but unlikely) possibility is there are various dropped tables, > etc which need to be deleted but there are stale postgresql processes > holding on to the fd. This would only happen following a postmaster > crash or some other bizarre scenario, but i've seen it on production > box. Brent Reid reported something similar in bug #3483 but I'm still quite unclear how it'd happen in any realistic scenario. Can you create a test case? regards, tom lane