Re: PostgreSQL and FreeBSD SoftUpdates

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: PostgreSQL and FreeBSD SoftUpdates
Дата
Msg-id 20040329232654.W51637@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>)
Список pgsql-hackers
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
> wg@goddard.calorieking.com:/usr/obj/usr/src/sys/GODDARD  i386
>
> We're not 100% sure it's softupdates, but we can't see anything else
> that it could be.

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?

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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump 7.4 bug
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: pg_dump end comment