postgresql

PostgreSQL 19 is being delayed until November because LLMs have made it far easier to discover bugs, leading to a 60-74% jump in back-patch commits and several late feature reverts as maintainers are flooded with fixes to review.

PostgreSQL 的 recovery_prefetch 功能可能导致数据库服务中断，文章警示该特性在恢复过程中的稳定性风险。

PostgreSQL 19 的发布被推迟至 11 月 19 日，原因是 LLM 辅助代码审查发现了大量缺陷，导致 8 到 10 个重要功能（包括 SQL/PGQ 图查询支持）被回滚到 PostgreSQL 20。

Timescale 开源了 pg_vectorsearch，一个 PostgreSQL 扩展，其 PRISM 索引在查询和建索引速度上均优于 pgvector 的 IVFFlat 和 HNSW，支持 RaBitQ 量化、SIMD 优化和动态更新。

PostgreSQL developer Peter Eisentraut reflects on why an unusual number of features were reverted from the PostgreSQL 19 branch after beta began, citing LLM-assisted code review raising the quality bar, the Vulnpocalypse diverting senior developers, and late discovery of defect long tails.

pg-jev is an open-source Postgres extension that lets you filter, classify, and rank rows with plain-language conditions via TypeSafe's Jev model, needing no vector columns or embedding indexes.

Amazon Aurora PostgreSQL now embeds DuckDB to let users directly query live operational data alongside historical data in Apache Iceberg and Parquet formats stored in S3 data lakes, eliminating the need for ETL pipelines and data duplication.

The article discusses common mistakes and pitfalls when using the 'at time zone UTC' function in PostgreSQL for timezone conversions.

The article discusses new database guarantees for agentic workflows, such as branches and isolation, and introduces Tencent Cloud's TDSQL-C PostgreSQL product as the first to offer all four key features.

uivoid now offers free hosted PostgreSQL databases for LLMs, enabling end-to-end system creation and hosting with authentication and MCP server integration.

PostgreSQL takes locks on all indexes during query planning, which can cause CPU contention with many indexes, and prepared statements can mitigate this issue.

The author is building Synathic, an open-source verification layer for AI-agent tool calls, and seeks feedback on whether timestamp-based checks suffice for proving causation in database writes, recommending operation IDs for attribution.

Solid Objects is an open-source library that implements a durable objects model for PostgreSQL, SQLite, and MySQL, providing stateful, ordered processing without vendor lock-in or additional infrastructure.

This article provides an interactive guide to new features in PostgreSQL 19 beta, focusing on SQL/PGQ for property graph queries with hands-on examples.

The article explores new PostgreSQL extensions pg_tre and pg_re2 for enhanced regular expression indexing, demonstrating significant performance improvements over traditional methods like pg_trgm in tests on a large database.

The article discusses the read-your-own-writes issue in database replicas and highlights PostgreSQL 19's new WAIT FOR LSN command as a solution to improve consistency and reduce lag.

This is an open-source analytics tool that can be self-hosted, doesn't require using Cookies, and keeps visitor data on your own server. The tool has garnered 38,000 stars on GitHub and supports features like traffic sources and marketing campaigns.

Pgbot is a 5.9 MB read-only Postgres tool that provides AI-powered insights for database health and performance, usable by both humans and AI agents.

A technical breakdown of how Papers with Code built a state-of-the-art hybrid search engine combining keyword and semantic search using PostgreSQL, pgvector, and Qwen3 embeddings, powered by Hugging Face infrastructure.

Fulling is an open-source tool that automatically sets up development environments with Next.js, PostgreSQL, and Claude Code, enabling full-stack app development through natural language conversation.