postgresql

Microsoft open sourced pg_durable, a PostgreSQL extension that enables durable execution of long-running SQL functions with automatic checkpointing and fault-tolerant resumption.

Postgres 19 introduces query hints via new contrib modules pg_plan_advice and pg_stash_advice, ending a long-standing community debate and providing DBAs with an escape hatch for optimizer edge cases.

This article argues that using weaker database isolation levels as default is a form of premature optimization, and recommends serializable isolation level unless the DBMS already defaults to it. It cites real examples of concurrency bugs leading to financial losses.

The author introduces Noosphere, an open-source memory and wiki layer for AI agents and humans, seeking feedback on its structured Postgres-backed memory, Redis-cached recall, and human-editable wiki pages.

The author replaced OpenClaw's default flat-file memory with a strict Node.js/PostgreSQL API layer, eliminating context drift and hallucinations by enforcing typed schemas and immutable truth.

Cache-aware scheduling improvements show significant performance gains for AMD Zen 5 processors running PostgreSQL and Valkey databases.

Describes implementing a three-layer memory stack for Hermes Agent, combining session memory on PostgreSQL, working memory with pattern redaction, and a long-term knowledge graph using PGLite.

pgGraph v0.1.1 is an open-source, high-performance graph traversal extension for PostgreSQL written in Rust, enabling graph superpowers for Postgres users.

pgBackRest, a popular PostgreSQL backup tool, announces it will continue development thanks to a coalition of sponsors including Amazon Web Services, Supabase, and others, ensuring long-term sustainability.

DeltaX is an Apache-licensed PostgreSQL extension providing compression and columnar storage for time-series data, offering a fast alternative to TimescaleDB or ClickHouse while keeping data in PostgreSQL.

listmonk is a self-hosted email marketing system deployed as a single binary, supporting Newsletter and mailing list management. It is open-source with no vendor lock-in.

Tabularis is an open-source, cross-platform modern database client that supports PostgreSQL, MySQL/MariaDB, and SQLite, with built-in AI, MCP, and Notebook, and supports plugin extensions. Designed for developers.

Explains the subtle differences in how ORDER BY handles bare identifiers versus expressions in SQL, using PostgreSQL examples to show that identical-looking queries can produce different results due to different code paths.

PostgreSQL has released security updates for versions 18.4, 17.10, 16.14, 15.18, and 14.23, fixing 11 CVEs and over 60 bugs. Notable fixes include CVE-2026-6473 (integer wraparound, CVSS 8.8) and CVE-2026-6475 (symlink overwrite, CVSS 8.8).

The article analyzes the scalability limitations of using PostgreSQL as a job queue, specifically highlighting performance bottlenecks caused by MultiXact SLRU contention under high concurrency. It explains why this architecture fails in production despite working well in development and suggests considering alternatives.

OpenAI shares technical insights on scaling PostgreSQL to support 800 million ChatGPT users and millions of queries per second, using a single-primary architecture with 50 read replicas while managing challenges from write-heavy workloads through sharding and optimization strategies.

listmonk is a standalone, self-hosted newsletter and mailing list manager that is fast, feature-rich, and packed into a single binary using a PostgreSQL database.