User Tools

Site Tools


soft:postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
soft:postgresql [2019/07/15 11:26]
phil
soft:postgresql [2019/07/24 21:17] (current)
phil
Line 7: Line 7:
 <file /​etc/​postgresql/​postgresql.conf>​ <file /​etc/​postgresql/​postgresql.conf>​
 listen_addresses = '​*'​ listen_addresses = '​*'​
-shared_buffers = 256MB  # ~25% of RAM and maximum at 16G+shared_buffers = 1024MB ​ # ~25% of RAM and maximum at 16G
 work_mem = 16MB work_mem = 16MB
 maintenance_work_mem = 128MB maintenance_work_mem = 128MB
Line 23: Line 23:
 log_autovacuum_min_duration = 1000 log_autovacuum_min_duration = 1000
 log_line_prefix = '%t [%p]: [%l-1] user=%u,​db=%d ' log_line_prefix = '%t [%p]: [%l-1] user=%u,​db=%d '
-effective_cache_size = 512MB+effective_cache_size = 3072MB # 75% of ram
 </​file>​ </​file>​
  
soft/postgresql.txt ยท Last modified: 2019/07/24 21:17 by phil