Загрузка видео...

Не удалось загрузить видео

На главную

Are processes or threads better for handling connections? Postgres and MySQL make the perfect case-study for this tradeoff.

BenjDicken's profile picture

Ben Dicken

35,591 subscribers

14,256 просмотров • 22 дней назад •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

Комментарии: 0

Нет доступных комментариев

Здесь появятся комментарии из оригинального поста

Похожие видео

Postgres: process-per-connection MySQL: thread-per-connection Learn more about processes, threads, connection pooling, and how they impact database performance in our latest interactive article.
0:34

Postgres: process-per-connection MySQL: thread-per-connection Learn more about processes, threads, connection pooling, and how they impact database performance in our latest interactive article.

PlanetScale

349,333 просмотров • 8 месяцев назад

MySQL vs Postgres: storage engine addition. Clustered indexes (MySQL) and heap tables (Postgres) each have unique advantages. Covered the differences and practical implications in the latest stream.
13:46

MySQL vs Postgres: storage engine addition. Clustered indexes (MySQL) and heap tables (Postgres) each have unique advantages. Covered the differences and practical implications in the latest stream.

Ben Dicken

19,991 просмотров • 29 дней назад

At scale, you can only put off sharding for so long. YouTube scaled MySQL with Vitess, and now we're building the same for Postgres.
1:29

At scale, you can only put off sharding for so long. YouTube scaled MySQL with Vitess, and now we're building the same for Postgres.

PlanetScale

54,747 просмотров • 24 дней назад

DBngin is such a good little app for managing database local DB servers. Highly recommended if your app needs a MySQL, Postgres or Redis DB
0:39

DBngin is such a good little app for managing database local DB servers. Highly recommended if your app needs a MySQL, Postgres or Redis DB

Wes Bos

85,389 просмотров • 1 год назад

Are you using automated impaction for #THA? This study showed better femur alignment, canal fill, and shorter OR times without the increased risk of ppfx.
0:25

Are you using automated impaction for #THA? This study showed better femur alignment, canal fill, and shorter OR times without the increased risk of ppfx.

The Journal of Arthroplasty

16,100 просмотров • 3 лет назад

Modi ji is a perfect case study for all business schools
1:16

Modi ji is a perfect case study for all business schools

desi mojito

367,295 просмотров • 2 лет назад

How do Postgres and MySQL achieve data durability? Our very own Chris Sinjakli spoke at SREcon about how this works and the many engineering challenges it presents.
1:45

How do Postgres and MySQL achieve data durability? Our very own Chris Sinjakli spoke at SREcon about how this works and the many engineering challenges it presents.

PlanetScale

11,568 просмотров • 7 месяцев назад

B-tree database lookups are way slower without a memory cache in place + a good replacement policy for OLTP. MySQL uses a segmented LRU whereas Postgres uses a clock-sweep algorithm. Both good choices for different reasons.
7:54

B-tree database lookups are way slower without a memory cache in place + a good replacement policy for OLTP. MySQL uses a segmented LRU whereas Postgres uses a clock-sweep algorithm. Both good choices for different reasons.

Ben Dicken

51,627 просмотров • 4 месяцев назад

Your Launchpad for Postgres: Get a Postgres connection URL in seconds, use your DB, claim it later. Perfect for building products like Netlify DB, OSS projects, and agents.
2:31

Your Launchpad for Postgres: Get a Postgres connection URL in seconds, use your DB, claim it later. Perfect for building products like Netlify DB, OSS projects, and agents.

Neon Postgres

21,019 просмотров • 1 год назад

Meet Schema — A new Postgres & MySQL database client for iOS. It’s great whether you’re a developer working at scale, a founder watching signups, or vibe coding your next big thing. Schema is available today.
0:27

Meet Schema — A new Postgres & MySQL database client for iOS. It’s great whether you’re a developer working at scale, a founder watching signups, or vibe coding your next big thing. Schema is available today.

Allan

129,093 просмотров • 1 год назад

Listen to Prof Joshua Alabi make a case for resetting Ghana for the better.
2:20

Listen to Prof Joshua Alabi make a case for resetting Ghana for the better.

Shamima Muslim

14,976 просмотров • 1 год назад

