PostgreSQL

A regression in Linux 7.0 has caused PostgreSQL throughput to drop by half on Graviton4 servers due to scheduler preemption changes. Kernel developers suggest PostgreSQL should adopt Restartable Sequences (RSEQ) rather than reverting kernel changes, potentially leading to performance degradation in upcoming Linux 7.0 stable releases, including Ubuntu 26.04 LTS.

pg_textsearch is a high-performance PostgreSQL extension providing BM25 ranking for text search. It features simple syntax, Block-Max WAND optimization for fast top-k queries, and parallel index builds. Designed for production, it supports PostgreSQL 17-18, partitioning, and configurable ranking parameters, making it a scalable alternative for textual information retrieval within the database.

Ghost provides instant, ephemeral Postgres databases for AI agents, enabling branching, forking, and isolation. It integrates seamlessly with a suite of Postgres-native tools—Memory Engine, TigerFS, and Ox—to provide persistent memory, file storage, and sandboxed execution without requiring complex middleware. This infrastructure simplifies agent workflows by treating databases as disposable, version-controlled project resources.

The author successfully imported the entire 20-year history of the Linux kernel into pgit, storing 1.4 million commits in a PostgreSQL database using delta compression. This setup enables rapid, complex SQL querying of the entire history, revealing deep technical insights, development trends, and contributor patterns that would be labor-intensive to produce using standard Git tools.

CTEs in PostgreSQL have evolved from 'optimization fences' into an efficient tool. Since PostgreSQL 12, the planner automatically inlines most CTEs unless they are recursive, have side effects, or are referenced multiple times. While materialization can be useful for performance or atomicity, it often hides statistics from the query planner, occasionally leading to inefficient execution plans.

Postgres uses a separate, unencrypted connection for CancelRequest messages sent during query termination. This creates security risks, including potential Denial-of-Service attacks via traffic interception. While Postgres 17 introduced TLS support for these requests, psql has not yet implemented them, highlighting the need for vigilance and secure configuration when managing database traffic and proxy tools.

This comparison table details the feature differences between two database management tools for PostgreSQL. It covers key functional areas including connection management, schema browsing, table inspection, data management, SQL editing, and file exploration, highlighting specific capabilities unique to each application's implementation.