📄️ How recommendations work
Structure, evidence, confidence, and provider awareness of tuning recommendations.
📄️ work_mem recommendation
Multi-signal work_mem guidance with spill detection, concurrency awareness, and validation.
📄️ max_connections recommendation
Connection limit guidance with memory pressure, workload headroom, and pooler advisory.
📄️ WAL and checkpoint tuning
max_wal_size, checkpoint_timeout, wal_compression, and checkpoint diagnosis.
📄️ Autovacuum global tuning
cost_limit, max_workers, and cost_delay — recommended together as one decision.