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

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:

📌 Let’s connect:  

#CitusCon #PostgreSQL #Citus