Last active
October 28, 2024 11:35
-
-
Save norman/66a088a1dfe20b9ead7b to your computer and use it in GitHub Desktop.
Optimal development-only Postgres settings for my Macbook Pro with 8GB RAM.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#------------------------------------------------------------------------------ | |
# 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