tubeshowcase●1,660,863 videos♡ My collection 0
← Learn to Code

Learn to Code26:22

Demystifying Postgres Foreign Key Constraints on Citus | Citus Con: An Event for Postgres 2023

Microsoft Developer ↗

From the creator

Video of a conference talk about the foreign keys on PostgreSQL as well as their usage on Citus, delivered at Citus Con: An Event for Postgres 2023. Foreign keys are one of the fundamental building blocks of any relational database, including PostgreSQL and Citus. For a distributed database, such as Citus database engine, there are some additional considerations when using these powerful constraints. Certain concepts like reference tables or distribution keys should be well thought along with foreign keys. Onder Kalaci is a Principal software engineer on the Postgres engineering team at Microsoft, who joined Citus Data years ago to scale out Postgres. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 02:02 What is a Foreign Key? ⏩ 07:49 Challenges of Foreign Keys on a distributed environment ⏩ 09:06 How Citus approaches foreign keys ✅ 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 ⭐ Stay connected with the Citus open source project on GitHub: https://github.com/citusdata/citus 🔔 Subscribe to the Citus monthly technical newsletter: https://aka.ms/citus-newsletter #CitusCon #PostgreSQL #Citus

Published 2023-04-18 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code