The default 128MB is wrong for any production workload.
# In postgresql.conf:\nshared_buffers = 8GB # 25% of 32GB RAM\neffective_cache_size = 24GB # 75% of RAM
The default 128MB is wrong for any production workload.
# In postgresql.conf:\nshared_buffers = 8GB # 25% of 32GB RAM\neffective_cache_size = 24GB # 75% of RAM
Was this helpful?