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/15 11:26] phil |
soft:postgresql [2019/07/24 21:17] 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 # read documentation before | + | synchronous_commit = off # read documentation before |
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 |
</ | </ | ||