PostgreSQL Technical Articles

Bryan Clark

Test out the Neon backend: Object Storage, Functions, and AI Gateway are beta

Neon has moved three backend services into public beta: object storage that integrates with Neon's branching model, long-running compute functions co-located with the database, an…

Read the Blog

Sonia Valeja

PostgreSQL Meta Commands that save time every day

This article from Percona introduces psql meta commands — client-side instructions interpreted by psql rather than PostgreSQL itself. Unlike SQL, they require no semicolons and ex…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Why clearing the VM doesn't require registering vm buffer in wal record

Melanie Plageman and Robert Haas are discussing implementation details for a pg_combinebackup debug logging helper in test infrastructure, as part of a broader patch fixing VM (vi…

Read Discussion

Small patch to improve safety of utf8_to_unicode().

Jeff Davis posted a patch to improve safety in `utf8_to_unicode()`. The patch adds Perl code to verify that the expansion factor of the UTF-8 representation does not exceed 3, and…

Read Discussion

Fix RLS checks for UPDATE/DELETE FOR PORTION OF leftover rows

The thread discusses a patch fixing Row-Level Security (RLS) checks for `UPDATE`/`DELETE FOR PORTION OF` leftover rows. Chao Li submitted v3 with a minor documentation change; Pau…

Read Discussion

walsummarizer can get stuck when switching timelines

The thread discusses a bug where the WAL summarizer gets stuck when switching timelines. A patch was proposed, and Amit Kapila reported a test failure on Windows. Andrey Borodin d…

Read Discussion

Fix FSM range endpoint after relation extension

Jingtang Zhang reported a bug where `FreeSpaceMapVacuumRange()` receives an incorrect exclusive endpoint after relation extension. The fix is a one-line change to pass `last_block…

Read Discussion

REASSIGN OWNED vs. relisshared dep on !relisshared

The thread discusses a patch by Dilip Kumar to fix a bug where `REASSIGN OWNED` incorrectly processes subscriptions belonging to other databases. Jeff Davis reviewed the patch and…

Read Discussion

Industry News

techcrunch.com

Thinking Machines Launches First Open AI Model 'Inkling' After 18 Months of Stealth Development

Thinking Machines has released its first publicly available AI model, called Inkling, marking the company's debut proof point after roughly 18 months of building AI infrastructure…

techcrunch.com

Anthropic and Blackstone Back 'Ode' Startup Betting on AI Implementation over Model Building

Anthropic and Blackstone have backed a new startup called Ode, which is betting that the next major AI opportunity lies in implementation rather than model development. Ode plans…

techcrunch.com

OpenAI Releases $230 Codex Keyboard Amid Legal Battle with Apple over Hardware Trade Theft

OpenAI has launched a $230 light-up keyboard designed to pair with its agentic coding application, Codex, even as the company faces an ongoing legal dispute with Apple over allega…

Social Media Updates

ColdFront got coverage in La Revue Tech last week 🐘🇫🇷 The article covers the OLTP/analytics angle well.

ColdFront received coverage in French publication La Revue Tech, highlighting its OLTP and analytics capabilities. A key differentiator not mentioned in the article: unlike other…

Great meetup from PostgresEDI in Edinburgh this past Thursday 🐘 July 9th at Paterson's Land, University of Edinburgh - two talks, good crowd, actual sunshine (a rarity).

PostgresEDI held a meetup on July 9th at the University of Edinburgh. Pat Wright from Redgate offered practical advice for introverts on community participation, including writing…

so where's the incremental chain?...

CYBERTEC CEO Hans-Juergen Schoenig addresses a common question about incremental backup chains in PostgreSQL backup and recovery: there isn't one, and that is intentional. The des…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates