--- title: "Postgres extensions even Amazon can trust" publication: "Postgres Weekly" issue: 484 published_at: "2022-12-07" canonical_url: "https://postgresweekly.com/issues/484" --- Plus speaking opportunities at Postgres events, some Postgres tips, and Postgres 14+'s multi range types. | #​484 — December 7, 2022 [Web Version](https://postgresweekly.com/issues/484) 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/amazon-rds-reducing-costs-increasing-performance/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/qoqb9smpem7n1pk6fqzc.jpg)](https://aws.amazon.com/blogs/aws/new-trusted-language-extensions-for-postgresql-on-amazon-aurora-and-amazon-rds/) [Amazon's _Trusted Language Extensions_ for Postgres](https://aws.amazon.com/blogs/aws/new-trusted-language-extensions-for-postgresql-on-amazon-aurora-and-amazon-rds/) — Amazon’s Aurora and RDS Postgres platforms both run [~85 popular Postgres extensions](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Extensions.html) but beyond that you’re out of luck. Given the power extensions have, Amazon doesn’t want users to install extensions arbitrarily so has come up with `pg_tle`, a solution for building secure extensions around a permissions model that platforms like RDS or Aurora _can_ be happy with. Could this idea take off more generally across the Postgres space? We shall see. Channy Yun (AWS) [![\](https://copm.s3.amazonaws.com/c648e5c7.png)](https://www.polyscale.ai/blog/amazon-rds-reducing-costs-increasing-performance/) [Faster, Cheaper Postgres on Amazon RDS](https://www.polyscale.ai/blog/amazon-rds-reducing-costs-increasing-performance/) — Learn how to dramatically increase query performance and lower costs when running Postgres on RDS. PolyScale is an intelligent, serverless database cache that can be connected in minutes, without writing code. PolyScale.ai sponsor [Neon's Serverless Postgres Platform Now Live to All](https://neon.tech/blog/neon-serverless-postgres-is-live/) — Invite gate be gone! _Neon_ is an interesting new entrant to the world of Postgres platforms ([first unveiled](https://neon.tech/blog/hello-world/) back in June) with a split storage and compute approach allowing them to offer a 'serverless' elastically scaling experience. As with the MySQL-oriented [PlanetScale](https://planetscale.com/), branching is also a headline feature. One to keep an eye on. Neon [Instacart on Dropping Postgres for Amazon DynamoDB](https://thenewstack.io/iso-better-scaling-instacart-drops-postgres-for-amazon-dynamodb/) — Odd vibe to this post, but an interesting look behind the scenes at Instacart’s scaling-motivated switch _from_ Postgres to DynamoDB. The engineering team shares the schema design that reduced their number of billable writes-per-transaction by over half. Jessica Wachtel **IN BRIEF:** - 🇫🇷 📅 A call for papers for _pgDay Paris 2023_ [is open.](https://2023.pgday.paris/call-for-papers/) The deadline for proposals is January 6, 2023 and the event takes place in Paris (_quelle surprise!_) in March 2023. - A ton of [bitesize Postgres tips](https://www.crunchydata.com/postgres-tips) (mostly one liners). - In anticipation of next year's _Citus Con_ Postgres conference, Microsoft's Claire Giordano has updated her handy [Why Give a Postgres Talk](https://www.citusdata.com/blog/2022/01/11/why-give-a-conference-talk/) post. If you decide it's a good idea, [the CFP for Citus Con 2023](https://www.citusdata.com/cituscon/2023/cfp/) is open until February 5, 2023. - Talking of Citus Con, [▶️ all 38 talks from Citus Con 2022](https://www.youtube.com/playlist?list=PLlrxD0HtieHjSzUZYCMvqffEU5jykfPTd#cituscon2022) are in a handy to watch YouTube playlist. [Picking a Random Element.. with Weights](https://www.depesz.com/2022/11/30/picking-random-element-with-weights/) — Let’s say you need to generate a large table full of sample data and want the distribution of that data to match certain requirements? Hubert has the `weighted_random` function for you. Hubert 'depesz' Lubaczewski **A few older posts we missed:** [Better Range Types in Postgres 14+: Turning 100 Lines of SQL Into 3](https://blog.crunchydata.com/blog/better-range-types-in-postgres-14-turning-100-lines-of-sql-into-3) — Multi range types can provide a little extra power to some pure SQL solutions.. an example of which is provided here. Jonathan S. Katz [Soft Deletion with Postgres: Writing the Logic in Postgres Itself](https://evilmartians.com/chronicles/soft-deletion-with-postgresql-but-with-logic-on-the-database) — If you’d rather not implement soft deletion (marking records as hidden rather than deleting them) in your main application language, you could use “rules” to do it directly in Postgres. Kozin and Turner [Replacing Lines of Code with 2 Little Regexes in Postgres](https://blog.crunchydata.com/blog/replacing-lines-of-code-with-2-little-regexs-in-postgresql) Steve Pousty 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/atg4ysujbp4ybqk0qqvx.jpg)](https://www.db-fiddle.com/) [DB Fiddle: An SQL Database Playground](https://www.db-fiddle.com/) — I frequently find this tool useful for testing out little bits of SQL and it now supports Postgres 15 too (in addition to various versions of MySQL and SQLite). Status200 [pg_stat_monitor 1.1.1: Query Performance Monitoring Tool](https://github.com/percona/pg_stat_monitor) — If you were having problems with running it on Postgres 15, 1.1.1 fixes this. Percona [Identity-Native Infrastructure Access for PostgreSQL?](https://goteleport.com/resources/books/indentity-native-infrastructure-access-management/?utm_campaign=eg&utm_medium=partner&utm_source=postgres) Teleport | goteleport․com sponsor [pg_hint_plan: Manually Force Decisions in Execution Plans](https://github.com/ossc-db/pg_hint_plan) — Postgres 15 support has _just_ been committed. NTT OSS Center DBMS Development and Support Team - [pgAdmin 4 v6.17](https://www.postgresql.org/about/news/pgadmin-4-v617-released-2553/) ↳ Popular, long standing web-based management tool. - [Pgpool-II 4.4.0](https://www.postgresql.org/about/news/pgpool-ii-440-is-now-released-2554/) ↳ Connection pooling and load balancing tool. - [FerretDB 0.7](https://github.com/FerretDB/FerretDB) ↳ MongoDB alternative built atop Postgres. - [pg_graphql 0.5.3](https://github.com/supabase/pg_graphql) ↳ GraphQL support for Postgres. - [sqldef 0.15](https://sqldef.github.io/) ↳ Idempotent schema management CLI tool. - [Piccolo 0.99](https://github.com/piccolo-orm/piccolo) ↳ Python ORM and query builder with `asyncio` - [Antares 0.7](https://antares-sql.app/) ↳ Cross platform visual database client. - [Evolve 3.1](https://evolve-db.netlify.app/) ↳ Flyway-inspired migration tool for .NET (Core) **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|*)