GP主要是为了解决IO瓶颈而设计的，所以，磁盘性能尤其重要。对OLAP型的应用， 目前主流的配置方案是，计算节点主机，配置24块机械盘，Master节点主机一般配置 8到12块机械硬盘。如果选择SSD或者NVMe，可以根据容量和性能来评估磁盘数量。 不能只是单纯的追求容量，要综合考虑性能指标，单块磁盘的容量越大，故障恢复 的时间就越久。一般来说，如果选择机械盘，目前主流的选择是单盘不超过1.8TB。 多，因此，不可以将SWAP设置在OS磁盘上。 对于SSD或者NVMe的磁盘来说，以上关于性能的问题需要重新衡量，比如SWAP放 在哪里，比如是否要做Raid，一般来说，在不考虑Raid 5安全要求的情况下，建议不 做Raid 5，因为Raid 5的校验计算对于Raid卡的计算能力来说，会约束磁盘的性能 发挥。如果条件允许，可能SSD或者NVMe会是更好的选择，这也是磁盘技术的未来趋 势。机械盘在长期高 么大，但最好还是要有一定的保障，比如1TB的尺寸还是有必要的，因为会有日志等信 息的累积。另外，Master磁盘的性能也不能太差，毕竟系统表的性能影响也不能忽略。 如果条件允许，可以考虑为Master目录配置NVMe，保证系统表的性能。 Greenplum Database 管理员指南 V6.2.1 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 282 - 例

Cores 48 RAM 768 GB Cache Storage 4x Dell Express Flash NVMe ColdStream P4800x 750 GB PCIe U.2 SSD Capacity Storage 20x Dell Express Flash NVMe PM1725B (MU) 6.4 TB PCIe U.2 SSD There are 4 vSAN disk types follow: Storage Device Type OS Recommended Scheduler Policy Non-Volatile Memory Express (NVMe) RHEL 7 RHEL 8 Ubuntu none Solid-State Drives (SSD) RHEL 7 noop RHEL 8 Ubuntu none Other RHEL

Cores 48 RAM 768 GB Cache Storage 4x Dell Express Flash NVMe ColdStream P4800x 750 GB PCIe U.2 SSD Capacity Storage 20x Dell Express Flash NVMe PM1725B (MU) 6.4 TB PCIe U.2 SSD There are 4 vSAN disk types follow: Storage Device Type OS Recommended Scheduler Policy Non-Volatile Memory Express (NVMe) RHEL 7 RHEL 8 Ubuntu none Solid-State Drives (SSD) RHEL 7 noop RHEL 8 Ubuntu none Other RHEL

Cores 48 RAM 768 GB Cache Storage 4x Dell Express Flash NVMe ColdStream P4800x 750 GB PCIe U.2 SSD Capacity Storage 20x Dell Express Flash NVMe PM1725B (MU) 6.4 TB PCIe U.2 SSD There are 4 vSAN disk types follow: Storage Device Type OS Recommended Scheduler Policy Non-Volatile Memory Express (NVMe) RHEL 7 RHEL 8 Ubuntu none Solid-State Drives (SSD) RHEL 7 noop RHEL 8 Ubuntu none Other RHEL

Cores 48 RAM 768 GB Cache Storage 4x Dell Express Flash NVMe ColdStream P4800x 750 GB PCIe U.2 SSD Capacity Storage 20x Dell Express Flash NVMe PM1725B (MU) 6.4 TB PCIe U.2 SSD There are 4 vSAN disk types follow: Storage Device Type OS Recommended Scheduler Policy Non-Volatile Memory Express (NVMe) RHEL 7 RHEL 8 Ubuntu none Solid-State Drives (SSD) RHEL 7 noop RHEL 8 Ubuntu none Other RHEL

Cores 48 RAM 768 GB Cache Storage 4x Dell Express Flash NVMe ColdStream P4800x 750 GB PCIe U.2 SSD Capacity Storage 20x Dell Express Flash NVMe PM1725B (MU) 6.4 TB PCIe U.2 SSD There are 4 vSAN disk VMware, Inc. 390 Storage Device Type OS Recommended Scheduler Policy Non-Volatile Memory Express (NVMe) RHEL 7 RHEL 8 Ubuntu none Solid-State Drives (SSD) RHEL 7 noop RHEL 8 Ubuntu none Other RHEL

by Broadcom 408 Storage Device Type OS Recommended Scheduler Policy Non-Volatile Memory Express (NVMe) RHEL 7 RHEL 8 RHEL 9 Ubuntu none Solid-State Drives (SSD) RHEL 7 noop RHEL 8 RHEL 9 Ubuntu scheduler policy: Storage Device Type Recommended Scheduler Policy Non-Volatile Memory Express (NVMe) none Solid-State Drives (SSD) none Other mq-deadline To specify the I/O scheduler at boot time

types follow: Storage Device Type OS Recommended Scheduler Policy Non-Volatile Memory Express (NVMe) RHEL 7 RHEL 8 Ubuntu none Solid-State Drives (SSD) RHEL 7 noop RHEL 8 Ubuntu none Other RHEL