Posts
All the articles I've posted.
B-Trees, LSM Trees, and the Indexing Tradeoff Spectrum
Published: at 12:03 PMB-trees balance reads and writes for OLTP. LSM trees maximize write throughput. Bitmap indexes accelerate OLAP filtering. Here is when to use each.
Performance and Apache Iceberg's Metadata
Published: at 12:02 PMIceberg's three-layer metadata tree eliminates directory listing and enables multi-level data skipping. Here is how scan planning actually works.
How Databases Organize Data on Disk: Pages, Blocks, and File Formats
Published: at 12:02 PMDatabases structure data on disk as heap files, sorted files, or LSM trees, then wrap it in formats like Parquet with metadata that lets engines skip irrelevant blocks.