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.

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

34,036 subscribers

11,568 views • 7 months 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

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 • 1 month 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 • 3 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

What do we do about the problems government can’t solve? For many Americans, the answer is “roll up our sleeves and take care of it ourselves.” Our new video looks at how everyday citizens are tackling some of the country’s biggest challenges.

What do we do about the problems government can’t solve? For many Americans, the answer is “roll up our sleeves and take care of it ourselves.” Our new video looks at how everyday citizens are tackling some of the country’s biggest challenges.

Kite & Key Media

441,685 views • 1 year ago

From the archives of our internal Postgres hack week this past spring.

From the archives of our internal Postgres hack week this past spring.

PlanetScale

15,296 views • 7 months ago

Mayorkas LIED about the screening and vetting of “refugees” from Afghanistan. How many more Rahmanullah Lakanwals are on our soil at this very moment?

Mayorkas LIED about the screening and vetting of “refugees” from Afghanistan. How many more Rahmanullah Lakanwals are on our soil at this very moment?

I Meme Therefore I Am 🇺🇸

40,376 views • 7 months 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

This week at PlanetScale, we lowered the price of your Postgres clusters, shipped new extensions, added support for event triggers, and more 👇

This week at PlanetScale, we lowered the price of your Postgres clusters, shipped new extensions, added support for event triggers, and more 👇

PlanetScale

33,699 views • 10 months ago

PlanetScale + Cloudflare Hyperdrive is perfect for building globally-distributed apps with a high-performance and scalable database. Today we dropped a deep-dive on how this works and why you should use it⬇️

PlanetScale + Cloudflare Hyperdrive is perfect for building globally-distributed apps with a high-performance and scalable database. Today we dropped a deep-dive on how this works and why you should use it⬇️

PlanetScale

35,513 views • 4 months ago

… is, I think, an important new stage in the effort to end democracy as our system of government. Here’s a 3-minute-ish clip of me and Chris Hayes talking (a few weeks ago) about how this was coming and how it works:

… is, I think, an important new stage in the effort to end democracy as our system of government. Here’s a 3-minute-ish clip of me and Chris Hayes talking (a few weeks ago) about how this was coming and how it works:

Rachel Maddow

266,676 views • 2 years ago

Aaron Judge and Aaron Boone spoke about how aggressive they want the Yankees to be with their ABS challenges

Aaron Judge and Aaron Boone spoke about how aggressive they want the Yankees to be with their ABS challenges

Talkin' Yanks

20,714 views • 4 months ago

The volume of this upper body is impressive. I wonder how many years and efforts it took to achieve this😵

The volume of this upper body is impressive. I wonder how many years and efforts it took to achieve this😵

knockout☆

17,016 views • 7 months ago

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Denis Magda

28,473 views • 5 months ago

"The unsolved problem of how do you turn data into something that is valuable within your business is now playing out." Aaron Levie spoke at Axios' AI+ Summit about the relationship between agents, data and business value.

"The unsolved problem of how do you turn data into something that is valuable within your business is now playing out." Aaron Levie spoke at Axios' AI+ Summit about the relationship between agents, data and business value.

Box

55,145 views • 7 months ago

Lovable is so cracked at websites. and anyone can achieve the same results. Here's how we do it ↓

Lovable is so cracked at websites. and anyone can achieve the same results. Here's how we do it ↓

damien

113,746 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,704 views • 6 months ago

DONALD TRUMP - "China spies on us. We spy on them too" "We do a lot of things, and so do they. That’s how the world works" 😳 "They steal things, we do the same to them" “But at the same time, I spoke very strongly to Xi Jinping about this issue" "I want it to stop. But they’ve been doing this for the last 50 years"

DONALD TRUMP - "China spies on us. We spy on them too" "We do a lot of things, and so do they. That’s how the world works" 😳 "They steal things, we do the same to them" “But at the same time, I spoke very strongly to Xi Jinping about this issue" "I want it to stop. But they’ve been doing this for the last 50 years"

News Algebra

225,932 views • 1 month ago