max_connections = 300
superuser_reserved_connections = 3
unix_socket_directories = '/var/run/postgresql'
ssl = on
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
shared_buffers = 7680MB
temp_buffers = 8MB
work_mem = 128MB
maintenance_work_mem = 1536MB
dynamic_shared_memory_type = posix
max_files_per_process = 1000
vacuum_cost_delay = 0
vacuum_cost_page_dirty = 20
vacuum_cost_limit = 200
bgwriter_delay = 200ms
max_worker_processes = 8
wal_level = replica
wal_compression = off
wal_log_hints = on
wal_buffers = 16MB
checkpoint_timeout = 1h
max_wal_size = 38GB
min_wal_size = 80MB
checkpoint_completion_target = 0.95 # checkpoint target duration, 0.0 - 1.0
checkpoint_warning = 30s
max_wal_senders = 5
wal_keep_segments = 3500
wal_sender_timeout = 60s
hot_standby = on
max_standby_streaming_delay = 30s
effective_cache_size = 9GB
default_statistics_target = 100
log_rotation_age = 1d
client_min_messages = warning
log_min_messages = warning
log_min_error_statement = warning
log_min_duration_statement = 5s
log_line_prefix = '%m [%p] %q%u@%d '
log_timezone = 'UTC'
cluster_name = '11/main'
stats_temp_directory = '/var/run/postgresql/11-main.pg_stat_tmp'
autovacuum_max_workers = 20
autovacuum_vacuum_threshold = 50
autovacuum_analyze_threshold = 50
autovacuum_analyze_scale_factor = 0.1
autovacuum_freeze_max_age = 1000000000
autovacuum_multixact_freeze_max_age = 400000000
vacuum_freeze_min_age = 50000000
vacuum_freeze_table_age = 600000000
vacuum_multixact_freeze_min_age = 5000000
vacuum_multixact_freeze_table_age = 150000000
datestyle = 'iso, mdy'
timezone = 'UTC'
lc_messages = 'en_US.UTF-8'
lc_monetary = 'en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'
default_text_search_config = 'pg_catalog.english'
shared_preload_libraries = 'pg_stat_statements,pg_pathman'
pg_stat_statements.max = 1000
pg_stat_statements.track = top
deadlock_timeout = 1s
max_locks_per_transaction = 250
max_pred_locks_per_transaction = 64

max_connections = 100 # (change requires restart)
unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
ssl = on
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
shared_buffers = 128MB # min 128kB
dynamic_shared_memory_type = posix # the default is the first option
max_wal_size = 1GB
min_wal_size = 80MB
log_line_prefix = '%m [%p] %q%u@%d ' # special values:
log_timezone = 'UTC'
cluster_name = '11/main' # added to process titles if nonempty
stats_temp_directory = '/var/run/postgresql/11-main.pg_stat_tmp'
datestyle = 'iso, mdy'
timezone = 'UTC'
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
shared_preload_libraries = 'pg_stat_statements,pg_pathman'

data_directory = '/var/lib/postgresql/11/main' # use data in another directory
hba_file = '/etc/postgresql/11/main/pg_hba.conf' # host-based authentication file
ident_file = '/etc/postgresql/11/main/pg_ident.conf' # ident configuration file
external_pid_file = '/var/run/postgresql/11-main.pid' # write an extra PID file
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
ssl = on
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
shared_buffers = 128MB # min 128kB
dynamic_shared_memory_type = posix # the default is the first option
max_wal_size = 1GB
min_wal_size = 80MB
log_line_prefix = '%m [%p] %q%u@%d ' # special values:
log_timezone = 'UTC'
cluster_name = '11/main' # added to process titles if nonempty
stats_temp_directory = '/var/run/postgresql/11-main.pg_stat_tmp'
datestyle = 'iso, mdy'
timezone = 'UTC'
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
include_dir = 'conf.d' # include files ending in '.conf' from