--- title: "Early excitement for Postgres 17" publication: "Postgres Weekly" issue: 551 published_at: "2024-04-17" canonical_url: "https://postgresweekly.com/issues/551" --- Plus Supabase and Neon go GA, Postgres sees a popularity boost, and putting Postgres in front of SQLite. | #​551 — April 17, 2024 [Web Version](https://postgresweekly.com/issues/551) Together with [![Ottertune logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_450,h_100/e_make_transparent/co_white,e_outline:7/d92wjjhrmysrssm2xhjm.png)](https://ottertune.com/free-trial/postgresql?utm_source=postgres_weekly&utm_medium=email&utm_campaign=april_24_primary) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/qrnxqrhzcdpmtmn11slw.jpg)](https://hdombrovskaya.wordpress.com/2024/04/16/postgresql-17-features-i-am-most-waiting-for/) [The Postgres 17 Features I'm Most Waiting for](https://hdombrovskaya.wordpress.com/2024/04/16/postgresql-17-features-i-am-most-waiting-for/) — It’s still several months away, but Postgres 17 is shaping up to be yet another great release. A lot of items in today's issue are about Postgres 17 – everyone's getting excited! Henrietta Dombrovskaya 📊 [Ten Years of Improvements in Postgres's Optimizer](https://rmarcus.info/blog/2024/04/12/pg-over-time.html) — _“I decided to run the join order benchmark (JOB)1 on PostgreSQL 8 through 16. I recorded the 90th percentile query latency for each database version.”_ Ryan Marcus [![\](https://copm.s3.amazonaws.com/b8a95c85.png)](https://ottertune.com/free-trial/postgresql?utm_source=postgres_weekly&utm_medium=email&utm_campaign=april_24_primary) [Improve Postgres Performance and Reduce Costs with OtterTune](https://ottertune.com/free-trial/postgresql?utm_source=postgres_weekly&utm_medium=email&utm_campaign=april_24_primary) — Automatically tune and optimize knobs, plus get index and query recommendations, along with table and autovacuum insights. Customers have improved performance over 90% and saved thousands of dollars in database labor costs. Do a free, 30-day trial. OtterTune sponsor [Supabase Declares 'General Availability'](https://supabase.com/ga) — I hadn’t noticed Supabase has been rocking ‘beta’ all this time, but the Postgres, auth, realtime, and edge functions platform has decided – some 1 million databases into their journey – that now they’re ready for anything! Supabase In other Supabase news, [the Oriole team has joined Supabase](https://supabase.com/blog/supabase-aquires-oriole). If you recall, [OrioleDB](https://github.com/orioledb/orioledb) is an effort to create a new 'cloud native' storage engine for Postgres. **IN BRIEF:** 📈 In the [latest DB-Engines database rankings](https://db-engines.com/en/ranking) for April 2024, Postgres has seen the largest surge in popularity. 🚀 [Neon's serverless Postgres platform](https://neon.tech/blog/neon-ga) is now generally available. The news provoked [quite a bit of discussion](https://news.ycombinator.com/item?id=40040593) on Hacker News. 🪙 Did you know the Postgres project [commissions gifts](https://wiki.postgresql.org/wiki/Contributor_Gifts) for contributors? Here's what Luca Ferrari's newly received [Postgres 16 coin looks like.](https://fluca1978.github.io/2024/04/14/PostgreSQL16Coin.html)😍 🎧 The _Hacking Postgres_ podcast is back for a second season and launches with [an interview with Andrew Atkinson](https://andyatkinson.com/blog/2024/04/15/hacking-postgres-podcast-andrew-atkinson), author of _High-Performance PostgreSQL for Rails_. ✍️ Christoph Berg shares [a quick trip report from PGConf.de 2024](https://www.cybertec-postgresql.com/en/pgconf-de-2024-in-munich/) which took place last week. 🙏 [Is SQL/JSON 'coming back'](https://www.depesz.com/2024/04/12/waiting-for-sql-json-is-coming-back-hopefully/) to Postgres? We hope so. [Postgres Roles and Privileges](https://supabase.com/blog/postgres-roles-and-privileges) — A follow along, tutorial style, guide to understanding how roles and privileges work. Raminder Singh (Supabase) [Use Cases for Merging and Splitting Partitions with Minimal Locking in Postgres 17](https://andyatkinson.com/blog/2024/04/16/postgresql-17-merge-split-partitions) — Some interesting new capabilities regarding managing partitioned tables are coming to Postgres 17. Andrew Atkinson [Improved Query Cancellation in Postgres 17 and Psycopg 3.2](https://blog.dalibo.com/2024/04/15/improved-query-cancellation-in-postgresql-17-and-psycopg-3.2.html) — Postgres 17 will gain some improved query cancellation capabilities and Python users will hopefully be able to take advantage from day one. Denis Laxalde 📄 [What I Learned Building a Postgres Extension In Rust](https://goodyduru.github.io/database/2024/04/15/what-i-learned-from-building-a-postgres-extension-in-rust.html) Goodness Duru 📄 [PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables](https://databaserookies.wordpress.com/2024/04/10/pl-pgsql-conversion-gotchas-how-to-handle-conflicting-variables/) Deepak Mahto 📄 [Rebuilding Tables Online using pg_repack](https://hexacluster.ai/postgresql/rebuilding-tables-online-using-pg_repack-in-postgresql/) Manisankar K 📄 [Five Tips on Postgres Logical Decoding](https://blog.peerdb.io/five-tips-on-postgres-logical-decoding) Sai Srirampur 📄 [Will Postgres Use My Index or Not?](https://medium.com/@magda7817/will-postgres-use-my-index-or-not-64f48089e597) Denis Magda 📄 [What Makes a Great Technical Blog](https://notes.eatonphil.com/2024-04-10-what-makes-a-great-tech-blog.html) Phil Eaton 📰 Classifieds Learn how you can boost your data transformation and analysis process using PostgreSQL in [this three-part series from Simple Talk](https://www.red-gate.com/simple-talk/databases/postgresql/transforming-and-analyzing-data-in-postgresql/?utm_source=postgresweekly&utm_medium=email&utm_campaign=mc-202404-t2-sodl-xdb-ubi-gc-all&utm_content=SimpleTalk). --- 📧 If you do any work with browser technologies, CSS, HTML, Web APIs, etc, be sure to check out [Frontend Focus](https://frontendfoc.us/), our sister newsletter covering everything frontend. 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/pbbhelns7nz6fq0bnyz2.jpg)](https://github.com/Florents-Tselai/vasco) [Vasco: MIC & MINE Statistics Extension](https://github.com/Florents-Tselai/vasco) — Maximal information coefficient ([MIC](https://en.wikipedia.org/wiki/Maximal_information_coefficient)) and maximal information-based nonparametric exploration (MINE) are statistical measures that can be used to explore multi-dimensional datasets and find important relationships within them. Florents Tselai [Postgres + SQLite = pglite?](https://github.com/viggy28/pglite) — Not to be confused with the [PGlite](https://github.com/electric-sql/pglite) WASM build of Postgres, this is a quick Go-powered proof of concept to put the Postgres wire protocol in front of SQLite. viggy28 [trdsql: Tool to Execute SQL Queries Upon Text-Based Data](https://github.com/noborus/trdsql) — A CLI tool that can execute SQL queries (in Postgres or MySQL syntax) on CSV, LTSV, JSON, YAML and TBLN files. It can also be [used as a library](https://pkg.go.dev/github.com/noborus/trdsql#pkg-overview) within Go apps. Noboru Saito - [pREST 1.5](https://prestd.com/) – A RESTful API to sit in front of a Postgres database. - [pg_graphql 1.5.3](https://github.com/supabase/pg_graphql) – Bring GraphQL support to Postgres. - [Bytebase 2.15](https://www.bytebase.com/changelog/bytebase-2-15-0/) – Database devops and CI/CD system for teams. - [RisingWave 1.8.1](https://github.com/risingwavelabs/risingwave) – Postgres-compatible streaming database. - [DoltgreSQL 0.6](https://github.com/dolthub/doltgresql) – Version-controlled Postgres. - [pspg 5.8.4](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|*).