growing – Pivotal engineering investment growing – 9 Greenplum Database releases in 2016 – Open source code contribution growing – 1417 commits to the github repo of Greenplum in 2016 – 111 unique contributors JSON/JSONB – Full Text Search – Improved XML Type/Functions – UUID Type – Raster PostGIS – Anonymous Code Blocks – PostgreSQL based Analyze (faster) – Extension Framework – Foreign Data Wrapper (FDW) plan alternatives – Optimizes a wider range of queries – Optimizes memory usage • New Extensible Code Base – Rapid adoption of emerging technologies 2016Postgres中国用户大会 Postgres Conference China 2016

Practices 0 Best Practices Summary 324 Best Practices Summary 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Distributions 325 Resource Queue Synopsis 583 Description 583 Arguments 584 Exit Code 584 backup_file 584 backup_file 0 Synopsis 584 Description 584 Arguments 584 Exit Code 584 VMware Greenplum v6.19 Documentation VMware, Inc Description 585 Arguments 585 Exit Code 586 cleanup_plugin_for_restore 586 cleanup_plugin_for_restore 0 Synopsis 586 Description 586 Arguments 586 Exit Code 587 delete_backup 587 delete_backup

Practices 0 Best Practices Summary 315 Best Practices Summary 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Distributions 316 Resource Queue Synopsis 574 Description 574 Arguments 575 Exit Code 575 backup_file 575 backup_file 0 Synopsis 575 Description 575 Arguments 575 Exit Code 575 VMware Greenplum v6.18 Documentation VMware, Inc Description 576 Arguments 576 Exit Code 577 cleanup_plugin_for_restore 577 cleanup_plugin_for_restore 0 Synopsis 577 Description 577 Arguments 577 Exit Code 578 delete_backup 578 delete_backup

Practices 0 Best Practices Summary 248 Best Practices Summary 0 Data Model 248 Heap vs. Append-Optimized Storage 248 Row vs. Column Oriented Storage 248 Compression 249 Distributions 249 Resource Queue Synopsis 506 Description 506 Arguments 507 Exit Code 507 backup_file 507 backup_file 0 Synopsis 507 Description 507 Arguments 507 Exit Code 507 cleanup_plugin_for_backup 507 VMware Greenplum Description 508 Arguments 508 Exit Code 509 cleanup_plugin_for_restore 509 cleanup_plugin_for_restore 0 Synopsis 509 Description 509 Arguments 509 Exit Code 510 delete_backup 510 delete_backup

Greenplum Database Best Practices 318 Best Practices Summary 319 Data Model 319 Heap vs. Append-Optimized Storage 319 Row vs. Column Oriented Storage 319 VMware Tanzu Greenplum v6.20 Documentation VMware Description 575 Arguments 575 Exit Code 575 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 28 backup\_file 575 Synopsis 575 Description 576 Arguments 576 Exit Code 576 cleanup\_plugin\_for\_backup 576 Exit Code 577 cleanup\_plugin\_for\_restore 577 Synopsis 577 Description 577 Arguments 578 Exit Code 578 delete\_backup 578 Synopsis 578 Description 579 Arguments 579 Exit Code 579 Example

Memory 1195 memory_spill_ratio and Low Memory Queries 1195 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1195 Other Memory Considerations 1196 Using VMware Greenplum Database Best Practices 1228 Best Practices Summary 1229 Data Model 1229 Heap vs. Append-Optimized Storage 1229 Row vs. Column Oriented Storage 1229 Compression 1230 Distributions 1230 Resource Queue Descriptors and Tuples 2430 Set-Returning Functions 2432 Table Functions 2434 Limitations 2434 Sample Code 2434 Building a GPPC Shared Library with PGXS 2435 Registering a GPPC Function with Greenplum Database

Memory 1163 memory_spill_ratio and Low Memory Queries 1164 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1164 Other Memory Considerations 1165 Using VMware Greenplum Database Best Practices 1196 Best Practices Summary 1197 Data Model 1197 Heap vs. Append-Optimized Storage 1197 Row vs. Column Oriented Storage 1197 Compression 1198 Distributions 1198 Resource Queue Descriptors and Tuples 2385 Set-Returning Functions 2387 Table Functions 2389 Limitations 2389 Sample Code 2389 Building a GPPC Shared Library with PGXS 2390 Registering a GPPC Function with Greenplum Database

Memory 1179 memory_spill_ratio and Low Memory Queries 1180 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1180 Other Memory Considerations 1181 Using VMware Greenplum 1211 Best Practices Summary 1212 Data Model 1212 Heap vs. Append-Optimized Storage 1212 VMware Greenplum 6 Documentation VMware, Inc 53 Row vs. Column Oriented Storage 1212 Compression 1213 Distributions Documentation VMware, Inc 128 Set-Returning Functions 2361 Table Functions 2362 Limitations 2363 Sample Code 2363 Building a GPPC Shared Library with PGXS 2363 Registering a GPPC Function with Greenplum Database

Memory 1142 memory_spill_ratio and Low Memory Queries 1143 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1143 Other Memory Considerations 1143 Using VMware Tanzu Database Best Practices 1172 Best Practices Summary 1173 Data Model 1173 Heap vs. Append-Optimized Storage 1173 Row vs. Column Oriented Storage 1173 Compression 1174 Distributions 1174 Resource Queue Descriptors and Tuples 2283 Set-Returning Functions 2285 Table Functions 2286 Limitations 2287 Sample Code 2287 Building a GPPC Shared Library with PGXS 2287 Registering a GPPC Function with Greenplum Database

Memory 1138 memory_spill_ratio and Low Memory Queries 1138 About Using Reserved Resource Group Memory vs. Using Resource Group Global Shared Memory 1138 Other Memory Considerations 1139 Using VMware Tanzu Database Best Practices 1167 Best Practices Summary 1168 Data Model 1168 Heap vs. Append-Optimized Storage 1168 Row vs. Column Oriented Storage 1168 Compression 1169 Distributions 1169 Resource Queue Descriptors and Tuples 2296 Set-Returning Functions 2298 Table Functions 2299 Limitations 2299 Sample Code 2300 Building a GPPC Shared Library with PGXS 2300 Registering a GPPC Function with Greenplum Database