36% Faster Without Changing a Single Query: Inside MemCP's New Scan Engine

MemCP is an in-memory columnar database written in Go with a Scheme scripting layer for query compilation, planning and optimization. Its storage engine organizes data into shards, each containing a compressed main storage and a small append-only delta buffer for recent writes. Until now, the two primary scan paths — unordered aggregation (scan) and ordered…















































