Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Lessons learned: Migrating from AWS-Hosted PostgreSQL RDS to Self-Hosted Citus | Citus Con 2023

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
942 views 2 years ago #PostgreSQL #CitusCon #Citus
Video of a conference talk about how Jellyfish implemented Citus and Postgres, presented at Citus Con: An Event for Postgres 2023. Jellyfish is a multi-tenant SaaS application based on PostgreSQL. Implementing Citus to distribute PostgreSQL necessitated leaving behind the managed database world of RDS and instead self-hosting PostgreSQL on their own machines. In this talk, Jellyfish shares their journey scaling out PostgreSQL with the open source Citus database extension, so others can learn from the Jellyfish team’s successes and their missteps. Matt Klein is a Principal engineer on the platform team. Having joined Jellyfish as a founding engineer 5 years ago, pre-series A, Matt has been a software engineer for almost (gulp) 30 years. Matt has worked at early stage startups since 2008 and has worked with PostgreSQL since 2010: application and administration. Delaney Mackenzie leads a software team at Jellyfish focused on DAGs and data quali …...more
...more
Lessons learned: Migrating from AWS-Hosted PostgreSQL RDS to Self-Hosted Citus | Citus Con 2023
25Likes
942Views
2023Apr 18
Video of a conference talk about how Jellyfish implemented Citus and Postgres, presented at Citus Con: An Event for Postgres 2023. Jellyfish is a multi-tenant SaaS application based on PostgreSQL. Implementing Citus to distribute PostgreSQL necessitated leaving behind the managed database world of RDS and instead self-hosting PostgreSQL on their own machines. In this talk, Jellyfish shares their journey scaling out PostgreSQL with the open source Citus database extension, so others can learn from the Jellyfish team’s successes and their missteps. Matt Klein is a Principal engineer on the platform team. Having joined Jellyfish as a founding engineer 5 years ago, pre-series A, Matt has been a software engineer for almost (gulp) 30 years. Matt has worked at early stage startups since 2008 and has worked with PostgreSQL since 2010: application and administration. Delaney Mackenzie leads a software team at Jellyfish focused on DAGs and data quality. Prior to Jellyfish, he worked on the technical team at a boutique consulting company in Boston, and prior to that he spent almost 5 years at Quantopian (a democratized quant trading startup). While at Quantopian, Delaney worked in many roles, including backend engineer on their event driven backtest system, building out a new educational business line, and running user data science under the auspices of user growth. Delaney has a degree in computer science from Princeton and spent a while doing computational genetics research before joining the startup world. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 02:16 Directed Acyclic Graph (DAG) at Jellyfish ⏩ 04:48 Why Citus? ⏩ 08:16 Infrastructure Design Choices ⏩ 12:03 What needs to happen to your database schema ⏩ 15:58 Changes to your codebase ⏩ 18:43 Our Rollout Strategy ⏩ 20:52 Wrap-Up & what we’re excited about ✅ Learn more: Watch more Citus Con 2023 talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect:   Twitter – @CitusCon,   / cituscon   ⭐ Star the GitHub repo for the Citus database extension, to show your support of Citus open source: https://github.com/citusdata/citus #CitusCon #PostgreSQL #Citus

Follow along using the transcript.

Microsoft Developer

589K subscribers