Divide and Conquer: Multi-tenancy in Postgres | Citus Con: An Event for Postgres 2023

Video Description

Video of a conference talk about multi-tenancy in Postgres, delivered at Citus Con: An Event for Postgres 2023. In this talk, Karen Jex explores how the Postgres environment can be designed in various different ways to accommodate multiple customers and/or applications. But which is the “right” option? The answer is, as always, “it depends”. The correct method is the one that provides the required balance between performance, security, high availability, and manageability. In this presentation, Karen looks at the different multi-tenant database architectures and the advantages and disadvantages of each. It should enable you to design the most appropriate database environment for your applications. Karen Jex was an Oracle DBA for 20 years before starting to work with PostgreSQL databases. She liked them so much that she became a Senior Database Consultant and then a Senior Solutions Architect working exclusively with PostgreSQL. Karen was once described as “quite personable for a DBA” which she decided to take as a compliment. Outside of the world of databases, Karen loves cycling, mountain biking, skiing, and spending time with her family in the mountains. Karen is also doing a part-time PhD in Computer Science. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:06 Multi-Tenancy ⏩ 02:30 Using a cake bakery to set the scene ⏩ 04:35 Multi-tenant Options ⏩ 21:32 How do you choose? ⏩ 26:16 Conclusions ✅ 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, https://twitter.com/CitusCon #CitusCon #PostgreSQL #Database