All types of databases, Redis, Postgres, Clickhouse, Mysql etc. now display important stats and metrics aswell as most run queries in the Maple service map
0:22

All types of databases, Redis, Postgres, Clickhouse, Mysql etc. now display important stats and metrics aswell as most run queries in the Maple service map

Makisuo

242,718 просмотров • 15 дней назад

With PGlite + Electric sync you can build an issue tracker handling 100k issues + 500k comments, synced from Postgres to PGlite in the browser! Super fast UI updates with all writes going though the local database, and Postgres FTS in PGlite for search 🔥
1:13

With PGlite + Electric sync you can build an issue tracker handling 100k issues + 500k comments, synced from Postgres to PGlite in the browser! Super fast UI updates with all writes going though the local database, and Postgres FTS in PGlite for search 🔥

Sam Willis

55,403 просмотров • 1 год назад

Super easy to make and so delicious 🤤 Toblerone Waffles are the perfect match for your morning coffee or tea! 🤤☕
0:31

Super easy to make and so delicious 🤤 Toblerone Waffles are the perfect match for your morning coffee or tea! 🤤☕

Funnie 🌿

2,078,719 просмотров • 7 месяцев назад

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values
3:39

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values

Hussein Nasser

143,151 просмотров • 1 год назад

Tamilnadu is a Case study for the whole world .
0:37

Tamilnadu is a Case study for the whole world .

HEY RAM

173,686 просмотров • 6 месяцев назад

Just Use Postgres feat. Denis Magda Denis literally just published a book called “Just Use Postgres”. In this conversation, that turned out to be super fun, we talked about: • what MySQL got wrong w.r.t community • the recent explosion of Postgres development in the world (Supabase, Neon, Crunchy, ClickHouse) • when Postgres instead of Kafka • the significance of the meme “just use postgres” • Postgres for data analytics Chapters (00:00) Intro (04:26) The Just Use Postgres Movement (08:36) The Small Data Trend and Its Implications (15:49) The Shift from Distributed Systems to Simplicity (17:15) Updating your priors re: PG capabilities (20:28) MySQL's OSS community split & our experiences with such things (39:48) Postgres for Analytics (55:49) PG in the lake house (59:27) AI Marketing Slop (01:02:19) How you'd build a brand new app on Postgres (01:05:24) Speedrun through PG extensions (01:11:56) PG as a Message Queue
1:30:33

Just Use Postgres feat. Denis Magda Denis literally just published a book called “Just Use Postgres”. In this conversation, that turned out to be super fun, we talked about: • what MySQL got wrong w.r.t community • the recent explosion of Postgres development in the world (Supabase, Neon, Crunchy, ClickHouse) • when Postgres instead of Kafka • the significance of the meme “just use postgres” • Postgres for data analytics Chapters (00:00) Intro (04:26) The Just Use Postgres Movement (08:36) The Small Data Trend and Its Implications (15:49) The Shift from Distributed Systems to Simplicity (17:15) Updating your priors re: PG capabilities (20:28) MySQL's OSS community split & our experiences with such things (39:48) Postgres for Analytics (55:49) PG in the lake house (59:27) AI Marketing Slop (01:02:19) How you'd build a brand new app on Postgres (01:05:24) Speedrun through PG extensions (01:11:56) PG as a Message Queue

Stanislav Kozlovski

13,036 просмотров • 4 месяцев назад

Who has the better case for MVP: Lamar or Josh Allen? 🤔 “Lamar has a better case for those who consume stats first & film second. But Josh has a better case for those who consume film first & stats second.” — Emmanuel Acho
1:14

Who has the better case for MVP: Lamar or Josh Allen? 🤔 “Lamar has a better case for those who consume stats first & film second. But Josh has a better case for those who consume film first & stats second.” — Emmanuel Acho

The Facility

512,492 просмотров • 1 год назад

Spin the Wheel and make a case for this team to make the playoffs next year Chief : Giants
1:45

Spin the Wheel and make a case for this team to make the playoffs next year Chief : Giants

Wake Up Barstool

66,059 просмотров • 4 месяцев назад

Renee Good is the perfect case study in left-wing ideology.
1:28

Renee Good is the perfect case study in left-wing ideology.

Isabella Maria DeLuca

41,935 просмотров • 5 месяцев назад