Recommendations

Overview

Alongside its autonomous tuning, DBtune surfaces recommendations: advisory suggestions that tell you what DBtune would set and why, while leaving the change and its timing to you. They cover restart-required parameters, which need a maintenance window to take effect.

Recommendations vs. autonomous tuning

DBtune combines two systems. Autonomous tuning applies changes for you to dynamic parameters that reload with no downtime. Recommendations are advisory: DBtune proposes a value but you apply it yourself, for restart-required parameters where the decision should stay with you.

See Tuning modes and Human in the loop for how autonomous tuning applies changes.

Available recommendations

• Max connections — flags when max_connections is set higher than your workload needs and proposes a tighter, safer value.

More recommendations for restart-required parameters such as shared_buffers and max_parallel_workers are planned and will appear here as they become available.