Re: which ext3 fs type should I use for postgresql

Поиск
Список
Период
Сортировка
От Guillaume Cottenceau
Тема Re: which ext3 fs type should I use for postgresql
Дата
Msg-id 87r6c3wpka.fsf@mnc.ch
обсуждение исходный текст
Ответ на Re: which ext3 fs type should I use for postgresql  (Matthew Wakeling <matthew@flymine.org>)
Ответы Re: which ext3 fs type should I use for postgresql  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-performance
Matthew Wakeling <matthew 'at' flymine.org> writes:

> On Thu, 15 May 2008, Guillaume Cottenceau wrote:
>> Also, IIRC when PG writes data up to a full filesystem,
>> postmaster won't be able to then restart if the filesystem is
>> still full (it needs some free disk space for its startup).
>>
>> Or maybe this has been fixed in recent versions?
>
> Ah, the "not enough space to delete file, delete some files and try
> again" problem. Anyway, that isn't relevant to the reserved
> percentage, as that will happen whether or not the filesystem is 5%
> smaller.

It is still relevant, as with 5% margin, you can afford changing
that to 0% with tune2fs, just the time for you to start PG and
remove some data by SQL, then shutdown and set the margin to 5%
again.

--
Guillaume Cottenceau

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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: which ext3 fs type should I use for postgresql
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: which ext3 fs type should I use for postgresql