94304 www.vmware.com Copyright © 2023 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Greenplum v6.19 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6.19 gpcheckperf 352 Monitoring with Operating System Utilities 352 Best Practices 353 Additional Information 353 Updating Statistics with ANALYZE 353 Updating Statistics with ANALYZE 0 Generating Statistics External Tables 361 External Tables with Gpfdist 362 Gpload 363 Best Practices 363 Additional Information 364 Security 364 Security 452 Basic Security Best Practices 364 Password Strength Guidelines

94304 www.vmware.com Copyright © 2023 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Greenplum v6.18 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6.18 gpcheckperf 343 Monitoring with Operating System Utilities 343 Best Practices 344 Additional Information 344 Updating Statistics with ANALYZE 344 Updating Statistics with ANALYZE 0 Generating Statistics External Tables 352 External Tables with Gpfdist 353 Gpload 354 Best Practices 354 Additional Information 355 Security 355 Security 443 Basic Security Best Practices 355 Password Strength Guidelines

94304 www.vmware.com Copyright © 2023 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Greenplum 6 Documentation VMware, Inc 2 Contents VMware Tanzu™ Greenplum® 6.23 Documentation Views 603 Example Data 604 About View Storage in Greenplum Database 605 Where View Dependency Information is Stored 606 Creating and Managing Materialized Views 606 Creating Materialized Views 607 Refreshing Hierarchical Regression using PL/R 1003 Downloading and Installing R Packages 1003 Displaying R Library Information 1005 VMware Greenplum 6 Documentation VMware, Inc 42 Loading R Modules at Startup 1006 References

94304 www.vmware.com Copyright © 2023 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Tanzu Greenplum 6 Documentation VMware, Inc 2 Contents VMware Tanzu™ Greenplum® 6.23 Views 581 Example Data 582 About View Storage in Greenplum Database 583 Where View Dependency Information is Stored 584 Creating and Managing Materialized Views 584 Creating Materialized Views 585 Refreshing Hierarchical Regression using PL/R 972 Downloading and Installing R Packages 972 Displaying R Library Information 974 Loading R Modules at Startup 975 References 975 Greenplum Database R Client 975 About Greenplum

more information, go to https://www.broadcom.com. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies. Copyright and trademark information. VMware Validating the Greenplum Installation 382 Getting the Greenplum Database Cluster Connection Information 383 Additional Resources 383 Installing the Greenplum High Availability Service 383 Prerequisites Views 609 Example Data 610 About View Storage in Greenplum Database 611 Where View Dependency Information is Stored 612 Creating and Managing Materialized Views 612 Creating Materialized Views 613 Refreshing

94304 www.vmware.com Copyright © 2023 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® gpcheckperf 347 Monitoring with Operating System Utilities 347 Best Practices 347 Additional Information 348 Updating Statistics with ANALYZE 348 Generating Statistics Selectively 348 Improving Statistics External Tables 356 External Tables with Gpfdist 356 Gpload 357 Best Practices 358 Additional Information 359 Security 359 Basic Security Best Practices 359 Password Strength Guidelines 359 Encrypting

94304 www.vmware.com Copyright © 2023 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Greenplum 6 Documentation VMware, Inc. 2 Contents VMware Greenplum 6.25 Documentation Validating the Greenplum Installation 366 Getting the Greenplum Database Cluster Connection Information 366 Managing Single Host Failures in VMware vSphere 366 How DRS and HA protect a running Greenplum Inc. 27 Example Data 581 About View Storage in Greenplum Database 582 Where View Dependency Information is Stored 582 Creating and Managing Materialized Views 583 Creating Materialized Views 584 Refreshing

94304 www.vmware.com Copyright © 2023 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Tanzu Greenplum 6 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6 Views 579 Example Data 579 About View Storage in Greenplum Database 580 Where View Dependency Information is Stored 581 Creating and Managing Materialized Views 581 Creating Materialized Views 582 Refreshing Hierarchical Regression using PL/R 967 Downloading and Installing R Packages 968 Displaying R Library Information 969 Loading R Modules at Startup 970 References 970 Greenplum Database R Client 971 About Greenplum

94304 www.vmware.com Copyright © 2023 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Greenplum v6.17 Documentation VMware, Inc. 2 Contents VMware Tanzu™ Greenplum® 6.17 gpcheckperf 278 Monitoring with Operating System Utilities 279 Best Practices 279 Additional Information 279 Updating Statistics with ANALYZE 279 Updating Statistics with ANALYZE 0 Generating Statistics External Tables 287 External Tables with Gpfdist 288 Gpload 289 Best Practices 289 Additional Information 290 Security 290 Security 378 Basic Security Best Practices 290 Password Strength Guidelines

94304 www.vmware.com Copyright © 2022 VMware, Inc. All rights reserved. Copyright and trademark information. VMware Tanzu Greenplum 6 Documentation VMware, Inc 2 Contents VMware Tanzu™ Greenplum® 6.21 Views 495 Example Data 496 About View Storage in Greenplum Database 497 Where View Dependency Information is Stored 497 Creating and Managing Materialized Views 497 Creating Materialized Views 498 Refreshing Installing R Packages 845 VMware Tanzu Greenplum 6 Documentation VMware, Inc 41 Displaying R Library Information 846 Loading R Modules at Startup 847 References 848 Greenplum Database R Client 848 About Greenplum