HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

Other Versions:

GUC Parameter List

GUC Parameter Index
acce_min_datasize_per_thread
advance_xlog_file_num
agent_backup_open
agent_check_interval
agent_connect_retries
agent_connect_timeout
agent_heartbeat_timeout
agent_kill_instance_timeout
agent_phony_dead_check_interval
agent_report_interval
alarm_component
alarm_report_interval
alarm_report_max_count
allocate_mem_cost
allow_concurrent_tuple_update
allow_system_table_mods
analysis_options
application_name
archive_command
archive_dest
archive_mode
archive_timeout
array_nulls
asp_flush_mode
asp_flush_rate
asp_log_filename
asp_retention_days
asp_sample_interval
asp_sample_num
audit_copy_exec
audit_data_format
audit_database_process
audit_directory
audit_dml_state
audit_dml_state_select
audit_enabled
audit_file_remain_threshold
audit_file_remain_time
audit_function_exec
audit_grant_revoke
audit_login_logout
audit_resource_policy
audit_rotation_interval
audit_rotation_size
audit_set_parameter
audit_space_limit
audit_system_object
audit_thread_num
audit_user_locked
audit_user_violation
audit_xid_info
auth_iteration_count
authentication_timeout
auto_explain_level
autoanalyze
autoanalyze_timeout
autovacuum
autovacuum_analyze_scale_factor
autovacuum_analyze_threshold
autovacuum_freeze_max_age
autovacuum_io_limits
autovacuum_max_workers
autovacuum_mode
autovacuum_naptime
autovacuum_vacuum_cost_delay
autovacuum_vacuum_cost_limit
autovacuum_vacuum_scale_factor
autovacuum_vacuum_threshold
available_zone
az_check_and_arbitrate_interval
az_connect_check_delay_time
az_connect_check_interval
az_switchover_threshold
backend_flush_after
backend_version
backslash_quote
backtrace_min_messages
backup_open
backwrite_quantity
basebackup_timeout
bbox_blanklist_items
bbox_dump_count
bbox_dump_path
behavior_compat_options
bgwriter_delay
bgwriter_flush_after
bgwriter_lru_maxpages
bgwriter_lru_multiplier
bgwriter_thread_num
block_encryption_mode
block_size
bulk_read_ring_size
bulk_write_ring_size
bytea_output
cache_connection
candidate_buf_percent_target
catchup2normal_wait_time
cgroup_name
check_function_bodies
check_implicit_conversions
checkpoint_completion_target
checkpoint_flush_after
checkpoint_segments
checkpoint_timeout
checkpoint_wait_timeout
checkpoint_warning
client_encoding
client_min_messages
cm_auth_method
cm_krb_server_keyfile
cm_server_arbitrate_delay_base_time_out
cm_server_arbitrate_delay_incrememtal_time_out
cmserver_demote_delay_on_etcd_fault
cmserver_ha_connect_timeout
cmserver_ha_heartbeat_timeout
cmserver_ha_status_interval
cmserver_self_vote_timeout
cn_send_buffer_size
codegen_cost_threshold
codegen_mot_limit
codegen_strategy
comm_proxy_attr
commit_delay
commit_siblings
config_file
connection_alarm_rate
connection_info
constraint_exclusion
convert_string_to_digit
cost_param
cost_weight_index
cpu_collect_timer
cpu_index_tuple_cost
cpu_operator_cost
cpu_tuple_cost
cross_cluster_replconninfoN
cstore_backwrite_max_threshold
cstore_backwrite_quantity
cstore_buffers
cstore_insert_mode
cstore_prefetch_quantity
current_schema
cursor_tuple_fraction
data_directory
data_replicate_buffer_size
data_sync_retry
datanode_heartbeat_interval
datastorage_threshold_check_interval
datastorage_threshold_value_check
DateStyle
db4ai_snapshot_mode
db4ai_snapshot_version_delimiter
db4ai_snapshot_version_separator
dcf_compress_algorithm
dcf_compress_level
dcf_config
dcf_connect_timeout
dcf_data_path
dcf_election_switch_threshold
dcf_election_timeout
dcf_enable_auto_election_priority
dcf_flow_control_cpu_threshold
dcf_flow_control_disk_rawait_threshold
dcf_flow_control_net_queue_message_num_threshold
dcf_log_backup_file_count
dcf_log_file_permission
dcf_log_level
dcf_log_path
dcf_log_path_permission
dcf_majority_groups
dcf_max_log_file_size
dcf_max_workers
dcf_mec_agent_thread_num
dcf_mec_batch_size
dcf_mec_channel_num
dcf_mec_fragment_size
dcf_mec_pool_max_size
dcf_mec_reactor_thread_num
dcf_mem_pool_init_size
dcf_mem_pool_max_size
dcf_node_id
dcf_rep_append_thread_num
dcf_run_mode
dcf_socket_timeout
dcf_ssl
dcf_stg_pool_init_size
dcf_stg_pool_max_size
dcf_truncate_threshold
ddb_election_timeout
ddb_log_backup_file_count
ddb_log_level
ddb_log_suppress_enable
ddb_max_log_file_size
ddb_type
deadlock_timeout
debug_assertions
debug_pretty_print
debug_print_parse
debug_print_plan
debug_print_rewritten
default_limit_rows
default_statistics_target
default_tablespace
default_text_search_config
default_transaction_deferrable
default_transaction_isolation
default_transaction_read_only
defer_csn_cleanup_time
delay_arbitrate_timeout
dilatation_shard_count_for_disk_capacity_alarm
dirty_page_percent_max
disable_memory_protect
disaster_recovery_type
dw_file_num
dw_file_size
dynamic_library_path
effective_cache_size
effective_io_concurrency
elastic_search_ip_addr
enable_absolute_tablespace
enable_access_server_directory
enable_adio_debug
enable_adio_function
enable_alarm
enable_analyze_check
enable_asp
enable_auto_clean_unique_sql
enable_auto_explain
enable_az_auto_switchover
enable_bbox_dump
enable_beta_features
enable_beta_opfusion
enable_bitmapscan
enable_bloom_filter
enable_cbm_tracking
enable_change_hjcost
enable_codegen
enable_codegen_mot
enable_codegen_mot_print
enable_codegen_print
enable_compress_spill
enable_consider_usecount
enable_constraint_optimization
enable_data_replicate
enable_dcf
enable_debug_vacuum
enable_default_ustore_table
enable_defer_calculate_snapshot
enable_double_write
enable_early_free
enable_extrapolation_stats
enable_fast_allocate
enable_fast_numeric
enable_ffic_log
enable_force_vector_engine
enable_functional_dependency
enable_global_plancache
enable_global_stats
enable_global_syscache
enable_hadoop_env
enable_hashagg
enable_hashjoin
enable_hdfs_predicate_pushdown
enable_hypo_index
enable_incremental_catchup
enable_incremental_checkpoint
enable_index_nestloop
enable_indexonlyscan
enable_indexscan
enable_instance_metric_persistent
enable_instr_cpu_timer
enable_instr_rt_percentile
enable_instr_track_wait
enable_kill_query
enable_logical_io_statistics
enable_log_compress
enable_material
enable_memory_context_contro
enable_memory_limit
enable_mergejoin
enable_mix_replication
enable_nestloop
enable_nodegroup_debug
enable_nonsysadmin_execute_direct
enable_online_ddl_waitlock
enable_opfusion
enable_orc_cache
enable_page_lsn_check
enable_partition_opfusion
enable_partitionwise
enable_pbe_optimization
enable_prevent_job_task_startup
enable_recyclebin
enable_resource_record
enable_resource_track
enable_save_datachanged_timestamp
enable_security_policy
enable_seqscan
enable_set_variables_b_format
enable_show_any_tuples
enable_slot_log
enable_sonic_hashagg
enable_sonic_hashjoin
enable_sonic_optspill
enable_sort
enable_ssl
enable_startwith_debug
enable_stmt_track
enable_stream_replication
enable_tde
enable_transaction_read_only
enable_thread_pool
enable_tidscan
enable_upgrade_merge_lock_mode
enable_user_metric_persisten
enable_valuepartition_pruning
enable_vector_engine
enable_wal_shipping_compression
enable_wdr_snapshot
enable_xc_maintenance_mode
enable_xlog_prune
enableSeparationOfDuty
enforce_a_behavior
escape_string_warning
event_source
exit_on_error
expected_computing_nodegroup
explain_dna_file
explain_perf_mode
external_pid_file
extra_float_digits
failed_login_attempts
fast_extend_file_size
fault_mon_timeout
FencedUDFMemoryLimit
force_bitmapand
force_pseudo_codegen_mot
force_promote
from_collapse_limit
fsync
full_page_writes
geqo
geqo_effort
geqo_generations
geqo_pool_size
geqo_seed
geqo_selection_bias
geqo_threshold
gin_fuzzy_search_limit
gin_pending_list_limit
global_syscache_threshold
gpc_clean_timeout
group_concat_max_len
gs_clean_timeout
ha_module_debug
hadr_max_size_for_xlog_receiver
hashagg_table_size
hba_file
hll_default_log2explicit
hll_default_log2m
hll_default_log2sparse
hll_duplicate_check
hot_standby
hot_standby_feedback
ident_file
idle_in_transaction_session_timeout
ignore_checksum_failure
ignore_system_indexes
incremental_build
incremental_checkpoint_timeout
inplace_upgrade_next_system_object_oids
install_type
instance_failover_delay_timeout
instance_heartbeat_timeout
instance_keep_heartbeat_timeout
instance_metric_retention_time
instance_phony_dead_restart_interval
instr_rt_percentile_interval
instr_unique_sql_count
instr_unique_sql_track_type
integer_datetimes
IntervalStyle
io_control_unit
io_limits
io_priority
isinplaceupgrade
is_sysadmin
job_queue_processes
join_collapse_limit
keep_sync_window
krb_caseins_users
krb_server_keyfile
krb_srvname
lastval_supported
lc_collate
lc_ctype
lc_messages
lc_monetary
lc_numeric
lc_time
listen_addresses
lo_compat_privileges
local_bind_address
local_preload_libraries
local_syscache_threshold
lockwait_timeout
log_autovacuum_min_duration
log_checkpoints
log_connections
log_destination
log_dir
log_directory
log_disconnections
log_duration
log_error_verbosity
log_executor_stats
log_file_mode
log_file_size
log_filename
log_hostname
log_line_prefix
log_lock_waits
log_max_count
log_max_size
log_min_duration_statement
log_min_error_statement
log_min_messages
log_pagewriter
log_parser_stats
log_pattern_%s
log_planner_stats
log_rotation_age
log_rotation_size
log_saved_days
log_statement
log_statement_stats
log_temp_files
log_threshold_check_interval
log_timezone
log_truncate_on_rotation
logging_collector
logging_module
maintenance_work_mem
max_active_global_temporary_table
max_cached_tuplebufs
max_changes_in_memory
max_cn_temp_file_size
max_compile_functions
max_concurrent_autonomous_transactions
max_connections
max_datastorage_threshold_check
max_files_per_process
max_function_args
max_identifier_length
max_index_keys
max_inner_tool_connections
max_io_capacity
max_loaded_cudesc
max_locks_per_transaction
max_logical_replication_workers
max_pred_locks_per_transaction
max_prepared_transactions
max_process_memory
max_query_retry_times
max_recursive_times
max_redo_log_size
max_replication_slots
max_size_for_xlog_prune
max_stack_depth
max_standby_archive_delay
max_standby_streaming_delay
max_sync_workers_per_subscription
max_undo_workers
max_user_defined_exception
max_wal_senders
memory_detail_tracking
memory_fault_percent
memory_tracking_mode
memorypool_enable
memorypool_size
minimum_pool_size
modify_initial_password
most_available_sync
mot_allow_index_on_nullable_column
mot_config_file
ngram_gram_size
ngram_grapsymbol_ignore
ngram_punctuation_ignore
nls_timestamp_format
num_internal_lock_partitions
numa_distribute_mode
omit_encoding_error
operation_mode
opfusion_debug_mode
pagewriter_sleep
pagewriter_thread_num
partition_iterator_elimination
partition_lock_upgrade_timeout
partition_page_estimation
password_effect_time
password_encryption_type
password_lock_time
password_max_length
password_min_digital
password_min_length
password_min_lowercase
password_min_special
password_min_uppercase
password_notify_time
password_policy
password_reuse_max
password_reuse_time
pca_shared_buffer
percentile
pgxc_node_name
phony_dead_effective_time
plan_cache_mode
plan_mode_seed
pldebugger_timeout
pljava_vmoptions
plog_merge_age
plpgsql.variable_conflict
plsql_show_all_error
pooler_maximum_idle_time
port
post_auth_delay
pre_auth_delay
prefetch_quantity
primary_slotname
process_cpu_affinity
psort_work_mem
qrw_inlist2join_optmode
query_band
query_dop
query_max_mem
query_mem
quote_all_identifiers
random_page_cost
recovery_max_workers
recovery_min_apply_delay
recovery_parallelism
recovery_parse_workers
recovery_redo_workers
recovery_time_target
recyclebin_retention_time
redo_bind_cpu_attr
remote_read_mode
remotetype
replconninfoN
replication_type
RepOriginId
require_ssl
reserve_space_for_nullable_atts
resource_track_cost
resource_track_duration
resource_track_level
resource_track_log
restart_after_crash
retry_ecode_list
rewrite_rule
schedule_splits_threshold
search_path
security_mode
segment_buffers
segment_size
seq_page_cost
server_encoding
server_version
server_version_num
session_authorization
session_history_memory
session_replication_role
session_respool
session_statistics_memory
session_timeout
shared_buffers
shared_preload_libraries
show_acce_estimate_detail
skew_option
sql_beta_feature
sql_compatibility
sql_ignore_strategy
sql_inheritance
sql_use_spacelimit
ssl
ssl_ca_file
ssl_cert_expire_alert_threshold
ssl_cert_expire_check_interval
ssl_cert_file
ssl_ciphers
ssl_crl_file
ssl_key_file
ssl_renegotiation_limit
standard_conforming_strings
standby_shared_buffers_fract
statement_timeout
stats_temp_directory
string_hash_compatible
support_batch_bind
support_extended_features
switch_rto
sync_config_strategy
synchronize_seqscans
synchronous_commit
synchronous_standby_names
sysadmin_reserved_connection
syslog_facility
syslog_ident
table_skewness_warning_rows
table_skewness_warning_threshold
tcp_keepalives_count
tcp_keepalives_idle
tcp_keepalives_interval
td_compatible_truncation
tde_cmk_id
temp_buffers
temp_file_limit
temp_tablespaces
thread_count
thread_pool_attr
TimeZone
timezone_abbreviations
topsql_retention_time
trace_notify
trace_recovery_messages
trace_sort
track_activities
track_activity_query_size
track_counts
track_functions
track_io_timing
track_sql_count
track_stmt_details_size
track_stmt_retention_time
track_stmt_session_slot
track_stmt_standby_chain_size
track_stmt_stat_level
track_thread_wait_status_interval
transaction_deferrable
transaction_isolation
transaction_pending_time
transaction_read_only
transform_null_equals
transparent_encrypt_kms_region
transparent_encrypt_kms_url
transparent_encrypted_string
try_vector_engine_strategy
udf_memory_limit
UDFWorkerMemHardLimit
uncontrolled_memory_context
undo_limit_size_per_transaction
undo_retention_time
undo_space_limit_size
undo_zone_count
unix_socket_directory
unix_socket_group
unix_socket_permissions
update_lockwait_timeout
upgrade_from
upgrade_mode
uppercase_attribute_name
use_elastic_search
use_workload_manager
user_metric_retention_time
ustore_attr
vacuum_cost_delay
vacuum_cost_limit
vacuum_cost_page_dirty
vacuum_cost_page_hit
vacuum_cost_page_miss
vacuum_defer_cleanup_age
vacuum_freeze_min_age
vacuum_freeze_table_age
vacuum_gtt_defer_check_age
var_eq_const_selectivity
version_retention_age
wait_dummy_time
wal_block_size
wal_buffers
wal_file_init_num
wal_flush_delay
wal_flush_timeout
wal_keep_segments
wal_level
wal_log_hints
wal_receiver_buffer_size
wal_receiver_connect_retries
wal_receiver_connect_timeout
wal_receiver_status_interval
wal_receiver_timeout
wal_segment_size
wal_sender_timeout
wal_sync_method
wal_writer_delay
walsender_max_send_size
walwriter_cpu_bind
walwriter_sleep_threshold
wdr_snapshot_interval
wdr_snapshot_query_timeout
wdr_snapshot_retention_days
work_mem
xc_maintenance_mode
xloginsert_locks
xmlbinary
xmloption
zero_damaged_pages
Copyright © 2011-2024 www.enmotech.com All rights reserved.