TechEmpower.FrameworkBenchmarks/toolset/databases/postgres/postgresql.conf

# For a full conf file see:
# https://github.com/TechEmpower/FrameworkBenchmarks/blob/d8f043d183d1ccbba41157bd57314ef61059edb8/toolset/databases/postgres/postgresql.conf.sample

listen_addresses = '*'
max_connections = 2000
ssl = false

# Tuning AIO in PostgreSQL 18:
# https://vondra.me/posts/tuning-aio-in-postgresql-18
# The config.sh script sets the actual value based on that article and the runtime environment.
io_workers = 32

# values from: http://blog.pgaddict.com/posts/performance-since-postgresql-7-4-to-9-4-pgbench
# details: http://www.postgresql.org/docs/9.4/static/runtime-config-resource.html
# http://www.postgresql.org/docs/9.4/static/runtime-config-wal.html
# http://www.postgresql.org/docs/9.4/static/runtime-config-query.html

shared_buffers = 256MB
work_mem = 64MB
maintenance_work_mem = 512MB
wal_level = minimal

# WARNING: disabling synchronous commit may be dangerous in certain cases.
# See http://www.postgresql.org/docs/current/static/runtime-config-wal.html
# for details.
synchronous_commit = off

checkpoint_completion_target = 0.9
max_wal_senders = 0

# when executed on the SSD (otherwise 4)
random_page_cost = 2

effective_cache_size = 8GB
log_line_prefix = '%t '
track_activity_query_size = 2048
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all
pg_stat_statements.max = 500000
max_pred_locks_per_transaction = 256