Scaling with PL/Proxy

Scaling with PL/Proxy

Do you have to work with millions of customers every day or manage billions of rows inside your database system? Maybe it’s time to scale beyond the limitations of a single server and enter into the world of endless scalability.

PL/Proxy offers incredible scalability and superior throughput for large database setups. Enjoy all the flexibility of a full-blown relational database server and benefit from the scalability of a professional software solution.

The traditional way of scaling PostgreSQL OLTP workloads

PL/Proxy is the traditional way to scale out PostgreSQL. It is no longer as important as it used to be, but for many years it has been pretty much the only way to scale out PostgreSQL.
The idea behind PL/Proxy is to provide a stored procedure language, which is only there to scale out close to infinitely. For many years PL/Proxy was key to scaling OLTP beyond a single machine.

PL/Proxy is simple to use and offers a variety of important features:

• PL/Proxy can call remote stored procedures with the same signature (function name and parameters)
• PL/Proxy can call remote stored procedures with the same signature (function name and parameters)
• Function can be run on one, some or all members of the PostgreSQL cluster
• If query is executed on several partitions, execution can happen in parallel.
• Queries can be run in auto-commit mode on the servers inside the cluster.
• Query parameters are sent separately from query body, thus avoiding quoting/unquoting overhead on all sides

If you would like to learn more about scaling with PL/Proxy, contact our team of experts today.

Professional help

Contact us today to receive your personal offer from CYBERTEC. We offer timely delivery, professional handling, and 20 years of PostgreSQL experience.