Performance Tuning
2 articles tagged Performance Tuning.
PostgreSQL Autovacuum Tuning: Fix Table Bloat and XID Wraparound Risk
Measure bloat and transaction ID age, remove what blocks vacuum, and tune autovacuum thresholds, cost limits and per-table settings so large, busy PostgreSQL tables stay healthy.
SQL Server Query Store: Find Plan Regressions and Force a Good Plan
Use Query Store in SQL Server and Azure SQL Database to find queries that got slower after a plan change, force the last good plan, check that forcing works, and automate it with automatic plan correction.