Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2

Поиск
Список
Период
Сортировка
От pinker
Тема Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2
Дата
Msg-id 1493059417652-5958066.post@n3.nabble.com
обсуждение исходный текст
Ответ на [GENERAL] Block size recommendation for Red Hat Linux 7.2  (chiru r <chirupg@gmail.com>)
Ответы Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
I've seen very big differences with huge_pages set to on, especially in
context of CPU usage on multiple socket servers.

You could play as well with storage options, for instance inode size and
check if there is any advantage for your db from inlining, which is
supported by xfs. You can find more informations here:
http://beegfs.com/wiki/StorageServerTuning

An interesting option for WAL would be to add the mount option- allocsize -
and set it to 16MB - so the exact size of WAL segment to reduce the risk of
fragmentation and optimal streaming write throughput.



--
View this message in context:
http://www.postgresql-archive.org/Block-size-recommendation-for-Red-Hat-Linux-7-2-tp5958026p5958066.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Mark Watson
Дата:
Сообщение: Re: [GENERAL] Postgres 9.6.2 and pg_log
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] Postgres 9.6.2 and pg_log