Re: PostgreSQL and FreeBSD SoftUpdates

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