Episode
Demystifying Postgres Foreign Key Constraints on Citus | Citus Con: An Event for Postgres 2023
with Onder Kalaci
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.
Recommended resources
- Watch more Citus Con 2023 talks
- Everything you need to know about Citus Con: An Event for Postgres 2023
- Star the GitHub repo for the Citus database extension, to show your support of Citus open source
Connect
- Citus Con An Event for Postgres | Twitter: @CitusCon
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.
Recommended resources
- Watch more Citus Con 2023 talks
- Everything you need to know about Citus Con: An Event for Postgres 2023
- Star the GitHub repo for the Citus database extension, to show your support of Citus open source
Connect
- Citus Con An Event for Postgres | Twitter: @CitusCon
Have feedback? Submit an issue here.