GUC参数列表

GUC参数索引	引入版本
acce_min_datasize_per_thread
acceleration_with_compute_pool
adaptive_hashagg_allow_spill
adaptive_hashagg_min_rows
adaptive_hashagg_reduce_ratio_threshold
advance_xlog_file_num
alarm_component
alarm_report_interval
allocate_mem_cost
allow_concurrent_tuple_update
allow_create_sysobject
allow_system_table_mods
analysis_options
application_name
archive_command
archive_dest
archive_interval
archive_mode
archive_timeout
array_nulls
asp_flush_mode
asp_flush_rate
asp_log_directory
asp_log_filename
asp_retention_days
asp_sample_interval
asp_sample_num
async_submit
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_function_exec
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
autocmpr_cost_delay
autocmpr_cost_limit
autocmpr_max_workers
autocmpr_naptime
autocompress
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_insert_scale_factor	5.0.9 - 纯insert表支持autovacuum
autovacuum_vacuum_insert_threshold	5.0.9 - 纯insert表支持autovacuum
autovacuum_vacuum_scale_factor
autovacuum_vacuum_threshold
available_zone
b_compatibility_user_host_auth
b_format_behavior_compat_options
backend_flush_after
backslash_quote
backtrace_min_messages
backwrite_quantity
basebackup_timeout
bbox_blanklist_items
bbox_dump_count
bbox_dump_path
behavior_compat_options
best_agg_plan
bgwriter_delay
bgwriter_flush_after
bgwriter_lru_maxpages
bgwriter_lru_multiplier
block_encryption_mode
block_size
bulk_read_ring_size
bulk_write_ring_size
bypass_dram
bypass_nvm
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_target_time	5.0.8 - 极致刷脏
checkpoint_timeout
checkpoint_wait_timeout
checkpoint_warning
client_encoding
client_min_messages
cluster_run_mode
cn_send_buffer_size
codegen_cost_threshold
codegen_strategy
comm_proxy_attr
commit_delay
commit_siblings
compress_cost_delay
compress_cost_limit
compress_cost_page_dirty
compress_cost_page_hit
compress_cost_page_miss
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_logic_cluster
current_schema
cursor_tuple_fraction
damage_page_ignore	5.0.6 - 文件损坏处理
data_directory
data_replicate_buffer_size
data_sync_failed_ignore	5.0.6 - 文件损坏处理
data_sync_retry
datanode_heartbeat_interval
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
deadlock_timeout
debug_assertions
debug_pretty_print
debug_print_parse
debug_print_plan
debug_print_rewritten
debug_select_o	5.0.8
default_limit_rows
default_statistics_target
default_tablespace
default_text_search_config
default_transaction_deferrable
default_transaction_isolation
default_transaction_read_only
default_with_oids
defer_csn_cleanup_time
delimiter_name
dfs_partition_directory_length
dirty_page_percent_max
disable_memory_protect
dolphin_server_port
dw_file_num
dw_file_size
dynamic_library_path
effective_cache_size
effective_io_concurrency
elastic_search_ip_addr
emit_illegal_bind_chars	5.0.2 - 写入不合法字符报错
enable_absolute_tablespace
enable_accept_empty_str	5.0.6
enable_access_server_directory
enable_adaptive_hashagg
enable_adio_debug
enable_adio_function
enable_ai_stats
enable_alarm
enable_analyze_check
enable_asp
enable_auto_clean_unique_sql
enable_auto_explain
enable_availablezone
enable_backend_compress
enable_batch_dispatch	5.0.2 - 日志回放性能增强
enable_bbox_dump
enable_beta_features
enable_beta_opfusion
enable_bitmapscan
enable_bloom_filter
enable_broadcast
enable_cachedplan_mgr
enable_cache_function_result	5.0.9 - 支持语句级Function Cache
enable_cbm_tracking
enable_change_hjcost
enable_codegen
enable_codegen_print
enable_compress_hll
enable_compress_spill
enable_compression_check
enable_consider_usecount
enable_constraint_optimization
enable_copy_server_files
enable_csqual_pushdown
enable_custom_parser
enable_data_replicate
enable_date_operator_sub_oracle	5.0.0 - 支持两个date类型的数据相减返回numeric类型
enable_dcf
enable_debug_vacuum
enable_default_cfunc_libpath
enable_default_compression_table
enable_default_index_compression
enable_default_ustore_table
enable_defer_calculate_snapshot
enable_delta_store
enable_ddl_logical_record	5.0.8 - 逻辑复制支持DDL操作
enable_dolphin_proto
enable_double_write
enable_early_free
enable_event_trigger_a_mode	5.0.1
enable_expr_fusion
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_gtt_concurrent_truncate
enable_hadoop_env
enable_hashagg
enable_hashjoin
enable_hdfs_predicate_pushdown
enable_heap_async_prefetch	5.0.8 - 顺序扫描预读
enable_hypo_index
enable_incremental_catchup
enable_incremental_checkpoint
enable_incremental_sort	3.1.0 - 排序算子优化
enable_index_nestloop
enable_indexonlyscan
enable_indexscan
enable_indexscan_optimization
enable_inner_unique_opt
enable_instance_metric_persistent
enable_instr_cpu_timer
enable_instr_rt_percentile
enable_instr_track_wait
enable_ios	5.0.8 - 顺序扫描预读
enable_kill_query
enable_logical_io_statistics
enable_material
enable_memory_context_contro
enable_memory_limit
enable_mergejoin
enable_mergeinto_subqueryalias	5.0.8
enable_mix_replication
enable_multitable_update	5.0.8
enable_nestloop
enable_nonsysadmin_execute_direct
enable_nvm
enable_online_ddl_waitlock
enable_opfusion
enable_orc_cache
enable_page_compression
enable_page_lsn_check
enable_partition_opfusion
enable_partitionwise
enable_pbe_optimization
enable_prevent_job_task_startup
enable_recyclebin
enable_remote_excute
enable_resource_record
enable_resource_track
enable_save_confirmed_lsn
enable_save_datachanged_timestamp
enable_security_policy
enable_segment	5.0.6
enable_seqscan
enable_seqscan_fusion
enable_set_variables_b_format
enable_show_any_tuples
enable_slot_log
enable_slow_query_log
enable_sonic_hashagg
enable_sonic_hashjoin
enable_sonic_optspill
enable_sort
enable_sse42
enable_startwith_debug
enable_stmt_track
enable_stream_replication
enable_tde
enable_thread_pool
enable_tidrangescan	5.0.6
enable_tidscan
enable_time_report	5.0.2 - 日志回放性能增强
enable_uheap_async_prefetch	5.0.8 - 顺序扫描预读
enable_upgrade_merge_lock_mode
enable_user_metric_persisten
enable_ustore
enable_valuepartition_pruning
enable_vector_engine
enable_wal_shipping_compression
enable_walrcv_reply_dueto_commit	5.0.2
enable_wdr_snapshot
enable_xlog_prune
enableSeparationOfDuty
enforce_a_behavior
escape_string_warning
event_source
exit_on_error
explain_dna_file
explain_perf_mode
external_pid_file
extra_float_digits
extreme_flush_dirty_page	5.0.8 - 极致刷脏
failed_login_attempts
fast_extend_file_size
fault_mon_timeout
FencedUDFMemoryLimit
force_bitmapand
force_promote
force_tidrangescan	5.0.6
from_collapse_limit
fsync
full_audit_users
full_page_writes
function_result_cache_max_mem	5.0.9 - 支持语句级Function Cache
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
hadr_recovery_point_target
hadr_recovery_time_target
hadr_super_user_record_path
handle_toast_in_autovac	5.0.6
hash_agg_total_cost_ratio	5.0.2
hash_join_total_cost_ratio	5.0.2
hashagg_table_size
hba_file
hll_default_expthresh
hll_default_log2explicit
hll_default_log2m
hll_default_log2sparse
hll_default_regwidth
hll_default_sparseon
hll_duplicate_check
hll_max_sparse
hot_standby
hot_standby_feedback
ident_file
idle_in_transaction_session_timeout
ifnull_all_return_text	5.0.3
ignore_checksum_failure
ignore_system_indexes
incremental_checkpoint_timeout
instance_metric_retention_time
instr_rt_percentile_interval
instr_unique_sql_count
instr_unique_sql_track_type
integer_datetimes
IntervalStyle
io_control_unit
io_limits
io_priority
ios_batch_read_size	5.0.8 - 顺序扫描预读
ios_status_update_gap	5.0.8 - 顺序扫描预读
ios_worker_num	5.0.8 - 顺序扫描预读
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
light_comm
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_directory
log_disconnections
log_duration
log_error_verbosity
log_executor_stats
log_file_mode
log_filename
log_hostname
log_line_prefix
log_lock_waits
log_min_duration_statement
log_min_error_statement
log_min_messages
log_pagewriter
log_parser_stats
log_planner_stats
log_rotation_age
log_rotation_size
log_statement
log_statement_stats
log_temp_files
log_timezone
log_truncate_on_rotation
logging_collector
logging_module
logical_decode_options_default
logical_sender_timeout
maintenance_work_mem
max_active_global_temporary_table
max_cached_tuplebufs
max_changes_in_memory
max_compile_functions
max_concurrent_autonomous_transactions
max_connections
max_error_count
max_files_per_process
max_function_args
max_identifier_length
max_index_keys
max_inner_tool_connections
max_io_capacity
max_keep_log_seg
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_requests_per_worker	5.0.8 - 顺序扫描预读
max_resource_package
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_trace_level
memory_tracking_mode
memorypool_enable
memorypool_size
merge_join_total_cost_ratio	5.0.2
min_table_block_num_enable_ios	5.0.8 - 顺序扫描预读
min_uheap_table_block_num_enable_ios	5.0.8 - 顺序扫描预读
modify_initial_password
most_available_sync
multi_stats_type
nestloop_total_cost_ratio	5.0.2
ngram_gram_size
ngram_grapsymbol_ignore
ngram_punctuation_ignore
nls_timestamp_format
no_audit_client
num_internal_lock_partitions
numa_distribute_mode
nvm_buffers
nvm_file_path
omit_encoding_error
operation_mode
opfusion_debug_mode
ora_dblink_col_case_sensitive
pagewriter_sleep
pagewriter_thread_num
parallel_recovery_batch	5.0.2 - 日志回放性能增强
parallel_recovery_dispatch_algorithm	5.0.2 - 日志回放性能增强
parallel_recovery_timeout	5.0.2 - 日志回放性能增强
parallel_scan_gap	5.0.8 - 顺序扫描预读
partition_lock_upgrade_timeout
partition_max_cache_size
partition_mem_batch
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
perf_directory
pgxc_node_name
plan_cache_mode
plan_cache_type_validation	5.0.2
plan_mode_seed
pldebugger_timeout
pljava_vmoptions
plog_merge_age
plsql_compile_check_options
plsql_show_all_error
port
post_auth_delay
pre_auth_delay
prefetch_protect_time	5.0.8 - 顺序扫描预读
prefetch_quantity
primary_slotname
proc_inparam_immutable	5.0.0 - 支持包内常量作为函数或者过程入参的默认值
protect_standby	5.0.6
psort_work_mem
qrw_inlist2join_optmode
query_band
query_dop
query_log_directory
query_log_file
query_max_mem
query_mem
quote_all_identifiers
raise_errors_if_no_files
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
repl_auth_mode
repl_uuid
replconninfoN
replication_type
RepOriginId
require_ssl
reserve_space_for_nullable_atts
resilience_memory_reject_percent
resilience_threadpool_reject_cond
resource_track_cost
resource_track_duration
resource_track_level
resource_track_log
restart_after_crash
retry_ecode_list
rewrite_rule
safe_data_path
schedule_splits_threshold
search_path
segment_buffers
segment_size
seq_page_cost
server_encoding
server_version
server_version_num
session_history_memory
session_replication_role
session_respool
session_statistics_memory
session_timeout
shared_buffers
shared_preload_libraries
show_acce_estimate_detail
show_fdw_remote_plan
skew_option
smp_thread_cost
sort_agg_total_cost_ratio	5.0.2
sort_key_pruning_level	5.0.6
sql_beta_feature
sql_compatibility
sql_ignore_strategy
sql_inheritance
sql_note
sql_use_spacelimit
ss_dss_conn_path
ss_dss_vg_name
ss_enable_aio
ss_enable_catalog_centralized
ss_enable_dms
ss_enable_dss
ss_enable_scrlock
ss_enable_scrlock_sleep_mode
ss_enable_ssl
ss_instance_id
ss_interconnect_channel_count
ss_interconnect_type
ss_interconnect_url
ss_log_backup_file_count
ss_log_level
ss_log_max_file_size
ss_ock_log_path
ss_rdma_work_config
ss_recv_msg_pool_size
ss_scrlock_server_bind_core
ss_scrlock_server_port
ss_scrlock_worker_bind_core
ss_scrlock_worker_count
ss_work_thread_count
ssl
ssl_ca_file
ssl_cert_file
ssl_cert_notify_time
ssl_ciphers
ssl_crl_file
ssl_key_file
ssl_renegotiation_limit
standard_conforming_strings
standby_shared_buffers_fraction
statement_timeout
stats_temp_directory
string_hash_compatible
support_batch_bind
support_extended_features
sync_config_strategy
synchronize_seqscans
synchronous_commit
synchronous_standby_names
sysadmin_reserved_connections
syslog_facility
syslog_ident
table_skewness_warning_rows
table_skewness_warning_threshold
tcp_keepalives_count
tcp_keepalives_idle
tcp_keepalives_interval
tcp_user_timeout
td_compatible_truncation
tde_cmk_id
temp_buffers
temp_file_limit
temp_tablespaces
thread_pool_attr
thread_pool_committer_max_retry_count
thread_pool_committerctl_max_retry_count
thread_pool_stream_attr
thread_pool_worker_num_per_committer
time_to_target_rpo
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_parameter
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
unique_sql_retention_time
unix_socket_directory
unix_socket_group
unix_socket_permissions
update_lockwait_timeout
update_process_title
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
view_independent	5.0.1
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
xlog_file_path
xlog_file_size
xlog_lock_file_path
xloginsert_locks
xmlbinary
xmloption
zero_damaged_pages