Cluster Phases 941 AO/CO Table Cluster Phases 942 COPY Progress Reporting 942 CREATE INDEX Progress Reporting 943 VACUUM Progress Reporting 944 Heap Table Vacuum Phases 944 AO/CO Table Vacuum Phases 961 Baseline Hardware Performance 961 Performance Benchmarks 961 Distribution and Skew 961 Local (Co-located) Joins 962 Data Skew 962 Considerations for Replicated Tables 963 Processing Skew 963 Common Append-Optimized Storage 1024 Row or Column Orientation 1024 Compression 1025 Distributions 1025 Local (Co-located) Joins 1026 Data Skew 1026 Processing Skew 1027 Partitioning 1027 Number of Partition and

Benchmarks 1118 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 51 Distribution and Skew 1118 Local (Co-located) Joins 1119 Data Skew 1119 Considerations for Replicated Tables 1119 Processing Skew 1120 Append-Optimized Storage 1181 Row or Column Orientation 1182 Compression 1182 Distributions 1183 Local (Co-located) Joins 1184 Data Skew 1184 Processing Skew 1185 Partitioning 1185 Number of Partition and memory corruption and PANIC errors. N/A Resolved an issue where a CREATE INDEX command on an AO/CO table would hang if there was a pre-existing read-only transaction accessing the same table. N/A

Baseline Hardware Performance 1159 Performance Benchmarks 1159 Distribution and Skew 1159 Local (Co-located) Joins 1160 Data Skew 1160 Considerations for Replicated Tables 1161 Processing Skew 1161 Append-Optimized Storage 1225 Row or Column Orientation 1226 Compression 1226 Distributions 1227 Local (Co-located) Joins 1228 Data Skew 1228 Processing Skew 1228 Partitioning 1229 VMware Greenplum 6 Documentation this release and for upgrade instructions. ANALYZE now skips columns that have been dropped from AO/CO tables, resulting in a performance improvement. Greenplum Database improves pg_upgrade performance

Append-Optimized Storage 329 Row or Column Orientation 329 Compression 330 Distributions 330 Local (Co-located) Joins 331 Data Skew 331 Processing Skew 332 Partitioning 332 Number of Partition and Columnar Performance 996 Performance Benchmarks 996 Distribution and Skew 996 Distribution and Skew 0 Local (Co-located) Joins 997 Data Skew 997 Considerations for Replicated Tables 998 Processing Skew 998 Common an assert failure in execMotionUnsortedReceiver. 12648 : Resolved an issue where inserting to an AO/CO table failed when using spgist index, caused by an empty transaction ID. Greenplum on Dell EMC VxRail

Append-Optimized Storage 338 Row or Column Orientation 338 Compression 339 Distributions 339 Local (Co-located) Joins 340 Data Skew 340 Processing Skew 341 Partitioning 341 Number of Partition and Columnar Performance 1005 Performance Benchmarks 1005 Distribution and Skew 1005 Distribution and Skew 0 Local (Co-located) Joins 1006 Data Skew 1006 Considerations for Replicated Tables 1007 Processing Skew 1007 initialization configuration file (gpinitsystem_config) and host file (hostfile_gpinitsystem). For example: $ cd ~ Note: You can initialize your Greenplum system with primary segments only and deploy mirrors later

Append-Optimized Storage 262 Row or Column Orientation 262 Compression 263 Distributions 263 Local (Co-located) Joins 264 Data Skew 264 Processing Skew 265 VMware Greenplum v6.17 Documentation VMware Performance 928 Performance Benchmarks 928 Distribution and Skew 928 Distribution and Skew 0 Local (Co-located) Joins 929 Data Skew 929 Considerations for Replicated Tables 930 Processing Skew 930 Common initialization configuration file (gpinitsystem_config) and host file (hostfile_gpinitsystem). For example: $ cd ~ $ gpinitsystem -c gpconfigs/gpinitsystem_config -h gpconfigs/hostfile_gpinitsystem For a fully

Baseline Hardware Performance 1123 Performance Benchmarks 1123 Distribution and Skew 1123 Local (Co-located) Joins 1123 Data Skew 1124 Considerations for Replicated Tables 1124 Processing Skew 1125 Append-Optimized Storage 1186 Row or Column Orientation 1187 Compression 1187 Distributions 1188 Local (Co-located) Joins 1188 Data Skew 1189 Processing Skew 1189 Partitioning 1190 Number of Partition and memory corruption and PANIC errors. N/A Resolved an issue where a CREATE INDEX command on an AO/CO table would hang if there was a pre-existing read-only transaction accessing the same table. N/A

Append-Optimized Storage 333 Row or Column Orientation 333 Compression 334 Distributions 334 Local (Co-located) Joins 335 Data Skew 335 Processing Skew 336 VMware Tanzu Greenplum v6.20 Documentation 995 Baseline Hardware Performance 996 Performance Benchmarks 996 Distribution and Skew 996 Local (Co-located) Joins 997 Data Skew 997 Considerations for Replicated Tables 998 Processing Skew 998 Common initialization configuration file (gpinitsystem_config) and host file (hostfile_gpinitsystem). For example: $ cd ~ $ gpinitsystem -c gpconfigs/gpinitsystem_config -h gpconfigs/hostfile_gpinitsystem For a fully

Baseline Hardware Performance 1174 Performance Benchmarks 1174 Distribution and Skew 1174 Local (Co-located) Joins 1175 Data Skew 1175 Considerations for Replicated Tables 1176 Processing Skew 1176 Append-Optimized Storage 1243 Row or Column Orientation 1243 Compression 1244 Distributions 1244 Local (Co-located) Joins 1245 Data Skew 1245 Processing Skew 1246 Partitioning 1246 Number of Partition and when running pg_dump with the -- binary-upgrade option as it caused issues for partition tables, AO/CO tables, and object recreation with pg_restore. Release 6.24 Release 6.24.6 Release Date: 2023-06-30

Benchmarks 1142 VMware Greenplum 6 Documentation VMware, Inc. 53 Distribution and Skew 1142 Local (Co-located) Joins 1143 Data Skew 1143 Considerations for Replicated Tables 1144 Processing Skew 1144 Append-Optimized Storage 1211 Row or Column Orientation 1211 Compression 1212 Distributions 1212 Local (Co-located) Joins 1213 Data Skew 1213 Processing Skew 1214 Partitioning 1214 Number of Partition and when running pg_dump with the -- binary-upgrade option as it caused issues for partition tables, AO/CO tables, and object recreation with pg_restore. Release 6.24 Release 6.24.6 Release Date: 2023-06-30