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.

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

37,975 subscribers

349,333 views • 8 months ago •via X (Twitter)

Science & Technology Education

Anya Rossi• Live Now

Private livecam show

0 Comments

No comments available

Comments from the original post will appear here

Related Videos

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

Sharding is the best way to scale a database. But how does it work? And what's the best way to ensure data and queries are evenly distributed? Our interactive article on database sharding teaches you how.

Sharding is the best way to scale a database. But how does it work? And what's the best way to ensure data and queries are evenly distributed? Our interactive article on database sharding teaches you how.

PlanetScale

28,639 views • 1 month ago

Why are there so many ways to connect to Postgres? Because each method has tradeoffs. The right choice depends on your architecture. Let's break down 5 connection methods including direct, PgBouncer, and Hyperdrive.

Why are there so many ways to connect to Postgres? Because each method has tradeoffs. The right choice depends on your architecture. Let's break down 5 connection methods including direct, PgBouncer, and Hyperdrive.

PlanetScale

16,681 views • 5 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,786 views • 14 days ago

You're probably sick of me saying "B-tree" but these impact SO MUCH of database performance. They're used all over the place in Postgres, MySQL, and SQLite. This week I broke down B-tree lookups and how the page cache makes lookups faster.

You're probably sick of me saying "B-tree" but these impact SO MUCH of database performance. They're used all over the place in Postgres, MySQL, and SQLite. This week I broke down B-tree lookups and how the page cache makes lookups faster.

Ben Dicken

186,597 views • 4 months ago

Postgres databases now come with LLM-powered index recommendations. Indexes are crucial for database performance, and these recommendations help ensure your queries are executing optimally.

Postgres databases now come with LLM-powered index recommendations. Indexes are crucial for database performance, and these recommendations help ensure your queries are executing optimally.

PlanetScale

38,328 views • 6 months ago

🌳🔍 Explore #Arbimon: How is it revolutionizing our understanding of ecosystems & endangered species? Rainforest Connection CTO Antony Harfield reveals this innovative tech's impact. Learn more: 🐾🌍 #TECH4ALL #Tech4Nature

🌳🔍 Explore #Arbimon: How is it revolutionizing our understanding of ecosystems & endangered species? Rainforest Connection CTO Antony Harfield reveals this innovative tech's impact. Learn more: 🐾🌍 #TECH4ALL #Tech4Nature

TECH4ALL

1,851,175 views • 2 years ago

When the new Ontario Line connection at Osgoode Station opens, one of its entrances will feature a familiar Queen Street building. Watch to see how the process went and learn more about the project here:

When the new Ontario Line connection at Osgoode Station opens, one of its entrances will feature a familiar Queen Street building. Watch to see how the process went and learn more about the project here:

Ontario Line

14,124 views • 1 year ago

Whop is building the #1 global creator marketplace. Jack Sharkey, Whop co-founder and CTO, covers how they migrated their 800GB Postgres database to PlanetScale with no downtime and no interruption to site traffic.

Whop is building the #1 global creator marketplace. Jack Sharkey, Whop co-founder and CTO, covers how they migrated their 800GB Postgres database to PlanetScale with no downtime and no interruption to site traffic.

PlanetScale

19,313 views • 1 year ago

I've put together an interactive article on database sharding. Learn more about the database scaling pattern used by large orgs to handle million+ QPS workloads. I hope you learn, enjoy, and have some fun along the way.

I've put together an interactive article on database sharding. Learn more about the database scaling pattern used by large orgs to handle million+ QPS workloads. I hope you learn, enjoy, and have some fun along the way.

Ben Dicken

39,472 views • 1 year 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,016 views • 1 year ago

One border, two countries, and a seamless connection! 🇫🇮🇸🇪 In our latest development blog post, we share more about the cities of Tornio and Haparanda in our upcoming Nordic Horizons DLC for Euro Truck Simulator 2 🚛 Read more at:

One border, two countries, and a seamless connection! 🇫🇮🇸🇪 In our latest development blog post, we share more about the cities of Tornio and Haparanda in our upcoming Nordic Horizons DLC for Euro Truck Simulator 2 🚛 Read more at:

SCS Software

11,474 views • 1 year ago

How does information connect us? Information isn’t just about truth – it’s about connection. This is the heart of 'Nexus'. The book explores the history of information and how it binds us together in many different ways. #NexusBook #Information #Connection #AI

How does information connect us? Information isn’t just about truth – it’s about connection. This is the heart of 'Nexus'. The book explores the history of information and how it binds us together in many different ways. #NexusBook #Information #Connection #AI

Yuval Noah Harari

44,903 views • 1 year ago

Introducing Database Traffic Control: a Postgres traffic management system built into PlanetScale. Enforce flexible budgets on your database traffic to protect against unexpected and dangerous workloads.

Introducing Database Traffic Control: a Postgres traffic management system built into PlanetScale. Enforce flexible budgets on your database traffic to protect against unexpected and dangerous workloads.

PlanetScale

160,786 views • 2 months ago

Why settle for slow? Our latest interactive blog covers the history of IO devices, how storage works in the cloud, and why separation of storage and compute is bad for OLTP databases.

Why settle for slow? Our latest interactive blog covers the history of IO devices, how storage works in the cloud, and why separation of storage and compute is bad for OLTP databases.

PlanetScale

319,567 views • 1 year ago

Autism & Vitamin A, is there a connection? Watch and learn!!!

Autism & Vitamin A, is there a connection? Watch and learn!!!

ᴀʀᴛ ᴏꜰ ᴘʜʏꜱɪQᴜᴇ

53,570 views • 5 months ago

Introducing pg_strict for Postgres. Our new extension adds a safety net to Postgres, catching dangerous queries before they run.

Introducing pg_strict for Postgres. Our new extension adds a safety net to Postgres, catching dangerous queries before they run.

PlanetScale

114,667 views • 4 months ago