Skip to content

Instantly share code, notes, and snippets.

@delfer

delfer/postgresql.conf

Created November 28, 2019 14:22
Show Gist options
  • Save delfer/b930fc01b61b6753cd0fc49b8bc6fb10 to your computer and use it in GitHub Desktop.
Save delfer/b930fc01b61b6753cd0fc49b8bc6fb10 to your computer and use it in GitHub Desktop.
Download ZIP
Non-Durable PostgreSQL
Raw
postgresql.conf
#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------
# Add settings for extensions here
wal_level = minimal
max_wal_senders = 0
fsync = off
synchronous_commit = off
full_page_writes = off
wal_compression = on
checkpoint_timeout = 1d
checkpoint_completion_target = 0.9
checkpoint_flush_after = 0
min_wal_size = 32MB
max_wal_size = 64MB
max_connections = 100
shared_buffers = 128MB
effective_cache_size = 384MB
maintenance_work_mem = 32MB
wal_buffers = 3932kB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 4
work_mem = 1310kB
max_worker_processes = 2
max_parallel_workers_per_gather = 1
max_parallel_workers = 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment