Tool

PostgreSQL Tune Calculator

Calculate postgresql.conf values for your hardware and workload.

Suggestions follow PostgreSQL resource consumption and tuning wiki. Enter your system parameters to get suggested settings for shared_buffers, work_mem, and more.

Back to tools

System parameters

Describe your server and workload so we can suggest configuration.

PostgreSQL version

OS type

DB type (workload)

Web: many simple queries. OLTP: mixed reads/writes. DW: large reporting. Desktop: general use. Mixed: combination.

Total memory (RAM)

Number of CPUs

CPUs = cores × sockets (threads per core optional)

Max connections

Data storage

Suggested configuration

Add these to postgresql.conf or use as a starting point. Restart required for most changes.

shared_buffers1024MB

effective_cache_size3072MB

work_mem10MB

maintenance_work_mem256MB

max_worker_processes4

max_parallel_workers_per_gather2

max_parallel_workers4

max_parallel_maintenance_workers2

random_page_cost1.1

effective_io_concurrency200

checkpoint_completion_target0.9

wal_buffers16MB

min_wal_size1024MB

max_wal_size2048MB

default_statistics_target100

max_connections100

postgresql.conf snippet

# PostgreSQL configuration (suggestions from official docs)
# Generated for: web, 4 GB RAM, 4 CPUs, 100 connections, SSD storage
# See: https://www.postgresql.org/docs/current/runtime-config-resource.html

shared_buffers = '1024MB'
effective_cache_size = '3072MB'
work_mem = '10MB'
maintenance_work_mem = '256MB'
max_worker_processes = '4'
max_parallel_workers_per_gather = '2'
max_parallel_workers = '4'
max_parallel_maintenance_workers = '2'
random_page_cost = '1.1'
effective_io_concurrency = '200'
checkpoint_completion_target = '0.9'
wal_buffers = '16MB'
min_wal_size = '1024MB'
max_wal_size = '2048MB'
default_statistics_target = '100'
max_connections = '100'

Disclaimer: These are suggestions based on official documentation only. Always test in a non-production environment. Windows has lower practical limits for shared_buffers. See PostgreSQL resource consumption and tuning wiki for details.

Was this tool helpful?

(4.8/5)