--- title: "Amazon RDS adds PL/Rust" publication: "Postgres Weekly" issue: 507 published_at: "2023-05-24" canonical_url: "https://postgresweekly.com/issues/507" --- Plus a sneak peek at the Postgres 16 release notes. | #​507 — May 24, 2023 [Web Version](https://postgresweekly.com/issues/507) Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://pganalyze.com/?utm_source=PostgresWeeklyPrimary05242023) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/xv7zxdw7y5twqnahnjvx.jpg)](https://aws.amazon.com/blogs/database/build-high-performance-functions-in-rust-on-amazon-rds-for-postgresql/) [Building High-Perf Functions in Rust on Amazon RDS](https://aws.amazon.com/blogs/database/build-high-performance-functions-in-rust-on-amazon-rds-for-postgresql/) — Amazon RDS for PostgreSQL now supports trusted [PL/Rust](https://github.com/tcdi/plrust), opening up a new opportunity for building stored procedures in Rust for Postgres on the popular cloud provider. This post walks through a complete example. We expect to see some interesting use cases spring up from this! Jonathan Katz (AWS) [The Draft Postgres 16 Release Notes](https://www.postgresql.org/docs/devel/release-16.html) — We’re still several months away from a final Postgres 16 release, but Bruce Momjian has been [hard at work](https://momjian.us/main/blogs/pgblog/2023.html#May_19_2023) and finished the first draft of the eventual Postgres 16 release notes. _“The release note feature count is 199, which is 7% higher than the average count of the previous five releases.”_ PostgreSQL Documentation [![\](https://copm.s3.amazonaws.com/2a4a0f32.png)](https://pganalyze.com/?utm_source=PostgresWeeklyPrimary05242023) [Postgres Performance at Any Scale](https://pganalyze.com/?utm_source=PostgresWeeklyPrimary05242023) — Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling. Take control of your Postgres workload and query plans and empower **all** development teams to fix slow queries. Try pganalyze today. pganalyze sponsor [Tags and Arrays: A Purrrrfect Combination?](https://www.crunchydata.com/blog/tags-aand-postgres-arrays-a-purrfect-combination) — One for both cat and tag lovers. If you need to model a tagging system in your database, there are several approaches. Paul reviews and benchmarks a relational many-to-many table approach as well as using Postgres’s native array support while suggesting why you might choose either option. Paul Ramsey **IN BRIEF:** - Timescale, best known for their Postgres-based TimescaleDB time series extension, have [sort of rebranded:](https://www.timescale.com/blog/announcing-the-new-timescale/) _"We used to be a database company with a cloud product. Now we are a cloud company with a database product."_ [TimescaleDB](https://github.com/timescale/timescaledb) remains open source, happily. - [A look at using AI to help choose](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/idea-for-gpt-plugin-citus-shard-key-selection-in-postgres/ba-p/3829172) a shard key when working with Citus. - 📕 Ruby on Rails developer? [High Performance PostgreSQL on Rails](https://pgrailsbook.com/) is an in-development book (to be published by _Pragmatic Bookshelf_) you can register an interest in. [Tuning Postgres and the New Insert Benchmark](https://smalldatum.blogspot.com/2023/05/tuning-postgres-for-insert-benchmark.html) — If you’ve been using Postgres a while it’ll be no surprise that tuning your config settings can have an outsized effect on performance, but few folks seem to (publicly) benchmark as wide a variety of configs as this. Mark Callaghan [Visualizing IoT Data at Scale with Hopara and TimescaleDB](https://www.timescale.com/blog/visualizing-iot-data-at-scale-with-hopara-and-timescaledb/) — Yes, _that_ [Michael Stonebraker](https://en.wikipedia.org/wiki/Michael_Stonebraker), co-founder of the 'post-Ingres' effort that formed the Postgres we know today. How many other people can start a blog post with _"I have been involved in building DBMSs for 50 years"_? Michael Stonebraker [Five Ways to Get Table Creation Information](https://www.crunchydata.com/blog/5-ways-to-get-table-creation-information-in-postgres) — When was a table created? The author covers five(!) places where you can get such information about Postgres objects. Greg Sabino Mullane [Migrating Generated Columns to Postgres using AWS Database Migration Service](https://aws.amazon.com/blogs/database/migrate-generated-columns-to-postgresql-using-aws-database-migration-service/) — From databases like SQL Server or Oracle, say. Karimi and Gopalappa (AWS) Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/f3iqqxlvkwtdcjzegcyi.jpg)](https://github.com/AdmTal/PostgreSQL-Query-Lock-Explainer) [Postgres Query Lock Explainer](https://github.com/AdmTal/PostgreSQL-Query-Lock-Explainer) — As the author says: _“it’s kind of like EXPLAIN but it tells you about what locks would be required by the query.”_ Written in Python. Adam Tal - [pgmetrics 1.15](https://www.postgresql.org/about/news/pgmetrics-115-released-2641/) ↳ Now supports Pgpool 4.x+. - [pg-online-schema-change / pg-osc 0.9](https://github.com/shayonj/pg-osc) ↳ CLI tool for zero downtime schema changes. - [Supabase Postgres Meta 0.65](https://github.com/supabase/postgres-meta) ↳ A RESTful API for managing Postgres. - [Remult 0.20.2](https://github.com/remult/remult) ↳ Full-stack TypeScript CRUD framework. - [PostgresML 2.4.6](https://github.com/postgresml/postgresml) – Machine learning from SQL. - [pgModeler 1.0.4](https://pgmodeler.io/) – Postgres data modelling tool. **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|*)