The Four Horsemen Behind Thousands of Postgres Outages — Two weeks ago we mentioned pgrust, an AI-assisted rewrite of Postgres in Rust (which now passes 100% of Postgres's regression tests). Here, its creator outlines the biggest Postgres pain points he set out to conquer with the rewrite.

Michael Malis

Search Without a Second System — One Postgres for your application data, full-text search, vector retrieval, and aggregations. ParadeDB is an open-source Postgres extension that keeps pace with Elasticsearch.

ParadeDB sponsor

How to Achieve Pruning When Querying by Non-Partitioned Columns — If a non-partition key column correlates strongly with your partition key (e.g. sequential session IDs in time-partitioned data), CHECK constraints can enable pruning on that column too. Includes a BRIN-inspired approach for handling outlier values.

Haki Benita

How SQL/PGQ Rewrites to Joins on Postgres 19 — Behind the scenes of Postgres 19's support for graph queries and how the graph query syntax compiles down to plain joins.

Hans-Jürgen Schönig

plx: Write Stored Functions in PHP, JavaScript, Python, and More — Hot on the heels of last week's PL/Ruby comes a more general extension that transpiles JavaScript, PHP, Python, Ruby and even COBOL to PL/pgSQL!

Command Prompt Inc.

pg_re2: Fast, RE2-Powered Regular Expressions in Postgres — Google's re2 offers more predictable execution time on regexes than the traditional backtracking approach. ClickHouse shows off its use in Postgres here.

David Wheeler and Philip Dubé

@neon/sdk: Neon's New TypeScript Client Library — For Neon users who want to work with the Postgres platform's specific features to manage projects, branches, and databases.

Andre Landgraf (Neon)

pgsavvy: A Vim-Style TUI for Working With Databases — A Go-powered TUI app for browsing and querying Postgres databases from the terminal, complete with Vim-style navigation, SQL completions, and interactive EXPLAIN plan navigation.

Dave Savic