This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2016

Read Scalability with PostgreSQL: issues and solutions

Date: 2016-11-02
Time: 16:20–17:10
Room: Alfa 1
Level: Intermediate

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:

  • Separating reads from writes

  • Balancing reads across standby nodes

  • The system is only eventually consistent

  • Adding extra nodes to a live cluster

  • Handling the failure of one node

  • Keeping complexity down to a manageable level

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.


Gianni Ciolli