---
answer: direct
beat: system-design
source: 1 article · updated: November 14, 2026
---

Why is an update-heavy workload hard for a data warehouse?

Warehouses are optimised for appending large batches and scanning columns. Frequent small updates to existing rows force expensive merges or rewrites of the files holding them. Content tools where users edit existing items far more than they create new ones hit this wall quickly, in both speed and cost.

Answered in

From Sharded Postgres to a Data Lake: CDC, Hudi and Update-Heavy Workloads

Why warehouses struggle when most writes are updates, and how Debezium, Kafka, Hudi and Spark replaced 480 hourly connectors for 200 billion rows.

Crashtech Editorial November 14, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design & Architecture beat.