Re: Disk Fills Up and fsck "Compresses" it

From: "Y Sidhu" <ysidhu(at)gmail(dot)com>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Disk Fills Up and fsck "Compresses" it
Date: 2007-05-16 15:21:23
Message-ID: b09064f30705160821k55a37476v65ba5ab054473cd2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)decibel(dot)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(at)decibel(dot)org
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>

--
Yudhvir Singh Sidhu
408 375 3134 cell

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2007-05-16 15:38:36 Re: New performance documentation released
Previous Message Guillaume Cottenceau 2007-05-16 07:41:46 Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal