Memory
shared_buffers, work_mem and maintenance_work_mem
PostgreSQL Auto Tune
Tune PostgreSQL against your real workload
PWR turns real workload metrics into justified, measurable PostgreSQL settings ready for review.
PWR workload intelligence
Tuning guided by data
Generic formulas provide a starting point. PWR checks them against 30 days of snapshots to account for your workload, trends and production constraints.
Cache & plans
effective_cache_size and random_page_cost
Concurrency
max_connections and transaction pressure
Writes
wal_buffers and WAL activity
Indexes & disk
wide scans, physical reads and I/O pressure
Confidence
severity, rationale and score for every recommendation
Recommendations your team can explain
Each proposal shows the current value, recommended value, observed metric, technical rationale and confidence level. You keep the final decision and can validate changes in staging first.