Specifying Table Distribution Columns 210 Resource Groups Features 211 PL/pgSQL Procedural Language Enhancements 211 Replicated Table Data 212 Concurrency Improvements in Greenplum 6 212 Additional Contrib when Using GPORCA 861 Considerations when Using GPORCA 0 GPORCA Features and Enhancements 862 GPORCA Features and Enhancements 0 Queries Against Partitioned Tables 863 Queries that Contain Subqueries Subqueries 864 Queries that Contain Common Table Expressions 865 DML Operation Enhancements with GPORCA 866 Changed Behavior with the GPORCA 866 Changed Behavior with the GPORCA 0 GPORCA Limitations 867 GPORCA

v6.19 Documentation VMware, Inc. 8 Resource Groups Features 219 PL/pgSQL Procedural Language Enhancements 219 Replicated Table Data 220 Concurrency Improvements in Greenplum 6 220 Additional Contrib when Using GPORCA 870 Considerations when Using GPORCA 0 GPORCA Features and Enhancements 871 GPORCA Features and Enhancements 0 Queries Against Partitioned Tables 872 Queries that Contain Subqueries Subqueries 873 Queries that Contain Common Table Expressions 874 DML Operation Enhancements with GPORCA 875 Changed Behavior with the GPORCA 875 Changed Behavior with the GPORCA 0 GPORCA Limitations 876 GPORCA

Specifying Table Distribution Columns 215 Resource Groups Features 216 PL/pgSQL Procedural Language Enhancements 216 Replicated Table Data 217 Concurrency Improvements in Greenplum 6 217 Additional Contrib GPORCA Features and Enhancements 863 Queries Against Partitioned Tables 864 Queries that Contain Subqueries 865 Queries that Contain Common Table Expressions 866 DML Operation Enhancements with GPORCA 867 and upgrade instructions. For customers deploying Greenplum on Dell EMC VxRail, the following enhancements have been introduced to the guidelines, and reference templates: Greenplum Command Center (GPCC)

Specifying Table Distribution Columns 271 Resource Groups Features 271 PL/pgSQL Procedural Language Enhancements 272 Replicated Table Data 272 VMware Greenplum 6 Documentation VMware by Broadcom 13 Concurrency GPORCA Features and Enhancements 782 Queries Against Partitioned Tables 782 Queries that Contain Subqueries 783 Queries that Contain Common Table Expressions 784 DML Operation Enhancements with GPORCA 785 Pivotal Query Optimizer during minirepro restore. Backports upstream PostgreSQL pg_dump performance enhancements. Includes pgcrypto module changes to facilitate testing. The license file for the Windows Client

Specifying Table Distribution Columns 239 Resource Groups Features 239 PL/pgSQL Procedural Language Enhancements 239 Replicated Table Data 240 Concurrency Improvements in Greenplum 6 240 Additional Contrib GPORCA Features and Enhancements 773 Queries Against Partitioned Tables 774 Queries that Contain Subqueries 775 Queries that Contain Common Table Expressions 776 DML Operation Enhancements with GPORCA 777 Pivotal Query Optimizer during minirepro restore. Backports upstream PostgreSQL pg_dump performance enhancements. Includes pgcrypto module changes to facilitate testing. The license file for the Windows Client

Specifying Table Distribution Columns 231 Resource Groups Features 232 PL/pgSQL Procedural Language Enhancements 232 Replicated Table Data 232 Concurrency Improvements in Greenplum 6 233 Additional Contrib Partition Statistics Collection 744 Considerations when Using GPORCA 744 GPORCA Features and Enhancements 746 VMware Tanzu Greenplum 6 Documentation VMware, Inc 32 Queries Against Partitioned Tables that Contain Subqueries 748 Queries that Contain Common Table Expressions 749 DML Operation Enhancements with GPORCA 749 Changed Behavior with GPORCA 750 GPORCA Limitations 751 Unsupported SQL Query

Specifying Table Distribution Columns 257 Resource Groups Features 258 PL/pgSQL Procedural Language Enhancements 258 Replicated Table Data 258 Concurrency Improvements in Greenplum 6 259 Additional Contrib GPORCA Features and Enhancements 752 Queries Against Partitioned Tables 753 Queries that Contain Subqueries 754 Queries that Contain Common Table Expressions 755 DML Operation Enhancements with GPORCA 756 Pivotal Query Optimizer during minirepro restore. Backports upstream PostgreSQL pg_dump performance enhancements. Includes pgcrypto module changes to facilitate testing. The license file for the Windows Client

Specifying Table Distribution Columns 207 Resource Groups Features 207 PL/pgSQL Procedural Language Enhancements 208 Replicated Table Data 208 Concurrency Improvements in Greenplum 6 208 Additional Contrib GPORCA Features and Enhancements 643 Queries Against Partitioned Tables 644 Queries that Contain Subqueries 645 Queries that Contain Common Table Expressions 646 DML Operation Enhancements with GPORCA 646 and upgrade instructions. For customers deploying Greenplum on Dell EMC VxRail, the following enhancements have been introduced to the guidelines, and reference templates: Greenplum Command Center (GPCC)

Specifying Table Distribution Columns 228 Resource Groups Features 229 PL/pgSQL Procedural Language Enhancements 229 Replicated Table Data 229 Concurrency Improvements in Greenplum 6 230 Additional Contrib GPORCA Features and Enhancements 745 Queries Against Partitioned Tables 746 Queries that Contain Subqueries 747 Queries that Contain Common Table Expressions 748 DML Operation Enhancements with GPORCA 748 and upgrade instructions. For customers deploying Greenplum on Dell EMC VxRail, the following enhancements have been introduced to the guidelines, and reference templates: Greenplum Command Center (GPCC)

when Using GPORCA 793 Considerations when Using GPORCA 0 GPORCA Features and Enhancements 794 GPORCA Features and Enhancements 0 Queries Against Partitioned Tables 795 Queries that Contain Subqueries Subqueries 796 Queries that Contain Common Table Expressions 797 DML Operation Enhancements with GPORCA 798 Changed Behavior with the GPORCA 798 Changed Behavior with the GPORCA 0 GPORCA Limitations 799 GPORCA detector for Python 2 and 3 ConfigParser Updated configparser module contextlib2 Backports and enhancements for the contextlib module Cycler Composable style cycles cymem Manage calls to calloc/free through