#626 — November 27, 2025 |
|
Postgres Weekly |
|
|
Super Fast Aggregations Coming to Postgres 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 |
Tiger Data Taught AI to Write Real Postgres Code. Try it Today — 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:
|
|
Exploring Fibonacci and Turing Completeness in Phil Eaton |
|
📺 The Computer Wants to Lose Your Data – A talk from SREcon25 that’s about safe data storage using MySQL and Postgres as examples. Chris Sinjakli 📄 PostGIS Performance: Data Sampling – The latest in Paul’s series of posts about PostGIS performance. Paul Ramsey 📄 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 Ahsan Hadi 📄 Why You Should Shard Your Database Lev Kokotov (PgDog) |
|
RELEASES AND CODE: |
|
|
🤖 pg_ai_query: An Extension for Querying in Natural Language — 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. Sachin Beniwal |
|
IvorySQL 5.0: Open Source Oracle-Compatible Postgres — 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 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 where you can play with an instance. IvorySQL |
|
|
Wrappers: A Foreign Data Wrapper Development Framework for Rust — It's two things in one: first, a framework for building FDWs for Postgres in Rust, but second, a large collection of FDWs 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 — A Postgres extension dedicated to reliably replicating data from other database systems such as MySQL, SQL Server, and Oracle. 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 Naheem Olaide |
|