PostgreSQL Technical Articles

Anisa Dean

CORTO’s billion-scale legal semantic search with Aurora PostgreSQL pgvector

CORTO, a legal technology platform serving over 10,000 law firms, built a billion-scale semantic search system on Amazon Aurora PostgreSQL with pgvector, managing 7.6 billion vect…

Read the Blog

Robert Bernier

Navigating the Walled Gardens of PostgreSQL: Hidden Risks of Postgres Vendor Lock-in

Robert Bernier of Percona warns PostgreSQL users about vendor lock-in risks created by commercial ecosystems built around the open-source database. Although PostgreSQL itself rema…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

datachecksums: handle invalid and dropped databases during enable

The thread discusses whether a patch handling invalid and dropped databases during `datachecksums` enable needs to be listed as an open item on the wiki. Daniel Gustafsson argues…

Read Discussion

Changing the state of data checksums in a running cluster

A TAP test reliability issue was identified in the "Changing the state of data checksums in a running cluster" patch. The tests were failing due to insufficient worker process lim…

Read Discussion

scary patch contest

The "scary patch contest" thread discusses six PostgreSQL v19 features with high post-freeze bug counts, identified using Claude: RI fast-path FK batching, REPACK CONCURRENTLY, on…

Read Discussion

tablecmds: fix bug where index rebuild loses replica identity on partitions

The thread discusses a bug where `ALTER COLUMN TYPE` (or `ALTER COLUMN SET EXPRESSION`) causes index rebuilds on partition leaves to lose several properties: replica identity mark…

Read Discussion

Snapshot export on a standby corrupts hint bits on subxact overflow

The thread discusses a bug where exporting snapshots on a standby corrupts hint bits when subxact overflow occurs. Key proposals included skipping recovery subxip entries and comm…

Read Discussion

Add a Nix flake

Greg Burd proposed adding a flake.nix file to the PostgreSQL source tree to give Nix users a shared, reproducible development environment. Andrew Dunstan questioned the claimed us…

Read Discussion

Industry News

techcrunch.com

OpenAI Releases Official Report on Hugging Face Security Breach

OpenAI has published its official report on the Hugging Face security breach, described as the most complete accounting of the incident to date. The report covers several discrete…

techcrunch.com

Arga Labs Raises $10M Seed Round to Improve Enterprise AI Agent Training

Arga Labs has raised $10 million in a seed funding round led by General Catalyst, with participation from Box Group, Emergence, Gradient, and SV Angel. The startup is focused on b…

techcrunch.com

Z.ai Revealed as Creator of Mystery Top-Performing Open AI Model Ox Alpha

Z.ai has confirmed it is the AI lab behind Ox Alpha, a previously mysterious open AI model that has been topping benchmarks and leaderboards. The company announced that the model'…

Social Media Updates

Pavlo Golub is back with another conference vlog, this time from Swiss PGDay 2026 in Rapperswil.

Pavlo Golub has shared a new conference vlog from Swiss PGDay 2026, held in Rapperswil. The vlog covers two days of talks, poster sessions, and conversations at the event, along w…

SpaceXAI 's latest model, Grok 4.6, is now available on Databricks!

SpaceXAI's latest model, Grok 4.6, is now available on Databricks. It achieves state-of-the-art performance on Databricks' OfficeQA Pro v2 benchmark, a flagship evaluation for com…

[DEMO] Give an AI agent the right context, tools, and guardrails, and it can do a lot more than answer questions.

This demo shows how to build a store operations AI agent capable of going beyond simple question-answering. The agent draws from enterprise context and MCP servers, with behavior…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates