Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D29E39FBFDA for ; Tue, 15 May 2007 20:42:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14326-02 for ; Tue, 15 May 2007 20:41:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id D6E1A9FBF90 for ; Tue, 15 May 2007 20:41:56 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 61C5D56457; Tue, 15 May 2007 18:41:55 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 15 May 2007 18:41:53 -0500 Date: Tue, 15 May 2007 18:41:53 -0500 From: "Jim C. Nasby" To: Y Sidhu Cc: pgsql-performance@postgresql.org Subject: Re: Disk Fills Up and fsck "Compresses" it Message-ID: <20070515234152.GD20707@nasby.net> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070515:ysidhu@gmail.com::fSVv7VGknX8/TfKN:05TZa X-Hashcash: 1:20:070515:pgsql-performance@postgresql.org::7XfcXKSfZ9L4F0La:00000 0000000000000000000000006T1h X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/280 X-Sequence-Number: 24670 I'm guessing you're seeing the affect of softupdates. With those enabled it can take some time before the space freed by a delete will actually show up as available. On Tue, May 15, 2007 at 01:18:42PM -0700, Y Sidhu wrote: > Anyone seen PG filling up a 66 GB partition from say 40-ish percentage to > 60-ish percentage in a manner of minutes. When I run a 'fsck' the disk usage > comes down to 40-ish percentage. That's about 10+ GB's variance. > > This is a FreeBSD 6.2 RC2, 4GB memory, Xeon 3.2 GHz '4' of the '8' CPUs in > use - dual cpu, dual core with HTT turned off in the sense that the other 4 > cpu's have been masked out. The drive is a Western Digital 70 GB SATA. > > -- > Yudhvir Singh Sidhu > 408 375 3134 cell -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)