Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

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.

BenjDicken's profile picture

Ben Dicken

41,040 subscribers

51,744 Aufrufe • vor 5 Monaten •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

0 Kommentare

Keine Kommentare verfügbar

Kommentare vom Original-Post werden hier angezeigt

Ähnliche 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
0:39

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 Aufrufe • vor 1 Jahr

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!
0:26

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,485 Aufrufe • vor 1 Jahr

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:
0:32

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 Aufrufe • vor 1 Jahr

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?
0:30

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 Aufrufe • vor 1 Jahr

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.
1:44

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 Aufrufe • vor 10 Monaten

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
9:50

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 Aufrufe • vor 1 Jahr

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?
0:40

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,241 Aufrufe • vor 2 Jahren

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.
0:58

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

211,974 Aufrufe • vor 3 Monaten

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!
0:27

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 Aufrufe • vor 3 Jahren

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
0:31

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 Aufrufe • vor 8 Monaten

"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.
1:12

"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 Aufrufe • vor 9 Monaten

Beyoncé is AMAZING and probably one of my fav artist, but honestly no one dances better than young Britney. It's clear that although Beyoncé has the vocals, Britney can dance better. Beyonce just does a lot of jiggling and spazzing, and she pretty much uses her butt/waist only to get the momentum whereas Britney uses ALL of her body to do the same. She’s like a white Janet with gymnastics steps incorporated. They’re both really good dancers but Britney is for a fact, a professional dancer with technique.
3:29

Beyoncé is AMAZING and probably one of my fav artist, but honestly no one dances better than young Britney. It's clear that although Beyoncé has the vocals, Britney can dance better. Beyonce just does a lot of jiggling and spazzing, and she pretty much uses her butt/waist only to get the momentum whereas Britney uses ALL of her body to do the same. She’s like a white Janet with gymnastics steps incorporated. They’re both really good dancers but Britney is for a fact, a professional dancer with technique.

santaspears

683,960 Aufrufe • vor 2 Jahren

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
0:44

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 Aufrufe • vor 2 Jahren

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.
1:00

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 Aufrufe • vor 4 Monaten

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.”
0:31

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 Aufrufe • vor 7 Monaten

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.
1:37

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 Aufrufe • vor 1 Monat