#postgresql

A discussion is ongoing about PostgreSQL's Virtual Column Index (VCI) proposal and whether it could position Postgres as a viable alternative to ClickHouse for analytical workloads. The proposal aims to add columnar storage and vectorized execution capabilities to PostgreSQL's traditional row-oriented engine.

New cache-aware scheduling patches for the Linux kernel show notable performance improvements on AMD Zen 5 processors, particularly boosting PostgreSQL and Valkey (formerly Redis) workloads by better optimizing cache utilization across the processor cores.

RSQL is a high-performance, open-source PostgreSQL client built with Tauri v2, React, and Rust. It offers features like a modern query editor, data browsing, and schema management, designed for speed and a native-like user experience.

PostgreSQL lacks native transparent data encryption due to conflicts with its MVCC architecture, performance concerns, and key management complexity. While commercial forks offer TDE, the open-source community prioritizes other features over implementing it.

EaglePress reached its v2.0 milestone, releasing a blog platform built with Python 3 and PostgreSQL.

VillageSQL has released AI agent skills that can port PostgreSQL extensions to MySQL. These skills are compatible with multiple AI coding tools including Claude Code, Gemini CLI, Cursor, and others.

The article discusses the implementation of polymorphic associations in PostgreSQL, covering patterns like single-table inheritance, multiple foreign keys, and junction tables. It explains trade-offs between schema flexibility and referential integrity, and offers practical guidance on choosing the right approach based on query patterns and data shape.

PostgreSQL's `now()` returns the transaction start time, not the real-time clock. The article explains how to use `clock_timestamp()`, `statement_timestamp()`, and `now()` correctly for event-driven systems, and warns against relying on `now()` for precise ordering in asynchronous event sourcing.

PostgreSQL's TOAST (The Oversized-Attribute Storage Technique) automatically handles large column values by compressing and storing them in a separate table, keeping the main table rows small and efficient. This mechanism is invisible to users but critical for performance when dealing with large text, JSON, or binary data.

The article provides a detailed comparison between CloudNativePG and Crunchy PGO, two Kubernetes operators for PostgreSQL, highlighting differences in architecture, features, and operational philosophies. It examines areas such as high availability, backup management, upgrade strategies, and community governance, offering an opinionated assessment of their respective strengths and trade-offs.

ExtendDB is an open-source adapter that provides a DynamoDB-compatible API with pluggable storage backends, allowing applications built for DynamoDB to work with PostgreSQL and other databases without code changes.

Multigres developed its own connection pooler because existing solutions like PgBouncer and Pgpool-II don't meet the specific requirements of its multi-database, multi-process architecture. The custom pooler allows Multigres to efficiently manage connections across different PostgreSQL databases and handle the unique demands of running multiple backend processes simultaneously.

Pgrls is a static analysis tool designed to detect and analyze Row-Level Security (RLS) policies in PostgreSQL databases. It helps developers verify that their RLS configurations are correct and secure, reducing the risk of unintended data exposure.

After the sole maintainer of the popular PostgreSQL backup tool pg_dumpbinary raised concerns about burnout and lack of support, the community has stepped in to provide assistance and ensure the project's continuity.

Drupal has issued a security advisory (SA-CORE-2026-004) warning of an SQL injection vulnerability affecting sites using PostgreSQL. The flaw could allow an attacker to inject malicious SQL queries. Users are advised to update to the latest Drupal core version to mitigate the risk.

The sole maintainer of pg_dumpbinary, a popular PostgreSQL backup tool, raised concerns about the project's sustainability. In response, the PostgreSQL community has stepped in to provide additional maintainer support. This ensures the tool's continued development and maintenance for users who rely on it for database backups.

A newly reported CVE (CVE-2025-1054) reveals a 20-year-old vulnerability in PostgreSQL's pgcrypto extension, stemming from code contributed in 2005. The flaw allows attackers to exploit weak randomness when PGP functions are used with no or low entropy, though risk is limited to specific configurations.

Deltax is an open-source, Apache-licensed PostgreSQL extension for time-series data management, offering an alternative to TimescaleDB. It automatically partitions data into delta and history tables for optimized inserts on recent data and efficient compression on older data, with full PostgreSQL compatibility.

PostgreSQL 19 beta introduces four key features for users: incremental backup support, improved query parallelism for correlated subqueries, initial SQL/JSON constructor and query functions, and faster MERGE performance via a new execution node. The release aims to enhance backup efficiency, query speed, JSON handling, and upsert operations.

The article debunks the myth that high-speed web applications must sacrifice ACID transactional consistency, demonstrating that PostgreSQL's strictest serializable isolation level can process over 20,000 ACID transactions per second on a single laptop. Benchmarks show that with careful design, PostgreSQL rivals NoSQL databases in throughput while retaining full consistency guarantees.

PgBackRest will continue development and support moving forward, ensuring ongoing maintenance and improvement of the open-source backup tool for PostgreSQL.

The article describes how to implement automatic contextual audit logging for clinical trial data in PostgreSQL without using database triggers. It presents an approach using application-level logging, session-level context variables, and a centralized function to capture who changed what, when, and why, ensuring compliance and traceability for regulated environments.

PgBackRest will continue development and support. The team announced ongoing maintenance of this PostgreSQL backup and restore tool, ensuring its availability for database administrators.

pg_infer is a PostgreSQL extension that integrates large language models directly into the database as an index for similarity searches and inference, enabling vector-based queries and AI-powered operations without external services.

The article explains how to implement vector similarity search in PostgreSQL using the pgvector extension, covering installation, data preparation, embedding generation, and querying with cosine or Euclidean distance for applications like semantic search and recommendation systems.

Microsoft is hosting POSETTE: An Event for Postgres 2026, a free and virtual conference for the PostgreSQL community. The event covers topics related to Postgres development, usage, and ecosystem, and is organized by Microsoft's Azure Database for PostgreSQL team.

Pgvector, a PostgreSQL extension for vector similarity search, now supports scalar and binary quantization. These techniques reduce vector storage size and speed up search by compressing high-dimensional vectors into smaller representations with minimal accuracy loss.

The article explains that PostgreSQL Foreign Data Wrappers (FDW) use a pushdown negotiation process where the foreign server indicates which SQL operations it can handle, rather than assuming full capability. This allows efficient query delegation by pushing down filtering, sorting, and joins only when the remote source supports them.

The PostgreSQL Global Development Group has released updates for versions 18.4, 17.10, 16.14, 15.18, and 14.23, fixing 11 security vulnerabilities including memory leaks and buffer overflows. Users are advised to upgrade to these latest minor releases to maintain security and stability.

PgGraph is an extension that brings graph database capabilities directly into existing PostgreSQL databases, enabling users to perform graph queries and operations on their relational data without migrating to a separate graph database system.