#​624 — November 13, 2025

Web Version

Together with  Tiger Data logo

Postgres Weekly

VectorChord 1.0: Fast Vector Search Extension for Postgres — An extension designed for high-performance, disk-efficient vector similarity search. It’s compatible with pgvector’s data types and syntax but uses an IVF (Inverted File Index) and RaBitQ quantization for extra performance in both indexing and querying, while boasting it can “store 26x more vectors than pgvector for the same price.” v1.0 release notes and GitHub repo.

TensorChord

💡 There's more background and technical details in this blog post from VectorChord's initial launch in December 2024.

Agentic Postgres: AI-Ready Postgres for Developers — Tiger Data’s Agentic Postgres turns vanilla Postgres into an AI-native database. Fork DBs, give agents memory, and query via REST or CLI. Perfect for Go backends building with Claude, Cursor, or custom agents. Try it free—no card needed.

Tiger Data sponsor

Postgres Internals Hiding in Plain Sight — A handy reminder of a variety of ways to interrogate Postgres in your day to day work, whether by asking psql to describe things about your database, or querying Postgres’s myriad catalog views for internal data and performance stats.

Elizabeth Christensen

IN BRIEF:

What Do Postgres 18's New 'Index Searches' Lines in EXPLAIN Mean?“In Postgres 18 you’ll now see “Index Searches” lines in EXPLAIN ANALYZE output. If like me you were wondering what those mean exactly, you’re in the right place.”

Michael Christofides

Did You Know Postgres Tables are Limited to 1,600 Columns? — If you read issue 226 back in 2017 you might have known this 😅 .. but yes, it’s still true. Here, Frédéric has a little fun experimenting with the consequences of the limit.

Frédéric Delacourt

▶  Building a Dev Experience for Postgres in VS Code — Microsoft’s Rob Emanuele joins Claire Giordano on the Talking Postgres podcast to talk about the ‘IDE for Postgres’ VS Code extension released by Microsoft earlier this year.

Talking Postgres Podcast

📄 Temporal Constraints in Postgres 18 – For enforcing uniqueness across time periods. Vinicius Negrisolo

📄 Postgres, Kafka and Event Queues Kaarel Moppel

RELEASES AND CODE:

pg_statviz 0.8 Released with Postgres 18 Support — An extension and utility for performing time series analysis and visualization of Postgres’ internal statistics. GitHub repo.

Jimmy Angelakos

pg_roaringbitmap 1.0: Roaring Bitmap Extension — Roaring bitmaps (explained here) are compressed and optimized bitmaps that tend to outperform conventional compressed bitmaps.

Chen Huajun

📰 Classifieds

⚙️ Need a 100% PostgreSQL starter pack that's enterprise-ready? Grab pgEdge Enterprise Postgres.


🐱 ConfigCat Feature Flag Service lets you release and roll back features safely without code changes. Set it up in minutes.

  • pgCodeKeeper 12.1 – Eclipse IDE plugin for working with PL/pgSQL and database schemas (above).

  • pg-promise v12.3 – Extended Postgres driver for Node.js with automatic connections and transactions, query generation, and more.

  • pgwire v0.35.0 – Rust-based implementation of the Postgres wire protocol.

  • pg_timetable v6.2.0 – Standalone job scheduler with cron-style scheduling.

  • PgDoorman 2.4 – High-performance connection pooler.