Re: which ext3 fs type should I use for postgresql

Поиск
Список
Период
Сортировка
От Guillaume Cottenceau
Тема Re: which ext3 fs type should I use for postgresql
Дата
Msg-id 87ve1fwqov.fsf@mnc.ch
обсуждение исходный текст
Ответ на Re: which ext3 fs type should I use for postgresql  (Craig James <craig_james@emolecules.com>)
Ответы Re: which ext3 fs type should I use for postgresql
Список pgsql-performance
Craig James <craig_james 'at' emolecules.com> writes:

> Matthew Wakeling wrote:
>> Probably of more use are some of the other settings:
>>
>>  -m reserved-blocks-percentage - this reserves a portion of the filesystem
>>     that only root can write to. If root has no need for it, you can kill
>>     this by setting it to zero. The default is for 5% of the disc to be
>>     wasted.
>
> This is not a good idea.  The 5% is NOT reserved for root's
> use, but rather is to prevent severe file fragmentation.  As

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?

--
Guillaume Cottenceau

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

Предыдущее
От: Craig James
Дата:
Сообщение: Re: which ext3 fs type should I use for postgresql
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: I/O on select count(*)