--- title: "This is the greatest database in the world.. tribute." publication: "Postgres Weekly" issue: 481 published_at: "2022-11-16" canonical_url: "https://postgresweekly.com/issues/481" --- Plus a look at Postgres's async IO future, a bevy of bugfix releases, and say goodbye to Windows XP. | #​481 — November 16, 2022 [Web Version](https://postgresweekly.com/issues/481) Together with [![Polyscale\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_300,h_160/e_make_transparent/co_white,e_outline:7/rrkstxca0vg7e1eww6yw.jpg)](https://www.polyscale.ai/blog/database-edge-caching-with-deno-deploy/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/dzp2oov9fbur0lggxlnp.jpg)](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/reducing-replication-lag-with-io-concurrency-in-postgres-15/ba-p/3673169) [Reducing Replication Lag with I/O Concurrency in Postgres 15](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/reducing-replication-lag-with-io-concurrency-in-postgres-15/ba-p/3673169) — Postgres 15 comes with key replication improvements, but the work done to get there was deep. This post explains how IO concurrency affects replication lag but _also_ tells the story of how Postgres’s IO story is improving over time and teases a future where data will be asynchronously transferred into Postgres’s buffers avoiding the kernel entirely. _“We’ve only scratched the surface,”_ says Thomas. Thomas Munro (Microsoft) [![\](https://copm.s3.amazonaws.com/a5662f2e.png)](https://www.polyscale.ai/blog/database-edge-caching-with-deno-deploy/) [Using Postgres with Deno Deploy](https://www.polyscale.ai/blog/database-edge-caching-with-deno-deploy/) — Accessing Postgres data at the edge presents new challenges with multi-region connectivity and latencies. Learn how to solve these in minutes with PolyScale’s plug-and-play database edge cache. PolyScale.ai sponsor [PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released](https://www.postgresql.org/about/news/postgresql-151-146-139-1213-1118-and-1023-released-2543/) — A bevy of bug fix releases for maintained release lines. None of the bugs _particularly_ stand out, but are listed in this post. We also get time zone data updates due to DST changes in various countries. It also marks the final v10 release. PostgreSQL Global Development Group [![\](https://res.cloudinary.com/cpress/image/upload/w_200,e_sharpen:60,q_auto/sxasogg3ntzbqluesd8y.png)](https://jkatz05.com/post/postgres/postgres-10-tribute/) [A Tribute to 2017's Postgres 10](https://jkatz05.com/post/postgres/postgres-10-tribute/) — Five years after each major Postgres release, the tide heads out and that version hits its ‘end of life’ (EOL) after [a final farewell release](https://www.postgresql.org/about/news/postgresql-151-146-139-1213-1118-and-1023-released-2543/) (more info about this in the [versioning policy document](https://www.postgresql.org/support/versioning/).) Jonathan indulges in some nostalgia for what was a ‘transformative’ version of Postgres that introduced logical replication, declarative partitioning, and SCRAM authentication. Jonathan Katz **IN BRIEF:** - **AWS RDS [now supports gp3 storage volumes](https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-rds-general-purpose-gp3-storage-volumes/).** This gives you more flexibility about defining the _performance_ of your storage independent of its size, so you can tweak max IOPS and MB/sec throughput to your heart's content. - 🟥 🟩 🟦 🟨**Windows XP?** If you've ever doubted the core team's commitment to testing Postgres on older platforms, consider that Andrew Dunstan has [only just decommissioned his Windows XP machine](http://adpgtech.blogspot.com/2022/11/goodbye-windows-xp.html) as part of Postgres 10's end of life – yes, Postgres 10 supported it! - [Amazon Aurora has upgraded](https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-aurora-supports-postgresql-versions-logical-replication-cache/) to Postgres 14.5, 13.8, 12.12, and 11.17 (these are all one minor version behind the latest releases mentioned above). There's also a logical replication performance improvement. [EXPLAIN That Parameterized Statement](https://www.cybertec-postgresql.com/en/explain-that-parameterized-statement/) — The output of `EXPLAIN` (`ANALYZE`, `BUFFERS`) is always useful, but can be hard to get for a parameterized statement. Unless you have some of Laurenz’s tips in your back pocket.. Laurenz Albe [What is an 'Upsert' and When Should You Use One?](https://www.cockroachlabs.com/blog/sql-upsert/) — This comes from CockroachDB but covers the use of the same idea in Postgres by way of `INSERT ON CONFLICT`. (Postgres 15’s [`MERGE`](https://www.crunchydata.com/blog/a-look-at-postgres-15-merge-command-with-examples) provides another approach.) Charlie Custer [Free eBook: How to Create the Best Postgres Index for Your Queries](https://pganalyze.com/ebooks/postgres-indexing?utm_source=PostgresWeeklySecondary11162022) pganalyze sponsor [Read Before You Upgrade: Best Practices for Choosing a Postgres Version](https://www.timescale.com/blog/read-before-you-upgrade-best-practices-for-choosing-your-postgresql-version/) — Reflections on when to consider upgrading your Postgres version and questions to ask before you start doing so. _(As a Timescale article, Timescale’s own managed service does get recommended, but at the end.)_ Laurence, Roybal and Godeke (Timescale) [JSON in PostgreSQL: The Ultimate Guide](https://www.databasestar.com/postgresql-json/) — I encountered this when putting together some JSONB queries this week and found it useful. Ben Brumm [Postgres at Scale: Running Multiple PgBouncers](https://www.crunchydata.com/blog/postgres-at-scale-running-multiple-pgbouncers) — Connection pooling with [pgBouncer](https://access.crunchydata.com/documentation/pgbouncer/latest/) is great, but at particularly high loads, there are benefits to be had with running _multiple_ pgBouncers. Elizabeth Christensen [How to Recreate `ROW CHANGE TIMESTAMP` from IBM Db2 on Amazon RDS or Aurora](https://aws.amazon.com/blogs/database/migrate-row-change-timestamp-from-ibm-db2-for-z-os-to-amazon-rds-for-postgresql-or-amazon-aurora-postgresql-compatible-edition/) — In Db2, a column created with `ROW CHANGE TIMESTAMP` always contains a timestamp of when the row was last modified. Can you do this in Postgres too? Triggers to the rescue. Amazon Web Services [How to Schedule Automatic Backups with pgAgent in pgAdmin](https://www.digitalocean.com/community/tutorials/how-to-schedule-automatic-backups-for-postgresql-with-pgagent-in-pgadmin) Horcasitas and Tran 🛠 Code and Tools [Improved Aarch64 (arm64) Support Now Available in the Postgres RPM Repository](https://people.planetpostgresql.org/devrim/index.php?/archives/121-Improved-aarch64-arm64-support-is-available-in-the-PostgreSQL-RPM-repository..html#improvedaarch64) — You’ve been able to install aarch64/ARM64 architecture Postgres rpm packages for a while, but some focus has been put into full RHEL 9 support, improved support and fixes for RHEL 7 and 8, and more. David Detter - [npgsql 7.0](https://github.com/npgsql/npgsql) ↳ .NET data provider for Postgres. - [VS Code SQLTools 0.26](https://github.com/mtxr/vscode-sqltools) ↳ Database management for VS Code. - [pgsync 0.7.3](https://github.com/ankane/pgsync) ↳ Sync data from one Postgres database to another. - [Pgpool-II 4.4 Beta 1](https://www.postgresql.org/about/news/pgpool-ii-44-beta1-is-now-released-2545/) ↳ Connection pooling, load balancing, and more. - [Pyrseas 0.10.0](https://www.postgresql.org/about/news/pyrseas-0100-is-now-available-2540/) ↳ Utilities for versioning PG database schemas. - [PostGIS 3.3.2, 3.2.4, 3.1.8 and 3.0.8](https://postgis.net/2022/11/13/postgis-3.3.2-3.2.4-3.1.8-3.0.8-patch-releases/) ↳ Geospatial goodness. _And last, but not least:_ - [PostGIS 2.5 has reached EOL too](https://postgis.net/2022/11/12/postgis-2.5.9-eol/) with version 2.5.9. **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|*)