Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2004-03-30 03:37:45
Subject: pg_dump end comment
Previous:From: Tom LaneDate: 2004-03-30 03:13:03
Subject: Re: pg_dump 7.4 bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group