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

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,976 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

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 1 Jahr

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 2 Jahren

Details of foldable iPhone Duo hinge wild. There are over 100 tiny components and Apple uses an AI algorithm during manufacturing to precisely place each part with “best-fit housing for perfect alignment”. This is why Apple only manufacturing a few 100 a day right now.
0:47

Details of foldable iPhone Duo hinge wild. There are over 100 tiny components and Apple uses an AI algorithm during manufacturing to precisely place each part with “best-fit housing for perfect alignment”. This is why Apple only manufacturing a few 100 a day right now.

Trung Phan

531,590 Aufrufe • vor 18 Tagen

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

212,679 Aufrufe • vor 5 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 10 Monaten

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!
1:24

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

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

25,212 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 6 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 9 Monaten