Re: [HACKERS] PostgreSQL and FreeBSD SoftUpdates

2004-03-29 Thread Sean Chittenden
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

Re: [HACKERS] PostgreSQL and FreeBSD SoftUpdates

2004-03-29 Thread Christopher Kings-Lynne
'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?) ... Log file's on

Re: [HACKERS] PostgreSQL and FreeBSD SoftUpdates

2004-03-29 Thread Marc G. Fournier
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

Re: [HACKERS] PostgreSQL and FreeBSD SoftUpdates

2004-03-29 Thread Christopher Kings-Lynne
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 (no

Re: [HACKERS] PostgreSQL and FreeBSD SoftUpdates

2004-03-29 Thread Marc G. Fournier
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 > [EMAIL PROTECTED]:/usr/obj/usr

Re: [HACKERS] PostgreSQL and FreeBSD SoftUpdates

2004-03-29 Thread Marc G. Fournier
what version of FreeBSD are you using? I'm running 4.9-STABLE with softupdates on my db file system ... On Tue, 30 Mar 2004, Christopher Kings-Lynne wrote: > Hi guys, > > Does anyone else have this problem? > > We have softupdates turned on on our data dir. (Soon to be turned off > due to thes

Re: [HACKERS] PostgreSQL and FreeBSD SoftUpdates

2004-03-29 Thread Christopher Kings-Lynne
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 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GODDARD i386 We're not 100% sure it's softupdates, but w

[HACKERS] PostgreSQL and FreeBSD SoftUpdates

2004-03-29 Thread Christopher Kings-Lynne
Hi guys, Does anyone else have this problem? We have softupdates turned on on our data dir. (Soon to be turned off due to these issues). The partition is 12GB. 'df' says that we're using 12 and a bit GB but 'du' says we're using 2GB (which we really are). It seems that perhaps softupdates i