Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 830269FBBA3 for ; Tue, 31 Jul 2007 13:16:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 87237-03 for ; Tue, 31 Jul 2007 13:16:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 78A2A9FBBF6 for ; Tue, 31 Jul 2007 13:16:40 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so110474ugf for ; Tue, 31 Jul 2007 09:16:38 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=V3DOTo9v2mgLAP/tMnsE1DLQ8Pv5AoJLaSRBqQUdWgPUDnT0liTKPuJfA1XOZHJadKA7wmRzkGMlJNmWoM6QbHiOD28a5oznYaAzIt5n+j/XAy5T5QGRmA7+viFQoR0KDCK8FlDE8oBiUULjl4UbhsbX1iJ8F7Ia9CUF84JmepY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=gV7TrANylwW3VEq9AhteJEzyCqbvcTsyYwbzhFI2a1B1ucaOexvIGoKzTnDPsbqbBbk1IcwqAWjVRS0iScQnUDLSq3ZKJdU+7dAWx45kqHqxTt8p8CaWHjb4nYdBIHShEgFfvaP6r+ahUhs7CU+KEJ0zu9ozsG9y7X6YgyD8Yjc= Received: by 10.78.160.4 with SMTP id i4mr1855484hue.1185898598159; Tue, 31 Jul 2007 09:16:38 -0700 (PDT) Received: by 10.78.18.9 with HTTP; Tue, 31 Jul 2007 09:16:38 -0700 (PDT) Message-ID: Date: Tue, 31 Jul 2007 12:16:38 -0400 From: "Merlin Moncure" To: "Tom Lane" Subject: Re: disk filling up Cc: "Joshua D. Drake" , "Brandon Shalton" , pgsql-performance@postgresql.org In-Reply-To: <6791.1185859156@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <009c01c7cfa0$ab526810$fc01a8c0@blaptop> <46A8B3EC.1090807@commandprompt.com> <6791.1185859156@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/441 X-Sequence-Number: 26125 On 7/31/07, Tom Lane wrote: > "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? No, but I've seen it on a production 8.1 box (once). I didn't actually cause the problem, just cleaned it up. It was unnoticed for several weeks/months because the postmaster processes showed up without a controlling tty. My best guess is the postmaster was killed improperly out of haste during a maintenance window, or possibly an out of disk space related issue at an earlier point. I never really considered that it was a postgresql problem. merlin