Core Dump 253 XFS Mount Options 253 Disk I/O Settings 254 Transparent Huge Pages (THP) 255 IPC Object Removal 256 SSH Connection Threshold 256 Synchronizing System Clocks 258 To configure NTP 258 Greenplum Database Best Practices 0 Best Practices Summary 324 Best Practices Summary 0 Data Model 324 Heap vs. Append-Optimized Storage 324 Row vs. Column Oriented Storage 324 Compression 325 Data Types 337 Use Types Consistently 337 Choose Data Types that Use the Least Space 337 Storage Model 337 Heap Storage or Append-Optimized Storage 338 Row or Column Orientation 338 Compression 339

Core Dump 246 XFS Mount Options 246 Disk I/O Settings 247 Transparent Huge Pages (THP) 248 IPC Object Removal 249 SSH Connection Threshold 249 Synchronizing System Clocks 251 To configure NTP 251 Greenplum Database Best Practices 0 Best Practices Summary 315 Best Practices Summary 0 Data Model 315 Heap vs. Append-Optimized Storage 315 Row vs. Column Oriented Storage 315 Compression 316 Data Types 328 Use Types Consistently 328 Choose Data Types that Use the Least Space 328 Storage Model 328 Heap Storage or Append-Optimized Storage 329 Row or Column Orientation 329 Compression 330

XFS Mount Options 401 Disk I/O Settings 402 Networking 404 Transparent Huge Pages (THP) 404 IPC Object Removal 404 SSH Connection Threshold 405 Synchronizing System Clocks 406 To configure NTP 406 Configuring Database Authorization 499 Access Permissions and Roles 499 Managing Object Privileges 499 About Object Access Privileges 500 About Password Encryption in Greenplum Database 501 Using SCRAM-SHA-256 Superusers 521 Login Users 521 Groups 521 VMware Tanzu Greenplum 6 Documentation VMware, Inc 21 Object Privileges 521 Operating System Users and File System 522 Managing Data 526 Defining Database

Core Dump 251 XFS Mount Options 251 Disk I/O Settings 252 Transparent Huge Pages (THP) 253 IPC Object Removal 254 SSH Connection Threshold 254 Synchronizing System Clocks 256 To configure NTP 256 Master 317 Segments 317 Greenplum Database Best Practices 318 Best Practices Summary 319 Data Model 319 Heap vs. Append-Optimized Storage 319 Row vs. Column Oriented Storage 319 VMware Tanzu Greenplum Data Types 332 Use Types Consistently 332 Choose Data Types that Use the Least Space 332 Storage Model 332 Heap Storage or Append-Optimized Storage 333 Row or Column Orientation 333 Compression 334

XFS Mount Options 338 Disk I/O Settings 338 Networking 340 Transparent Huge Pages (THP) 340 IPC Object Removal 341 SSH Connection Threshold 341 Synchronizing System Clocks 342 To configure NTP 342 Permissions and Roles 421 VMware Tanzu Greenplum 6 Documentation VMware, Inc 19 Managing Object Privileges 422 About Object Access Privileges 423 About Password Encryption in Greenplum Database 423 Using SCRAM-SHA-256 Security Best Practices 440 System User (gpadmin) 441 Superusers 441 Login Users 441 Groups 441 Object Privileges 441 Operating System Users and File System 442 Managing Data 445 Defining Database

XFS Mount Options 398 Disk I/O Settings 399 Networking 401 Transparent Huge Pages (THP) 401 IPC Object Removal 402 SSH Connection Threshold 402 Synchronizing System Clocks 403 To configure NTP 403 Configuring Database Authorization 497 Access Permissions and Roles 497 Managing Object Privileges 497 About Object Access Privileges 498 About Password Encryption in Greenplum Database 499 Using SCRAM-SHA-256 Security Best Practices 518 System User (gpadmin) 518 Superusers 518 Login Users 519 Groups 519 Object Privileges 519 Operating System Users and File System 519 Managing Data 523 Defining Database

XFS Mount Options 389 Disk I/O Settings 389 Networking 391 Transparent Huge Pages (THP) 392 IPC Object Removal 393 VMware Greenplum 6 Documentation VMware, Inc. 18 SSH Connection Threshold 393 Synchronizing Configuring Database Authorization 495 Access Permissions and Roles 495 Managing Object Privileges 495 About Object Access Privileges 496 About Password Encryption in Greenplum Database 497 Using SCRAM-SHA-256 Security Best Practices 516 System User (gpadmin) 517 Superusers 517 Login Users 517 Groups 517 Object Privileges 518 Operating System Users and File System 518 Managing Data 522 Defining Database

XFS Mount Options 415 Disk I/O Settings 415 Networking 417 Transparent Huge Pages (THP) 417 IPC Object Removal 418 SSH Connection Threshold 418 Synchronizing System Clocks 420 To configure NTP 420 Configuring Database Authorization 519 Access Permissions and Roles 519 Managing Object Privileges 519 About Object Access Privileges 520 About Password Encryption in Greenplum Database 521 VMware Security Best Practices 540 System User (gpadmin) 541 Superusers 541 Login Users 541 Groups 541 Object Privileges 542 Operating System Users and File System 542 Managing Data 546 Defining Database

XFS Mount Options 407 Disk I/O Settings 407 Networking 410 Transparent Huge Pages (THP) 410 IPC Object Removal 411 SSH Connection Threshold 411 Synchronizing System Clocks 412 Option 1: Configure System Configuring Database Authorization 524 Access Permissions and Roles 524 Managing Object Privileges 525 About Object Access Privileges 525 About Password Encryption in Greenplum Database 526 Using SCRAM-SHA-256 Security Best Practices 545 System User (gpadmin) 546 Superusers 546 Login Users 546 Groups 546 Object Privileges 547 Operating System Users and File System 547 Managing Data 551 Defining Database

Resources Limits 179 XFS Mount Options 180 Disk I/O Settings 180 Transparent Huge Pages (THP) 182 IPC Object Removal 183 VMware Greenplum v6.17 Documentation VMware, Inc. 5 SSH Connection Threshold 183 Greenplum Database Best Practices 0 Best Practices Summary 248 Best Practices Summary 0 Data Model 248 Heap vs. Append-Optimized Storage 248 Row vs. Column Oriented Storage 248 Compression 249 Data Types 261 Use Types Consistently 261 Choose Data Types that Use the Least Space 261 Storage Model 261 Heap Storage or Append-Optimized Storage 262 Row or Column Orientation 262 Compression 263