PostgreSQL Features 270 Zstandard Compression Algorithm 271 Relaxed Rules for Specifying Table Distribution Columns 271 Resource Groups Features 271 PL/pgSQL Procedural Language Enhancements 272 Replicated Constraints 561 Primary Keys 562 Foreign Keys 562 Choosing the Table Distribution Policy 562 Declaring Distribution Keys 563 Custom Distribution Key Hash Functions 564 Example Custom Hash Operator Class 564 (Append-Optimized Tables Only) 569 To create a compressed table 570 Checking the Compression and Distribution of an Append-Optimized Table 570 Support for Run-length Encoding 571 VMware Greenplum 6 Documentation

PostgreSQL Features 238 Zstandard Compression Algorithm 238 Relaxed Rules for Specifying Table Distribution Columns 239 Resource Groups Features 239 PL/pgSQL Procedural Language Enhancements 239 Replicated Reviewing the Results 342 Next Steps 342 Creating the Jumpbox Virtual Machine 342 Uploading the ISO Image to vCenter 342 Deploying the Jumpbox Virtual Machine 343 Initializing the Jumpbox Virtual Machine Constraints 556 Primary Keys 556 Foreign Keys 557 Choosing the Table Distribution Policy 557 Declaring Distribution Keys 558 Custom Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559

PostgreSQL Features 231 Zstandard Compression Algorithm 231 Relaxed Rules for Specifying Table Distribution Columns 231 Resource Groups Features 232 PL/pgSQL Procedural Language Enhancements 232 Replicated Reviewing the Results 332 Next Steps 332 Creating the Jumpbox Virtual Machine 332 Uploading the ISO Image to vCenter 332 Deploying the Jumpbox Virtual Machine 333 Initializing the Jumpbox Virtual Machine Greenplum 6 Documentation VMware, Inc 22 Choosing the Table Distribution Policy 536 Declaring Distribution Keys 537 Custom Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538

PostgreSQL Features 257 Zstandard Compression Algorithm 257 Relaxed Rules for Specifying Table Distribution Columns 257 Resource Groups Features 258 PL/pgSQL Procedural Language Enhancements 258 Replicated Constraints 532 Primary Keys 533 Foreign Keys 533 Choosing the Table Distribution Policy 533 Declaring Distribution Keys 534 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 (Append-Optimized Tables Only) 540 To create a compressed table 541 Checking the Compression and Distribution of an Append-Optimized Table 541 Support for Run-length Encoding 542 Adding Column-level Compression

PostgreSQL Features 227 Zstandard Compression Algorithm 228 Relaxed Rules for Specifying Table Distribution Columns 228 Resource Groups Features 229 PL/pgSQL Procedural Language Enhancements 229 Replicated Reviewing the Results 328 Next Steps 328 Creating the Jumpbox Virtual Machine 328 Uploading the ISO Image to vCenter 328 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 14 Deploying the Jumpbox Virtual Constraints 533 Primary Keys 533 Foreign Keys 533 Choosing the Table Distribution Policy 534 Declaring Distribution Keys 535 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535

PostgreSQL Features 206 Zstandard Compression Algorithm 207 Relaxed Rules for Specifying Table Distribution Columns 207 Resource Groups Features 207 PL/pgSQL Procedural Language Enhancements 208 Replicated Reviewing the Results 297 Next Steps 297 Creating the Jumpbox Virtual Machine 297 Uploading the ISO Image to vCenter 297 Deploying the Jumpbox Virtual Machine 297 Initializing the Jumpbox Virtual Machine Constraints 454 Primary Keys 454 Foreign Keys 454 Choosing the Table Distribution Policy 454 Declaring Distribution Keys 455 Custom Distribution Key Hash Functions 456 Example Custom Hash Operator Class 456

Foreign Keys 328 Exclusion Constraints 329 Choosing the Table Distribution Policy 329 Declaring Distribution Keys 330 Custom Distribution Key Hash Functions 331 Example Custom Hash Operator Class 331 (Append-Optimized Tables Only) 336 To create a compressed table 337 Checking the Compression and Distribution of an Append-Optimized Table 337 Support for Run-length Encoding 338 Adding Column-level Compression TYPE Command 343 Choosing Block Size 343 Altering a Table 343 Altering Table Distribution 344 Changing the Distribution Policy 344 Redistributing Table Data 344 Altering the Table Access Method 344

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 9.1.7 GraalVM Native Image . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 v Background Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 Build GraalVM Native Image(Alpha) . . . . . . . . . . . . . . . . . . . . . . . . . 147 Use Helm . . . . . . . . . . . . . Proxy using binary distribution, the environment must have Java JRE 8 or higher. 7.2.4 Procedure 1. Get ShardingSphere‐Proxy. ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152 9.1.7 GraalVM Native Image . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152 Background Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Build GraalVM Native Image(Alpha) . . . . . . . . . . . . . . . . . . . . . . . . . 166 Use Helm . . . . . . . . . . . . . Proxy using binary distribution, the environment must have Java JRE 8 or higher. 7.2.4 Procedure 1. Get ShardingSphere‐Proxy. ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 Build GraalVM Native Image(Alpha) . . . . . . . . . . . . . . . . . . . . . . . . . 185 Use Helm . . . . . . . . . . . . . Proxy using binary distribution, the environment must have Java JRE 8 or higher. 2.2.4 Procedure 1. Get ShardingSphere‐Proxy. ShardingSphere‐Proxy is available at: ‐ Binary Distribution ‐ Docker ‐ Helm classified into two forms: uniform distribution and custom distribution. Uniform Distribution refers to situations where the data table exhibits a uniform distribution within each data source. For example: