What’s New in pgAssistant Since Version 2.8

Since version 2.8, pgAssistant has evolved significantly.

The initial goal was to introduce a Global Advisor capable of combining multiple PostgreSQL signals—schema design, indexes, maintenance statistics, configuration, and workload activity—to provide higher-level recommendations.

Several releases later, this experimental feature has become a much more mature expert system. At the same time, the Query Advisor, Index Advisor, ranking engine, collector integrations, and developer-facing maintenance views have also improved.

This article summarizes the main changes introduced between pgAssistant 2.8.0 and 2.9.2 .

Global Advisor: from an experiment to a broader expert system

Version 2.8 introduced the first version of the Global Advisor.

Its purpose was to move beyond isolated query analysis and evaluate the database as a whole.…