User Tools
soft:postgresql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
soft:postgresql [2019/07/14 23:48] phil |
soft:postgresql [2019/07/24 21:17] (current) phil |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| <file / | <file / | ||
| listen_addresses = ' | listen_addresses = ' | ||
| - | shared_buffers = 256MB # ~25% of RAM and maximum at 16G | + | shared_buffers = 1024MB |
| work_mem = 16MB | work_mem = 16MB | ||
| maintenance_work_mem = 128MB | maintenance_work_mem = 128MB | ||
| - | synchronous_commit = off | + | synchronous_commit = off # read documentation before using this |
| random_page_cost = 3.0 # if using ssd | random_page_cost = 3.0 # if using ssd | ||
| track_functions = all | track_functions = all | ||
| Line 23: | Line 23: | ||
| log_autovacuum_min_duration = 1000 | log_autovacuum_min_duration = 1000 | ||
| log_line_prefix = '%t [%p]: [%l-1] user=%u, | log_line_prefix = '%t [%p]: [%l-1] user=%u, | ||
| - | effective_cache_size = 512MB | + | effective_cache_size = 3072MB # 75% of ram |
| </ | </ | ||
soft/postgresql.1563148129.txt.gz ยท Last modified: 2019/07/14 23:48 by phil
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
