--- title: "Postgres 18 released" publication: "Postgres Weekly" issue: 617 published_at: "2025-09-25" canonical_url: "https://postgresweekly.com/issues/617" --- Plus PlanetScale makes its Postgres offering generally available. | #​617 — September 25, 2025 [Web Version](https://postgresweekly.com/issues/617) Together with [![Posthog\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_2303,h_420/e_make_transparent/co_white,e_outline:12/i4lkeq9vxu5ccjyxdkep.png)](https://go.posthog.com/pgweek-sep25) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/iosout28y26yrnqummvo.jpg)](https://www.postgresql.org/about/news/postgresql-18-released-3142/) [Postgres 18 Released](https://www.postgresql.org/about/news/postgresql-18-released-3142/) — Right on schedule comes the latest major version of Postgres. It's not one of Postgres's biggest steps forward, but has many notable changes to boost the performance of your database. Some of what’s new: - The introduction of [an asynchronous I/O subsystem,](https://www.cybertec-postgresql.com/en/postgresql-18-better-i-o-performance-with-aio/) allowing for more efficient scans, vacuuming, and more. - [UUIDv7 support](https://www.thenile.dev/blog/uuidv7), along with [several other new functions.](https://www.postgresql.org/docs/18/release-18.html#RELEASE-18-FUNCTIONS) - [`UPDATE ... RETURNING` gets a notable improvement.](https://www.cybertec-postgresql.com/en/postgresql-update-returning-made-even-better/) - [Parallel apply of large transactions.](https://amitkapila16.blogspot.com/2025/09/parallel-apply-of-large-transactions.html) - [OAuth 2.0 authorization and authentication.](https://www.postgresql.org/docs/18/auth-oauth.html) 💡 If you want the complete list of everything's that new, [the release notes](https://www.postgresql.org/docs/18/release-18.html) provide a thorough bulletpoint walkthrough. [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/e9d8819e.png)](https://go.posthog.com/pgweek-sep25) [The First Newsletter Dedicated to Product Engineers](https://go.posthog.com/pgweek-sep25) — Product for Engineers is PostHog’s newsletter dedicated to helping engineers get better at product. It includes what they’ve learned from building PostHog, research into top startups, and curated advice on building great products. PostHog sponsor [PlanetScale for Postgres is Now GA](https://planetscale.com/blog/planetscale-for-postgres-is-generally-available) — Back in July, PlanetScale, a cloud database platform best known for its MySQL services, announced it would be moving into the PG space, [sharing a variety of benchmarks](https://planetscale.com/blog/benchmarking-postgres) of how their solution stood against the rest. In ‘private preview’ till now, the service is now open to all. Sam Lambert 💡 It's noteworthy how positive [the comments on Hacker News were about this news,](https://news.ycombinator.com/item?id=45334545) with numerous early users complimenting the service. **IN BRIEF:** - Elizabeth Christensen looks at [the original 1986 paper](https://dsf.berkeley.edu/papers/ERL-M85-95.pdf) defining Postgres' design goals and concludes that ['the PostgreSQL creators totally nailed it.'](https://www.crunchydata.com/blog/the-postgres-project-original-goals-and-how-the-creators-totally-nailed-it) - The IEEE has released a list of [the top programming languages in 2025](https://spectrum.ieee.org/top-programming-languages-2025) and SQL comes in at number four. - Ben Dicken has put together [a visual explainer of processes and threads](https://planetscale.com/blog/processes-and-threads) which results in a comparison of Postgres and MySQL's approaches. - Red Gate is running [its latest State of the Database Landscape survey.](https://rd.gt/46inTtU) There's [more info here.](https://www.red-gate.com/blog/innovation-or-fragility-help-shape-the-state-of-the-database-landscape) [Tuning Asynchronous I/O (AIO) in Postgres 18](https://vondra.me/posts/tuning-aio-in-postgresql-18/) — One of Postgres 18’s most striking changes is the introduction of asynchronous I/O (a.k.a. AIO – which you can [learn more about here](https://pganalyze.com/blog/postgres-18-async-io)). Tomas looks at the new config settings introduced to affect how AIO works and scales. Tomas Vondra 📄 [Redis is Fast - I'll Cache in Postgres](https://dizzy.zone/2025/09/24/Redis-is-fast-Ill-cache-in-Postgres/) – A comparison of using Postgres vs Redis for basic caching tasks. Redis is faster, but not necessarily faster _enough_ to justify running a second system, depending on your setup. Viktoras Kuznecovas 📄 [Writing Nothing But Docs for a Week](https://pgdog.dev/blog/writing-nothing-but-docs) – The creator of the [PgDog](https://docs.pgdog.dev/) Postgres connection pooler and sharder has really gone to the docs. Lev Kokotov 📄 [Postgres Partitioning Best Practices: Sofia's Story](https://karenjex.blogspot.com/2025/09/postgres-partitioning-best-practices.html) Karen Jex 📄 [Understanding WAL and Optimizing It with a Dedicated Disk](https://stormatics.tech/blogs/understanding-postgresql-wal-and-optimizing-it-with-a-dedicated-disk) Warda Bibi **RELEASES:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/c2401vxr0z16de9mqvp2.jpg)](https://www.pgschema.com/) [pgschema: Declarative Schema Migrations for Postgres](https://www.pgschema.com/) — Imagine something like Terraform but for bringing a declarative schema migration workflow to Postgres. There’s a lot on offer here and [support for many advanced features](https://www.pgschema.com/blog/pgschema-postgres-declarative-schema-migration-like-terraform#comprehensive-postgres-support) – [GitHub repo.](https://github.com/pgschema/pgschema) Tianzhou et al. [pgAudit 18.0: An Audit Logging Extension](https://github.com/pgaudit/pgaudit) — Postgres 18 support comes to this extension for producing audit logs such as may be required to comply with government, financial, or ISO certifications. PostgreSQL Global Development Group [pgexporter 0.7: Prometheus Exporter for Postgres](https://pgexporter.github.io/releases/pgexporter_0_7_0.html) — Now with improvements to the core metrics, including new metrics for autovacuum, and new support for several extensions including PostGIS, pg_stat_statements, pgvector, and Timescale. [Homepage.](https://pgexporter.github.io/) pgexporter community - [DoltgreSQL 0.52](https://github.com/dolthub/doltgresql) – Version controlled Postgres-a-like with Git-like functionality. - [BemiDB 1.6](https://github.com/BemiHQ/BemiDB) – Single binary Postgres read replica optimized for analytics. - [pgFormatter 5.8](https://www.postgresql.org/about/news/pgformatter-v58-has-been-released-3137/) – SQL code formatter and beautifier. - [pgenv 1.4.3](https://fluca1978.github.io/2025/09/21/pgenv1_4_3.html) – Postgres binary manager. **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|*).