AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. Table of Contents Preface .............................................. Benchmark compared to POSTGRES, Version 4.2. Apart from bug fixes, the following were the major enhancements: • The query language PostQUEL was replaced with SQL (implemented in the server). Subqueries pg_dump and pg_dumpall programs from the newer version of PostgreSQL, to take advantage of any enhancements that may have been made in these programs. Current releases of the dump programs can read data

AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. Table of Contents Preface .............................................. Benchmark compared to POSTGRES, Version 4.2. Apart from bug fixes, the following were the major enhancements: • The query language PostQUEL was replaced with SQL (implemented in the server). Subqueries pg_dump and pg_dumpall programs from the newer version of Post- greSQL, to take advantage of any enhancements that may have been made in these programs. Current releases of the dump programs can read data

AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. Table of Contents Preface .............................................. Benchmark compared to POSTGRES, Version 4.2. Apart from bug fixes, the following were the major enhancements: • The query language PostQUEL was replaced with SQL (implemented in the server). Subqueries pg_dump and pg_dumpall programs from the newer version of Post- greSQL, to take advantage of any enhancements that may have been made in these programs. Current releases of the dump programs can read data

AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. Table of Contents Preface .............................................. Benchmark compared to POSTGRES, Version 4.2. Apart from bug fixes, the following were the major enhancements: • The query language PostQUEL was replaced with SQL (implemented in the server). Subqueries pg_dump and pg_dumpall programs from the newer version of Post- greSQL, to take advantage of any enhancements that may have been made in these programs. Current releases of the dump programs can read data

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)

AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. Table of Contents Preface .............................................. Benchmark compared to POSTGRES, Version 4.2. Apart from bug fixes, the following were the major enhancements: • The query language PostQUEL was replaced with SQL (implemented in the server). Subqueries pg_dump and pg_dumpall programs from the newer version of Post- greSQL, to take advantage of any enhancements that may have been made in these programs. Current releases of the dump programs can read data

AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. Table of Contents Preface .............................................. Benchmark compared to POSTGRES, Version 4.2. Apart from bug fixes, the following were the major enhancements: • The query language PostQUEL was replaced with SQL (implemented in the server). Subqueries pg_dump and pg_dumpall programs from the newer version of Post- greSQL, to take advantage of any enhancements that may have been made in these programs. Current releases of the dump programs can read data

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