157 Resolved Issues 158 Server 158 Query Processing 159 Cluster Management 159 Data Flow 159 Upgrade 159 Release 6.24 160 Release 6.24.6 160 Query Processing 160 Server 160 Release 6.24.5 160 Changed Features 161 Resolved Issues 161 Server 161 Cluster Management 161 Query Processing 161 Upgrade 162 Release 6.24.3 162 Changed Features 162 Resolved Issues 162 Server 162 Query Processing Prerequisites 457 Upgrading from 6.x to a Newer 6.x Release 458 Troubleshooting a Failed Upgrade 460 PXF Upgrade and Migration 460 Migrating PXF from Greenplum 5.x to 6.x 461 Prerequisites 461 Step

Greenplum 6 Documentation VMware, Inc. 3 Query Processing 145 Cluster Management 146 Data Flow 146 Upgrade 146 Release 6.24 146 Release 6.24.6 146 Query Processing 146 Server 147 Release 6.24.5 147 Changed Features 147 Resolved Issues 147 Server 147 Cluster Management 148 Query Processing 148 Upgrade 148 Release 6.24.3 149 Changed Features 149 Resolved Issues 149 Server 149 Query Processing Prerequisites 438 Upgrading from 6.x to a Newer 6.x Release 439 Troubleshooting a Failed Upgrade 441 PXF Upgrade and Migration 441 Migrating PXF from Greenplum 5.x to 6.x 442 Prerequisites 442 Step

Prerequisites 462 Upgrading from 6.x to a Newer 6.x Release 463 Troubleshooting a Failed Upgrade 466 PXF Upgrade and Migration 466 Migrating PXF from Greenplum 5.x to 6.x 466 Prerequisites 467 Step Greenplum 6 Documentation VMware, Inc 19 Upgrading PXF When You Upgrade from a Previous Greenplum Database 6.x Version 476 Step 1: PXF Pre-Upgrade Actions 477 Step 2: Registering or Upgrading PXF 477 Migrating Wrapper Helper Functions 640 Greenplum Database Considerations 641 Building a Foreign Data Wrapper Extension with PGXS 642 Deployment Considerations 644 Using the Greenplum Parallel File Server (gpfdist)

Prerequisites 447 Upgrading from 6.x to a Newer 6.x Release 447 Troubleshooting a Failed Upgrade 450 PXF Upgrade and Migration 450 VMware Tanzu Greenplum 6 Documentation VMware, Inc 18 Migrating PXF Privileges to the gphdfs Protocol 460 Upgrading PXF When You Upgrade from a Previous Greenplum Database 6.x Version 460 Step 1: PXF Pre-Upgrade Actions 461 Step 2: Registering or Upgrading PXF 461 Migrating Wrapper Helper Functions 617 Greenplum Database Considerations 618 Building a Foreign Data Wrapper Extension with PGXS 619 Deployment Considerations 620 Using the Greenplum Parallel File Server (gpfdist)

Prerequisites 291 Upgrading from 6.x to a Newer 6.x Release 292 Troubleshooting a Failed Upgrade 294 PXF Upgrade and Migration 294 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 12 Migrating Resource Management with Resource Groups 339 Configuring Memory for Greenplum Database 339 Memory Considerations when using Resource Groups 341 Configuring Resource Groups 341 Low Memory Queries 341 Administrative PostGIS 2.1.5 to the PostGIS 2.5.4 pivotal.3 Package 418 Removing the PostGIS 2.1.5 package 418 Upgrade a PostGIS 2.5.4 Package from pivotal.1 or pivotal.2 to pivotal.3 419 Checking the PostGIS Version

Failed Upgrade 223 PXF Upgrade and Migration 223 Migrating or Upgrading to Greenplum 6 224 Migrating or Upgrading to Greenplum 6 0 Preparing the Greenplum 6 Cluster 224 Using Greenplum Upgrade 224 Using Greenplum Backup/Restore 224 Preparing Greenplum 4.3 and 5 Databases for Backup and Upgrade 226 Backing Up and Restoring a Database 229 Completing the Migration 230 Working With Hash Operator Resource Management with Resource Groups 0 Configuring Memory for Greenplum Database 271 Memory Considerations when using Resource Groups 272 Configuring Resource Groups 272 Low Memory Queries 273 Administrative

Prerequisites 444 Upgrading from 6.x to a Newer 6.x Release 445 Troubleshooting a Failed Upgrade 447 PXF Upgrade and Migration 447 Migrating PXF from Greenplum 5.x to 6.x 448 Prerequisites 448 Step Privileges to the gphdfs Protocol 457 Upgrading PXF When You Upgrade from a Previous Greenplum Database 6.x Version 457 Step 1: PXF Pre-Upgrade Actions 458 Step 2: Registering or Upgrading PXF 458 Migrating Wrapper Helper Functions 615 Greenplum Database Considerations 616 Building a Foreign Data Wrapper Extension with PGXS 617 Deployment Considerations 618 Using the Greenplum Parallel File Server (gpfdist)

Preparing to Upgrade 245 Steps to Upgrade 246 Steps to Upgrade Using Backup/Restore 246 VMware Greenplum 7 Documentation VMware by Broadcom 8 Steps to Upgrade Using gpcopy 246 Completing the Upgrade 246 Broadcom 14 What Hasn’t Changed With Classic Syntax? 367 What Has Changed? 367 Additional Considerations 370 Examples Using the Classic Partitioning Syntax 370 Creating Partitioned Tables with the Wrapper Helper Functions 414 Greenplum Database Considerations 415 Building a Foreign Data Wrapper Extension with PGXS 416 Deployment Considerations 418 Accessing External Data with External Tables

Prerequisites 295 Upgrading from 6.x to a Newer 6.x Release 296 Troubleshooting a Failed Upgrade 298 PXF Upgrade and Migration 299 Migrating or Upgrading to Greenplum 6 299 Migrating or Upgrading to 0 Preparing the Greenplum 6 Cluster 300 Preparing Greenplum 4.3 and 5 Databases for Backup and Upgrade 301 Backing Up and Restoring a Database 305 Completing the Migration 306 Working With Hash Operator Resource Management with Resource Groups 0 Configuring Memory for Greenplum Database 344 Memory Considerations when using Resource Groups 345 Configuring Resource Groups 346 Low Memory Queries 346 Administrative

Prerequisites 286 Upgrading from 6.x to a Newer 6.x Release 287 Troubleshooting a Failed Upgrade 289 PXF Upgrade and Migration 290 Migrating or Upgrading to Greenplum 6 290 Migrating or Upgrading to 0 Preparing the Greenplum 6 Cluster 290 Preparing Greenplum 4.3 and 5 Databases for Backup and Upgrade 292 Backing Up and Restoring a Database 296 Completing the Migration 297 Working With Hash Operator Resource Management with Resource Groups 0 Configuring Memory for Greenplum Database 335 Memory Considerations when using Resource Groups 336 Configuring Resource Groups 337 Low Memory Queries 337 Administrative