# Scaling Stored Procedures

DevFeed: [Scaling Stored Procedures](<https://devfeed.tech/articles/scaling-stored-procedures-34460.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2011/10/scaling-stored-procedures/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2011-10-06T16:23:00Z

Content type: opinion

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>), [Architecture & Design](<https://devfeed.tech/topics/architecture-design.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [cluster](<https://devfeed.tech/tags/cluster.md>), [database](<https://devfeed.tech/tags/database.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [stored-procedures](<https://devfeed.tech/tags/stored-procedures.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [version](<https://devfeed.tech/tags/version.md>)

## AI overview

The article argues that stored procedures do not inherently prevent database scalability. It describes PostgreSQL Extensions for managing procedure code and versions, and PLproxy for scaling out across database shards with a shared procedural API.

## Source excerpt

In the news recently stored procedures where used as an excuse for moving away logic from the database layer to application layer, and to migrate away from a powerful technology to a simpler one, now that there's no logic anymore in the database. It's not the way I would typically approach scaling problems, and apparently I'm not alone on the Stored Procedures camp. Did you read this nice blog post Mythbusters: Stored Procedures Edition already? Well it happens in another land that where my comfort zone is, but still has some interesting things to say.