Posts

All the articles I've posted.

• 8 MIN READ•Apr 29, 2026

  Volcano, Vectorized, Compiled: How Engines Execute Your Query

  The Volcano model processes one row at a time. Vectorized execution processes batches with SIMD. Code generation fuses operators into compiled code. Here is how each works.

  query execution modelsvectorized executionvolcano iterator model
• 8 MIN READ•Apr 29, 2026

  Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

  Iceberg's hidden partitioning separates physical layout from user queries using transform functions. Here is how it works and why it eliminates accidental full scans.

  Iceberg hidden partitioningpartition transformsaccidental full table scan
• 8 MIN READ•Apr 29, 2026

  Inside the Query Optimizer: How Engines Pick a Plan

  Query optimizers transform SQL into execution plans using rule-based rewrites, cost-based search, and adaptive runtime adjustments. Here is how each approach works.

  query optimizercost-based optimizationquery planning