On a db.m6i.xlarge RDS for PostgreSQL instance, this took about 3 seconds to compile. # For PostgreSQL 15.3 and higher versionsĬREATE OR REPLACE FUNCTION public.array_sum(x float8) Using the AWS Command Line Interface (AWS CLI), you can create a DB parameter group that adds plrust to the shared_preload_libraries parameter: Additionally, you’ll need to add plrust to the shared_preload_libraries parameter into a DB parameter group and assign the DB parameter group to your database instance. To run the examples in this post, you’ll need to provision an RDS for PostgreSQL instance or Multi-AZ DB cluster running PostgreSQL 15.2 or higher. We also look at a use case that involves a lot of computations, and see how writing it in PL/Rust compares to PL/pgSQL and PL/v8 (JavaScript). In this post, we show how to deploy an RDS for PostgreSQL instance with PL/Rust enabled, and review several examples for how to write high-performance Rust code directly in your database. Also, all of these languages are interpreted, which means that there may be performance overhead when executing functions written in these languages. For example, PL/pgSQL, PostgreSQL’s native procedural language, is convenient for writing trigger functions and multi-step procedures that may interface with built-in PostgreSQL functions. Each programming language has benefits, and choosing a language may come down to what problem you’re solving or your familiarity with the programming language. In addition to PL/Rust, Amazon RDS for PostgreSQL supports several trusted programming languages, including PL/pgSQL, PL/Perl, PL/v8 (JavaScript), and PL/Tcl. The property of being a “trusted” programming language in PostgreSQL makes it possible to build Trusted Language Extensions for PostgreSQL, using the open-source pg_tle project, and safely run them in production systems. PostgreSQL designates languages as “trusted” or “untrusted,” where a “trusted” language is safe for an unprivileged user to use without risk of privilege escalation. PostgreSQL gives developers choices in what programming languages you can use through its procedural language system, and the open-source community maintains a wiki page that lists available procedural languages.

Stored procedures in databases help developers build code that can perform calculations on data and reduce latency to the application, apply follow-up actions on data modifications, and simplify data visualization. For more information on how PL/Rust works, see the PL/Rust Guide. You can also use PL/Rust to build Trusted Language Extensions for PostgreSQL with performance benefits that are comparable to writing code in C without the risk of unsafe memory access. PL/Rust is an open-source project that lets you write Rust code that runs directly inside a PostgreSQL database, and provides support for PostgreSQL features such as running queries, writing trigger functions, and logging output. Amazon Relational Database Service (Amazon RDS) for PostgreSQL now supports trusted PL/Rust, allowing developers to safely build high-performance database functions in the Rust programming language.

Postgresql function array parameter