正在加载视频...

视频加载失败

加载此视频时出现问题。这可能是由于临时网络问题，或视频可能不可用。

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 次观看 • 6 个月前 •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

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 次观看 • 8 个月前

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,747 次观看 • 17 天前

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 次观看 • 1 个月前

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,892 次观看 • 22 天前

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 次观看 • 1 年前

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 次观看 • 1 年前

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 次观看 • 1 年前

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 次观看 • 6 个月前

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 次观看 • 1 年前

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,369 次观看 • 6 个月前

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 次观看 • 9 个月前

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 次观看 • 3 个月前

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

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

Ben Dicken

14,234 次观看 • 15 天前

HOW IT WORKS: Utilizing VanaHQ’s tech stack, YOU own your data, YOU earn rewards, and YOU choose how it's used. Your data is safe and encrypted. To make it more fun, we’ve added global leaderboards for sleep, recovery, and others. Welcome to the future of data ownership!

HOW IT WORKS: Utilizing VanaHQ’s tech stack, YOU own your data, YOU earn rewards, and YOU choose how it's used. Your data is safe and encrypted. To make it more fun, we’ve added global leaderboards for sleep, recovery, and others. Welcome to the future of data ownership!

BiohackerDAO | Official

12,672 次观看 • 1 年前

In all seriousness - how do they engineer these monster machines? How many tries does it take them to make one that actually works? Engineering marvels! 👍

In all seriousness - how do they engineer these monster machines? How many tries does it take them to make one that actually works? Engineering marvels! 👍

Croxxed Out

15,527 次观看 • 11 个月前

Finish the week with a Postgres video 🌟 All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres.

Finish the week with a Postgres video 🌟 All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres.

Gwen (Chen) Shapira

27,568 次观看 • 1 年前

… 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,415 次观看 • 2 年前

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 次观看 • 3 个月前

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,461 次观看 • 4 个月前

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 次观看 • 6 个月前