#624 — November 13, 2025 |
|
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 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 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 |
|
|
|



