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.…