To 100TB, and beyond! | Postgres.FM 100 |

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

Michael and Nikolay are joined by three special guests for episode 100 who have all scaled Postgres to significant scale — Arka Ganguli from Notion, Sammy Steele from Figma, and Derk van Veen from Adyen. They cover how their setup has evolved, what their plans are for the future, and get into the weeds of some fun and interesting challenges along the way!

Links to some of the things discussed:
Arka Ganguli from Notion https://postgres.fm/people/arka-ganguli
Sammy Steele from Figma https://postgres.fm/people/sammy-steele
Derk van Veen from Adyen https://postgres.fm/people/derk-van-veen
Thank you to yerrysherry on Reddit for the idea!   / what_should_we_do_for_episode_100_of_postg...  
Lessons learned from sharding Postgres at Notion (October 2021) https://www.notion.so/blog/sharding-p...
Adding Postgres capacity (again) with zero downtime (July 2023) https://www.notion.so/blog/the-great-...
How Figma’s databases team lived to tell the scale (March 2024) https://www.figma.com/blog/how-figmas...
Updating a 50 terabyte PostgreSQL database (March 2018) https://www.adyen.com/knowledge-hub/u...
Part 1: Introduction to Table Partitioning (July 2023) https://www.adyen.com/knowledge-hub/i...
Part 2: Partitioning at Adyen (October 2023) https://www.adyen.com/knowledge-hub/p...
Part 3: Maintenance Under Pressure (January 2024) https://www.adyen.com/knowledge-hub/m...
Fighting PostgreSQL write amplification with HOT updates (May 2022) https://www.adyen.com/knowledge-hub/p...
Tracking HOT updates and tuning FillFactor (October 2022) https://www.adyen.com/knowledge-hub/p...
Partitioning your Postgres tables for 20X better performance (upcoming talk by Derk at Posette) https://www.citusdata.com/posette/spe...
Figma, including Sammy’s team, is hiring https://www.figma.com/careers
Notion’s engineering team is hiring https://www.notion.so/careers
Adyen’s engineering team is hiring https://careers.adyen.com


~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm   / postgresfm  , @samokhvalov   / samokhvalov   and @michristofides   / michristofides  


~~~


Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see transcripts, guest profiles, and more.