--- title: "Pipelining comes to `psql` in Postgres 18" publication: "Postgres Weekly" issue: 618 published_at: "2025-10-02" canonical_url: "https://postgresweekly.com/issues/618" --- Plus a web UI for Postgres backups, implementing a Kalman filter in SQL, and yet more Postgres 18 enhancements. | #​618 — October 2, 2025 [Web Version](https://postgresweekly.com/issues/618) Together with [![TigerData logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_296/e_make_transparent/co_white,e_outline:30/ri3mjutb8cydvqo9zn6r.png)](https://www.tigerdata.com/blog/scaling-postgresql-to-petabyte-scale/?utm_source=cooperpress&utm_medium=referral&utm_campaign=project-eyeballs-2025&utm_content=postgres-weekly-newsletter-owl-1) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/y9wrtagqf7bunkiwxang.jpg)](https://xata.io/blog/going-down-the-rabbit-hole-of-postgres-18-features) [Going Down the Rabbit Hole of Postgres 18 Features](https://xata.io/blog/going-down-the-rabbit-hole-of-postgres-18-features) — Excuse us if we maintain the excitement from last week’s [release of Postgres 18](https://www.postgresql.org/about/news/postgresql-18-released-3142/). Tudor walks through a variety of the exciting and useful new features in a way you might find more accessible than the [lengthy release notes.](https://www.postgresql.org/docs/current/release-18.html) Tudor Golubenco (Xata) 💡 Tianzhou of Bytebase has a similar roundup in [What's New in Postgres 18 – A Developer's Perspective](https://www.bytebase.com/blog/what-is-new-in-postgres-18-for-developer/). We also feature some more deep dives into specific Postgres 18 features later in this issue. [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/9890c86d.png)](https://www.tigerdata.com/blog/scaling-postgresql-to-petabyte-scale/?utm_source=cooperpress&utm_medium=referral&utm_campaign=project-eyeballs-2025&utm_content=postgres-weekly-newsletter-owl-1) [🚀 Scale Postgres to 2PB & Trillions of Metrics/Day](https://www.tigerdata.com/blog/scaling-postgresql-to-petabyte-scale/?utm_source=cooperpress&utm_medium=referral&utm_campaign=project-eyeballs-2025&utm_content=postgres-weekly-newsletter-owl-1) — TigerData, creators of TimescaleDB, are pushing Postgres to new limits: scale to 2PB and 1.5 trillion metrics/day—without proprietary black boxes or hidden tools. With Tiger Postgres, you get massive scale while keeping the SQL you know and love. TigerData sponsor [Pipelining Comes to `psql` in Postgres 18](https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html) — As of Postgres 18, `psql` comes equipped with commands to use [pipelining](https://www.postgresql.org/docs/current/libpq-pipeline-mode.html) in SQL scripts, something which Daniel notes _“can provide huge gains in query throughput”._ Daniel Vérité **IN BRIEF:** - Postgres 18 has just arrived, but Hubert Lubaczewski is looking forward to Postgres _19_ with blog posts about the introduction of [GROUP BY ALL](https://www.depesz.com/2025/10/02/waiting-for-postgresql-19-add-group-by-all/), adding [date and timestamp versions of `random(min, max)`](https://www.depesz.com/2025/09/17/waiting-for-postgresql-19-add-date-and-timestamp-variants-of-randommin-max/), and the display of [memoize planner estimates in `EXPLAIN`.](https://www.depesz.com/2025/08/04/waiting-for-postgresql-19-display-memoize-planner-estimates-in-explain/) - EDB's Floor Drees shares [a behind-the-scenes look at EDB's program](https://www.enterprisedb.com/blog/barcelona-beginnings-onboarding-new-postgresql-contributors) for onboarding new Postgres contributors at the company. [How to Do `UPDATE ... LIMIT`](https://www.cybertec-postgresql.com/en/update-limit-in-postgresql/) — Sorry, you can’t use `UPDATE` (or `DELETE` for that matter) with `LIMIT` in Postgres (though some SQL dialects, like MySQL’s, support it) but there are alternative approaches you can (carefully) use. Laurenz Albe [Postgres 18 and Beyond: From AIO to Direct IO?](https://www.cybertec-postgresql.com/en/postgresql-18-and-beyond-from-aio-to-direct-io/) — One of Postgres 18’s most exciting features is its [support for asynchronous IO](https://www.cybertec-postgresql.com/en/postgresql-18-better-i-o-performance-with-aio/) but could we do even better with Direct IO and skipping OS caching entirely? Hans-Jürgen Schönig [How I Learned to Use `wal_inspect`](https://hdombrovskaya.wordpress.com/2025/09/27/how-i-learned-to-use-wal_inspect/) — [pg_walinspect](https://www.postgresql.org/docs/current/pgwalinspect.html) is a module for inspecting the contents of a write-ahead log. Hettie Dombrovskaya 📄 [Implementing a Kalman Filter in Postgres to Smooth GPS Data](https://neon.com/blog/implementing-a-kalman-filter-in-postgres-to-smooth-gps-data) – Certainly something I’ve not seen done in SQL before. Thorsten Rieß 📄 [Postgres 18: `OLD` and `NEW` Rows in the `RETURNING` Clause](https://www.crunchydata.com/blog/postgres-18-old-and-new-in-the-returning-clause) Brandur Leach 📄 [How the `COPY` Command Gets More User Friendly in Postgres 18](https://databaserookies.wordpress.com/2025/09/28/postgres-18-copy-command/) Deepak Mahto 📄 [Cumulative Statistics in Postgres 18](https://www.data-bene.io/en/blog/cumulative-statistics-in-postgresql-18/) Cédric Villemain **RELEASES:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/xpbhlpxeazos0yneoxrx.jpg)](https://github.com/eduardolat/pgbackweb) [PG Back Web 0.5: A Postgres Backup System with Web Interface](https://github.com/eduardolat/pgbackweb) — A Go-powered app for bringing a bit more of a friendly user interface to Postgres backups, as well as scheduled backups (including to S3), backup monitoring, and webhooks. It’s available as a Docker image and now supports Postgres 18 too. Luis Eduardo [Introducing Elephantshark: A Tool to Monitor Postgres Network Traffic](https://neon.com/blog/elephantshark-monitor-postgres-network-traffic) — A Ruby-powered tool that sits between the two parties in a Postgres-protocol exchange, forwarding messages in both directions while parsing and logging them. [GitHub repo.](https://github.com/neondatabase-labs/elephantshark) George MacKerron (Neon) - [pgrx 0.16.1](https://github.com/pgcentralfoundation/pgrx/releases/tag/v0.16.1) – A way to build Postgres extensions with Rust ([full feature set here](https://github.com/pgcentralfoundation/pgrx?tab=readme-ov-file#key-features)) – now supporting Postgres 18. - [VectorChord 0.5.3](https://github.com/tensorchord/VectorChord/releases/tag/0.5.3) – Scalable, fast, and disk-friendly vector search in Postgres. - [pgmetrics 1.18](https://pgmetrics.io/) – Collect and display stats from a running Postgres server. - [ChartDB 1.16](https://github.com/chartdb/chartdb) – Open-source diagram-based database editor. **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|*).