proomt

Search

Search posts, papers, and topics

All posts

PostgreSQLpgAssistant dev team1 min readrelease notesintro

pgAssistant 3.8.0 : continuous improvement loop for Postgres

Read on postgresql.org

Summary

pgAssistant 3.8.0 expands from a tuning advisor to a continuous PostgreSQL improvement platform, adding a Collector that records historical workload and environment data. It lets teams run an Observe‑Diagnose‑Prioritize‑Plan‑Implement‑Measure loop, compare consecutive snapshots, and measure the impact of applied recommendations.

  • pgAssistant 3.8.0 adds a Collector that stores historical workload and environment snapshots.
  • The platform defines a six‑step improvement loop (Observe → Diagnose → Prioritize → Plan → Implement → Measure) to turn recommendations into an Executive Plan.
  • Workload Insights compare consecutive collections, surfacing new/removed recommendations, version/config changes, statement‑type trends, execution time, call volume, and top‑impact queries.
  • pgAssistant distinguishes correlation from causation and does not replace real‑time monitoring; it’s for post‑hoc validation of changes.

Postgres DBAs and SREs who need a systematic way to prioritize, track, and verify configuration and query optimizations will find it useful.

5/10
devopsobservabilityautomationperformancepostgres

Related reading

  1. Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026

    The author recaps two Dutch conferences where they presented ClickHouse‑Postgres extensions and discussed PostgreSQL 19 monitoring enhancements. The post explains how pg_clickhouse provides transparent query push‑down to ClickHouse and how pg_stat_ch streams per‑query metrics, plus new logging defaults and system views in PG 19.

    ClickHouseclickhouse.com7 min

  2. Postgres on NVMe: performance and the convergence of transactions and analytics

    Local NVMe storage cuts Postgres I/O latency from ms to µs, yielding ~9× higher TPS and 10× lower transaction latency on a 482 GiB pgbench workload. The gain comes from reduced IO wait, not more CPU work. To retain durability, combine NVMe with quorum synchronous replication and continuous WAL archiving (WAL‑G). For analytics, offload scans to ClickHouse via WAL‑based CDC (pg_clickhouse or the ne…

    ClickHouseclickhouse.com8 min

  4. pgAdmin 4 v9.18 Released

    pgAdmin 4 v9.18 adds a VS‑Code‑style Object Explorer toggle, tightens CSP defaults, and patches five CVEs (auth bypass, argument/connection‑string injection, TOCTOU file write, LLM redirect, empty username import). It also fixes numerous UI bugs, schema‑diff regressions, and updates dependencies. Windows/macOS installers, Docker, RPM/DEB, and a Python wheel are shipped.

    PostgreSQLpostgresql.org4 minrelease

  6. Introducing TIN: full-text search for Postgres

    PlanetScale’s TIN is a new PostgreSQL extension that implements a full‑text search index supporting Boolean, phrase, span, fuzzy, wildcard, regex, case/accent folding, COUNT(*) and BM25 top‑k queries. In a suite of benchmarks on an i7i.8xlarge EC2 instance (8 vCPU, 32 GB RAM), TIN built in 8 min 10 s (50.7 GB index) and outperformed ParadeDB, pg_textsearch and the built‑in GIN index by large marg…

    PlanetScaleplanetscale.com15 minHN20175