postgres

PlanetScale explains how its Neki database performs a planned primary-to-replica switchover with minimal disruption, covering preflight validation, convergence/promotion, WAL position tracking, and client recovery.

PostHog 决定将数据仓库从 DuckDB/DuckLake 迁出，原因是单节点引擎和 DuckLake 的目录设计难以支撑云端大规模、复杂的工作负载。文章详述了容量预估、S3 异步抓取、目录统计膨胀以及 Postgres 连接扩展等实际瓶颈。

YC's Lightcone podcast interviews Supabase co-founder Paul Copplestone about the open source Postgres platform reaching 13 million users, with ~70% of new activity driven by AI agents, and how the product is being redesigned agent-first.

ParadeDB details how segment partitioning (based on the Spooky LSM compaction paper) and other optimizations dramatically sped up COUNT queries and filtered, sorted searches—up to 66x faster than before—on Postgres-based search workloads.

DBOS explains how Postgres DELETE can scale for high-throughput workloads by tuning cache locality and index performance when enforcing data retention policies on tens of thousands of workflows per second, despite MVCC's inherent overhead.

Sparrow 是一款自托管的 webhook 投递产品，以单一 Go 二进制加 PostgreSQL 实现重试、加密签名、健康追踪、负载转换以及 Slack/Discord/PagerDuty 集成配方，免费并采用 MIT 许可。

开发者正在构建一个分支式数据库，让每个 AI 代理先在私有分支中自由读写生产数据，随后通过三行级三方合并、读取追踪与 SQL 校验来审查并安全合并更改，目前正在寻找协作者与早期试用者。

Materialize describes how it reworked its `persist` metadata store to build a linearizable log using PostgreSQL's READ COMMITTED isolation instead of SERIALIZABLE, tripling write throughput after a metastable latency incident, and validated correctness by modeling PostgreSQL's behavior in Lean 4 to prove linearizability.

介绍如何用 Postgres + pgvector、FastAPI、Gemini、Celery 和 Redis 构建生产级 RAG 流水线：答案引用来源、在不知道时拒绝回答，并在数据库层面强制执行行级安全。

Supabase is acquiring Turso to build AI-agent-oriented database infrastructure, combining Supabase's Postgres platform with Turso's SQLite-based cloud that can serve millions of databases on demand.

ParadeDB responds to PlanetScale's new TIN Postgres text-search extension by closing its 8x BM25 performance gap through optimization passes rather than architectural changes, benchmarking both on the same StackExchange dataset.

作者分享了为 AI agent 提供只读 Postgres 账号后发现其权限并不真正只读的经历（通过角色继承等机制可获得写权限），并开源了一个名为 agent-db-scan 的工具，用于审计给定 Postgres 连接串的有效权限、继承角色、可写表、RLS 及敏感列访问等。

This article introduces a web-based tool that checks the safety of PostgreSQL migrations using a WASM parser, helping developers validate database changes.

The article explains that PostgreSQL's SELECT DISTINCT clause does not scale efficiently, as it always scans all matching rows, leading to performance problems in certain workloads, and provides insights and workarounds.

Cronhq is a scheduler that ensures exactly-once execution for cron jobs, featuring retries, HMAC-signed webhooks, and heartbeats, built on Rust and Postgres, and is open-source under MIT license.

TIN is a fast, full-featured full-text search extension for Postgres that supports boolean expressions, fuzzy matching, and concurrent operations, released by PlanetScale as a GA product.

A discussion about using Jev for query optimization, with one user sharing a 12% speed improvement in Postgres queries and another commenting on Jev's performance issues.

Supabase is an open-source Postgres development platform offering a hosted database, automatic API generation, authentication, and AI tools, earning over 109k stars on GitHub for its efficiency and comprehensiveness.

The article describes an experiment where a 4B AI model is trained via fine-tuning and reinforcement learning to optimize Postgres query plans, achieving an 81% faster performance and 44.7% latency reduction across join-heavy queries.

The article explores the role of humans in AI-assisted software development, emphasizing that human expertise is crucial beyond basic AI prompting, as seen in projects like rewriting Postgres in Rust for performance gains and the author's own AI orchestration systems.