--- title: "The Postgres 15 afterglow" publication: "Postgres Weekly" issue: 477 published_at: "2022-10-19" canonical_url: "https://postgresweekly.com/issues/477" --- Plus why Materialize chose Postgres's wire protocol, a database podcast, and PostgresML 2.0 is released. | ✏️ In case you missed last week's slightly unusual 'newsflash' issue: [Postgres 15 was released last week.](https://postgresweekly.com/issues/476) __ _Peter Cooper, your editor_ #​477 — October 19, 2022 [Web Version](https://postgresweekly.com/issues/477) 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/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/jmtp5gbajpbojzbvdgpp.jpg)](https://supabase.com/blog/postgres-full-text-search-vs-the-rest) [Postgres Full Text Search vs.. Some Others](https://supabase.com/blog/postgres-full-text-search-vs-the-rest) — As long as you are aware of the limitations (or work around them), Postgres’s [full text search](https://www.postgresql.org/docs/current/textsearch.html) features can take you a _long_ way. Victor shows off the basics and compares what Postgres offers to a few popular, modern alternatives. This article provoked [extensive discussion on Hacker News](https://news.ycombinator.com/item?id=33203370) that went a little deeper. Victor Vados [A Look at Postgres 15: The `MERGE` Command with Examples](https://www.crunchydata.com/blog/a-look-at-postgres-15-merge-command-with-examples) — One of Postgres 15’s headline new features is support for the SQL standard `MERGE` statement. Where you might have once used `UPSERT .. ON CONFLICT`, `MERGE` can now do the heavy lifting of synchronizing tables by inserting, updating, and deleting rows based on differences between tables – Jean-Paul shows us a use case. Jean-Paul Argudo [![\](https://copm.s3.amazonaws.com/559cea64.png)](https://www.polyscale.ai/) [Less Plugging, More Play. Scale Postgres in Minutes](https://www.polyscale.ai/) — PolyScale is an intelligent, serverless database edge cache. Using PolyScale, you can distribute your database compute and storage globally, dramatically lowering latency for data-driven applications. PolyScale.ai sponsor [How and Why a Streaming Database 'Presents' as Postgres](https://materialize.com/blog/postgres-compatibility/) — [Materialize](https://materialize.com/) is a distributed SQL database that _isn’t_ Postgres, but like many up and coming database systems, can _'speak'_ Postgres’s wire protocol to offer interoperability. This post is an interesting, yet rare, look at why database developers are increasingly making this decision. Andy Hattemer (Materialize) [Be Ready for Postgres 15's `public` Schema Changes](https://www.crunchydata.com/blog/be-ready-public-schema-changes-in-postgres-15) — Postgres 15 has introduced changes to privileges relating to the `public` schema you need to be prepared for – luckily you can benefit from Paul’s advice even before upgrading. Paul Ramsey **IN BRIEF:** - [Amazon Aurora now supports Postgres 14.4](https://aws.amazon.com/about-aws/whats-new/2022/10/amazon-aurora-postgresql-14-4-version/). - Amazon RDS's _"Preview Environment"_ is [providing access to Postgres 15 RC 2](https://aws.amazon.com/about-aws/whats-new/2022/10/postgresql-15-candidate-2-amazon-rds-database-preview-environment/) for your testing purposes. - 🎧 If you're looking for a database-aligned podcast, we've recently been enjoying ["More than a Refresh"](https://www.commandprompt.com/about/more-than-a-refresh/) a great deal. It's an interview led show focusing on the people working with data systems every day. - _Azure PostgreSQL Flexible Server_ has [three new backup/restore enhancements](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/azure-postgresql-flexible-server-has-three-exciting-new-backup/ba-p/3649253) oriented around speed and resilience. [Updates Getting Slower? Causes and Remedies](https://www.cybertec-postgresql.com/en/why-are-my-postgresql-updates-getting-slower/) — If things are getting slower and slower and sl_oooo_wer the more you’re updating a table, you’ve got a problem you need to resolve quickly. Laurenz shows off one such cause. Laurenz Albe [Postgres 15's Configuration Changes](https://blog.rustprooflabs.com/2022/10/postgres-15-config-changes) — A quick look at some of the changes in Postgres 15’s `postgresql.conf` options (of which there are 6 new items, 3 changed items, and 1 removed item - _au revoir_, `stats_temp_directory`). Ryan Lambert [Spinning Up a Performance Testing Framework for Aurora PostgreSQL](https://aws.amazon.com/blogs/database/configure-a-performance-testing-framework-for-amazon-aurora-postgresql/) — How to use CloudFormation, Apache JMeter, and Python to build a performance testing framework for Postgres-based Aurora databases. Amazon Web Services [Using `pg_upgrade` to Upgrade Postgres 9.6 and PostGIS 2.4 to Postgres 15 3.3 with `yum`](https://www.bostongis.com/blog/index.php?/archives/278-Using-pg_upgrade-to-upgrade-PostgreSQL-9.6-PostGIS-2.4-to-PostgreSQL-15-3.3-on-Yum.html) — It’s always good to follow someone else’s trodden path with these sorts of migrations. Regina Obe 📅 [Register for Unblock 22 - A CI/CD Conference by Buildkite](http://buildkite.com/unblock?utm_campaign=CPress&utm_source=ppc&utm_medium=Q4-2022-Postgres%20Weekly&utm_term=Sign-Up-Unblock) Buildkite sponsor [Upgrading Postgres 14 to 15 on Red Hat Derived Distros with PGDG RPM Packages](https://www.endpointdev.com/blog/2022/10/upgrading-postgresql-14-to-15-on-fedora-centos-rocky-alma-linux/) — Think Fedora, RHEL, CentOS, Rocky, Alma Linux, etc. Jon Jensen [Global Indexes: A Different Approach?](https://www.highgo.ca/2022/10/14/global-index-a-different-approach/) — This is _not_ a Postgres feature (yet) but David thinks about an approach to having a global index for a partitioned table. David Zhang [Microsoft Announces PostgreSQL Option for Cosmos DB](https://thenewstack.io/microsoft-announces-postgresql-option-for-cosmos-db/) Andrew Brust (The New Stack) [Running Postgres in Kubernetes: Solutions, Pros and Cons](https://www.percona.com/blog/run-postgresql-in-kubernetes-solutions-pros-and-cons/) Sergey Pronin (Percona) 🛠 Code and Tools [pg_enquo: A Way to Securely Query Against Encrypted Data](https://enquo.org/components/pg_enquo/) — [Enquo](https://enquo.org/) (standing for “ENcrypted QUery Operations”) is an admittedly niche (for now) approach as it also requires client support (currently only in Rust and Ruby) but it’s interesting to see experiments in this important area. Matt Palmer [OxideDB: Teach Postgres How to Speak MongoDB's Wire Protocol](https://github.com/fcoury/oxide) — A translation layer that looks like a MongoDB database server while using PostgreSQL’s JSON capabilities as the underlying data store. Felipe Coury [PostgresML 2.0: Train Models and Make Predictions from SQL](https://github.com/postgresml/postgresml) — _“You train models using simple SQL commands, and you get the predictions in your apps via a mechanism you’re already using: a query over a standard Postgres connection.”_ v2.0 is a 1.0-compatible [complete rewrite in Rust](https://postgresml.org/blog/postgresml-is-moving-to-rust-for-our-2.0-release/). Lev Kokotov and Montana Low - [Ora2Pg 23.2](https://www.postgresql.org/about/news/ora2pg-232-released-2523/) ↳ Oracle database to Postgres migration tool. - [AgensGraph 2.13](https://www.postgresql.org/about/news/announcing-the-release-of-agensgraph-213-2527/) ↳ Multi-model graph database based on Postgres. - [pgsql_tweaks 0.10.1](https://proopensource.it/blog/pgsql_tweaks-0-10-1-released) ↳ A [variety](https://github.com/sjstoelting/pgsql-tweaks#table-of-content) of helper functions. **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|*)