Re: PostgreSQL and FreeBSD SoftUpdates - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: PostgreSQL and FreeBSD SoftUpdates
Date
Msg-id 20040330000327.A51637@ganymede.hub.org
Whole thread Raw
In response to Re: PostgreSQL and FreeBSD SoftUpdates  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: PostgreSQL and FreeBSD SoftUpdates  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: PostgreSQL and FreeBSD SoftUpdates  (Sean Chittenden <sean@chittenden.org>)
List pgsql-hackers
On Tue, 30 Mar 2004, Christopher Kings-Lynne wrote:

> > 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?
>
> No - have to reboot.  That's probably because of softupdates though.

'k, *shouldn't* require a reboot ... but, what I'd try is to do what
you've thought .. disable softupdates and see if you can recreate ... if
killing off the process auto-reclaims the space fast, then it sounds like
a stale file being held open (log file being rotated improperly?) ...

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


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: PostgreSQL and FreeBSD SoftUpdates
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: PostgreSQL and FreeBSD SoftUpdates