pgAssistant 3.8.0 : continuous improvement loop for Postgres

Поиск
Список
Период
Сортировка
Искать

pgAssistant 3.8.0 : continuous improvement loop for Postgres

От:
pgAssistant dev team via PostgreSQL Announce <announce-noreply@postgresql.org>
Дата:
 

pgAssistant 3.8.0 : continuous improvement loop for Postgres

With this release, pgAssistant is evolving beyond PostgreSQL analysis and tuning to become a continuous PostgreSQL improvement platform.

The new positioning is built around a continuous improvement loop:

Observe → Diagnose → Prioritize → Plan → Implement → Collect again → Measure

pgAssistant already helped identify what should be improved and turn recommendations into a prioritized Executive Plan with clear DEV and OPS ownership.

Combined with pgAssistant Collector, version 3.8.0 goes further by adding historical workload and environment measurements. The objective is to answer four essential questions:

  • What should we improve?
  • What did we decide to do?
  • What did we actually change?
  • What was the result?

Workload Insights compares consecutive collections and highlights:

  • new and no-longer-detected recommendations;
  • changes to the PostgreSQL version and configuration;
  • workload evolution by statement type;
  • changes in execution time and call volume;
  • the queries with the greatest impact on the overall workload.

The ambition is to correlate the application of pgAssistant recommendations and the Executive Plan with observed performance changes.

Correlation is not causation, and a recommendation that is no longer detected does not necessarily prove that it was implemented. pgAssistant keeps these distinctions explicit while bringing the relevant evidence together in one place.

pgAssistant is not intended to replace real-time monitoring. Monitoring shows what is happening now; pgAssistant helps teams decide what to improve next, organize the remediation work, and measure what changed afterwards.

From recommendations to action—and from action to measurable evidence.

pgAssistant 3.8.0: https://github.com/beh74/pgassistant-community

pgAssistant Collector: https://github.com/beh74/pgassistant-collector

pgAssistant Grafana : https://github.com/beh74/pgassistant-grafana

This email was sent to you from pgAssistant dev team. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to pgAssistant dev team.

You were sent this email as a subscriber of the pgsql-announce mailinglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click the personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
FAQ