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

Re: PostgreSQL and FreeBSD SoftUpdates

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: Warren Guy <wg(at)familyhealth(dot)com(dot)au>,Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL and FreeBSD SoftUpdates
Date: 2004-03-30 04:27:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
>>> 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?) ...

Install the latest version of lsof(8) and see if there are any stale 
files being held open.  I've got databases on FreeBSD 4.X and 5.X with 
softupdates on both and haven't had a problem.  I'm wondering if your 
database is doing something "exotic" that hasn't been tickled.  The 
first thing that comes to mind is, are you using deferred constraints?  
Second, if it is a soft updates issue, then a reboot isn't necessary 
(as Marc says)... you should be able to stop the database and type df 
-k && sync && sleep 30 && df -k see space being freed up.  -sc

Sean Chittenden

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-03-30 05:29:00
Subject: Re: pg_dump end comment
Previous:From: Christopher Kings-LynneDate: 2004-03-30 04:21:05
Subject: Re: PostgreSQL and FreeBSD SoftUpdates

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