Re: PostgreSQL and FreeBSD SoftUpdates

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: PostgreSQL and FreeBSD SoftUpdates
Дата
Msg-id 20040330000327.A51637@ganymede.hub.org
обсуждение исходный текст
Ответ на Re: PostgreSQL and FreeBSD SoftUpdates  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: PostgreSQL and FreeBSD SoftUpdates  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: PostgreSQL and FreeBSD SoftUpdates  (Sean Chittenden <sean@chittenden.org>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: PostgreSQL and FreeBSD SoftUpdates
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: PostgreSQL and FreeBSD SoftUpdates