Documentation VMware by Broadcom 3 Disaster Recovery 148 Data Flow 149 Release 6.26.1 149 Zstandard (zstd) Supported Version 149 Query Processing 149 Server 149 Cluster Management 150 Release Core Features 269 INTERVAL Data Type Handling 269 Additional PostgreSQL Features 270 Zstandard Compression Algorithm 271 Relaxed Rules for Specifying Table Distribution Columns 271 Resource Groups Features Hash Algorithm System-wide 526 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 526 Using SHA-256 Password Encryption 527 Setting the SHA-256 Password Hash Algorithm System-wide

Core Features 256 INTERVAL Data Type Handling 256 Additional PostgreSQL Features 257 Zstandard Compression Algorithm 257 Relaxed Rules for Specifying Table Distribution Columns 257 Resource Groups Features Hash Algorithm System-wide 497 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 497 Using SHA-256 Password Encryption 498 Setting the SHA-256 Password Hash Algorithm System-wide System-wide 498 Setting the SHA-256 Password Hash Algorithm for an Individual Session 498 Example 499 Restricting Access by Time 499 Example 1 – Create a New Role with Time-based Constraints 501 Example

Core Features 237 INTERVAL Data Type Handling 237 Additional PostgreSQL Features 238 Zstandard Compression Algorithm 238 Relaxed Rules for Specifying Table Distribution Columns 239 Resource Groups Features Hash Algorithm System-wide 521 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 521 Using SHA-256 Password Encryption 522 Setting the SHA-256 Password Hash Algorithm System-wide System-wide 522 Setting the SHA-256 Password Hash Algorithm for an Individual Session 522 Example 523 Restricting Access by Time 523 Example 1 – Create a New Role with Time-based Constraints 525 Example

Core Features 227 INTERVAL Data Type Handling 227 Additional PostgreSQL Features 227 Zstandard Compression Algorithm 228 Relaxed Rules for Specifying Table Distribution Columns 228 Resource Groups Features Hash Algorithm System-wide 499 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 499 Using SHA-256 Password Encryption 500 Setting the SHA-256 Password Hash Algorithm System-wide System-wide 500 Setting the SHA-256 Password Hash Algorithm for an Individual Session 500 Example 501 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 21 Restricting Access by Time 501 Example 1 –

Core Features 230 INTERVAL Data Type Handling 230 Additional PostgreSQL Features 231 Zstandard Compression Algorithm 231 Relaxed Rules for Specifying Table Distribution Columns 231 Resource Groups Features Hash Algorithm System-wide 501 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 501 Using SHA-256 Password Encryption 502 Setting the SHA-256 Password Hash Algorithm System-wide System-wide 502 Setting the SHA-256 Password Hash Algorithm for an Individual Session 502 Example 503 Restricting Access by Time 503 Example 1 – Create a New Role with Time-based Constraints 505 Example

Core Features 217 INTERVAL Data Type Handling 217 Additional PostgreSQL Features 218 Zstandard Compression Algorithm 218 Relaxed Rules for Specifying Table Distribution Columns 218 VMware Greenplum v6 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Distributions 325 Resource Queue Memory Management 325 Partitioning 327 Indexes 327 Resource Storage Model 337 Heap Storage or Append-Optimized Storage 338 Row or Column Orientation 338 Compression 339 Distributions 339 Local (Co-located) Joins 340 Data Skew 340 Processing Skew 341 Partitioning

Core Features 209 INTERVAL Data Type Handling 209 Additional PostgreSQL Features 210 Zstandard Compression Algorithm 210 Relaxed Rules for Specifying Table Distribution Columns 210 Resource Groups Features 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Distributions 316 Resource Queue Memory Management 316 Partitioning 318 Indexes 318 Resource Storage Model 328 Heap Storage or Append-Optimized Storage 329 Row or Column Orientation 329 Compression 330 Distributions 330 Local (Co-located) Joins 331 Data Skew 331 Processing Skew 332 Partitioning

Core Features 214 INTERVAL Data Type Handling 214 Additional PostgreSQL Features 215 Zstandard Compression Algorithm 215 Relaxed Rules for Specifying Table Distribution Columns 215 Resource Groups Features vs. Column Oriented Storage 319 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 14 Compression 320 Distributions 320 Resource Queue Memory Management 320 Partitioning 322 Indexes 322 Resource Storage Model 332 Heap Storage or Append-Optimized Storage 333 Row or Column Orientation 333 Compression 334 Distributions 334 Local (Co-located) Joins 335 Data Skew 335 Processing Skew 336 VMware

Core Features 206 INTERVAL Data Type Handling 206 Additional PostgreSQL Features 206 Zstandard Compression Algorithm 207 Relaxed Rules for Specifying Table Distribution Columns 207 Resource Groups Features Hash Algorithm System-wide 423 Setting the SCRAM-SHA-256 Password Hash Algorithm for an Individual Session 424 Using SHA-256 Password Encryption 424 Setting the SHA-256 Password Hash Algorithm System-wide System-wide 424 Setting the SHA-256 Password Hash Algorithm for an Individual Session 425 Example 425 Restricting Access by Time 426 Example 1 – Create a New Role with Time-based Constraints 427 Example

.................................... 3003 xxii List of Figures 62.1. Structure of a Genetic Algorithm .............................................................................. 2524 70.1. GIN Internals .............................................................................. 2875 F.18. Hash Algorithm Speeds ........................................................................................ stable sort, add data columns as secondary sorting columns. Tip The recursive query evaluation algorithm produces its output in breadth-first search order. How- ever, this is an implementation detail and