Skip to content

Instantly share code, notes, and snippets.

Last active Aug 29, 2015
What would you like to do?
Optimal development-only Postgres settings for my Macbook Pro with 8GB RAM.
# 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