Data and storageCache vs index
How does one cold cache turn a missing index into thousands of scans?
0%
Page 37
More questions.
Data and storageDeletes
Why does deleting one key make another key vanish?
0%
Data and storageRare items
A search ran 300 times. Why might the sketch say 100,300?
0%
Data and storageH3
Why did Uber pick hexagons, not squares, to price surge?
0%
Data and storageFour places
How does a kirana shop explain your whole data layer?
0%
Data and storageHOT updates
A tiny index fixed the read. Why did writes get more expensive?
0%
Data and storageDual write
Commit the order, then publish to Kafka. What could possibly go wrong?
0%
Data and storageGap locks
Why does an insert for user 9 wait on a lock for user 7?
0%
Data and storageCutover
Notion’s first sharding needed five minutes of downtime. Where did it hide?
0%
Data and storageBloom filters
An LSM read may check eight files. How is it still fast?
0%
Data and storageKeeping in sync
You write to the database and to Elasticsearch. Why do they drift apart?
0%
Data and storageHot rows
With 5 ms locks, why can’t more servers push a hot row past 200/s?
0%
Data and storageFuzzy search
Fuzzy search forgives “kurtha”. Why does it also turn “red” into “bed”?
0%
Data and storageTypos
Shoppers type “kurtha”. How does search avoid comparing it with every word?
0%
Data and storageUpdates
One price changes. Why does Bazaar re-index the entire product?
0%
Data and storageLicences
Elasticsearch left Apache 2.0 in 2021. How is it open source again?
0%
Data and storageAggregations
Your brand facet says Kesar sells most. Why is Rangrez really first?
0%
Data and storagePartitioning
Why does Google ask every shard when two could answer “chai recipe”?
0%
Data and storageBlue-green rebuild
How do you rebuild a 50-million-product index while shoppers keep searching?
0%
Data and storageUber logs
Only 5% of Uber’s indexed log fields were ever queried. What did it do?
0%
Data and storageMyth
If NoSQL is faster, why does one query hit every node?
0%
Data and storageConnections
Why can 300 PostgreSQL connections need 6 GB of query memory?
0%
Data and storageRestore time
Your 10 TB database takes 5.6 hours to restore. Time to shard?
0%
Data and storagePicture it
Why does a kirana owner copy every bill into two long registers?
0%
Data and storageHot partitions
What happens when one seller takes 2,000 orders a second on DynamoDB?
0%
Data and storageDependencies
Every customer name in your data is unique. So is the name a key?
0%