Help / Database Engineering
DATABASE ENGINEERING

Tuning PostgreSQL shared_buffers

Updated by Clustrix Admin · May 21, 2026 · 6 views

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?