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 the Master and Standby Master Hosts 267 To create the data directory location on the master 267 Creating Data Storage Areas on Segment Hosts 267 To create the data directory locations on all segment Creating the Initialization Host File 271 To create the initialization host file 272 Creating the Greenplum Database Configuration File 272 To create a gpinitsystem_config file 272 Running the Initialization

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 Improvements in the Master and Standby Master Hosts 259 To create the data directory location on the master 259 Creating Data Storage Areas on Segment Hosts 259 To create the data directory locations on all segment Creating the Initialization Host File 263 To create the initialization host file 263 Creating the Greenplum Database Configuration File 264 To create a gpinitsystem_config file 264 Running the Initialization

the Master and Standby Master Hosts 192 To create the data directory location on the master 192 Creating Data Storage Areas on Segment Hosts 193 To create the data directory locations on all segment Initialization Host File 197 To create the initialization host file 197 Creating the Greenplum Database Configuration File 197 VMware Greenplum v6.17 Documentation VMware, Inc. 6 To create a gpinitsystem_config Enabling PostGIS Support 341 Installing the Greenplum PostGIS Extension Package 341 Using the CREATE EXTENSION Command 341 Enabling GDAL Raster Drivers 342 Enabling Out-of-Database Rasters 343 Removing

About Database Statistics in Greenplum Database 180 System Statistics 181 Table Size 181 The pg_statistic System Table and pg_stats View 181 Sampling 185 Updating Statistics 185 Analyzing Partitioned Coordinator and Standby Coordinator Hosts 214 To create the data directory location on the coordinator 214 Creating Data Storage Areas on Segment Hosts 214 To create the data directory locations on all segment Creating the Initialization Host File 218 To create the initialization host file 219 Creating the Greenplum Database Configuration File 219 To create a gpinitsystem_config file 219 Running the Initialization

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 Improvements in the Master and Standby Master Hosts 264 To create the data directory location on the master 264 Creating Data Storage Areas on Segment Hosts 264 To create the data directory locations on all segment Creating the Initialization Host File 268 To create the initialization host file 269 Creating the Greenplum Database Configuration File 269 To create a gpinitsystem_config file 269 Running the Initialization

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 Greenplum 6 Documentation About Database Statistics in Greenplum Database 329 System Statistics 330 Table Size 330 The pg_statistic System Table and pg_stats View 330 Sampling 334 Updating Statistics 334 Analyzing Partitioned the Master and Standby Master Hosts 422 To create the data directory location on the master 422 Creating Data Storage Areas on Segment Hosts 423 To create the data directory locations on all segment

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 Improvements in About Database Statistics in Greenplum Database 297 System Statistics 298 Table Size 298 The pg_statistic System Table and pg_stats View 298 Sampling 302 Updating Statistics 302 Analyzing Partitioned the Master and Standby Master Hosts 429 To create the data directory location on the master 429 Creating Data Storage Areas on Segment Hosts 429 To create the data directory locations on all segment

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 Improvements in About Database Statistics in Greenplum Database 286 System Statistics 287 Table Size 287 The pg_statistic System Table and pg_stats View 287 Sampling 291 Updating Statistics 291 Analyzing Partitioned the Master and Standby Master Hosts 414 To create the data directory location on the master 414 Creating Data Storage Areas on Segment Hosts 415 To create the data directory locations on all segment

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 Improvements in About Database Statistics in Greenplum Database 315 System Statistics 316 Table Size 316 The pg_statistic System Table and pg_stats View 316 Sampling 320 Updating Statistics 320 Analyzing Partitioned the Master and Standby Master Hosts 403 To create the data directory location on the master 404 Creating Data Storage Areas on Segment Hosts 404 To create the data directory locations on all segment

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 Improvements in About Database Statistics in Greenplum Database 283 System Statistics 283 Table Size 283 The pg_statistic System Table and pg_stats View 284 Sampling 287 Updating Statistics 287 Analyzing Partitioned the Master and Standby Master Hosts 412 To create the data directory location on the master 412 Creating Data Storage Areas on Segment Hosts 412 To create the data directory locations on all segment