Загрузка видео...

Не удалось загрузить видео

На главную

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 просмотров • 6 месяцев назад •via X (Twitter)

LIVE

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
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 просмотров • 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!
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,585 просмотров • 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:
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 просмотров • 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?
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 просмотров • 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.
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 просмотров • 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
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 просмотров • 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?
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 просмотров • 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.
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,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!
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 просмотров • 3 лет назад

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 просмотров • 11 дней назад

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 просмотров • 9 месяцев назад

"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 просмотров • 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
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 просмотров • 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.
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 просмотров • 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.”
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 просмотров • 7 месяцев назад

'Today is a good day for Northern Ireland, and for the deaf community' - Communities Minister Gordon Lyons MLA uses sign language in the Chamber as he introduces the second stage of the Sign Language Bill
1:12

'Today is a good day for Northern Ireland, and for the deaf community' - Communities Minister Gordon Lyons MLA uses sign language in the Chamber as he introduces the second stage of the Sign Language Bill

DUP

17,741 просмотров • 1 год назад