Performance: Difference between revisions

5 bytes added ,  01:55, 26 November 2023
No edit summary
Line 159: Line 159:
# OS Type: linux
# OS Type: linux
# DB Type: web
# DB Type: web
# Total Memory (RAM): 4 GB
# Total Memory (RAM): 3 GB
# CPUs num: 4
# CPUs num: 4
# Connections num: 200
# Connections num: 200
Line 165: Line 165:


max_connections = 200
max_connections = 200
shared_buffers = 1GB
shared_buffers = 768MB
effective_cache_size = 3GB
effective_cache_size = 2304MB
maintenance_work_mem = 256MB
maintenance_work_mem = 192MB
checkpoint_completion_target = 0.9
checkpoint_completion_target = 0.9
wal_buffers = 16MB
wal_buffers = 16MB
Line 173: Line 173:
random_page_cost = 1.1
random_page_cost = 1.1
effective_io_concurrency = 200
effective_io_concurrency = 200
work_mem = 2621kB
work_mem = 1966kB
huge_pages = off
huge_pages = off
min_wal_size = 1GB
min_wal_size = 1GB