Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

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 Aufrufe • vor 20 Tagen •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

0 Kommentare

Keine Kommentare verfügbar

Kommentare vom Original-Post werden hier angezeigt

Ähnliche 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.
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 Aufrufe • vor 8 Monaten

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 Aufrufe • vor 27 Tagen

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 Aufrufe • vor 21 Tagen

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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 3 Jahren

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 Aufrufe • vor 2 Jahren

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 Aufrufe • vor 7 Monaten

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 Aufrufe • vor 4 Monaten

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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 1 Jahr

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,394 Aufrufe • vor 12 Tagen

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 Aufrufe • vor 1 Jahr

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 Aufrufe • vor 7 Monaten

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 Aufrufe • vor 1 Jahr

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

Tamilnadu is a Case study for the whole world .

HEY RAM

173,686 Aufrufe • vor 6 Monaten

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 Aufrufe • vor 4 Monaten

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 Aufrufe • vor 4 Monaten

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 Aufrufe • vor 1 Jahr

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,906 Aufrufe • vor 5 Monaten