Serializable Isolation Level 320 About Setting the Transaction Isolation Level 320 Removing Dead Rows from Tables 321 Example of Managing Transaction IDs 322 Simple MVCC Example 322 Managing Simultaneous Upgrading from an Earlier Greenplum 6 Release 456 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 Upgrading PXF When You Upgrade from a Previous Greenplum Database 6.x Version 471 Step 1: PXF Pre-Upgrade Actions 471 Step 2: Registering or Upgrading PXF 472 Migrating Data from Greenplum 4.3 or 5 to Greenplum

Serializable Isolation Level 306 About Setting the Transaction Isolation Level 306 Removing Dead Rows from Tables 307 Example of Managing Transaction IDs 308 Simple MVCC Example 308 Managing Simultaneous Upgrading to Greenplum 6 437 Upgrading from an Earlier Greenplum 6 Release 437 VMware Greenplum 6 Documentation VMware, Inc. 20 Prerequisites 438 Upgrading from 6.x to a Newer 6.x Release 439 Troubleshooting Troubleshooting a Failed Upgrade 441 PXF Upgrade and Migration 441 Migrating PXF from Greenplum 5.x to 6.x 442 Prerequisites 442 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration Actions 443 Step

Upgrading from an Earlier Greenplum 6 Release 295 Upgrading from an Earlier Greenplum 6 Release 0 VMware Greenplum v6.19 Documentation VMware, Inc. 12 Prerequisites 295 Upgrading from 6.x to a Newer Detecting Bloat 356 Removing Bloat from Database Tables 357 Removing Bloat from Append-Optimized Tables 357 Removing Bloat from Indexes 358 Removing Bloat from System Catalogs 358 Monitoring Greenplum MADlib Package 398 Upgrading MADlib Functions 398 Uninstalling MADlib 398 Remove MADlib objects from the database 398 Uninstall the Greenplum Database MADlib Package 398 Examples 399 VMware Greenplum

Upgrading to Greenplum 6 0 Upgrading from an Earlier Greenplum 6 Release 286 Upgrading from an Earlier Greenplum 6 Release 0 Prerequisites 286 Upgrading from 6.x to a Newer 6.x Release 287 Troubleshooting Detecting Bloat 347 Removing Bloat from Database Tables 348 Removing Bloat from Append-Optimized Tables 348 Removing Bloat from Indexes 349 Removing Bloat from System Catalogs 349 Monitoring Greenplum Uninstalling MADlib 389 VMware Greenplum v6.18 Documentation VMware, Inc. 18 Remove MADlib objects from the database 389 Uninstall the Greenplum Database MADlib Package 389 Examples 390 Linear Regression

150 Server 150 Query Optimizer 151 Cluster Management 151 Postgres Query Planner 152 Upgrading from Greenplum 6.x to Greenplum 6.17 152 Deprecated Features 152 Migrating Data to Greenplum 6 154 Known Upgrading to Greenplum 6 0 Upgrading from an Earlier Greenplum 6 Release 220 Upgrading from an Earlier Greenplum 6 Release 0 Prerequisites 220 Upgrading from 6.x to a Newer 6.x Release 0 Troubleshooting Detecting Bloat 282 Removing Bloat from Database Tables 283 Removing Bloat from Append-Optimized Tables 283 Removing Bloat from Indexes 284 Removing Bloat from System Catalogs 284 Monitoring Greenplum

Server and Client 288 Upgrading to Greenplum 6 290 Upgrading from an Earlier Greenplum 6 Release 291 Prerequisites 291 Upgrading from 6.x to a Newer 6.x Release 292 Troubleshooting a Failed Upgrade Upgrade and Migration 294 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 12 Migrating Data from Greenplum 4.3 or 5 to Greenplum 6 295 Preparing the Greenplum 6 Cluster 295 Preparing Greenplum Detecting Bloat 351 Removing Bloat from Database Tables 351 Removing Bloat from Append-Optimized Tables 352 Removing Bloat from Indexes 352 Removing Bloat from System Catalogs 352 VMware Tanzu Greenplum

Serializable Isolation Level 288 About Setting the Transaction Isolation Level 288 Removing Dead Rows from Tables 289 Example of Managing Transaction IDs 290 Simple MVCC Example 290 Managing Simultaneous Upgrading from an Earlier Greenplum 6 Release 462 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 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 Data from Greenplum 4.3 or 5 to Greenplum

Serializable Isolation Level 171 About Setting the Transaction Isolation Level 171 Removing Dead Rows from Tables 172 Example of Managing Transaction IDs 173 Simple MVCC Example 173 Managing Simultaneous Features 244 Changes in Feature Behavior 244 Other Important Changes in Greenplum 7 245 Upgrading from Greenplum 6 to Greenplum 7 245 Preparing to Upgrade 245 Steps to Upgrade 246 Steps to Upgrade Using pg_partition_encoding 257 Composing a Similar View in Greenplum 7 258 pg_stat_partition_operations 258 Migrating from Open Source Greenplum Database to VMware Greenplum 259 Prerequisites 259 Procedure 259 Enabling

Snapshots 275 Transaction ID Wraparound 276 Transaction Isolation Modes 276 Removing Dead Rows from Tables 278 Example of Managing Transaction IDs 279 Simple MVCC Example 280 Managing Simultaneous Server and Client 444 Upgrading to Greenplum 6 446 Upgrading from an Earlier Greenplum 6 Release 446 Prerequisites 447 Upgrading from 6.x to a Newer 6.x Release 447 Troubleshooting a Failed Upgrade PXF Upgrade and Migration 450 VMware Tanzu Greenplum 6 Documentation VMware, Inc 18 Migrating PXF from Greenplum 5.x to 6.x 450 Prerequisites 451 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration

Snapshots 271 Transaction ID Wraparound 272 Transaction Isolation Modes 273 Removing Dead Rows from Tables 274 Example of Managing Transaction IDs 275 Simple MVCC Example 276 Managing Simultaneous Upgrading from an Earlier Greenplum 6 Release 444 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 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 Data from Greenplum 4.3 or 5 to Greenplum