Chapter 10. Scaling Your Database with PL/Proxy
If you have followed the advice in the previous chapters for doing all your database access through functions, you are in a great position to scale your database by horizontally distributing the data over multiple servers, also known as database sharding. Horizontal distribution means that you keep just a portion of a table on each partition of the database, and that you have a method to automatically access the right database when accessing the data.
We will gently introduce the concepts leading to the PL/Proxy partitioning language, and then delve into the syntax and proper usage of the language itself. Let's start with writing a scalable application from scratch. First, we will write it to be as ...
Get PostgreSQL Server Programming - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
