Parameter Categories
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.
Parameter Categories
Configuration parameters affect categories of server behaviors, such as resource consumption, query tuning, and authentication. The following topics describe Greenplum configuration parameter categories.
- Connection and Authentication Parameters
- System Resource Consumption Parameters
- GPORCA Parameters
- Query Tuning Parameters
- Error Reporting and Logging Parameters
- System Monitoring Parameters
- Runtime Statistics Collection Parameters
- Automatic Statistics Collection Parameters
- Client Connection Default Parameters
- Lock Management Parameters
- Resource Management Parameters (Resource Queues)
- Resource Management Parameters (Resource Groups)
- External Table Parameters
- Database Table Parameters
- Database and Tablespace/Filespace Parameters
- Past Version Compatibility Parameters
- Greenplum Database Array Configuration Parameters
- Greenplum Mirroring Parameters for Master and Segments
- Greenplum Database Extension Parameters
Connection and Authentication Parameters
These parameters control how clients connect and authenticate to Greenplum Database.
Connection Parameters
Security and Authentication Parameters
System Resource Consumption Parameters
Memory Consumption Parameters
These parameters control system memory usage.
gp_resource_group_memory_limit (resource group-based resource management) gp_vmem_protect_limit (resource queue-based resource management) |
Free Space Map Parameters
These parameters control the sizing of the free space map, which contains expired rows. Use VACUUM to reclaim the free space map disk space.
OS Resource Parameters
Cost-Based Vacuum Delay Parameters
You can configure the execution cost of VACUUM and ANALYZE commands to reduce the I/O impact on concurrent database activity. When the accumulated cost of I/O operations reaches the limit, the process performing the operation sleeps for a while, Then resets the counter and continues execution
Transaction ID Management Parameters
GPORCA Parameters
These parameters control the usage of GPORCA by Greenplum Database. For information about GPORCA, see About GPORCA.
Query Tuning Parameters
Legacy Query Optimizer Operator Control Parameters
The following parameters control the types of plan operations the legacy query optimizer can use. Enable or disable plan operations to force the legacy optimizer to choose a different plan. This is useful for testing and comparing query performance using different plan types.
gp_enable_agg_distinct_pruning gp_enable_groupext_distinct_gather gp_enable_groupext_distinct_pruning gp_enable_predicate_propagation |
Legacy Query Optimizer Costing Parameters
Database Statistics Sampling Parameters
These parameters adjust the amount of data sampled by an ANALYZE operation. Adjusting these parameters affects statistics collection system-wide. You can configure statistics collection on particular tables and columns by using the ALTER TABLESET STATISTICS clause.
Sort Operator Configuration Parameters
Aggregate Operator Configuration Parameters
Join Operator Configuration Parameters
Other Legacy Query Optimizer Configuration Parameters
Query Plan Execution
Control the query plan execution.
Error Reporting and Logging Parameters
Log Rotation
When to Log
What to Log
System Monitoring Parameters
SNMP Alerts
The following parameters send SNMP notifications when events occur.
Email Alerts
The following parameters configure the system to send email alerts for fatal error events, such as a segment going down or a server crash and reset.
Greenplum Command Center Agent
The following parameters configure the data collection agents that populate the gpperfmon database for Greenplum Command Center.
Runtime Statistics Collection Parameters
These parameters control the server statistics collection feature. When statistics collection is enabled, you can access the statistics data using the pg_stat family of system catalog views.
Automatic Statistics Collection Parameters
When automatic statistics collection is enabled, you can run ANALYZE automatically in the same transaction as an INSERT, UPDATE, DELETE, COPY or CREATE TABLE...AS SELECT statement when a certain threshold of rows is affected (on_change), or when a newly generated table has no statistics (on_no_stats). To enable this feature, set the following server configuration parameters in your Greenplum Database master postgresql.conf file and restart Greenplum Database:
gp_autostats_mode_in_functions |
Client Connection Default Parameters
Statement Behavior Parameters
Locale and Formatting Parameters
Other Client Default Parameters
Lock Management Parameters
Resource Management Parameters (Resource Queues)
The following configuration parameters configure the Greenplum Database resource management feature (resource queues), query prioritization, memory utilization and concurrency control.
gp_resqueue_priority_cpucores_per_segment gp_resqueue_priority_sweeper_interval |
max_resource_portals_per_transaction resource_cleanup_gangs_on_wait |
Resource Management Parameters (Resource Groups)
The following parameters configure the Greenplum Database resource group workload management feature.
gp_resource_group_bypass |
External Table Parameters
The following parameters configure the external tables feature of Greenplum Database.
readable_external_table_timeout |
Database Table Parameters
The following parameter configures default option settings for Greenplum Database tables.
gp_create_table_random_default_distribution |
Append-Optimized Table Parameters
The following parameters configure the append-optimized tables feature of Greenplum Database.
Database and Tablespace/Filespace Parameters
The following parameters configure the maximum number of databases, tablespaces, and filespaces allowed in a system.
Past Version Compatibility Parameters
The following parameters provide compatibility with older PostgreSQL and Greenplum Database versions. You do not need to change these parameters in Greenplum Database.
PostgreSQL
Greenplum Database
Greenplum Database Array Configuration Parameters
The parameters in this topic control the configuration of the Greenplum Database array and its components: segments, master, distributed transaction manager, master mirror, and interconnect.
Interconnect Configuration Parameters
Dispatch Configuration Parameters
Fault Operation Parameters
Distributed Transaction Management Parameters
Greenplum Mirroring Parameters for Master and Segments
These parameters control the configuration of the replication between Greenplum Database primary master and standby master.
This parameter controls validation between Greenplum Database primary segment and standby segment during incremental resynchronization.
Greenplum Database Extension Parameters
The parameters in this topic control the configuration of Greenplum Database extensions.