Skip to content

Instantly share code, notes, and snippets.

@t0rik

t0rik/gist:5e99df2f6c7f65b1f9fb0724fd5ff071

Created May 16, 2023 10:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save t0rik/5e99df2f6c7f65b1f9fb0724fd5ff071 to your computer and use it in GitHub Desktop.
Save t0rik/5e99df2f6c7f65b1f9fb0724fd5ff071 to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql config for 256Gb RAM
Raw
gistfile1.txt
# DB Version: 12
# OS Type: linux
# DB Type: oltp
# Total Memory (RAM): 256 GB
# Number of Connections: 1000
max_connections = 1000
shared_buffers = 64GB
effective_cache_size = 128GB
work_mem = 64554kB
maintenance_work_mem = 4GB
min_wal_size = 2GB
max_wal_size = 4GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment