From owner-freebsd-questions@FreeBSD.ORG Wed Mar 20 16:09:59 2013 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 4D9B9472 for ; Wed, 20 Mar 2013 16:09:59 +0000 (UTC) (envelope-from matthew@freebsd.org) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id E145F1D3 for ; Wed, 20 Mar 2013 16:09:58 +0000 (UTC) Received: from rufus.webfusion.com (mail.heartinternet.co.uk [79.170.40.31]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.6/8.14.6) with ESMTP id r2KG9snW060928 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Wed, 20 Mar 2013 16:09:55 GMT (envelope-from matthew@freebsd.org) DKIM-Filter: OpenDKIM Filter v2.8.0 smtp.infracaninophile.co.uk r2KG9snW060928 Authentication-Results: smtp.infracaninophile.co.uk/r2KG9snW060928; dkim=none reason="no signature"; dkim-adsp=none (unprotected policy) X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host mail.heartinternet.co.uk [79.170.40.31] claimed to be rufus.webfusion.com Message-ID: <5149DF52.5040804@freebsd.org> Date: Wed, 20 Mar 2013 16:09:54 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:17.0) Gecko/20130312 Thunderbird/17.0.4 MIME-Version: 1.0 To: freebsd-questions@freebsd.org Subject: Re: "Leaking" disk space References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: clamav-milter 0.97.6 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-1.6 required=5.0 tests=AWL,BAYES_00,SPF_SOFTFAIL autolearn=no version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk Cc: mckusick@mckusick.com X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Mar 2013 16:09:59 -0000 On 20/03/2013 15:23, Dan Thomas wrote: > Hi Guys, > > We're seeing a problem with some of our FreeBSD/PostgreSQL servers > "leaking" quite significant amounts of disk space: > > > df -h /usr/local/pgsql/ > Filesystem Size Used Avail Capacity Mounted on > /dev/mfid1s1d 1.1T 772G 222G 78% /usr/local/pgsql > > > du -sh /usr/local/pgsql/ > 741G /usr/local/pgsql/ > > Stopping Postgres doesn't fix it, but rebooting does which points at > the OS rather than PG to me. However, the leak is only apparent in the > dedicated pgsql partition, and only on our database servers, so > PostgreSQL seems to at least be involved. The partition itself is a > relatively standard UFS partition: Hi, Dan You're not the first person to report that. Please see the thread: "leaking lots of unreferenced inodes (pg_xlog files?), maybe after moving tables and indexes to tablespace on different volume" on the freebsd-fs@freebsd.org mailing list. Kirk McKusick was investigating the original report: CC'd. Cheers, Matthew