Skip to content

Instantly share code, notes, and snippets.

@kustodian
Last active March 15, 2018 14:02
Show Gist options
  • Save kustodian/a43ade99daac934b21af684c7bb7b7f7 to your computer and use it in GitHub Desktop.
Save kustodian/a43ade99daac934b21af684c7bb7b7f7 to your computer and use it in GitHub Desktop.
postgresql.conf for the Meltdown and Spectre Kernel Mitigations Benchmarks
listen_addresses = '*'
port = 5432
max_connections = 200
shared_buffers = 4GB
work_mem = 1MB
maintenance_work_mem = 16MB
dynamic_shared_memory_type = posix
wal_level = minimal
fsync = on
synchronous_commit = off
max_wal_size = 1GB
min_wal_size = 80MB
checkpoint_timeout = 10min
checkpoint_completion_target = 0.9
autovacuum = off
seq_page_cost = 1.0
random_page_cost = 1.0
effective_cache_size = 22GB
log_directory = 'pg_log'
log_filename = 'postgresql-%a.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 0
log_line_prefix = '%t [%p]: [%l-1] '
log_timezone = 'Europe/Belgrade'
datestyle = 'iso, mdy'
timezone = 'Europe/Belgrade'
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'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment