From: Y Sidhu <ysidhu@gmail.com>
To: Jim C. Nasby <decibel@decibel.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Disk Fills Up and fsck "Compresses" it
Date: Wed, 16 May 2007 08:21:23 -0700
Message-ID: <b09064f30705160821k55a37476v65ba5ab054473cd2@mail.gmail.com> (raw)
In-Reply-To: <20070515234152.GD20707@nasby.net>
References: <b09064f30705151318v2c770d76h89e32c9303777070@mail.gmail.com>
<20070515234152.GD20707@nasby.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ysidhu@gmail.com, decibel@decibel.org
Subject: Re: Disk Fills Up and fsck "Compresses" it
In-Reply-To: <b09064f30705160821k55a37476v65ba5ab054473cd2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox