83 lines
2.8 KiB
YAML
83 lines
2.8 KiB
YAML
#loop_wait: 10
|
|
#master_start_timeout: 300
|
|
#maximum_lag_on_failover: 1048576
|
|
postgresql:
|
|
parameters:
|
|
# archive_command: pgbackrest --stanza=sandbox-postgres-cluster archive-push
|
|
# %p || cd .
|
|
# archive_mode: true
|
|
# archive_timeout: 1800s
|
|
# auto_explain.log_analyze: true
|
|
# auto_explain.log_buffers: true
|
|
# auto_explain.log_min_duration: 10s
|
|
# auto_explain.log_nested_statements: true
|
|
# auto_explain.log_timing: false
|
|
# auto_explain.log_triggers: true
|
|
# auto_explain.log_verbose: true
|
|
# autovacuum: true
|
|
# autovacuum_analyze_scale_factor: 0.02
|
|
# autovacuum_max_workers: 8
|
|
# autovacuum_naptime: 1s
|
|
# autovacuum_vacuum_cost_delay: 20
|
|
# autovacuum_vacuum_cost_limit: 200
|
|
# autovacuum_vacuum_scale_factor: 0.01
|
|
# checkpoint_completion_target: 0.9
|
|
# checkpoint_timeout: 15min
|
|
# default_statistics_target: 100
|
|
# effective_cache_size: 12GB
|
|
# effective_io_concurrency: 200
|
|
# hot_standby: true
|
|
# huge_pages: try
|
|
# log_checkpoints: true
|
|
# log_directory: /var/log/postgresql
|
|
# log_filename: postgresql-%a.log
|
|
# log_line_prefix: '%t [%p-%l] %r %q%u@%d '
|
|
# log_lock_waits: true
|
|
# log_rotation_age: 1d
|
|
# log_rotation_size: 0
|
|
# log_temp_files: 0
|
|
# log_timezone: Europe/Moscow
|
|
# log_truncate_on_rotation: true
|
|
# logging_collector: true
|
|
# maintenance_work_mem: 1GB
|
|
max_connections: 100
|
|
# max_files_per_process: 4096
|
|
# max_locks_per_transaction: 64
|
|
# max_parallel_maintenance_workers: 4
|
|
# max_parallel_workers: 8
|
|
# max_parallel_workers_per_gather: 4
|
|
# max_prepared_transactions: 0
|
|
# max_replication_slots: 10
|
|
# max_wal_senders: 10
|
|
# max_wal_size: 8GB
|
|
# max_worker_processes: 8
|
|
# min_wal_size: 2GB
|
|
# pg_stat_statements.max: 10000
|
|
# pg_stat_statements.save: false
|
|
# pg_stat_statements.track: all
|
|
# random_page_cost: 1.1
|
|
# seq_page_cost: 1
|
|
# shared_buffers: 4GB
|
|
# shared_preload_libraries: pg_stat_statements,auto_explain,pg_cron,pg_partman_bgw,redis_fdw
|
|
# superuser_reserved_connections: 5
|
|
# synchronous_commit: true
|
|
# timezone: Europe/Moscow
|
|
# track_activities: true
|
|
# track_counts: true
|
|
# track_functions: all
|
|
# track_io_timing: true
|
|
# wal_buffers: 16MB
|
|
# wal_keep_segments: 1000
|
|
# wal_level: replica
|
|
# wal_log_hints: true
|
|
# work_mem: 10485kB
|
|
# recovery_conf:
|
|
# restore_command: pgbackrest --stanza=sandbox-postgres-cluster archive-get
|
|
# %f %p
|
|
# use_pg_rewind: true
|
|
#retry_timeout: 10
|
|
#synchronous_mode: true
|
|
#synchronous_mode_strict: true
|
|
#synchronous_node_count: 1
|
|
#ttl: 100
|