正在加载视频...

视频加载失败

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

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

35,297 subscribers

51,627 次观看 • 5 个月前 •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

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

相关视频

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

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

We built a no-signup Postgres tool 📸 - Get a Postgres URL in a second, from your browser or terminal - If you want to keep your database, transfer it to your Neon account It uses Cloudflare, React Router, and Drizzle ORM under the hood

We built a no-signup Postgres tool 📸 - Get a Postgres URL in a second, from your browser or terminal - If you want to keep your database, transfer it to your Neon account It uses Cloudflare, React Router, and Drizzle ORM under the hood

Neon Postgres

26,526 次观看 • 1 年前

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

I love that Selena Gomez always uses her birthday as a way to do good

I love that Selena Gomez always uses her birthday as a way to do good

𝐊𝐞𝐯𝐢𝐧

22,244 次观看 • 11 个月前

A Q engineer has designed a bicycle that uses caterpillar tracks in place of traditional wheels, angled at 75 degrees. The tracks, however, are reported to be noisier and slower than standard wheels.

A Q engineer has designed a bicycle that uses caterpillar tracks in place of traditional wheels, angled at 75 degrees. The tracks, however, are reported to be noisier and slower than standard wheels.

Tansu Yegen

270,523 次观看 • 3 年前

FINALLY SOME GOOD SONG CHOICES FOR A SURVIVAL?

FINALLY SOME GOOD SONG CHOICES FOR A SURVIVAL?

🫀

68,727 次观看 • 2 年前

Finish off your full-stack apps in v0 with a database. For example, if you are building a financial dashboard, you can now persist transaction data in Neon - Serverless Postgres.

Finish off your full-stack apps in v0 with a database. For example, if you are building a financial dashboard, you can now persist transaction data in Neon - Serverless Postgres.

v0

34,320 次观看 • 1 年前

Look what came up in my Facebook memories! A good memory for me…a bad memory for other wireless companies. 😎

Look what came up in my Facebook memories! A good memory for me…a bad memory for other wireless companies. 😎

John Legere

22,318 次观看 • 3 个月前

New tool drop! 🔥🔥 de-optimizer uses several mathematical approaches for mutating machine code instructions to their functional equivalents. Very good for bypassing rule-based detection without using any RWE memory.

New tool drop! 🔥🔥 de-optimizer uses several mathematical approaches for mutating machine code instructions to their functional equivalents. Very good for bypassing rule-based detection without using any RWE memory.

ege

29,461 次观看 • 2 年前

Merkle trees are everywhere: - ZFS uses them to detect data corruption - Git uses them to verify repo integrity - Cursor uses them for codebase sync - Bitcoin uses them for transaction verification Talked through how they work on the latest database stream.

Merkle trees are everywhere: - ZFS uses them to detect data corruption - Git uses them to verify repo integrity - Cursor uses them for codebase sync - Bitcoin uses them for transaction verification Talked through how they work on the latest database stream.

Ben Dicken

134,223 次观看 • 2 个月前

Mom uses a different punishment technique.

Mom uses a different punishment technique.

The Figen

30,632,505 次观看 • 2 年前

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,256 次观看 • 24 天前

A flock of crested ibis perched on a persimmon tree. In Chinese culture, both the crested ibis and persimmon tree symbolize good fortune and prosperity. Hence it’s not only Nature’s poetry in motion, but also good omen for anyone who sees it!

A flock of crested ibis perched on a persimmon tree. In Chinese culture, both the crested ibis and persimmon tree symbolize good fortune and prosperity. Hence it’s not only Nature’s poetry in motion, but also good omen for anyone who sees it!

Hua Chunying 华春莹

100,412 次观看 • 1 年前

Kicking off Earth Week with a big question: Is crypto good for the environment? 🌍 Bitcoin uses more energy than Finland — but there’s a better way. We break it down in the latest Stronghold 101. 🎥 Watch:

Kicking off Earth Week with a big question: Is crypto good for the environment? 🌍 Bitcoin uses more energy than Finland — but there’s a better way. We break it down in the latest Stronghold 101. 🎥 Watch:

Stronghold

17,292 次观看 • 1 年前

3 reasons why you should date a tr&ns girl. Are any of them good enough for y’all to consider settling for a man in a dress?

Sensitive content

3 reasons why you should date a tr&ns girl. Are any of them good enough for y’all to consider settling for a man in a dress?

Hazel Appleyard

126,653 次观看 • 1 年前

Here's a simple B execute for Cache from One Position - Tree Smoke (Left + Right Click) - Heaven Smoke - Backsite Molotov

Here's a simple B execute for Cache from One Position - Tree Smoke (Left + Right Click) - Heaven Smoke - Backsite Molotov

Thour

91,995 次观看 • 1 个月前

you want this one?? the dumb super senior who uses his dead mom to get his own way, cheats on his girlfriend after a tiny argument, can’t even read an email, uses his girlfriend as a replacement for his mother, and finds any excuse to be aggressive to his brother for no reason???

you want this one?? the dumb super senior who uses his dead mom to get his own way, cheats on his girlfriend after a tiny argument, can’t even read an email, uses his girlfriend as a replacement for his mother, and finds any excuse to be aggressive to his brother for no reason???

𝐞𝐥𝐥𝐞 🏒

220,327 次观看 • 10 个月前

India is a country which can understand the implication of a good which comes in our way, although a good is never unmitigated, a good is never without riders, a good is never - on its own - good, it is for us all to use in such a way that it is for the common good. I think the AI is something which we should know how to keep well under our reins and serve for the common good. - Smt Nirmala Sitharaman in New Delhi.

India is a country which can understand the implication of a good which comes in our way, although a good is never unmitigated, a good is never without riders, a good is never - on its own - good, it is for us all to use in such a way that it is for the common good. I think the AI is something which we should know how to keep well under our reins and serve for the common good. - Smt Nirmala Sitharaman in New Delhi.

Nirmala Sitharaman Office

17,401 次观看 • 9 个月前