Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 529689FB964
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 16 May 2007 12:21:34 -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 39899-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 16 May 2007 12:21:09 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.243])
	by postgresql.org (Postfix) with ESMTP id 02A629FB4D9
	for <pgsql-performance@postgresql.org>;
	Wed, 16 May 2007 12:21:25 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id d17so46914and
	for <pgsql-performance@postgresql.org>;
	Wed, 16 May 2007 08:21:25 -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:references;
	b=rb89AY/+PEYKs1ccr2E/chEHGBYyv4wMDx19LJxsidBiyYPGMR81u4tHTS5T2D4d/I0Kr++ozTMvlCszXkZJbPFFgXGHEQ5USq6peaiBxM9WFV2BR/wUa5MARseyM6VBVotc8Xb9/vpdeJca3SXWiFAoOPB2QIw3NHic3E7aBMY=
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:references;
	b=JFk4c9hdGFtxOR9sZTzuHqZMcyYfptsjdvum77AjnqKxudNqcD0d26eulWGHor1HgRZfoh/1E1rGDu9IUrH/lxWzyLXoEjNFfIYSuuQbnjvytyRfjiM2fhsDMN2g7Mgtq2O28RlMeEDEoEhCOovB1iE3PSV81Ho2MGAMfnjmsVc=
Received: by 10.100.173.19 with SMTP id v19mr6227128ane.1179328883291;
	Wed, 16 May 2007 08:21:23 -0700 (PDT)
Received: by 10.100.6.20 with HTTP; Wed, 16 May 2007 08:21:23 -0700 (PDT)
Message-ID: <b09064f30705160821k55a37476v65ba5ab054473cd2@mail.gmail.com>
Date: Wed, 16 May 2007 08:21:23 -0700
From: "Y Sidhu" <ysidhu@gmail.com>
To: "Jim C. Nasby" <decibel@decibel.org>
Subject: Re: Disk Fills Up and fsck "Compresses" it
Cc: pgsql-performance@postgresql.org
In-Reply-To: <20070515234152.GD20707@nasby.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_30374_7842097.1179328883074"
References: <b09064f30705151318v2c770d76h89e32c9303777070@mail.gmail.com>
	<20070515234152.GD20707@nasby.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200705/284
X-Sequence-Number: 24674

------=_Part_30374_7842097.1179328883074
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What do you mean by "softupdates?" Is that a parameter in what I am guessing
is the conf file?


Yudhvir

On 5/15/07, Jim C. Nasby <decibel@decibel.org> wrote:
>
> 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)
>



-- 
Yudhvir Singh Sidhu
408 375 3134 cell

------=_Part_30374_7842097.1179328883074
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What do you mean by &quot;softupdates?&quot; Is that a parameter in what I am guessing is the conf file? <br>
<br>
<br>
Yudhvir<br><br><div><span class="gmail_quote">On 5/15/07, <b class="gmail_sendername">Jim C. Nasby</b> &lt;<a href="mailto:decibel@decibel.org">decibel@decibel.org</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I&#39;m guessing you&#39;re seeing the affect of softupdates. With those enabled<br>it can take some time before the space freed by a delete will actually<br>show up as available.<br><br>On Tue, May 15, 2007 at 01:18:42PM -0700, Y Sidhu wrote:
<br>&gt; Anyone seen PG filling up a 66 GB partition from say 40-ish percentage to<br>&gt; 60-ish percentage in a manner of minutes. When I run a &#39;fsck&#39; the disk usage<br>&gt; comes down to 40-ish percentage. That&#39;s about 10+ GB&#39;s variance.
<br>&gt;<br>&gt; This is a FreeBSD 6.2 RC2, 4GB memory, Xeon 3.2 GHz &#39;4&#39; of the &#39;8&#39; CPUs in<br>&gt; use - dual cpu, dual core with HTT turned off in the sense that the other 4<br>&gt; cpu&#39;s have been masked out. The drive is a Western Digital 70 GB SATA.
<br>&gt;<br>&gt; --<br>&gt; Yudhvir Singh Sidhu<br>&gt; 408 375 3134 cell<br><br>--<br>Jim
Nasby&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="mailto:decibel@decibel.org">decibel@decibel.org</a><br>EnterpriseDB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://enterprisedb.com">http://enterprisedb.com</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;512.569.9461 (cell)<br></blockquote>
</div><br><br clear="all"><br>-- <br>Yudhvir Singh Sidhu<br>408 375 3134 cell

------=_Part_30374_7842097.1179328883074--