--- title: "Postgres 16 goes GA on AWS RDS and Azure" publication: "Postgres Weekly" issue: 531 published_at: "2023-11-22" canonical_url: "https://postgresweekly.com/issues/531" --- And IBM mainframes..? | #​531 — November 22, 2023 [Web Version](https://postgresweekly.com/issues/531) Together with [![Epsio\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_345,h_155/e_make_transparent/co_white,e_outline:10/mmeowbxba1ikxyqjznii.png)](https://docs.epsio.io/?utm_source=pgwk22) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/bfifhr47blxnrnlk1orh.jpg)](https://notes.eatonphil.com/2023-11-19-exploring-a-postgres-query-plan.html) [Exploring a Postgres Query Plan](https://notes.eatonphil.com/2023-11-19-exploring-a-postgres-query-plan.html) — Phil continues his spelunking into the technicalities of how Postgres works by looking at how the query execution process can be intercepted and what you can learn by doing so. Admittedly, **most Postgres users will never need to dig this deep** but it’s worth a skim if you want to at least get a feel for what goes on under the hood. Phil Eaton [![\](https://copm.s3.amazonaws.com/21cf5cfd.png)](https://docs.epsio.io/?utm_source=pgwk22) [Boosting Query Performance with Incremental Materialized Views!](https://docs.epsio.io/?utm_source=pgwk22) — Boost the performance of your most complex queries by plugging Epsio into your database. Epsio constantly prepares and updates results for queries you define whenever the underlying data changes, without ever recalculating the entire dataset. Epsio sponsor **IN BRIEF:** - **AWS RDS for PostgreSQL [now supports Postgres 16.1.](https://aws.amazon.com/about-aws/whats-new/2023/11/amazon-rds-postgresql-major-version-16/)** Postgres 16 is also [GA on Azure Database for PostgreSQL](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/general-availability-of-postgresql-16-on-azure-database-for/ba-p/3980354) too. - 📗 Luca Ferrari and Enrico Pirozzi [have unveiled](https://fluca1978.github.io/2023/11/21/LearnPostgreSQLSecondEdition.html) the second edition of their book [_Learn PostgreSQL_](https://www.packtpub.com/product/learn-postgresql-second-edition/9781837635641), as published by Packt. - [Bruce Momjian reflects](https://momjian.us/main/blogs/pgblog/2023.html#November_20_2023) on a mailing list thread from 2021 that pondered whether SQL was a good thing or not. _Unsurprising spoiler: Bruce loves SQL._ [Designing Your Database for Multi-Tenancy](https://www.crunchydata.com/blog/designing-your-postgres-database-for-multi-tenancy) — Craig digs into multi-tenancy apps, sharding, and the role the Citus extension can play to manage such situations. He gives several approaches to data design so you’ll be better prepared to scale if, and when, the time comes. Craig Kerstiens (Crunchy Data) [Running Postgres on s390x (i.e. IBM Mainframes)](https://www.cybertec-postgresql.com/en/postgresql-on-s390x/) — Postgres is gaining support for a not-so-new architecture in the shape of IBM’s Z-series mainframe architecture, known as `s390x` in Debian. A build machine has been provided by Marist College’s LinuxOne cloud. Christoph Berg [How to Use pgvector for Similarity Search on Heroku](https://blog.heroku.com/pgvector-for-similarity-search-on-heroku-postgres) — Heroku Postgres [announced support](https://blog.heroku.com/pgvector-launch) for pgvector a few weeks ago, and here’s the obligatory ‘how to use it’ post. Valerie Woolard (Heroku) [Experiencing WAL REDO in Postgres](https://www.highgo.ca/2023/11/18/experiencing-wal-redo-in-postgresql/) — A technical look at the steps involved in adding a piece of customized information as an XLOG record for use during WAL REDO. David Zhang [PostgreSQL 101 Webinar: Database Monitoring and Optimization](https://www.red-gate.com/hub/events/postgresql-101-database-monitoring-and-optimization?utm_source=postgresweekly&utm_medium=email&utm_campaign=postgres) Redgate sponsor [Citus Live Query Inspection with `citus_stat_activity`](https://www.cybertec-postgresql.com/en/citus-live-query-inspection-using-citus_stat_activity/) — How to use `citus_stat_activity` to get all the information about your shards in one go. Hans-Jürgen Schönig [Teaching Postgres New Tricks: SIMD Vectorization for Faster Analytical Queries](https://www.timescale.com/blog/teaching-postgres-new-tricks-simd-vectorization-for-faster-analytical-queries/) James Blackwood-Sewell (Timescale) [Fast Switchovers with PgBouncer on Amazon RDS Multi-AZ Deployments with Two Readable Standbys](https://aws.amazon.com/blogs/database/fast-switchovers-with-pgbouncer-on-amazon-rds-multi-az-deployments-with-two-readable-standbys-for-postgresql/) Khodorkovskiy and Jain (AWS) Code and Tools [River: A Fast, Robust Job Queue for Go and Postgres](https://brandur.org/river) — A new in-beta, open-source job queue “_for building fast, airtight applications_” that’s written in Go and takes advantage of generics. It uses [pgx](https://github.com/jackc/pgx) to interface with Postgres. Brandur Leach [pgcopydb: Copy a Postgres Database to a Target Postgres Server](https://github.com/dimitri/pgcopydb) — Automates and provides a little structure around the running of `pg_dump | pg_restore` between two running Postgres servers. Dimitri Fontaine [PGSync 3.0: A Postgres to Elasticsearch Syncing Tool](https://github.com/toluaina/pgsync) — Middleware for syncing Postgres to Elasticsearch so you can expose denormalized documents in Elasticsearch for querying. Now MIT licensed. Tolu Aina - [PostGIS Patch Releases](https://postgis.net/2023/11/PostGIS-Patch-Releases/) – Namely 3.4.1, 3.3.5, 3.2.6, 3.1.10, and 3.0.10. - [Orafce 4.7](https://github.com/orafce/orafce) – Oracle Database compatibility functions and packages for Postgres. - [pg-mem 2.7.2](https://github.com/oguimbal/pg-mem) – In-memory emulated Postgres for unit testing in JavaScript. - [Pgpool-II 4.5 Beta 1](https://www.postgresql.org/about/news/pgpool-ii-45-beta1-is-now-released-2751/) – Connection pooling and balancing. **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|*).