olap

1 article
sort: new top best
clear filter
0 5/10

This article explains why OLAP database schema migrations are significantly more complex than OLTP migrations due to fundamental design tradeoffs: immutable columnar storage, physical ordering keys, and materialized view dependencies. The author demonstrates how optimizations that enable fast analytical reads (compression, asynchronous mutations, pre-aggregated tables) create cascading costs when schemas change.

ClickHouse Postgres MergeTree F45 MooseStack Johanan Ottensooser
fiveonefour.com · mooreds · 17 hours ago · details · hn