#indexing (7)

1 note • 6 videos

2026

(1)

Jun 30

NOTE Optimizations Are Trades Made Within Constraints With No Free Lunch

Career Growth #career-growth #concurrency #concurrency-control

2024

(2)

May 31

VIDEO How Converged Indexes Work: Inside Rockset's Search and Analytics Engine

Systems Internals #rockset #rocksdb #converged-index
Feb 23

VIDEO Understanding Database Trade-offs: The RUM Conjecture Explained

Systems Internals #databases #rum-conjecture #storage-engines

2022

(3)

Sep 19

VIDEO How Instagram Efficiently Serves Hashtags Ordered by Count

Databases #postgresql #indexing #partial-indexes
Jun 06

VIDEO Post-Mortem: How a Single MySQL Index Broke GitHub

Databases #mysql #indexing #databases
Mar 16

VIDEO How Database Indexes Minimize Disk I/O to Accelerate Read Performance

Systems Internals #databases #indexing #disk-io

2021

(1)

Apr 19

VIDEO Designing a Scalable Udemy-Style Taxonomy Hierarchy in SQL

Databases #system-design #sql #database-design