Content-Type: multipart/alternative;
 boundary="===============0072992140359581679=="
MIME-Version: 1.0
Subject: pgAssistant 3.8.0 : continuous improvement loop for Postgres
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
From: pgAssistant dev team via PostgreSQL Announce
 <announce-noreply@postgresql.org>
Reply-To: hartwig.bertrand@gmail.com
Date: Wed, 16 Sep 2026 02:52:59 +0000
Message-ID: <178952717935.1256.3445053158444721743@wrigleys.postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/178952717935.1256.3445053158444721743%40wrigleys.postgresql.org>
Precedence: bulk

--===============0072992140359581679==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

With this release, pgAssistant is evolving beyond PostgreSQL analysis and t=
uning to become a **continuous PostgreSQL improvement platform**.

The new positioning is built around a **continuous improvement loop**:

Observe =E2=86=92 Diagnose =E2=86=92 Prioritize =E2=86=92 Plan =E2=86=92 Im=
plement =E2=86=92 Collect again =E2=86=92 Measure

pgAssistant already helped identify what should be improved and turn recomm=
endations into a prioritized Executive Plan with clear DEV and OPS ownershi=
p.

Combined with pgAssistant Collector, version 3.8.0 goes further by adding h=
istorical 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 detect=
ed does not necessarily prove that it was implemented. pgAssistant keeps th=
ese distinctions explicit while bringing the relevant evidence together in =
one place.

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