Updating Statistics 185 Analyzing Partitioned Tables 185 Configuring Statistics 186 Statistics Target 186 Automatic Statistics Collection 187 Installing and Upgrading Greenplum 189 Estimating Storage “f2”:null},2,null,3]’) [{“f1”:1},2,null,3] jsonb_set(target jsonb, path text[], new_value jsonb [, create_missing boolean]) jsonb Returns target with the section designated by path replaced by new_value null, “f3”: [2, 3, 4]}, 2] jsonb_insert(target jsonb, path text[], new_value jsonb [, insert_after boolean]) jsonb Returns target with new_value inserted. If target section designated by path is in a JSONB

Updating Statistics 334 Analyzing Partitioned Tables 334 Configuring Statistics 335 Statistics Target 335 Automatic Statistics Collection 336 VMware Greenplum on vSphere 338 Overview 338 Getting debug_print_prelim_plan 1892 debug_print_rewritten 1892 debug_print_slice_table 1892 default_statistics_target 1893 default_tablespace 1893 default_text_search_config 1893 default_transaction_deferrable 1893 Resolves an issue where running a differential recovery copied all tablespace directories to the target segment instead of only the necessary ones. VMware Greenplum 6 Documentation VMware by Broadcom

Updating Statistics 320 Analyzing Partitioned Tables 320 Configuring Statistics 321 Statistics Target 321 Automatic Statistics Collection 322 VMware Greenplum on vSphere 324 Overview 324 Getting debug_print_prelim_plan 1852 debug_print_rewritten 1852 debug_print_slice_table 1852 default_statistics_target 1852 default_tablespace 1852 default_text_search_config 1853 default_transaction_deferrable 1853 point was never reached. The code was fixed to ensure that the restore errors out of the recovery target is not reached. Release 6.25.2 Release Date: 2023-09-13 VMware Greenplum 6.25.2 is a maintenance

Updating Statistics 302 Analyzing Partitioned Tables 302 Configuring Statistics 303 Statistics Target 303 Automatic Statistics Collection 304 VMware Tanzu Greenplum on vSphere 306 Overview 306 Getting debug_print_prelim_plan 1858 debug_print_rewritten 1858 debug_print_slice_table 1858 default_statistics_target 1858 default_tablespace 1858 default_text_search_config 1859 default_transaction_deferrable 1859 query. Cluster Management 14627 Updates incremental recovery to preserve pg_controldata output for target segments in case of a recovery failure. Greenplum on vSphere 1472 Resolves an issue in the Greenplum

292 VMware Tanzu Greenplum 6 Documentation VMware, Inc 12 Configuring Statistics 292 Statistics Target 292 Automatic Statistics Collection 293 VMware Tanzu Greenplum on vSphere 295 Supported Platforms and target lists. Extracting multiple values in this way can improve performance over extracting them separately with per-key operators. JSON keys are matched to identical column names in the target row in desired values for some types. JSON fields that do not appear in the target row type will be omitted from the output, and target columns that do not match any JSON field will be NULL. The json_typeof

Updating Statistics 260 Analyzing Partitioned Tables 261 Configuring Statistics 261 Statistics Target 261 Automatic Statistics Collection 262 VMware Tanzu Greenplum on vSphere 264 Supported Platforms and target lists. Extracting multiple values in this way can improve performance over extracting them separately with per-key operators. JSON keys are matched to identical column names in the target row in desired values for some types. JSON fields that do not appear in the target row type will be omitted from the output, and target columns that do not match any JSON field will be NULL. The json_typeof

Updating Statistics 287 Analyzing Partitioned Tables 288 Configuring Statistics 288 Statistics Target 288 Automatic Statistics Collection 289 VMware Tanzu Greenplum on vSphere 291 Overview 291 Getting debug_print_prelim_plan 1790 debug_print_rewritten 1790 debug_print_slice_table 1790 default_statistics_target 1791 default_tablespace 1791 default_text_search_config 1791 default_transaction_deferrable 1791 pushing cast operations below the join when safe. 13746 : Fallback to Postgres optimizer when a target list in CTE producer is empty. 13683 : Fixes incorrect addrefs that caused memory leaks. Data Flow

debug_print_prelim_plan 1561 debug_print_rewritten 1561 debug_print_slice_table 1562 default_statistics_target 1562 default_tablespace 1562 default_text_search_config 1562 default_transaction_deferrable 1563 exceeded 1GB. 12402 : Resolves an issue where Greenplum Database failed to complete a query when the target relation of an UPDATE or DELETE operation was a partition table and Greenplum generated a unique 31296 - Server : Fixed an issue with gpcheckcat reporting an error when a VIEW is defined without a target and does not have an entry in pg_attribute. 31272 - Data Flow : In dual stack IPv4 and IPv6 hosts

debug_print_prelim_plan 1570 debug_print_rewritten 1571 debug_print_slice_table 1571 default_statistics_target 1571 default_tablespace 1571 default_text_search_config 1572 default_transaction_deferrable 1572 exceeded 1GB. 12402 : Resolves an issue where Greenplum Database failed to complete a query when the target relation of an UPDATE or DELETE operation was a partition table and Greenplum generated a unique 31296 - Server : Fixed an issue with gpcheckcat reporting an error when a VIEW is defined without a target and does not have an entry in pg_attribute. 31272 - Data Flow : In dual stack IPv4 and IPv6 hosts

debug_print_prelim_plan 1496 debug_print_rewritten 1496 debug_print_slice_table 1497 default_statistics_target 1497 default_tablespace 1497 VMware Greenplum v6.17 Documentation VMware, Inc. 107 default_text_search_config t1 Table "public.t1" Column | Type | Modifiers | Storage | Stats target | Description --------+---------+-----------+---------+--------------+------------- c1 | integer t1 Table "public.t1" Column | Type | Modifiers | Storage | Stats target | Description --------+---------+-----------+---------+--------------+------------- VMware Greenplum