[GENERAL] Prudent practices for PostgreSQL disk configuration?

Поиск
Список
Период
Сортировка
От Ray Cote
Тема [GENERAL] Prudent practices for PostgreSQL disk configuration?
Дата
Msg-id CAG5tnzp6x-cBeE1MxF-gCeY2Aj7djCgwnR2sPLonww7v+FQSyA@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Hello:

I’m about to upgrade my disk configuration and looking for prudent disk configuration practices for running PostgreSQL 9.3 on RHEL6 in a VMWare environment in a shared hosting facility — physical disk not SSD. This is a write-heavy transactional application. 8 Cpu cores (if it matters)

Things I (think I) know to do:
- Separate database storage, WAL, and standard logs into different partitions.
- 8K disk blocks.
- Use ext4 vs. XFS(?)
- data=writeback,noatime,nodiratime

Any other disk-specific settings you would recommend as a starting point for initial testing? 
Appreciate any thoughts.

—Ray

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

Предыдущее
От: Ray Stell
Дата:
Сообщение: [GENERAL] 10beta1 role
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] 10beta1 role