Posts

All the articles I've posted.

• 8 MIN READ•Apr 29, 2026

  Buffer Pools, Caches, and the Memory Hierarchy

  Databases use buffer pools, column caches, and result caches to keep hot data in RAM. Here is how each caching strategy works and what happens when data does not fit.

  database cachingbuffer poolcache eviction
• 8 MIN READ•Apr 29, 2026

  Writing to an Apache Iceberg Table: How Commits and ACID Actually Work

  Here is exactly how an engine writes to an Iceberg table, step by step, from data files through the atomic commit that makes ACID guarantees possible.

  writing to Apache IcebergIceberg ACID transactionsatomic commit
• 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