Greenplum 6 and 7 Partitioning Catalogs 248 Why are Migration Tasks Required? 248 pg_partitions 248 Examples Retrieving Similar Information in Greenplum 7 250 partitionname / parentpartitionname 250 partitionposition Compression Settings 340 Optimal Location for Column Compression Settings 341 Storage Parameters Examples 341 Example 1 341 Example 2 341 Example 3 341 Example 4 342 Example 5 342 Adding Compression What Hasn’t Changed With Classic Syntax? 367 What Has Changed? 367 Additional Considerations 370 Examples Using the Classic Partitioning Syntax 370 Creating Partitioned Tables with the Classic Syntax 370

Remove MADlib objects from the database 398 Uninstall the Greenplum Database MADlib Package 398 Examples 399 VMware Greenplum v6.19 Documentation VMware, Inc. 19 Linear Regression 399 Association Rules Limitations 462 The PL/pgSQL Language 462 Running SQL Commands 463 PL/pgSQL Plan Caching 463 PL/pgSQL Examples 464 Example: Aliases for Function Parameters 464 Example: Using the Data Type of a Table Column pip 478 Building and Installing Python Modules Locally 478 Testing Installed Python Modules 478 Examples 479 References 481 Technical References 481 PL/R Language 481 PL/R Language 0 About Greenplum

Remove MADlib objects from the database 389 Uninstall the Greenplum Database MADlib Package 389 Examples 390 Linear Regression 390 Association Rules 391 Naive Bayes Classification 393 References 397 454 PL/pgSQL Plan Caching 454 VMware Greenplum v6.18 Documentation VMware, Inc. 22 PL/pgSQL Examples 455 Example: Aliases for Function Parameters 455 Example: Using the Data Type of a Table Column pip 468 Building and Installing Python Modules Locally 469 Testing Installed Python Modules 469 Examples 470 References 471 Technical References 471 PL/R Language 472 VMware Greenplum v6.18 Documentation

Single-Tier 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 pg_hba.conf File 512 Authentication Methods 513 Basic Authentication 513 Basic Authentication Examples 514 GSSAPI Authentication 515 LDAP Authentication 516 SSL Client Authentication 518 SSL Authentication Compression Settings 573 Optimal Location for Column Compression Settings 574 Storage Directives Examples 574 Example 1 574 Example 2 574 Example 3 575 Example 4 575 Example 5 575 Adding Compression

pg_hba.conf File 483 Authentication Methods 483 Basic Authentication 484 Basic Authentication Examples 485 GSSAPI Authentication 485 LDAP Authentication 487 SSL Client Authentication 488 SSL Authentication Compression Settings 544 Optimal Location for Column Compression Settings 545 Storage Directives Examples 545 Example 1 545 Example 2 545 Example 3 545 VMware Greenplum 6 Documentation VMware, Inc Documentation VMware, Inc. 28 Command-based External Web Tables 606 URL-based External Web Tables 606 Examples for Creating External Tables 607 Example 1—Single gpfdist instance on single-NIC machine 607 Example

pg_hba.conf File 507 Authentication Methods 508 Basic Authentication 508 Basic Authentication Examples 509 GSSAPI Authentication 509 LDAP Authentication 511 SSL Client Authentication 512 SSL Authentication Compression Settings 568 Optimal Location for Column Compression Settings 568 Storage Directives Examples 569 Example 1 569 Example 2 569 Example 3 569 Example 4 569 Example 5 570 Adding Compression External Web Tables 628 Command-based External Web Tables 628 URL-based External Web Tables 629 Examples for Creating External Tables 629 Example 1—Single gpfdist instance on single-NIC machine 630 Example

Remove MADlib objects from the database 324 Uninstall the Greenplum Database MADlib Package 324 Examples 325 Linear Regression 325 Association Rules 326 Naive Bayes Classification 328 References 332 Limitations 387 The PL/pgSQL Language 387 Running SQL Commands 389 PL/pgSQL Plan Caching 389 PL/pgSQL Examples 390 Example: Aliases for Function Parameters 390 Example: Using the Data Type of a Table Column pip 403 Building and Installing Python Modules Locally 404 Testing Installed Python Modules 404 Examples 405 References 406 Technical References 406 PL/R Language 407 PL/R Language 0 About Greenplum

pg_hba.conf File 488 Authentication Methods 488 Basic Authentication 489 Basic Authentication Examples 489 GSSAPI Authentication 490 LDAP Authentication 491 SSL Client Authentication 493 SSL Authentication Compression Settings 547 Optimal Location for Column Compression Settings 547 Storage Directives Examples 547 Example 1 548 Example 2 548 Example 3 548 Example 4 548 Example 5 549 Adding Compression External Web Tables 606 Command-based External Web Tables 606 URL-based External Web Tables 607 Examples for Creating External Tables 607 Example 1—Single gpfdist instance on single-NIC machine 608 Example

pg_hba.conf File 485 Authentication Methods 486 Basic Authentication 486 Basic Authentication Examples 487 GSSAPI Authentication 488 LDAP Authentication 489 SSL Client Authentication 491 SSL Authentication Compression Settings 544 Optimal Location for Column Compression Settings 544 Storage Directives Examples 545 Example 1 545 Example 2 545 Example 3 545 Example 4 545 Example 5 546 Adding Compression External Web Tables 603 Command-based External Web Tables 603 URL-based External Web Tables 604 Examples for Creating External Tables 604 Example 1—Single gpfdist instance on single-NIC machine 605 Example

Remove MADlib objects from the database 393 Uninstall the Greenplum Database MADlib Package 393 Examples 393 Linear Regression 394 Association Rules 395 Naive Bayes Classification 396 References 401 Limitations 456 The PL/pgSQL Language 456 Running SQL Commands 457 PL/pgSQL Plan Caching 458 PL/pgSQL Examples 458 Example: Aliases for Function Parameters 458 Example: Using the Data Type of a Table Column pip 472 Building and Installing Python Modules Locally 472 Testing Installed Python Modules 472 Examples 473 References 475 Technical References 475 PL/R Language 475 About Greenplum Database PL/R