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.1563189982.txt.gz ยท Last modified: 2019/07/15 11:26 by phil