PostgreSQL provides read scalability capabilities, owing to Hot Standby and Streaming Replication, two longstanding and popular features. While this is commonly known, there are a number of issues which become apparent only while performing the actual implementation. For instance:
In this presentation we will describe the implementation of a read-scalable architecture, from the perspective of how the above issues were tackled, and how successfully. Finally, we will also consider improvements such as multiple synchronous standby nodes, or the new durability level, introduced in PostgreSQL 9.6. |