Constraints | Postgres.FM 075 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try TH-cam's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss PostgreSQL constraints - the six different types we have, how to add and modify them, including on large tables with high TPS.
Here are some links to things they mentioned:
* Constraints (docs) www.postgresql...
* Unique index vs unique constraint issue (2017) www.postgresql...
* Our episode on NULLs postgres.fm/ep...
* Advanced Int to Bigint Conversions (talk by Robert Treat) • PGConf NYC 2021 - Adva...
* Use BIGINT in Postgres (blog post by Ryan Lambert) blog.rustproof...
* How to add a foreign key (Tweet by Nikolay) / 1732056107483636188
* Bloat, pg_repack, and deferred constraints (blog post by Nikolai Averin from Miro) / postgresql-bloat-pg-re...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the uncut version, with video. Check out Postgres.fm to find audio-only podcast episodes, edited for convenient listening.