pgAssistant
  • Documentation
  • Posts
  • Search
  • Tags
Home » Tags

PGASSISTANT JOURNAL

Postgresql

Oct 25, 2026 · 1 min read

Introducing pgAssistant Auto-Tune: From Recommendations to Action

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 Action
Sep 10, 2026 · 9 min read

Managing More Than 1,000 PostgreSQL Databases with pgAssistant

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 pgAssistant
Sep 09, 2026 · 3 min read

pgAssistant 3.8.0: Closing the Continuous Improvement Loop

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 Loop
May 12, 2026 · 6 min read

PostgreSQL: Which Queries Should You Optimize First?

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

Designing the Right PostgreSQL Index Using Query Plans and Statistics

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 Statistics
May 10, 2026 · 4 min read

Detecting PostgreSQL optimization issues with deterministic analysis

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
© 2026 pgAssistant — Continuous PostgreSQL Improvement · Powered by Hugo & PaperMod