PostgreSQL News

Load shared libraries per-session from a single curated directory, no superuser needed.

Prevent your migration from starving behind long-running queries.

A Postgres sequence out of sync with its table breaks the first insert after a data load. Why it happens on serial and identity columns, and how to realign it.

UUID v7 lands in PostgreSQL 18. Here's a benchmark comparison against v4 from Shaun Thomas on index size, fragmentation, and when you should still reach for something else.

Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 1.2 with PostgreSQL 19 support, a new blocking locks analysis module, and an OpenAI-compatible AI provider.

Back in February, I wrote about Hackorum, a forum style web view of the pg-hackers mailing list. If you missed that post, you can read it here first. It turns the mailing list into something that reads and navigates a bit more like a modern forum, while t

Andrei Lepikov implemented the Xue & Marcus shared hash table approach in PostgreSQL and measured what it buys - and what PostgreSQL's process model costs.

5.15. Property Graphs # A property graph is a way to represent database contents, as an alternative to the usual (in …

28.4. Asynchronous Commit # Asynchronous commit is an option that allows transactions to complete more quickly, at the cost that the …

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 18.6, 17.11, 16.15, 15.19, …