--- title: "The draft Postgres 17 release notes" publication: "Postgres Weekly" issue: 555 published_at: "2024-05-15" canonical_url: "https://postgresweekly.com/issues/555" --- Plus new PG releases, everything going on with Postgres at Microsoft, and we prepare to say goodbye to Postgres 12. | #​555 — May 15, 2024 [Web Version](https://postgresweekly.com/issues/555) Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://pganalyze.com?utm_source=PostgresWeeklyPrimary05152024) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/srgba651kvcwksgtdc4o.jpg)](https://www.postgresql.org/docs/devel/release-17.html) [The Draft Postgres 17 Release Notes](https://www.postgresql.org/docs/devel/release-17.html) — Bruce [just announced](https://momjian.us/main/blogs/pgblog/2024.html#May_9_2024) he’s completed the first draft of the release notes for Postgres 17 (due later this year). It’s mostly a bullet-point list of low level improvements for now, but it makes the release feel a lot closer! The first beta is due imminently. Bruce Momjian [Making a Postgres Query 1,000 Times Faster](https://mattermost.com/blog/making-a-postgres-query-1000-times-faster/) — If you want to get attention for a blog post, this is the sort of title you need to write! But you also need to back it up with a story, a solution, some useful insights, and perhaps a little humor – thankfully all those elements are present here. Alejandro García Montoro [![\](https://copm.s3.amazonaws.com/e40d0143.png)](https://pganalyze.com?utm_source=PostgresWeeklyPrimary05152024) [Postgres Performance at Any Scale](https://pganalyze.com?utm_source=PostgresWeeklyPrimary05152024) — Deliver consistent database performance and availability through intelligent Indexing and VACUUM advisors and continuous database profiling. pganalyze integrates with Amazon Web Services, Google Cloud Platform, Microsoft Azure, and more. pganalyze sponsor [Postgres 16.3, 15.7, 14.12, 13.15, and 12.19 Released](https://www.postgresql.org/about/news/postgresql-163-157-1412-1315-and-1219-released-2858/) — Right on schedule, the Postgres team has unveiled new minor versions of each maintained release line. Bug fixes are the focus, but Postgres 14-16 have also received a fix for a security issue with `pg_stats_ext` and `pg_stats_ext_exprs`. _(Note that Postgres 12 will stop receiving fixes from November this year.)_ PostgreSQL Global Development Group **IN BRIEF:** - David Wheeler recently did a poll of whether new services for the PGXN v2 Postgres extension project should be written in Go or Rust: [Rust was the clear winner.](https://justatheory.com/2024/05/pgxn-language-poll-result/) - At Google I/O, Google unveiled [Firebase Data Connect](https://firebase.google.com/products/data-connect), a way to use Firebase with a Postgres instance hosted on _Cloud SQL for PostgreSQL._ - Philip Marks, a recruiter in the Postgres space, is [this week's _Postgres Person of the Week._](https://postgresql.life/post/philip_marks/) - 🇧🇪 Stefan Fercot has [some notes from the recent _PGConf Belgium_event.](https://dataegret.com/2024/05/back-from-pgconf-belgium-2024/) [What’s New with Postgres at Microsoft, 2024 Edition](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/what-s-new-with-postgres-at-microsoft-2024-edition/ba-p/4140085) — Partly thanks to buying Citus Data and partly through Azure, Microsoft is a significant contributor to the Postgres ecosystem these days and this is a surprisingly thorough summary of everything they’ve got going on lately. Microsoft [Advanced `psql` Scripting with `coproc`](https://postgresql.verite.pro/blog/2024/05/13/advanced-psql-coproc.html) — `coproc` is a shell command that runs a process asynchronously in a subshell. If you invoke `psql` with it, it’s still possible to interact with it from afar and here’s how. Daniel Vérité 📰 Classifieds 📚 Stay informed about database technology and industry trends with a list of [recommended learning resources](https://www.red-gate.com/simple-talk/free-stuff/database-technology-learning-resources/?utm_source=postgresweekly&utm_medium=email&utm_campaign=mc-202405-t2-sodl-xdb-ubi-gc-all&utm_content=SimpleTalk) from Simple Talk editor Louis Davidson. --- Your fastest path to production. [With Render you can Build, deploy, and scale your apps with unparalleled ease](https://render.com) – from your first user to your billionth. 📄 [Removing Bloat with the `pg_repack` Extension](https://stormatics.tech/blogs/removing-bloat-with-pg_repack-extension) – `pg_repack` is an extension for removing bloat from tables and indexes _online_ without holding exclusive locks. Muhammad Ali 📄 [When to Split Patches for Postgres](https://peter.eisentraut.org/blog/2024/05/14/when-to-split-patches-for-postgresql) – For those actively contributing to Postgres. Peter Eisentraut 📄 [Dealing with Invisible Indexes in an Oracle to Postgres Migration](https://databaserookies.wordpress.com/2024/05/13/conversion-chronicles-invisible-indexes-in-oracle-to-postgresql-migration/) Deepak Mahto 🛠 Code and Tools [pg_lakehouse: Query Any Data Lake from Postgres](https://github.com/paradedb/paradedb/tree/dev/pg_lakehouse) — An extension that lets you query object stores like S3 and table formats like Delta Lake. Queries are pushed down to Apache DataFusion. Google Cloud Storage and Azure Blob Storage support is promised soon. ParadeDB - [ParadeDB 0.7](https://github.com/paradedb/paradedb) – Postgres for search and analytics. - [PostgREST 12.0.3](https://postgrest.org/en/v12/) – A REST API for any Postgres database. - [Prisma 5.14](https://github.com/prisma/prisma/releases/tag/5.14.0) – Popular ORM for Node.js and TypeScript. - [ScalikeJDBC 4.3](https://github.com/scalikejdbc/scalikejdbc/releases/tag/4.3.0) – Database client library for Scala. - [DoltgreSQL 0.7](https://github.com/dolthub/doltgresql) – Version-controlled Postgres-a-like. - [pspg 5.8.6](https://github.com/okbob/pspg) – Unix terminal pager for tabular data. **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|*).