Syntax, Semantics, and Segfaults

Thoughts, stories and ideas.

Latest

Stencil-Based Just-In-Time Compilation for SQL Expression Evaluation: A Copy-and-Patch Approach

Abstract Just-in-time compilation offers significant performance improvements for database query execution by eliminating interpreter overhead. However, traditional JIT frameworks such as LLVM introduce compilation latencies measured in milliseconds, which fail to amortize for typical OLTP workloads. This article presents a practical implementation of stencil-based JIT compilation for SQL expression evaluation,

By J

Memory Locality in the Age of Virtualization: Optimizing Database Performance in Hidden NUMA Topologies

1. Introduction Modern cloud infrastructure presents a fascinating paradox: as we advance toward more sophisticated hardware architectures, virtualization increasingly obscures these same architectures from the software running within virtual machines. This phenomenon is particularly evident in Non-Uniform Memory Access (NUMA) systems, where memory access times depend on the memory location

By J