正在加载视频...

视频加载失败

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

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

41,040 subscribers

51,744 次观看 • 7 个月前 •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

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

相关视频

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

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

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

Cleotrapa finally exposes Ice Spice in a 2 series video. “She’s not a good human being..this girl uses me for her rollout, everytime we hangout she drops a song the next day” + more

Cleotrapa finally exposes Ice Spice in a 2 series video. “She’s not a good human being..this girl uses me for her rollout, everytime we hangout she drops a song the next day” + more

໊

543,333 次观看 • 1 年前

Being a candidate and governing requires different skillsets. Debates are not a good way to pick a president. Instead of these gotcha sound bite performances, let's sit down with each candidate for an hour long, substantive policy discussion. Who can bring us together again?

Being a candidate and governing requires different skillsets. Debates are not a good way to pick a president. Instead of these gotcha sound bite performances, let's sit down with each candidate for an hour long, substantive policy discussion. Who can bring us together again?

John Kasich

27,242 次观看 • 2 年前

Database table size impacts performance in more ways than one: a) B-tree depth. Using 8k pages and a 16b uuid: 1 level = ~370 rows 2 levels = ~138k rows 3 levels = ~50m rows 4 levels = ~20b rows The lookup cost on a table with 100k rows is not the same as one with 1b rows. This can apply both to the table itself (MySQL cluster index) as well as the indexes. Sometimes a single query requires many of them. b) Small table → fits in RAM → fast reads. The larger the table, the more likely to read from disk plus churn the cache. c) # of indexes. Each adds maintenance overhead for insertions, and for Postgres vacuum overhead as well. Keep an eye on this! It's useful to take regular stock of your tables + indexes. Clean bloat. Remove unused indexes. Partition if needed.

Database table size impacts performance in more ways than one: a) B-tree depth. Using 8k pages and a 16b uuid: 1 level = ~370 rows 2 levels = ~138k rows 3 levels = ~50m rows 4 levels = ~20b rows The lookup cost on a table with 100k rows is not the same as one with 1b rows. This can apply both to the table itself (MySQL cluster index) as well as the indexes. Sometimes a single query requires many of them. b) Small table → fits in RAM → fast reads. The larger the table, the more likely to read from disk plus churn the cache. c) # of indexes. Each adds maintenance overhead for insertions, and for Postgres vacuum overhead as well. Keep an eye on this! It's useful to take regular stock of your tables + indexes. Clean bloat. Remove unused indexes. Partition if needed.

Ben Dicken

212,291 次观看 • 4 个月前

Experimenting with a new way of doing stochastic transparency. It still uses a checkerboard pattern, but allows for both variable transparency, tinted and frosted glass by recombining transparent and opaque pixels in a post-pass. Looks pretty promising so far!

Experimenting with a new way of doing stochastic transparency. It still uses a checkerboard pattern, but allows for both variable transparency, tinted and frosted glass by recombining transparent and opaque pixels in a post-pass. Looks pretty promising so far!

Dennis Gustafsson

112,658 次观看 • 3 年前

bonjour paris✨ nothing like a Sephora stop to finish off glam! ari uses our r.e.m. x wicked: for good glinda lip liner and glossy balm to finish off her look♡ Wicked: For Good only in theaters november 21st

bonjour paris✨ nothing like a Sephora stop to finish off glam! ari uses our r.e.m. x wicked: for good glinda lip liner and glossy balm to finish off her look♡ Wicked: For Good only in theaters november 21st

r.e.m. beauty

65,738 次观看 • 9 个月前

Mets get two prospects with different skillsets and positions for a middle reliever. Both ranked in the top 30 of a farm system better than ours. Good process here, and good luck to AJ!

Mets get two prospects with different skillsets and positions for a middle reliever. Both ranked in the top 30 of a farm system better than ours. Good process here, and good luck to AJ!

jack

43,556 次观看 • 20 天前

"You are killing your party. Because you are not a real one. - You're doing what's good for you in a vacuum. - You're no different than a pod bro." Democrats are in shambles.

"You are killing your party. Because you are not a real one. - You're doing what's good for you in a vacuum. - You're no different than a pod bro." Democrats are in shambles.

Trump Girl 🇺🇲🦅🇺🇲

76,564 次观看 • 10 个月前

Found a old memory in my library, What do you think guys ? Should I do a come back in bodybuilding or Yoga Athletics are good ? Type 1 for Bodybuilding and 2 for Yoga

Found a old memory in my library, What do you think guys ? Should I do a come back in bodybuilding or Yoga Athletics are good ? Type 1 for Bodybuilding and 2 for Yoga

Anurag Singh Vairagi

24,895 次观看 • 2 年前

Today's feel good video. In London two men are arrested for dealing Class A and B drugs. They live in a migrant hotel, and are wearing designer clothes.

Today's feel good video. In London two men are arrested for dealing Class A and B drugs. They live in a migrant hotel, and are wearing designer clothes.

David Atherton

64,667 次观看 • 5 个月前

Andy Reid on Patrick Mahomes: “I’ve had a good visit with him a couple different times. He’s in a good place. He always feels like he let people down, but then he comes back and he’s ready for the challenge ahead.”

Andy Reid on Patrick Mahomes: “I’ve had a good visit with him a couple different times. He’s in a good place. He always feels like he let people down, but then he comes back and he’s ready for the challenge ahead.”

KC Sports Network

262,541 次观看 • 8 个月前

JD VANCE: “I know that a lot of people are frustrated with the role that Israel played in all of this. But where we are right now is a good place for America.” Yes. The American people are pissed about the role Israel plays in our foreign policy.

JD VANCE: “I know that a lot of people are frustrated with the role that Israel played in all of this. But where we are right now is a good place for America.” Yes. The American people are pissed about the role Israel plays in our foreign policy.

Stew Peters

85,649 次观看 • 2 个月前