--- title: "Today is Postgres 13's final day" publication: "Postgres Weekly" issue: 624 published_at: "2025-11-13" canonical_url: "https://postgresweekly.com/issues/624" --- Plus 'index searches' explained, and playing with Postgres' 1600 column limit on tables. | #​624 — November 13, 2025 [Web Version](https://postgresweekly.com/issues/624) Together with [![Tiger Data logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_282/e_make_transparent/co_white,e_outline:30/px1u7kjyvz7xnbm6ytir.png)](https://www.tigerdata.com/blog/postgres-for-agents) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/w6r3bhlr0kdnrx2oy7yy.jpg)](https://docs.vectorchord.ai/vectorchord/getting-started/overview.html) [VectorChord 1.0: Fast Vector Search Extension for Postgres](https://docs.vectorchord.ai/vectorchord/getting-started/overview.html) — 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](https://github.com/tensorchord/VectorChord/releases/tag/1.0.0) and [GitHub repo.](https://github.com/tensorchord/VectorChord) TensorChord 💡 There's more background and technical details [in this blog post from VectorChord's initial launch](https://blog.vectorchord.ai/vectorchord-store-400k-vectors-for-1-in-postgresql) in December 2024. [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/d923f0a0.png)](https://www.tigerdata.com/blog/postgres-for-agents) [Agentic Postgres: AI-Ready Postgres for Developers](https://www.tigerdata.com/blog/postgres-for-agents) — 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](https://www.crunchydata.com/blog/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:** - 👋 [Postgres 13 has reached its 'end of life' today](https://www.percona.com/blog/postgresql-13-is-reaching-end-of-life-the-time-to-upgrade-is-now/) with no more security patches or bug fixes for the now five year old release. - 🇺🇸 [PgDay Dallas 2026](https://pgdaydallas.sched.com/registration) is taking place in Texas next February 19. Early bird tickets are available till November 28. - 🇩🇪 [PostgreSQL Conference Germany 2026](https://2026.pgconf.de/) is taking place in Essen, Germany next April 21-22. Its [call for papers](https://2026.pgconf.de/call-for-papers/) (English and German talks are both acceptable) is open until December 19. - Microsoft's popular annual POSETTE virtual Postgres conference [is returning in 2026](https://posetteconf.com/2026/) and [its CFP has just opened](https://posetteconf.com/2026/cfp/). The event takes place next June and the CFP closes on February 1. We'll remind you again before then. - A recap of [what was new with _Azure Database for PostgreSQL_](https://techcommunity.microsoft.com/blog/adforpostgresql/october-2025-recap-azure-database-for-postgresql/4468818) in October. - Aiven has introduced [a new $8/mo 'developer tier'](https://aiven.io/blog/new-developer-tier-for-aiven-for-postgres) of its Postgres cloud service. - [ClickPipes for Postgres now supports failover replication slots.](https://clickhouse.com/blog/clickpipes-postgres-failover-replication) [What Do Postgres 18's New 'Index Searches' Lines in EXPLAIN Mean?](https://www.pgmustard.com/blog/what-do-index-searches-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?](https://www.data-bene.io/en/blog/did-you-know-tables-in-postgresql-are-limited-to-1600-columns/) — If you read [issue 226](https://postgresweekly.com/issues/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](https://talkingpostgres.com/episodes/building-a-dev-experience-for-postgres-in-vs-code-with-rob-emanuele) — Microsoft’s Rob Emanuele joins Claire Giordano on the _Talking Postgres_ podcast to talk about the [‘IDE for Postgres’ VS Code extension](https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-a-new-ide-for-postgresql-in-vs-code-from-microsoft/4414648) released by Microsoft earlier this year. Talking Postgres Podcast 📄 [Temporal Constraints in Postgres 18](https://hashrocket.com/blog/posts/postgresql-18-temporal-constraints) – For enforcing uniqueness across time periods. Vinicius Negrisolo 📄 [Postgres, Kafka and Event Queues](https://kmoppel.github.io/2025-11-13-postgres-kafka-and-event-queues/) Kaarel Moppel **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/qotwna6md0icziiteqao.jpg)](https://vyruss.org/blog/pg_statviz-0.8-released-postgresql-18-support.html) [pg_statviz 0.8 Released with Postgres 18 Support](https://vyruss.org/blog/pg_statviz-0.8-released-postgresql-18-support.html) — An extension and utility for performing time series analysis and visualization of Postgres’ internal statistics. [GitHub repo.](https://github.com/vyruss/pg_statviz/) Jimmy Angelakos [pg_roaringbitmap 1.0: Roaring Bitmap Extension](https://github.com/ChenHuajun/pg_roaringbitmap) — Roaring bitmaps ([explained here](https://vikramoberoi.com/posts/a-primer-on-roaring-bitmaps-what-they-are-and-how-they-work/)) 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](https://www.pgedge.com/get-started/enterprise-vm). --- 🐱 [ConfigCat Feature Flag Service](https://configcat.com/promotions/node-weekly/?utm_source=cooperpress_newsletter&utm_medium=sponsor&utm_campaign=cooperpress_node_202510) lets you release and roll back features safely without code changes. Set it up in minutes. [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/ygajvrm4dvzmhozcarxa.jpg)](https://pgcodekeeper.org/) - [pgCodeKeeper 12.1](https://pgcodekeeper.org/) – Eclipse IDE plugin for working with PL/pgSQL and database schemas_(above)_. - [pg-promise v12.3](https://github.com/vitaly-t/pg-promise) – Extended Postgres driver for Node.js with automatic connections and transactions, query generation, and more. - [pgwire v0.35.0](https://github.com/sunng87/pgwire) – Rust-based implementation of the Postgres wire protocol. - [pg_timetable v6.2.0](https://github.com/cybertec-postgresql/pg_timetable) – Standalone job scheduler with cron-style scheduling. - [PgDoorman 2.4](https://github.com/ozontech/pg_doorman) – High-performance connection pooler. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).