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.

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 views • 6 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

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 views • 1 year ago

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 views • 1 year ago

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 views • 1 year ago

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

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 views • 1 year ago

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 views • 2 years ago

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 views • 4 months ago

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 views • 3 years ago

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 views • 9 months ago

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 views • 15 days ago

"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 views • 10 months ago

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,842 views • 2 years ago

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 views • 5 months ago

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 views • 8 months ago

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 views • 1 month ago