← All digests

DBMS Weekly — 2026-05-24 (week of 2026-05-18–2026-05-24)

PostgreSQL

  • The four PG19 features you'll actually feel in production — ahead of the (then-imminent) PG19 beta, Christophe Pettus skips the SQL/PGQ graph headline and flags the operational changes: 64-bit MultiXact members (kills the "vacuum-or-die" member-exhaustion failure mode), parallel autovacuum index workers (watch the autovacuum_max_workers × autovacuum_max_parallel_workers × maintenance_work_mem worst case), temporal UPDATE/DELETE ... FOR PORTION OF, and jit = off by default (OLAP shops should re-enable and benchmark before upgrading). (thebuild.com)
  • pgBackRest gets a multi-vendor lifeline after its maintainer steps back — the most widely-used Postgres backup tool was archived in late April when its sole maintainer of 13 years (David Steele) lost funding after the Crunchy Data acquisition; a coalition (AWS, Percona, Supabase, pgEdge, Tiger Data, Eon) stepped in to fund continued development. (The Register)
  • Backrest's back, alright! — the anatomy of a sustainability gap — Jan Wieremjewicz reframes the panic: an archived repo isn't EOL, it's the "Nebraska guy problem" — critical infra carried by one person — and argues forks fragment trust where coordinated funding restores continuity. (Jan Wieremjewicz · percona.community)
  • pg_infer 1.0.0 — transformer model internals as SQL relations — not text-to-SQL: a PG18+ index AM that brings small-transformer inference into the query plan as a planner-costable operator, exposing gate activations / learned associations / embeddings as scannable relations. (Greg Burd · postgresql.org)
    • <~> model-similarity operator is index-backed and composes with WHERE/JOIN/aggregation; describe(), walk(), implies() probe what a model "knows"
    • "model" indexes WAL-log the entire vindex inside PG pages, so backup/replication/PITR cover the model like any table; targets CPU inference (OpenBLAS, BitNet b1.58 ternary weights) and idle replica CPUs via a remote backend
    • PostgreSQL 18+; built with pgrx; credits the upstream LARQL project
  • pg_tre 1.1.1 — approximate-regex index access method — a real IndexAmRoutine (USING tre) doing Levenshtein-distance regex matching ("within k edits of this pattern"), with WAL coverage, VACUUM awareness, and REINDEX CONCURRENTLY; three-tier filter funnel (BRIN-style range bloom → trigram postings → per-tuple bloom) over Laurikari's TRE library. Fills a gap pg_trgm/FTS/pgvector don't cover. PostgreSQL 18+. (Greg Burd · postgresql.org)
  • pg_mentat 1.3.0 — Datomic-compatible Datalog inside Postgres — immutable datoms, a Datalog compiler that lowers to ordinary SQL, the pull API, time-travel (as-of/since/history), and ACID via PG transactions; built with pgrx in Rust for PG13–18, with soft integrations into pg_trgm/fuzzystrmatch/pgvector/PostGIS/etc. (Greg Burd · postgresql.org)
  • pg_sorted_heap 0.14.0 — physically-sorted heap storage with zone-map pruning and a planner-integrated vector-search path. (Sergey Kuznetsov · postgresql.org)
    • sorted_hnsw made planner-visible via the Index AM path for covered KNN, including parent Merge Append over leaf HNSW indexes
    • composite zone-map metadata (first-key block ranges + bounded second-key summary); sorted_heap_bulk_load_ordered(...) trusted ordered ingestion
    • verified on PostgreSQL 16, 17, 18; now on PGXN
  • plpgsql_wrap v1.0 — Oracle-style PL/pgSQL obfuscation — stored procedures written LANGUAGE plpgsql_wrap are AES-256-GCM-encrypted into pg_proc.prosrc; source is unreadable (including in pg_dump, whose output stays restorable) without the key, otherwise behaves identically to plpgsql. PostgreSQL 12+. (HexaCluster · postgresql.org)
  • pg_statviz 1.0 — with opt-in AI analysis — minimalist in-database stats time-series extension, now with an opt-in --ai analysis flag. (pg_statviz project · postgresql.org)
    • --ai sends each chart's data/PNG to a vision LLM (Claude/Gemini/local Ollama) for a HEALTHY/WARNING/CRITICAL verdict plus remediation
    • notable design discipline: a deterministic rules engine runs first and a "severity floor" prevents the LLM downgrading a real finding; prompts wrap user data in <user_data> envelopes for prompt-injection containment
    • AI is fully optional; with no --ai flag there are zero extra dependencies and no external calls
  • Barman 3.18.0 — new release of EDB's backup-and-recovery manager for PostgreSQL. (EDB · postgresql.org)
  • check_pgactivity 2.10 — new release of the Nagios/monitoring plugin for PostgreSQL. (check_pgactivity project · postgresql.org)

Wider DBMS & distributed data

  • Postgres is all you need for durable workflows — Peter Kraft argues external workflow orchestrators (Temporal, Airflow, Step Functions) are overcomplicated: if durable execution is really about checkpointing to a database, the database can be the orchestrator — workers cooperatively dequeue from a Postgres table via locking clauses, checkpoint each step, and recover each other's state, inheriting Postgres's replication/observability/security instead of adding a new point of failure. (Peter Kraft · dbos.dev)

Migration experience

  • 21 CFR Part 11 audit logging in Postgres without triggers — Nathan Leung walks through why Harbor rejected pgAudit (no app context) and PL/pgSQL triggers (SET LOCAL plumbing, per-study-DB duplication, PgBouncer transaction-pooling wariness) and instead wrapped their Drizzle ORM in a JS Proxy that forces .withAuditLogCtx(...) before any mutation, writing the data change and a signed before/after audit row in one transaction (SELECT ... FOR UPDATE for a consistent snapshot). Honest trade-offs section: extra round trips, weaker guarantee than a DB-level trigger, and a note on eventually moving signing into pgcrypto. (Nathan Leung · runharbor.com)

Call for papers

Upcoming events

  • DEBS 2026 — Lisbon, PT, Jun 23–26 — the ACM conference on Distributed and Event-Based Systems; close to Postgres logical-decoding/CDC and real-time analytics. Full program still going up; one accepted paper already of note:
    • Lean Gossip: Big Gains from Small Talk — a leaner gossip / membership-dissemination protocol; applicable to cluster membership and failure detection in distributed Postgres deployments.

12 items · sources scanned: ~30 · community threads scanned: HN (Algolia, postgres + database queries — a quiet week, no in-window thread cleared the engagement bar) · international: Habr/Qiita/Dalibo feeds checked but none reach back to the window (plain feeds only carry recent items) · filtered out as marketing/ads: ~7