Re: PostgreSQL and FreeBSD SoftUpdates

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, Hackers <pgsql-hackers(at)postgresql(dot)org>, Warren Guy <wg(at)familyhealth(dot)com(dot)au>
Subject: Re: PostgreSQL and FreeBSD SoftUpdates
Date: 2004-03-30 03:28:15
Message-ID: 20040329232654.W51637@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 30 Mar 2004, Christopher Kings-Lynne wrote:

> > what version of FreeBSD are you using? I'm running 4.9-STABLE with
> > softupdates on my db file system ...
>
> FreeBSD goddard.calorieking.com 4.9-STABLE FreeBSD 4.9-STABLE #2: Mon
> Jan 26 23:23:17 EST 2004
> wg(at)goddard(dot)calorieking(dot)com:/usr/obj/usr/src/sys/GODDARD i386
>
> We're not 100% sure it's softupdates, but we can't see anything else
> that it could be.

Right off the top of my head, it almost sounds like a file is being held
open after its been deleted ... we went through that with the new aspseek
a little while back, where 170gig just disappeared overnight, but du
showed hardly any disk space being used ...

Does restarting the database server (not rebooting, just restarting the
postmaster) free up the disk space?

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-03-30 03:37:45 pg_dump end comment
Previous Message Tom Lane 2004-03-30 03:13:03 Re: pg_dump 7.4 bug