PostgreSQL Technical Articles

www.postgresql.org

pgAssistant 3.8.0 : continuous improvement loop for Postgres

pgAssistant 3.8.0 introduces a continuous improvement loop for PostgreSQL: Observe → Diagnose → Prioritize → Plan → Implement → Measure. The release adds historical workload and e…

Read the Blog

Andrew Stebbins

How Meshtastic Metrics Exporter Turned Eight Prometheus Queries Into One with Tiger Data

Meshtastic Metrics Exporter, an open source monitoring tool for LoRa mesh radio networks, migrated from Prometheus to PostgreSQL with TimescaleDB after hitting cardinality limits.…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Trying to break online checksums with LLMs

A patch related to online checksums was reverted following discussion among contributors. Nathan Bossart had agreed that reverting was the right call. Daniel Gustafsson had planne…

Read Discussion

Optimize UUID parse using SIMD

A patch to optimize UUID parsing using SIMD instructions has been pushed to the PostgreSQL repository. Masahiko Sawada submitted the patch (v6), which Bharath Rupireddy reviewed,…

Read Discussion

[PATCH] Release replication slot on error in SQL-callable slot functions

The discussion centers on a patch (v16) to fix replication slot leaks when errors are caught in SQL-callable slot functions. Bharath Rupireddy's v16 adds a WARNING and slot handof…

Read Discussion

Add a test for index_rebuild_count of REPACK (CONCURRENTLY)

Manuel Reyes Bravo proposed adding an isolation test to verify `index_rebuild_count` correctness in `pg_stat_progress_repack` for the `REPACK (CONCURRENTLY)` path, covering two re…

Read Discussion

Distinguish publication exclusions in object addresses

The patch adds `OBJECT_PUBLICATION_EXCLUDED_REL` to distinguish EXCEPT-clause entries from regular publication relations in `pg_get_object_address`. Key review points: Amit Kapila…

Read Discussion

pgsql: Revert online data checksum transitions

The revert of the "online data checksum transitions" feature on REL_19_STABLE introduced several follow-on bugs. Fujii Masao reported that buildfarm member longfin hit an assertio…

Read Discussion

Industry News

techcrunch.com

Anthropic merges Claude chat and Cowork in one interface

Anthropic has merged its Claude chat and Cowork features into a single unified interface. The update is initially being rolled out to Pro and Max plan subscribers. The move consol…

techcrunch.com

Hackers publish thousands of drivers' data after breaching Florida motor vehicle database

The ShinyHunters hacking gang has leaked thousands of drivers' personal data online after breaching Florida's motor vehicle database. The group published the files after the Flori…

techcrunch.com

Google launches MCP server for Google Home, enabling AI agents to control smart home devices

Google is launching early access to a new MCP server for Google Home, enabling AI agents such as Claude, ChatGPT, and others to control connected smart home devices, review camera…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates