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

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:
Watch more Citus Con talks: aka.ms/citusco...
Read Postgres Tips: How to convert 2 Billion Rows to Bigint with Citus: XXX
Watch Rob Treat’s Citus Con talk, Advanced INT to BIGINT Conversions: • Advanced INT to BIGINT...
📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: aka.ms/cituscon
📌 Let’s connect:
Twitter - @CitusCon, / cituscon
#CitusCon #PostgreSQL #Citus

[@sureshchaudhari4465]

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

[@2008topshelf]

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.

[@JaNaMSoNi]

Really helpful

[@Kingromstar]

Timescaledb wasn't out yet, lol.

[@ahmettek315]

It is out, so what?

[@svenbb4937]

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

[@mzyil]

startups rarely have the money

[@PatrickMichalina]

​@@mzyil they can and do!

[@RU-qv3jl]

Well they‘re still going so apparently that luxury isn‘t needed and it is a luxury for a startup.

[@RH-of5cr]

naturally we chose ruby on rails.... wahahaha

[@RU-qv3jl]

Did it work? Did they make money? Are they still going? Business is less abut ego than things working, which is what they did.