CYBERTEC PostgreSQL Logo

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.

Scaling PL/Proxy

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.

CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram