Тёмный
No video :(

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

PostgresTV 💙💛
Подписаться 4,1 тыс.
Просмотров 1,3 тыс.
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/pe...
* Sammy Steele from Figma postgres.fm/pe...
* Derk van Veen from Adyen postgres.fm/pe...
* 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/...
* Adding Postgres capacity (again) with zero downtime (July 2023) www.notion.so/...
* How Figma’s databases team lived to tell the scale (March 2024) www.figma.com/...
* Updating a 50 terabyte PostgreSQL database (March 2018) www.adyen.com/...
* Part 1: Introduction to Table Partitioning (July 2023) www.adyen.com/...
* Part 2: Partitioning at Adyen (October 2023) www.adyen.com/...
* Part 3: Maintenance Under Pressure (January 2024) www.adyen.com/...
* Fighting PostgreSQL write amplification with HOT updates (May 2022) www.adyen.com/...
* Tracking HOT updates and tuning FillFactor (October 2022) www.adyen.com/...
* Partitioning your Postgres tables for 20X better performance (upcoming talk by Derk at Posette) www.citusdata....
* Figma, including Sammy’s team, is hiring www.figma.com/...
* Notion’s engineering team is hiring www.notion.so/...
* 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.

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

 

26 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@prashanttendulkar
@prashanttendulkar 11 дней назад
Best episode of postgres tv
@poppop101010
@poppop101010 Месяц назад
great content thnx for the effort!
@bhautikin
@bhautikin 2 месяца назад
One of the best episodes!
@rosendo3219
@rosendo3219 2 месяца назад
gratz boys on episode 100! always listening to you in my car while driving to my boring work
@JamesBData
@JamesBData 2 месяца назад
Congrats on reaching episode 100!
@anbu630
@anbu630 2 месяца назад
Congrats on your 100th episode !! Watched your 1st one and here the 100th one as well :-)
@dshukertjr
@dshukertjr 2 месяца назад
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 2 месяца назад
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 2 месяца назад
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.
Далее
Ajdarlar...😅 QVZ 2024
00:39
Просмотров 377 тыс.
ChatGPT for Data Analytics: Full Course
3:35:30
Просмотров 255 тыс.
This Might Be The Best Advice I Have Ever Seen
40:02
Просмотров 296 тыс.
What is ChatGPT doing...and why does it work?
3:15:38
Просмотров 2,1 млн
This is why Deep Learning is really weird.
2:06:38
Просмотров 383 тыс.