VMware Greenplum 6 Documentation VMware, Inc. 15 Provider Layer 326 Infrastructure Layer 326 Virtual Machine Cluster Layer 326 Greenplum Layer 327 Planning VMware vSphere with Greenplum 327 Calculating 14576 Resolves a problem where append-only tables that were upgraded from version 5 could show duplicate ctid system column values, and querys that used the indexes of those tables would return incorrect risk. 13860 : The EPQ routine for AO/AOCS relations and DML node has been disallowed. 13699 : Duplicate gp_fastsequence values (ctid) no longer appear in AO tables. Query Processing VMware Greenplum

VMware by Broadcom 16 Layered Architecture 339 Provider Layer 340 Infrastructure Layer 340 Virtual Machine Cluster Layer 340 Greenplum Layer 341 High Availability 341 Planning VMware vSphere with 14576 Resolves a problem where append-only tables that were upgraded from version 5 could show duplicate ctid system column values, and querys that used the indexes of those tables would return incorrect risk. 13860 : The EPQ routine for AO/AOCS relations and DML node has been disallowed. 13699 : Duplicate gp_fastsequence values (ctid) no longer appear in AO tables. Query Processing 32348 : Non-optimal

vSphere Architecture 297 Layered Architecture 297 Provider Layer 297 Infrastructure Layer 297 Virtual Machine Cluster Layer 298 Greenplum Layer 298 Planning VMware vSphere with Greenplum 299 Calculating bigint[], float[] pivot_sum( array[‘A1’,‘A2’], attr, value) A pivot aggregation using sum to resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’, ‘row’, ‘per’, ‘item’]) Transforms bigint[], float[] pivot_sum( array[‘A1’,‘A2’], attr, value) A pivot aggregation using sum to resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’, ‘row’, ‘per’, ‘item’]) Transforms

vSphere Architecture 307 Layered Architecture 307 Provider Layer 308 Infrastructure Layer 308 Virtual Machine Cluster Layer 308 Greenplum Layer 309 VMware Greenplum 6 Documentation VMware, Inc 13 Planning 14576 Resolves a problem where append-only tables that were upgraded from version 5 could show duplicate ctid system column values, and querys that used the indexes of those tables would return incorrect security risk. 13860 The EPQ routine for AO/AOCS relations and DML node has been disallowed. 13699 Duplicate gp_fastsequence values (ctid) no longer appear in AO tables. Query Processing 32348 Non-optimal

vSphere Architecture 292 Layered Architecture 292 Provider Layer 293 Infrastructure Layer 293 Virtual Machine Cluster Layer 293 Greenplum Layer 294 Planning VMware vSphere with Greenplum 294 Calculating risk. 13860 : The EPQ routine for AO/AOCS relations and DML node has been disallowed. 13699 : Duplicate gp_fastsequence values (ctid) no longer appear in AO tables. Query Processing 32348 : Non-optimal Database. 31736 - Resource Queues Due to improper error handling, Greenplum Database raised a duplicate portal identifier warning that was in some cases immediately followed by an out of shared memory

vSphere Architecture 266 Layered Architecture 266 Provider Layer 266 Infrastructure Layer 266 Virtual Machine Cluster Layer 266 Greenplum Layer 267 Planning VMware vSphere with Greenplum 268 Calculating bigint[], float[] pivot_sum( array[‘A1’,‘A2’], attr, value) A pivot aggregation using sum to resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’, ‘row’, ‘per’, ‘item’]) Transforms bigint[], float[] pivot_sum( array[‘A1’,‘A2’], attr, value) A pivot aggregation using sum to resolve duplicate entries. unnest (array[]) set of anyelement unnest( array[‘one’, ‘row’, ‘per’, ‘item’]) Transforms

Database. 31736 - Resource Queues : Due to improper error handling, Greenplum Database raised a duplicate portal identifier warning that was in some cases immediately followed by an out of VMware Greenplum shared memory error. This issue is resolved; Greenplum Database now raises distinct errors for duplicate portal identifier and out of shared memory. 31734 : Greenplum was generating the error ERROR: interconnect resolves a single issue. Resolved Issue Postgres Query Planner 12583 : A previous fix to resolve duplicate sequence values (178253995) resulted in a performance regression. An incomplete hash key in the

Database. 31736 - Resource Queues : Due to improper error handling, Greenplum Database raised a duplicate portal identifier warning that was in some cases immediately followed by an out of shared memory memory error. This issue is resolved; Greenplum Database now raises distinct errors for duplicate portal identifier and out of shared memory. VMware Greenplum v6.19 Documentation VMware, Inc. 159 31734 resolves a single issue. Resolved Issue Postgres Query Planner 12583 : A previous fix to resolve duplicate sequence values (178253995) resulted in a performance regression. An incomplete hash key in the

resolves a single issue. Resolved Issue Postgres Query Planner 12583 A previous fix to resolve duplicate sequence values (178253995) resulted in a performance regression. An incomplete hash key in the sequence nextval. 178253995 Resolved an issue where the sequence executor node was generating duplicate sequence values. Upgrading from Greenplum 6.x to Greenplum 6.17 See Upgrading from an Earlier storage. The segments communicate with each other and the master over the interconnect, the networking layer of Greenplum Database. VMware Greenplum v6.17 Documentation VMware, Inc. 161 Greenplum Database

Database. 31736 - Resource Queues : Due to improper error handling, Greenplum Database raised a duplicate portal identifier warning that was in some cases immediately followed by an out of shared memory memory error. This issue is resolved; Greenplum Database now raises distinct errors for duplicate portal identifier and out of shared memory. VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 156 resolves a single issue. Resolved Issue Postgres Query Planner 12583 : A previous fix to resolve duplicate sequence values (178253995) resulted in a performance regression. An incomplete hash key in the