Тёмный

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

PostgresTV 💙💛
Подписаться 3,9 тыс.
Просмотров 1,2 тыс.
50% 1

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RU-vid'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 postgres.fm/people/arka-ganguli
* Sammy Steele from Figma postgres.fm/people/sammy-steele
* Derk van Veen from Adyen postgres.fm/people/derk-van-veen
* Thank you to yerrysherry on Reddit for the idea! / what_should_we_do_for_...
* Lessons learned from sharding Postgres at Notion (October 2021) www.notion.so/blog/sharding-p...
* Adding Postgres capacity (again) with zero downtime (July 2023) www.notion.so/blog/the-great-...
* How Figma’s databases team lived to tell the scale (March 2024) www.figma.com/blog/how-figmas...
* Updating a 50 terabyte PostgreSQL database (March 2018) www.adyen.com/knowledge-hub/u...
* Part 1: Introduction to Table Partitioning (July 2023) www.adyen.com/knowledge-hub/i...
* Part 2: Partitioning at Adyen (October 2023) www.adyen.com/knowledge-hub/p...
* Part 3: Maintenance Under Pressure (January 2024) www.adyen.com/knowledge-hub/m...
* Fighting PostgreSQL write amplification with HOT updates (May 2022) www.adyen.com/knowledge-hub/p...
* Tracking HOT updates and tuning FillFactor (October 2022) www.adyen.com/knowledge-hub/p...
* Partitioning your Postgres tables for 20X better performance (upcoming talk by Derk at Posette) www.citusdata.com/posette/spe...
* Figma, including Sammy’s team, is hiring www.figma.com/careers
* Notion’s engineering team is hiring www.notion.so/careers
* Adyen’s engineering team is hiring 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 postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to subscribe to the audio-only version, to see transcripts, guest profiles, and more.

Развлечения

Опубликовано:

 

6 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 8   
@bhautikin
@bhautikin Месяц назад
One of the best episodes!
@poppop101010
@poppop101010 17 дней назад
great content thnx for the effort!
@rosendo3219
@rosendo3219 Месяц назад
gratz boys on episode 100! always listening to you in my car while driving to my boring work
@JamesBData
@JamesBData Месяц назад
Congrats on reaching episode 100!
@anbu630
@anbu630 Месяц назад
Congrats on your 100th episode !! Watched your 1st one and here the 100th one as well :-)
@dshukertjr
@dshukertjr Месяц назад
Congrats on episode 100! Sorry if this has been covered in the past episodes, but I would love to know more about the following. 1. Why do you seem to discourage using foreign keys? 2. It seemed like all of the three companies rarely perform joins within their databases, but do they do they perform joins on the application layer? Is this common for large scale databases to not join within the database?
@NikolaySamokhvalov
@NikolaySamokhvalov Месяц назад
FKs are great and I personally use them everywhere. However, they have risks: 1) perf. overhead required to maintain them (that's ok usually), 2) perf. cliff related to multixact IDs - going to demonstrate soon with the PostgresAI bot.
@utenatenjou2139
@utenatenjou2139 Месяц назад
I large scale, having (constraint) foreign key make managing data real difficult. under complex structure, imagine when there are data to be correct. Note: for small data set no prob.
Далее
▼ЕГО БОЯЛИСЬ МОНГОЛЫ 🍣
32:51
Просмотров 432 тыс.
This Might Be The Best Advice I Have Ever Seen
40:02
Просмотров 257 тыс.
Why I Quit the Scrum Alliance
7:58
Просмотров 12 тыс.
🚀  TDD, Where Did It All Go Wrong (Ian Cooper)
1:03:55
Просмотров 553 тыс.
Migrating from Postgres to SQLite with Kent C. Dodds
57:02
Ставь ❤️ и подписывайся 🔥
0:14
Этот Пёс Кое-Что Наделал 😳
0:31