Making Postgres stored procedures 9X faster in Citus

This post by Marco Slot about Postgres stored procedures in Citus was originally published on the Azure Postgres Blog on Microsoft TechCommunity. Stored procedures are widely used in commercial relational databases. You write most of your application logic in PL/SQL and achieve notable performance gains by pushing this logic into the database. As a result, customers who are looking to migrate from other databases to PostgreSQL usually make heavy use of stored procedures. When migrating from a large database, using the Citus extension to distribute your database can be an attractive option, because you will always have enough hardware capacity to power your workload.