Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

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 görüntüleme • 3 ay önce •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

0 Yorum

Yorum bulunmuyor

Orijinal gönderinin yorumları burada görünecek

Benzer Videolar

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,579 görüntüleme • 1 yıl önce

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

55,021 görüntüleme • 3 ay önce

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,410 görüntüleme • 2 yıl önce

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,103 görüntüleme • 3 yıl önce

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,345 görüntüleme • 3 yıl önce

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,744 görüntüleme • 8 ay önce

Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.
2:47

Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.

Xata 🦋

355,655 görüntüleme • 3 ay önce

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

21,070 görüntüleme • 1 yıl önce

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,150 görüntüleme • 1 yıl önce

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,629 görüntüleme • 1 yıl önce

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,412 görüntüleme • 1 yıl önce

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 görüntüleme • 10 ay önce

Dear, ST or whoever is handling the case of Dj Chicken😭 Abeg make them no release am ohh
1:38

Dear, ST or whoever is handling the case of Dj Chicken😭 Abeg make them no release am ohh

EasYOfLagos ✨️

111,739 görüntüleme • 2 ay önce

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 görüntüleme • 8 ay önce

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

Tamilnadu is a Case study for the whole world .

HEY RAM

173,761 görüntüleme • 9 ay önce

Reece James and the squad need to be doing more in this case! Be vocal, stop play, make a case and demand for VAR. Arsenal are the only team who seems to understand this.
1:11

Reece James and the squad need to be doing more in this case! Be vocal, stop play, make a case and demand for VAR. Arsenal are the only team who seems to understand this.

MrBanks💰

196,476 görüntüleme • 6 gün önce

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 görüntüleme • 7 ay önce