Lessons learned scaling our SaaS on Postgres to 8+ billion events | Citus Con 2022

preview_player
Показать описание
Video of a talk by Jonathan Denney at Citus Con: An Event for Postgres. Abstract: How we scaled ConvertFlow's platform to 40 million visitors per month and 8+ billion events processed, using Postgres and Citus on Azure.

Jonathan Denney is co-founder and CTO at ConvertFlow, a no-code visitor conversion platform that helps marketing teams scale their marketing workflows without waiting on developers. ConvertFlow runs their multi-tenant SaaS offering on top of Citus on Azure.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 00:58 What is Convertflow
⏩ 02:27 From 0 to 1M events
⏩ 06:42 From 1M to 100M events
⏩ 08:57 From 100M to 1B events
⏩ 12:13 From 1B to multiple billion events
⏩ 15:03 Bigint migration
⏩ 16:08 Migration to Hyperscale (Citus)
⏩ 17:19 Lessons learned recap

✅ Learn more:
Read Postgres Tips: How to convert 2 Billion Rows to Bigint with Citus: XXX

📌 Let’s connect:

#CitusCon #PostgreSQL #Citus
Рекомендации по теме
Комментарии
Автор

bro you nailed it even senior engineers dont talk to the point the webinar is not lengthy delivers so much on time

sureshchaudhari
Автор

Nicely done. Though I'd be curious what was the overriding beneficial interesting in moving the citus from aws to azure when citus does its thing on both? Possibly some more incentivizing credits on the MS side, I'd guess.

topshelf
Автор

The most important lesson was missing:
Hire some experienced developer who know what they are doing...

svenbb
Автор

Timescaledb wasn't out yet, lol.

Kingromstar
Автор

naturally we chose ruby on rails.... wahahaha

RH-ofcr