Configuration Parameter Categories
Configuration parameters affect categories of server behaviors, such as resource consumption, query tuning, and authentication. The following topics describe Greenplum Database configuration parameter categories.
- Configuration Parameter Categories
- System Resource Consumption 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
- Workload Management Parameters
- External Table Parameters
- Database Table Parameters
- Database and Tablespace/Filespace Parameters
- Past PostgreSQL Version Compatibility Parameters
- Greenplum Array Configuration Parameters
- Greenplum Master and Segment Mirroring Parameters
- Greenplum Database Extension Parameters
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 and pg_statio family of system catalog views.
stats_queue_level track_activities |
track_counts update_process_title |
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 master postgresql.conf file and restart Greenplum Database:
- gp_autostats_mode
- gp_autostats_mode_in_functions
- log_autostats
- gp_autostats_on_change_threshold
Lock Management Parameters
- deadlock_timeout
- max_locks_per_transaction
Workload Management Parameters
The following configuration parameters configure the Greenplum Database workload management feature (resource queues), query prioritization, memory utilization and concurrency control.
gp_resqueue_priority gp_resqueue_priority_cpucores_per_ segment gp_resqueue_priority_sweeper_ interval gp_vmem_idle_resource_timeout gp_vmem_protect_limit gp_vmem_protect_segworker_cache_ limit |
max_resource_queues max_resource_portals_per_ transaction resource_cleanup_gangs_on_ wait resource_select_only runaway_detector_activation_percent stats_queue_level |
External Table Parameters
The following parameters configure the external tables feature of Greenplum Database.
See Accessing File-Based External Tables for more information about external tables.
gp_external_enable_exec gp_external_grant_privileges gp_external_max_segs |
gp_initial_bad_row_limit gp_reject_percent_threshold readable_external_table_timeout |
Database Table Parameters
The following parameter configures default option settings for Greenplum Database tables.
See Creating and Managing Tables for more information about Greenplum Database tables.
- gp_create_table_random_default_distribution
- gp_default_storage_options
Append-Optimized Table Parameters
The following parameters configure the append-optimized tables feature of Greenplum Database.
See Append-Optimized Storage for more information about append-optimized tables.
- gp_default_storage_options
- max_appendonly_tables
- gp_appendonly_compaction
- gp_appendonly_compaction_threshold
Database and Tablespace/Filespace Parameters
The following parameters configure the maximum number of databases, tablespaces, and filespaces allowed in a system.
- gp_max_tablespaces
- gp_max_filespaces
- gp_max_databases
Past PostgreSQL Version Compatibility Parameters
The following parameters provide compatibility with older PostgreSQL versions. You do not need to change these parameters in Greenplum Database.
add_missing_from array_nulls backslash_quote escape_string_warning |
regex_flavor standard_conforming_strings transform_null_equals |
Greenplum Master and Segment Mirroring Parameters
These parameters control the configuration of the replication between Greenplum Database primary master and standby master.
- keep_wal_segments
- repl_catchup_within_range
- replication_timeout
- wal_receiver_status_interval
This parameter controls validation between Greenplum Database primary segment and standby segment during incremental resynchronization.
- filerep_mirrorvalidation_during_resync
Greenplum Database Extension Parameters
The parameters in this topic control the configuration of Greenplum Database extensions.
- pgcrypto.fips
- pljava_classpath
- pljava_statement_cache_size
- pljava_release_lingering_savepoints
- pljava_vmoptions