Updating Statistics with ANALYZE 0 Generating Statistics Selectively 353 Improving Statistics Quality 354 When to Run ANALYZE 354 Configuring Automatic Statistics Collection 354 Managing Bloat in 1526 Using dblink as a Non-Superuser 1527 Using dblink as a Non-Superuser without Authentication Checks 1529 Using dblink with SSL-Encrypted Connections to Greenplum 1530 Additional Module Documentation "CREATE EXTENSION IF NOT EXISTS dataflow; when connecting to a Greenplum Database 5.x. This fix checks the Greenplum version to determine whether it should create a new extension. Greenplum Installation

Updating Statistics with ANALYZE 0 Generating Statistics Selectively 344 Improving Statistics Quality 345 When to Run ANALYZE 345 Configuring Automatic Statistics Collection 345 Managing Bloat in 1517 Using dblink as a Non-Superuser 1518 Using dblink as a Non-Superuser without Authentication Checks 1520 Using dblink with SSL-Encrypted Connections to Greenplum 1521 Additional Module Documentation out of range in select() due to liveness checks performed on all hostnames associated with each database id. This issue has been resolved and liveness checks are now performend only on unique hostnames

Updating Statistics with ANALYZE 348 Generating Statistics Selectively 348 Improving Statistics Quality 349 When to Run ANALYZE 349 Configuring Automatic Statistics Collection 349 Managing Bloat in 1521 Using dblink as a Non-Superuser 1522 Using dblink as a Non-Superuser without Authentication Checks 1524 Using dblink with SSL-Encrypted Connections to Greenplum 1524 Additional Module Documentation this problem by setting the client_connection_check_interval GUC to a non-zero time value to enable checks for disconnected clients while running queries. If the server backend process detects the client

Updating Statistics with ANALYZE 1241 Generating Statistics Selectively 1241 Improving Statistics Quality 1241 When to Run ANALYZE 1242 Configuring Automatic Statistics Collection 1242 Managing Bloat 1767 Using dblink as a Non-Superuser 1768 Using dblink as a Non-Superuser without Authentication Checks 1769 Using dblink with SSL-Encrypted Connections to Greenplum 1770 Additional Module Documentation Section 2094 Generic Settings 2094 Log Settings 2098 Console Access Control 2099 Connection Sanity Checks, Timeouts 2099 TLS settings 2101 Dangerous Timeouts 2104 Low-level Network Settings 2104 [users]

Updating Statistics with ANALYZE 1201 Generating Statistics Selectively 1202 Improving Statistics Quality 1202 When to Run ANALYZE 1202 Configuring Automatic Statistics Collection 1202 Managing Bloat 1719 Using dblink as a Non-Superuser 1721 Using dblink as a Non-Superuser without Authentication Checks 1722 Using dblink with SSL-Encrypted Connections to Greenplum 1722 Additional Module Documentation Section 2024 Generic Settings 2025 Log Settings 2029 Console Access Control 2030 Connection Sanity Checks, Timeouts 2030 TLS settings 2032 Dangerous Timeouts 2034 Low-level Network Settings 2035 [users]

Updating Statistics with ANALYZE 1197 Generating Statistics Selectively 1197 Improving Statistics Quality 1197 When to Run ANALYZE 1198 Configuring Automatic Statistics Collection 1198 Managing Bloat 1716 Using dblink as a Non-Superuser 1717 Using dblink as a Non-Superuser without Authentication Checks 1718 Using dblink with SSL-Encrypted Connections to Greenplum 1719 Additional Module Documentation Section 2017 Generic Settings 2018 Log Settings 2022 Console Access Control 2023 Connection Sanity Checks, Timeouts 2023 TLS settings 2026 Dangerous Timeouts 2028 VMware Tanzu Greenplum 6 Documentation

Updating Statistics with ANALYZE 1050 Generating Statistics Selectively 1051 Improving Statistics Quality 1051 When to Run ANALYZE 1051 Configuring Automatic Statistics Collection 1051 Managing Bloat 1516 Using dblink as a Non-Superuser 1517 Using dblink as a Non-Superuser without Authentication Checks 1518 Using dblink with SSL-Encrypted Connections to Greenplum 1519 Additional Module Documentation Section 1783 Generic Settings 1783 Log Settings 1787 Console Access Control 1788 Connection Sanity Checks, Timeouts 1788 TLS settings 1790 Dangerous Timeouts 1792 Low-level Network Settings 1793 [users]

Updating Statistics with ANALYZE 1039 Generating Statistics Selectively 1039 Improving Statistics Quality 1039 When to Run ANALYZE 1040 Configuring Automatic Statistics Collection 1040 Managing Bloat null, 3 ] jsonb_path_exists(target jsonb, path jsonpath [, vars jsonb [, silent bool]]) boolean Checks whether JSON path returns any item for the specified JSON value. jsonb_path_exists(‘{“a”:[1,2,3 sampled to generate root partition statistics. Sampling table data takes longer and results in lower quality root partition statistics. The Greenplum Database server configuration parameter optimizer_analyze_root_partition

Updating Statistics with ANALYZE 1258 Generating Statistics Selectively 1258 Improving Statistics Quality 1259 VMware Greenplum 6 Documentation VMware by Broadcom 60 When to Run ANALYZE 1259 Configuring 1795 Using dblink as a Non-Superuser 1797 Using dblink as a Non-Superuser without Authentication Checks 1798 Using dblink with SSL-Encrypted Connections to Greenplum 1799 Additional Module Documentation Section 2142 Generic Settings 2142 Log Settings 2147 Console Access Control 2148 Connection Sanity Checks, Timeouts 2148 TLS settings 2151 Dangerous Timeouts 2153 Low-level Network Settings 2154 [users]

Updating Statistics with ANALYZE 0 Generating Statistics Selectively 279 Improving Statistics Quality 280 When to Run ANALYZE 280 Configuring Automatic Statistics Collection 280 Managing Bloat in 1453 Using dblink as a Non-Superuser 1454 Using dblink as a Non-Superuser without Authentication Checks 1456 Using dblink with SSL-Encrypted Connections to Greenplum 1456 Additional Module Documentation install the hugepages package and run this command as root: # hugeadm --thp-never This cat command checks the state of THP. The output indicates that THP is disabled. VMware Greenplum v6.17 Documentation