Scaling a Saas application beyond a single Postgres with Citus.

Date: 2017-09-08
Time: 17:30 - 18:20
Room: Market Street
Level: Intermediate

ProsperWorks CRM is a cloud-based CRM that integrates with Gmail, Google Drive and the rest of the Google Apps suite.
As a Saas provider of customer relations management, we have a complicated data model which is constantly evolving.

In 2016-Q4 through 2017-Q1 we migrated our 300 kLoC Ruby on Rails service from a single Postgres instance to sharded Postgres with CitusData. Today we enjoy a primary store with is not bound by the limits of vertical scaling.

This is the story of the challenges we faced, the strategies we employed to overcome them, with notes on what went well and what we wish we had done differently to help should you yourself need to scale beyond single node Postgres.


Jesse H. Willett