Specifying Table Distribution Columns 218 VMware Greenplum v6.19 Documentation VMware, Inc. 8 Resource Groups Features 219 PL/pgSQL Procedural Language Enhancements 219 Replicated Table Data 220 Concurrency Column Oriented Storage 324 Compression 325 Distributions 325 Resource Queue Memory Management 325 Partitioning 327 Indexes 327 Resource Queues 327 Monitoring and Maintenance 328 ANALYZE 328 Vacuum Settings 334 Number of Segments per Host 334 Resource Queue Segment Memory Configuration 334 Resource Queue Statement Memory Configuration 335 Resource Queue Spill File Configuration 336 Schema Design

Zstandard Compression Algorithm 210 Relaxed Rules for Specifying Table Distribution Columns 210 Resource Groups Features 211 PL/pgSQL Procedural Language Enhancements 211 Replicated Table Data 212 Concurrency Column Oriented Storage 315 Compression 316 Distributions 316 Resource Queue Memory Management 316 Partitioning 318 Indexes 318 Resource Queues 318 Monitoring and Maintenance 319 ANALYZE 319 Vacuum Settings 325 Number of Segments per Host 325 Resource Queue Segment Memory Configuration 325 Resource Queue Statement Memory Configuration 326 Resource Queue Spill File Configuration 327 Schema Design

Compression 249 Distributions 249 Resource Queue Memory Management 249 VMware Greenplum v6.17 Documentation VMware, Inc. 10 Partitioning 251 Indexes 251 Resource Queues 251 Monitoring and Maintenance Settings 258 Number of Segments per Host 258 Resource Queue Segment Memory Configuration 258 Resource Queue Statement Memory Configuration 260 Resource Queue Spill File Configuration 260 Schema Design Memory and Resource Management with Resource Groups 270 Memory and Resource Management with Resource Groups 0 Configuring Memory for Greenplum Database 271 Memory Considerations when using Resource Groups

Zstandard Compression Algorithm 215 Relaxed Rules for Specifying Table Distribution Columns 215 Resource Groups Features 216 PL/pgSQL Procedural Language Enhancements 216 Replicated Table Data 217 Concurrency Documentation VMware, Inc. 14 Compression 320 Distributions 320 Resource Queue Memory Management 320 Partitioning 322 Indexes 322 Resource Queues 323 Monitoring and Maintenance 323 ANALYZE 323 Vacuum Settings 329 Number of Segments per Host 329 Resource Queue Segment Memory Configuration 329 Resource Queue Statement Memory Configuration 330 Resource Queue Spill File Configuration 331 Schema Design

Zstandard Compression Algorithm 271 Relaxed Rules for Specifying Table Distribution Columns 271 Resource Groups Features 271 PL/pgSQL Procedural Language Enhancements 272 Replicated Table Data 272 VMware Mount Options 493 Disk I/O Settings 493 Synchronizing System Clocks 493 Configuring and Using Resource Groups 494 Enabling iptables (Optional) 494 How to Enable iptables 494 Example iptables Rules References 952 Using PL/Container 952 PL/Container Resource Management 952 Using Resource Groups to Manage PL/Container Resources 953 Configuring Resource Groups for PL/Container 954 Notes 955 PL/Container

Zstandard Compression Algorithm 257 Relaxed Rules for Specifying Table Distribution Columns 257 Resource Groups Features 258 PL/pgSQL Procedural Language Enhancements 258 Replicated Table Data 258 Concurrency Inc. 41 Using PL/Container 923 PL/Container Resource Management 923 Using Resource Groups to Manage PL/Container Resources 923 Configuring Resource Groups for PL/Container 924 Notes 926 PL/Container Configuration Calculations 1151 Managing Resources 1153 Using Resource Groups 1154 Understanding Role and Component Resource Groups 1155 Resource Group Attributes and Limits 1156 Memory Auditor 1156 Transaction

Zstandard Compression Algorithm 238 Relaxed Rules for Specifying Table Distribution Columns 239 Resource Groups Features 239 PL/pgSQL Procedural Language Enhancements 239 Replicated Table Data 240 Concurrency References 941 Using PL/Container 941 PL/Container Resource Management 942 Using Resource Groups to Manage PL/Container Resources 942 Configuring Resource Groups for PL/Container 943 Notes 944 PL/Container Managing Resources 1169 Using Resource Groups 1170 Understanding Role and Component Resource Groups 1171 VMware Greenplum 6 Documentation VMware, Inc 51 Resource Group Attributes and Limits 1172

Zstandard Compression Algorithm 231 Relaxed Rules for Specifying Table Distribution Columns 231 Resource Groups Features 232 PL/pgSQL Procedural Language Enhancements 232 Replicated Table Data 232 Concurrency References 912 Using PL/Container 912 PL/Container Resource Management 912 Using Resource Groups to Manage PL/Container Resources 912 Configuring Resource Groups for PL/Container 914 Notes 915 PL/Container Configuration Calculations 1132 Managing Resources 1133 Using Resource Groups 1134 Understanding Role and Component Resource Groups 1135 Resource Group Attributes and Limits 1136 Memory Auditor 1136 Transaction

Zstandard Compression Algorithm 228 Relaxed Rules for Specifying Table Distribution Columns 228 Resource Groups Features 229 PL/pgSQL Procedural Language Enhancements 229 Replicated Table Data 229 Concurrency References 910 Using PL/Container 910 PL/Container Resource Management 910 Using Resource Groups to Manage PL/Container Resources 911 Configuring Resource Groups for PL/Container 912 Notes 913 PL/Container Configuration Calculations 1127 Managing Resources 1128 Using Resource Groups 1129 Understanding Role and Component Resource Groups 1130 Resource Group Attributes and Limits 1131 Memory Auditor 1132 Transaction

Zstandard Compression Algorithm 207 Relaxed Rules for Specifying Table Distribution Columns 207 Resource Groups Features 207 PL/pgSQL Procedural Language Enhancements 208 Replicated Table Data 208 Concurrency PL/Container 795 PL/Container Resource Management 795 VMware Tanzu Greenplum 6 Documentation VMware, Inc 38 Using Resource Groups to Manage PL/Container Resources 795 Configuring Resource Groups for PL/Container Configuration Calculations 988 Managing Resources 989 Using Resource Groups 990 Understanding Role and Component Resource Groups 991 Resource Group Attributes and Limits 991 Memory Auditor 992 VMware