Architecture 344 Deployment Examples 344 10 TiB Database 344 100 TiB Database 345 1 PiB Database 345 Two-Tier Architecture 346 Deployment Examples 346 10 TiB Database 346 100 TiB Database 347 1 PiB Database Sizing the Greenplum Segment Host (Virtual Machine) 348 Next Steps 348 Greenplum Storage Sizer for Two-Tiered Architectures 348 Prerequisites 349 Greenplum Cluster 349 VMware vSphere 350 Network 350 Broadcom 104 Installing and Registering the Module 1819 Using the Module 1819 Migrating to the Two-Argument string_agg() Function 1820 gp_parallel_retrieve_cursor 1820 Installing and Registering the

gp_legacy_string_agg 1788 Installing and Registering the Module 1788 Using the Module 1788 Migrating to the Two-Argument string_agg() Function 1789 gp_parallel_retrieve_cursor 1789 Installing and Registering the gp_dispatch_keepalives_idle 1871 gp_dispatch_keepalives_interval 1871 gp_dynamic_partition_pruning 1872 gp_eager_two_phase_agg 1872 gp_enable_agg_distinct 1872 gp_enable_agg_distinct_pruning 1872 gp_enable_direct_dispatch configure cores for the master host first and then segment hosts, using a semicolon to separate the two. For example, CPUSET='1;1-3' configures core 1 for the master host, and cores 1 through 3 for segment

(expression) Example: SELECT departmzent_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional array as input. Treats such arrays as matrices. sum(array[]) smallint[], int[], bigint[] SELECT sum(myvalue) FROM mymatrix; sum {{1,3}, {4,4}} Performs matrix summation. Can take as input a two-dimensional array that is treated as a matrix. pivot_sum (label[], label, expr) int[], bigint[], float[] (expression) Example: SELECT department_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional array as input. Treats such arrays as matrices. PERCENTILE_CONT (expr) WITHIN GROUP (ORDER

gp_legacy_string_agg 1734 Installing and Registering the Module 1734 Using the Module 1734 Migrating to the Two-Argument string_agg() Function 1735 gp_parallel_retrieve_cursor 1735 Installing and Registering the gp_dispatch_keepalives_idle 1803 gp_dispatch_keepalives_interval 1803 gp_dynamic_partition_pruning 1803 gp_eager_two_phase_agg 1804 gp_enable_agg_distinct 1804 gp_enable_agg_distinct_pruning 1804 gp_enable_direct_dispatch Point-in-Time Recovery for Greenplum Database 6X. gp_pitr creates a new view -- gp_stat_archiver -- and two new internally used user-defined functions. For more information, see Additional Supplied Modules

(expression) Example: SELECT departmzent_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional array as input. Treats such arrays as matrices. sum(array[]) smallint[], int[], bigint[] SELECT sum(myvalue) FROM mymatrix; sum {{1,3}, {4,4}} Performs matrix summation. Can take as input a two-dimensional array that is treated as a matrix. pivot_sum (label[], label, expr) int[], bigint[], float[] (expression) Example: SELECT department_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional array as input. Treats such arrays as matrices. PERCENTILE_CONT (expr) WITHIN GROUP (ORDER

Together 330 Dell EMC VxRail Reference Architecture 331 Next Steps 331 Greenplum Storage Sizer for Two-Tiered Architectures 331 Prerequisites 332 Greenplum Cluster 332 VMware vSphere 333 Network 333 gp_legacy_string_agg 1779 Installing and Registering the Module 1779 Using the Module 1779 Migrating to the Two-Argument string_agg() Function 1780 gp_parallel_retrieve_cursor 1780 Installing and Registering the 1865 VMware Greenplum 6 Documentation VMware, Inc. 108 gp_dynamic_partition_pruning 1865 gp_eager_two_phase_agg 1866 gp_enable_agg_distinct 1866 gp_enable_agg_distinct_pruning 1866 gp_enable_direct_dispatch

(expression) Example: SELECT department_id, MEDIAN(salary) FROM employees GROUP BY department_id; Can take a two-dimensional array as input. Treats such arrays as matrices. PERCENTILE_CONT (expr) WITHIN GROUP (ORDER gp_legacy_string_agg 1635 Installing and Registering the Module 1636 Using the Module 1636 Migrating to the Two-Argument string_agg() Function 1636 gp_sparse_vector 1637 Installing and Registering the Module 1637 gp_dispatch_keepalives_idle 1728 gp_dispatch_keepalives_interval 1728 gp_dynamic_partition_pruning 1728 gp_eager_two_phase_agg 1728 gp_enable_agg_distinct 1728 VMware Greenplum 7 Documentation VMware by Broadcom 102

gp_legacy_string_agg 0 Installing and Registering the Module 1535 Using the Module 1536 Migrating to the Two-Argument string_agg() Function 1536 gp_sparse_vector 1536 gp_sparse_vector 0 Installing and Registering been expanded partition prepare”. The gpexpand code has been modified so that the expand script – a two-stage process – can be run again in the second stage if it fails in the first stage. Release 6.19 fields are now gone. The Mirror status field in gpstate -s output for primary segments now has just two valid values: Synchronized or Not in Sync. Greenplum 6.18.0 introduces a new Query Optimizer server

gp_legacy_string_agg 0 Installing and Registering the Module 1527 Using the Module 1527 Migrating to the Two-Argument string_agg() Function 1527 gp_sparse_vector 1528 gp_sparse_vector 0 Installing and Registering fields are now gone. The Mirror status field in gpstate -s output for primary segments now has just two valid values: Synchronized or Not in Sync. Greenplum 6.18.0 introduces a new Query Optimizer server Resolved a problem that could cause a transaction to incorrectly use single-phase commit instead of two-phase commit. 275569338 - Query Dispatcher : Resolved a problem that could cause the error, ERROR:

to also run ETL and reporting tools on the master, which requires more disk space and processing power. Parent topic: Introduction to Greenplum Master Redundancy You may optionally deploy a backup or number of effective CPUs or CPU core. For example, if your segment hosts have two dual-core processors, you may have two or four primary segments per host. If your segment hosts have three quad-core than its primary segment. Mirror segments can be arranged across the hosts in the system in one of two standard configurations, or in a custom configuration you design. The default configuration, called