recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes to the Greenplum Database master host: wget https://cran.r-project.org/src/contrib/Archive/arm/arm_1.5-03.tar.gz wget https://cran.r-project.org/src/contrib/Archive/Matrix/Matrix_0.9996875-1.tar.gz 3 to do this. gpscp -f hosts_all Matrix_0.9996875-1.tar.gz =:/home/gpadmin gpscp -f /hosts_all arm_1.5-03.tar.gz =:/home/gpadmin 4. Use the gpssh utility in interactive mode to log into each Greenplum

recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes to the Greenplum Database master host: wget https://cran.r-project.org/src/contrib/Archive/arm/arm_1.5-03.tar.gz Note: If you expand Greenplum Database and add segment hosts, you must install the R packages to do this. gpscp -f hosts_all Matrix_0.9996875-1.tar.gz =:/home/gpadmin gpscp -f /hosts_all arm_1.5-03.tar.gz =:/home/gpadmin 4. Use the gpssh utility in interactive mode to log into each Greenplum

recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes to the Greenplum Database master host: wget https://cran.r-project.org/src/contrib/Archive/arm/arm_1.5-03.tar.gz wget https://cran.r-project.org/src/contrib/Archive/Matrix/Matrix_0.9996875-1.tar.gz 3 to do this. gpscp -f hosts_all Matrix_0.9996875-1.tar.gz =:/home/gpadmin gpscp -f /hosts_all arm_1.5-03.tar.gz =:/home/gpadmin 4. Use the gpssh utility in interactive mode to log into each Greenplum

recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes to the Greenplum Database master host: wget https://cran.r-project.org/src/contrib/Archive/arm/arm_1.5-03.tar.gz wget https://cran.r-project.org/src/contrib/Archive/Matrix/Matrix_0.9996875-1.tar.gz 3 to do this. gpscp -f hosts_all Matrix_0.9996875-1.tar.gz =:/home/gpadmin gpscp -f /hosts_all arm_1.5-03.tar.gz =:/home/gpadmin VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 479 4. Use the

"vm.dirty_ratio = 0" >> /etc/sysctl.d/10-gpdb.conf $ echo "vm.dirty_background_bytes = 1610612736 # 1.5GB" >> /etc/sy sctl.d/10-gpdb.conf $ echo "vm.dirty_bytes = 4294967296 # 4GB" >> /etc/sysctl.d/10-gpd "vm.dirty_ratio = 0" >> /etc/sysctl.d/10-gpdb.conf $ echo "vm.dirty_background_bytes = 1610612736 # 1.5GB" >> /etc/sy sctl.d/10-gpdb.conf $ echo "vm.dirty_bytes = 4294967296 # 4GB" >> /etc/sysctl.d/10-gpd dirty_ratio = 0 VMware Greenplum 6 Documentation VMware, Inc 413 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes

"vm.dirty_ratio = 0" >> /etc/sysctl.d/10-gpdb.conf $ echo "vm.dirty_background_bytes = 1610612736 # 1.5GB" >> /etc/sy sctl.d/10-gpdb.conf $ echo "vm.dirty_bytes = 4294967296 # 4GB" >> /etc/sysctl.d/10-gpd "vm.dirty_ratio = 0" >> /etc/sysctl.d/10-gpdb.conf $ echo "vm.dirty_background_bytes = 1610612736 # 1.5GB" >> /etc/sy sctl.d/10-gpdb.conf $ echo "vm.dirty_bytes = 4294967296 # 4GB" >> /etc/sysctl.d/10-gpd recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes

"vm.dirty_ratio = 0" >> /etc/sysctl.d/10-gpdb.conf $ echo "vm.dirty_background_bytes = 1610612736 # 1.5GB" >> /etc/sy sctl.d/10-gpdb.conf $ echo "vm.dirty_bytes = 4294967296 # 4GB" >> /etc/sysctl.d/10-gpd "vm.dirty_ratio = 0" >> /etc/sysctl.d/10-gpdb.conf $ echo "vm.dirty_background_bytes = 1610612736 # 1.5GB" >> /etc/sy sctl.d/10-gpdb.conf $ echo "vm.dirty_bytes = 4294967296 # 4GB" >> /etc/sysctl.d/10-gpd recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes

ESA RAID Type ESXi Hosts Space Overhead RAID-1 (mirroring) 4 2x RAID-5 (erasure coding) 4 to 5 1.5x RAID-5 (erasure coding) 6 or more 1.25x vSAN OSA RAID Type ESXi Hosts Space Overhead RAID-1 recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes Broadcom 806 SELECT ... WHERE x <> 0 AND y/x > 1.5; The following example shows a trustworthy evaluation order: SELECT ... WHERE CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false END; This CASE construct usage

recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes clause: SELECT ... WHERE x <> 0 AND y/x > 1.5; The following example shows a trustworthy evaluation order: SELECT ... WHERE CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false END; This CASE construct usage Greenplum Database coordinator host: wget https://cran.r-project.org/src/contrib/Archive/arm/arm_1.5-03.tar.gz wget https://cran.r-project.org/src/contrib/Archive/Matrix/Matrix_0.9996875-1.t ar.gz

"vm.dirty_ratio = 0" >> /etc/sysctl.d/10-gpdb.conf $ echo "vm.dirty_background_bytes = 1610612736 # 1.5GB" >> /etc/sy sctl.d/10-gpdb.conf $ echo "vm.dirty_bytes = 4294967296 # 4GB" >> /etc/sysctl.d/10-gpd recommended: vm.dirty_background_ratio = 0 vm.dirty_ratio = 0 vm.dirty_background_bytes = 1610612736 # 1.5GB vm.dirty_bytes = 4294967296 # 4GB For host systems with 64GB of memory or less, remove vm.dirty_background_bytes clause: SELECT ... WHERE x <> 0 AND y/x > 1.5; The following example shows a trustworthy evaluation order: SELECT ... WHERE CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false VMware Tanzu Greenplum 6 Documentation