Skip to content

Instantly share code, notes, and snippets.

@norman

norman/pg.txt

Last active August 29, 2015 14:04
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 norman/66a088a1dfe20b9ead7b to your computer and use it in GitHub Desktop.
Save norman/66a088a1dfe20b9ead7b to your computer and use it in GitHub Desktop.
Download ZIP
Optimal development-only Postgres settings for my Macbook Pro with 8GB RAM.
Raw
pg.txt
#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------
# Add settings for extensions here
#
# Some stupid, dangerous settings only used to speed things up on a local
# development machine, where if data is lost I'll just wipe and recreate.
# Never ever ever use these in production or anything approximating
# production.
fsync = off
full_page_writes = off
synchronous_commit = off
wal_writer_delay = 1s
checkpoint_segments = 64
max_connections = 10
maintenance_work_mem = 512MB
effective_cache_size = 2GB
work_mem = 128MB
wal_buffers = 1536kB
shared_buffers = 512MB
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment