基于PG内核数据库的常见系统参数

allow_system_table_mods off
application_name PostgreSQL JDBC Driver
archive_command /usr/pgsql/bin/rds_wal_archive_lz4 %p
archive_mode on
archive_timeout 5min
array_nulls on
authentication_timeout 1min
auto_create_tablespace_dir off
auto_explain.log_analyze off
auto_explain.log_buffers off
auto_explain.log_format text
auto_explain.log_min_duration 10s
auto_explain.log_nested_statements off
auto_explain.log_timing on
auto_explain.log_triggers off
auto_explain.log_verbose off
auto_explain.sample_rate 1
autovacuum on
autovacuum_analyze_scale_factor 0.05
autovacuum_analyze_threshold 50
autovacuum_freeze_max_age 200000000
autovacuum_max_workers 3
autovacuum_multixact_freeze_max_age 400000000
autovacuum_naptime 30s
autovacuum_vacuum_cost_delay 20ms
autovacuum_vacuum_cost_limit -1
autovacuum_vacuum_scale_factor 0.1
autovacuum_vacuum_threshold 50
autovacuum_work_mem -1
backend_flush_after 0
backslash_quote safe_encoding
bgwriter_delay 200ms
bgwriter_flush_after 512kB
bgwriter_lru_maxpages 100
bgwriter_lru_multiplier 2
block_size 8192
bonjour off
bonjour_name
bytea_output escape
check_function_bodies on
checkpoint_completion_target 0.9
checkpoint_flush_after 0
checkpoint_timeout 5min
checkpoint_warning 30s
client_encoding UTF8
client_min_messages notice
cluster_name
commit_delay 0
commit_siblings 5
constraint_exclusion partition
convert_string_to_digit on
cpu_index_tuple_cost 0.005
cpu_operator_cost 0.0025
cpu_tuple_cost 0.01
cursor_tuple_fraction 0.1
cut_coredump on
data_checksums off
data_directory_mode 0700
DateStyle ISO, YMD
db_user_namespace off
deadlock_timeout 1s
debug_assertions off
debug_pretty_print on
debug_print_parse off
debug_print_plan off
debug_print_rewritten off
default_statistics_target 100
default_tablespace
default_text_search_config pg_catalog.english
default_transaction_deferrable off
default_transaction_isolation read committed
default_transaction_read_only off
default_with_oids off
dynamic_shared_memory_type sysv
effective_cache_size 4GB
effective_io_concurrency 1
empty_is_null on
enable_bitmapscan on
enable_gathermerge on
enable_hashagg on
enable_hashjoin on
enable_indexonlyscan on
enable_indexscan on
enable_material on
enable_mergejoin on
enable_nestloop on
enable_parallel_append on
enable_parallel_hash on
enable_partition_pruning on
enable_partitionwise_aggregate off
enable_partitionwise_join off
enable_seqscan on
enable_sort on
enable_tidscan on
escape_string_warning on
event_source PostgreSQL
exit_on_error off
extra_float_digits 3
force_parallel_mode off
from_collapse_limit 8
fsync on
full_page_writes on
geqo on
geqo_effort 5
geqo_generations 0
geqo_pool_size 0
geqo_seed 0
geqo_selection_bias 2
geqo_threshold 12
gin_fuzzy_search_limit 0
gin_pending_list_limit 4MB
hot_standby on
hot_standby_feedback off
huge_pages try
idle_in_transaction_session_timeout 1h
ignore_checksum_failure off
ignore_system_indexes off
implicit_ignore_undigit_err on
integer_datetimes on
IntervalStyle postgres
jit on
jit_above_cost 100000
jit_debugging_support off
jit_dump_bitcode off
jit_expressions on
jit_inline_above_cost 500000
jit_optimize_above_cost 500000
jit_profiling_support off
jit_tuple_deforming on
join_collapse_limit 8
krb_caseins_users off
kw_limit_offset_ignore on
lc_collate en_US.UTF-8
lc_ctype en_US.UTF-8
lc_messages C
lc_monetary C
lc_numeric C
lc_time C
listen_addresses *
lo_compat_privileges off
local_preload_libraries
lock_timeout 0
log_autovacuum_min_duration -1
log_checkpoints on
log_connections off
log_destination stderr
log_disconnections off
log_duration off
log_error_verbosity default
log_executor_stats off
log_file_mode 0600
log_hostname off
log_line_prefix %m:%r:%u@%d:[%p]:
log_lock_waits off
log_min_duration_statement 1s
log_min_error_statement error
log_min_messages warning
log_parser_stats off
log_planner_stats off
log_replication_commands off
log_rotation_age 1h
log_rotation_size 10MB
log_statement none
log_statement_stats off
log_temp_files -1
log_timezone Etc/GMT-8
log_truncate_on_rotation off
logging_collector on
maintenance_work_mem 137518kB
max_connections 1200
max_files_per_process 1000
max_function_args 100
max_identifier_length 63
max_index_keys 32
max_locks_per_transaction 64
max_logical_replication_workers 4
max_parallel_maintenance_workers 0
max_parallel_workers 8
max_parallel_workers_per_gather 0
max_parallel_write_conn_rate 1
max_pred_locks_per_page 2
max_pred_locks_per_relation -2
max_pred_locks_per_transaction 64
max_prepared_transactions 0
max_replication_slots 5
max_stack_depth 6MB
max_standby_archive_delay 30s
max_standby_streaming_delay 30s
max_sync_workers_per_subscription 2
max_wal_senders 16
max_wal_size 128GB
max_worker_processes 8
min_parallel_index_scan_size 512kB
min_parallel_table_scan_size 8MB
min_wal_size 10GB
most_available_sync off
NLS_COMP BINARY
NLS_CURRENCY $
NLS_DATE_FORMAT yyyy-mm-dd
NLS_DATE_LANGUAGE american
NLS_DUAL_CURRENCY $
NLS_ISO_CURRENCY america
NLS_LANGUAGE american
NLS_LENGTH_SEMANTICS char
NLS_NUMERIC_CHARACTERS .,
NLS_SORT BINARY
NLS_TERRITORY america
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_FORMAT yyyy-mm-dd hh24:mi:ss
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SS.FF AM TZR
old_snapshot_threshold -1
operator_precedence_warning off
ora_double_chars_len off
ora_migrator off
parallel_leader_participation on
parallel_setup_cost 1000
parallel_tuple_cost 0.1
password_encryption md5
pg_benchmark_unlog off
pg_pathman.enable on
pg_pathman.enable_auto_partition on
pg_pathman.enable_bounds_cache on
pg_pathman.enable_partitionfilter on
pg_pathman.enable_partitionrouter off
pg_pathman.enable_runtimeappend on
pg_pathman.enable_runtimemergeappend on
pg_pathman.insert_into_fdw postgres
pg_pathman.override_copy on
pg_stat_statements.max 5000
pg_stat_statements.save on
pg_stat_statements.track top
pg_stat_statements.track_utility on
port 5432
post_auth_delay 0
pre_auth_delay 0
quote_all_identifiers off
random_page_cost 4
restart_after_crash on
row_security on
search_path "$user", public
segment_size 1GB
seq_page_cost 1
server_encoding UTF8
server_version 11.5
server_version_num 110005
session_replication_role origin
shared_buffers 2034496kB
sql_format oracle
ssl on
ssl_ca_file
ssl_cert_file /CA/server.pem
ssl_crl_file
ssl_key_file /CA/server.key
ssl_passphrase_command
ssl_passphrase_command_supports_reload off
ssl_prefer_server_ciphers on
standard_conforming_strings on
statement_timeout 0
superuser_reserved_connections 3
switch_sync_allow_flush_lag 0
synchronize_seqscans on
synchronous_commit on
synchronous_standby_names dbnode2
syslog_facility local0
syslog_ident postgres
syslog_sequence_numbers on
syslog_split_messages on
tcp_keepalives_count 2
tcp_keepalives_idle 300
tcp_keepalives_interval 30
temp_buffers 161920kB
temp_file_limit 20000000kB
temp_tablespaces
time_zone Asia/Shanghai
timescaledb.disable_load off
timescaledb.max_background_workers 8
TimeZone Asia/Shanghai
timezone_abbreviations Default
trace_notify off
trace_recovery_messages log
trace_sort off
track_activities on
track_activity_query_size 1kB
track_commit_timestamp off
track_counts on
track_functions none
track_io_timing off
transaction_deferrable off
transaction_isolation read committed
transaction_read_only off
transform_null_equals off
union_null on
unix_socket_group Ruby
unix_socket_permissions 0700
update_process_title on
vacuum_cleanup_index_scale_factor 0.1
vacuum_cost_delay 0
vacuum_cost_limit 200
vacuum_cost_page_dirty 20
vacuum_cost_page_hit 1
vacuum_cost_page_miss 10
vacuum_defer_cleanup_age 0
vacuum_freeze_min_age 50000000
vacuum_freeze_table_age 150000000
vacuum_multixact_freeze_min_age 5000000
vacuum_multixact_freeze_table_age 150000000
wal_block_size 8192
wal_buffers 16MB
wal_compression off
wal_consistency_checking
wal_keep_segments 256
wal_level replica
wal_log_hints off
wal_receiver_status_interval 10s
wal_receiver_timeout 30s
wal_retrieve_retry_interval 5s
wal_segment_size 16MB
wal_sender_timeout 30s
wal_speedup_disk_size 0
wal_sync_method fdatasync
wal_writer_delay 200ms
wal_writer_flush_after 1MB
work_mem 1024096kB
xmlbinary base64
xmloption content
zero_damaged_pages off