Configuration Parameter Categories

Configuration Parameter Categories

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
Warning: Depending on the specific nature of your database operations, automatic statistics collection can have a negative performance impact. Carefully evaluate whether the default setting of on_no_stats is appropriate for your system.

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

writable_external_table_bufsize

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
  • gp_enable_exchange_default_partition

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