--- title: "Postgres 19 to bring even more performance for free" publication: "Postgres Weekly" issue: 626 published_at: "2025-11-27" canonical_url: "https://postgresweekly.com/issues/626" --- Plus a new extension for writing queries in natural language. | #​626 — November 27, 2025 [Web Version](https://postgresweekly.com/issues/626) 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/we-taught-ai-to-write-real-postgres-code-open-sourced-it) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/qqnso0ubnlkmlojsw4nf.jpg)](https://www.cybertec-postgresql.com/en/super-fast-aggregations-in-postgresql-19/) [Super Fast Aggregations Coming to Postgres 19](https://www.cybertec-postgresql.com/en/super-fast-aggregations-in-postgresql-19/) — Postgres 19 is still ten months away, but some recent commits show we can look forward to dramatically faster aggregations _without_ needing to change your queries. Rather than “join first, aggregate later”, the query optimizer will be able to choose to aggregate first _then_ join when it makes more sense. Hans-Jürgen Schönig [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/ee37bdbe.png)](https://www.tigerdata.com/blog/we-taught-ai-to-write-real-postgres-code-open-sourced-it) [Tiger Data Taught AI to Write Real Postgres Code. Try it Today](https://www.tigerdata.com/blog/we-taught-ai-to-write-real-postgres-code-open-sourced-it) — Tiger Data taught AI how to write idiomatic Postgres and open-sourced it. pg-aiguide brings real DB expertise to Claude Code, or any other MCP-enabled tool. Tiger Data sponsor **IN BRIEF:** - 📘 [Just Use Postgres!](https://www.manning.com/books/just-use-postgres) is a book, written by Denis Magda and published by Manning, that entered print this month. It's essentially a modern introduction to Postgres that goes beyond typical RDBMS operations and into JSON, full-text search, pgvector, TimescaleDB, implementing message queues, and more. - 🌐 On December 9, the San Francisco Bay Area Postgres group is hosting [a free, online event featuring Christophe Pettus](https://www.meetup.com/postgresql-1/events/311995096/) talking about what's new in Postgres 18. - 🇧🇪 [FOSDEM PGDay 2026](https://2026.fosdempgday.org/) takes place in Brussels, Belgium on January 30 and [its call for papers is now open](https://2026.fosdempgday.org/callforpapers/) till December 15 if you want to speak. - **Trip reports:** Andreas Scherbaum [went to PostgreSQL Conference Japan](https://andreas.scherbaum.la/post/2025-11-25_postgresql-conference-japan-2025/) and [PostgreSQL Berlin](https://andreas.scherbaum.la/post/2025-11-24_postgresql-berlin-november-2025-meetup/), and Henrietta Dombrovskaya reports from [the Prairie PostgreSQL User Group meetup.](https://hdombrovskaya.wordpress.com/2025/11/19/prairie-postgresql-user-group-november-meetup/) - [PlanetScale launched](https://planetscale.com/blog/5-dollar-planetscale-is-here) its $5/mo tier of Postgres hosting. [Exploring Fibonacci and Turing Completeness in `psql`'s Scripting Language](https://www.enterprisedb.com/blog/psqls-scripting-language-turing-complete-or-fibonacci-psql) — `psql` supports several elements of syntax that let you perform structured, programming-like tasks you might not expect in a database front-end. Phil has a play; you might learn a thing or two about `psql`, too. Phil Eaton 📺 [The Computer Wants to Lose Your Data](https://www.youtube.com/watch?v=bFGNZqsKV-E) – A talk from SREcon25 that’s about safe data storage using MySQL and Postgres as examples. Chris Sinjakli 📄 [PostGIS Performance: Data Sampling](https://www.crunchydata.com/blog/postgis-performance-data-sampling) – The latest in Paul’s [series of posts](https://www.crunchydata.com/blog/topic/postgis-performance) about PostGIS performance. Paul Ramsey 📄 [PostgreSQL vs. MongoDB for Laravel: Choosing the Right Database](https://laravel-news.com/postgresql-vs-mongodb-for-laravel-choosing-the-right-database) – A surprisingly detailed comparison from the Laravel POV. Farhan Hasin Chowdhury 📄 [Postgres 18: Skip Scan - Breaking Free from the Left-Most Index Limitation](https://www.pgedge.com/blog/postgres-18-skip-scan-breaking-free-from-the-left-most-index-limitation) Ahsan Hadi 📄 [Why You Should Shard Your Database](https://pgdog.dev/blog/shard-your-database) Lev Kokotov (PgDog) **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/fdv1bgar1zoh5vyodpme.jpg)](https://benodiwal.github.io/pg_ai_query/) 🤖 [pg_ai_query: An Extension for Querying in Natural Language](https://benodiwal.github.io/pg_ai_query/) — An interesting extension that takes your requests written in natural language and uses either OpenAI or Anthropic models to turn them into SQL on the fly. There are many examples [in the README.](https://github.com/benodiwal/pg_ai_query) Sachin Beniwal [IvorySQL 5.0: Open Source Oracle-Compatible Postgres](https://www.ivorysql.org/) — There are numerous approaches for migrating from Oracle to Postgres and IvorySQL’s approach is to add compatibility elements such as supporting Oracle’s PL/SQL syntax and XML functions. [v5.0](https://www.postgresql.org/about/news/ivorysql-50-released-major-oracle-compatibility-expansion-on-postgresql-180-foundation-3180/) is now based on Postgres 18 and introduces even more Oracle compatibility features and support for more Postgres extensions. There’s also now [an online playground](http://trial.ivorysql.org:8080/) where you can play with an instance. IvorySQL 📰 Classifieds 🐘 [pgEdge Enterprise Postgres:](https://www.pgedge.com/get-started/enterprise-vm?utm_medium=advertising&utm_source=PostgresWeekly&utm_campaign=PostgresWeekly%20Display%20EnterprisePostgres%20WebPage) 100% open-source, scalable, designed for up to 99.999% uptime, and distributed-ready. --- 🛣️ _[The Road to Next.js](https://www.road-to-next.com/?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=next_course)_ is a course by Robin Wieruch for learning full-stack web development with Next.js 15 and React 19. The perfect match for JavaScript developers ready to go beyond the frontend. [Wrappers: A Foreign Data Wrapper Development Framework for Rust](https://fdw.dev/) — It's two things in one: first, a framework for building FDWs for Postgres in Rust, but second, [a large collection of FDWs](https://github.com/supabase/wrappers) built using the framework, covering systems like Apache Iceberg, Clickhouse, BigQuery, and AWS S3 Vectors. Supabase [SynchDB 1.3: An Extension to Replicate Data From Other Databases](https://github.com/Hornetlabs/synchdb) — A Postgres extension dedicated to reliably replicating data from other database systems such as MySQL, SQL Server, and Oracle. [v1.3](https://github.com/Hornetlabs/synchdb/releases/tag/v1.3) introduces a new, faster FDW-based snapshot engine for speeding up initial snapshot performance. Hornetlabs Technology Inc [Dbdock: A New Postgres Backup and Restore Solution](https://dbdock.mintlify.app/) Naheem Olaide - [PGSync 6.1](https://github.com/toluaina/pgsync) – Postgres to Elasticsearch/OpenSearch syncing. It can now run as a WAL consumer without Redis as a requirement. - [Pgpool-II 4.6.4, 4.5.9, 4.4.14, 4.3.17 and 4.2.24](https://www.postgresql.org/about/news/pgpool-ii-464-459-4414-4317-and-4224-released-3179/) – The connection pooler and load balancer. - [pgweb 0.17](https://github.com/sosedoff/pgweb) – Web-based, cross-platform Postgres client. ([Screenshots.](https://github.com/sosedoff/pgweb/blob/main/SCREENS.md)) - [asyncpg 0.31](https://github.com/MagicStack/asyncpg/releases/tag/v0.31.0) – A Postgres client libary for asyncio in Python. - [Npgsql 10.0](https://github.com/npgsql/npgsql) – .NET data provider for PostgreSQL. **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|*).