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
