Oct 25, 2026 · 1 min read
Apply selected pgAssistant recommendations across your PostgreSQL fleet with YAML policies, dry-run previews, and execution history.
Read more →: Introducing pgAssistant Auto-Tune: From Recommendations to ActionSep 10, 2026 · 9 min read
A practical architecture for analyzing more than 1,000 PostgreSQL databases with one pgAssistant per environment and one central Collector and Grafana stack.
Read more →: Managing More Than 1,000 PostgreSQL Databases with pgAssistantSep 09, 2026 · 3 min read
pgAssistant 3.8.0 introduces Workload Insights to connect PostgreSQL changes, recommendation history, and measured workload results.
Read more →: pgAssistant 3.8.0: Closing the Continuous Improvement LoopMay 12, 2026 · 6 min read
When investigating PostgreSQL performance, the usual starting point is pg_stat_statements. From there, many teams sort queries by mean_exec_time or total_exec_time and start optimizing the …
Read more →: PostgreSQL: Which Queries Should You Optimize First?May 11, 2026 · 9 min read
PostgreSQL index design is often misunderstood.
Many developers think that creating a good index simply means:
“Create an index containing the columns from the WHERE clause.”
In reality, …
Read more →: Designing the Right PostgreSQL Index Using Query Plans and StatisticsMay 10, 2026 · 4 min read
Detecting PostgreSQL optimization issues with deterministic analysis For years, I kept seeing the same PostgreSQL problems in production:
missing foreign key indexes stale statistics unused …
Read more →: Detecting PostgreSQL optimization issues with deterministic analysis