Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

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

Ben Dicken

35,591 subscribers

14,256 views • 24 days ago •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 Comments

No comments available

Comments from the original post will appear here

Related Videos

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.

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 views • 9 months ago

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.

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 views • 1 month ago

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.

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,848 views • 26 days ago

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

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 views • 1 year ago

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.

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 views • 3 years ago

Modi ji is a perfect case study for all business schools

Modi ji is a perfect case study for all business schools

desi mojito

367,295 views • 2 years ago

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.

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 views • 7 months ago

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.

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 views • 5 months ago

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.

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 views • 1 year ago

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.

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 views • 1 year ago

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

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

Shamima Muslim

14,976 views • 1 year ago

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

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,979 views • 17 days ago

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 🔥

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 views • 1 year ago

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

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

Funnie 🌿

2,078,719 views • 7 months ago

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

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 views • 1 year ago

Tamilnadu is a Case study for the whole world .

Tamilnadu is a Case study for the whole world .

HEY RAM

173,686 views • 6 months ago

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 views • 4 months ago

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

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 views • 1 year ago

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

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

Wake Up Barstool

66,059 views • 4 months ago

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

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

Isabella Maria DeLuca

41,935 views • 5 months ago