Last active
January 15, 2017 05:08
-
-
Save pioh/089d69825cce43ddd58f4f2d6109aabf to your computer and use it in GitHub Desktop.
postgres.conf
This file contains hidden or 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
| listen_addresses = '*' | |
| max_connections = 100 # (change requires restart) | |
| shared_buffers = 50GB # min 128kB | |
| work_mem = 512MB # min 64kB | |
| maintenance_work_mem = 2GB # min 1MB | |
| dynamic_shared_memory_type = posix # the default is the first option | |
| effective_io_concurrency = 8 # 1-1000; 0 disables prefetching | |
| max_worker_processes = 12 # (change requires restart) | |
| wal_buffers = 16MB # min 32kB, -1 sets based on shared_buffers | |
| max_wal_size = 4GB | |
| min_wal_size = 2GB | |
| checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0 | |
| random_page_cost = 1.0 # same scale as above | |
| effective_cache_size = 150GB | |
| default_statistics_target = 100 # range 1-10000 | |
| log_timezone = 'UTC+3' | |
| datestyle = 'iso, mdy' | |
| timezone = 'UTC' | |
| lc_messages = 'en_US.utf8' # locale for system error message | |
| lc_monetary = 'en_US.utf8' # locale for monetary formatting | |
| lc_numeric = 'en_US.utf8' # locale for number formatting | |
| lc_time = 'en_US.utf8' # locale for time formatting | |
| default_text_search_config = 'pg_catalog.english' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment