// Link · 25 April 2026

Traditional vs. MPP Databases: Architecture, Scaling, and Workload Tradeoffs

SMP databases (PostgreSQL, Oracle) run on a single shared server - great for OLTP workloads like transactions and microservices. MPP databases (ClickHouse, Greenplum) distribute data across many servers - built for OLAP analytics over terabytes. Pick SMP for transaction speed, MPP for analytical sca...

Hacker Noon

@hacker-noon · hackernoon.com

hackernoon.com

Hacker Noon@hacker-noon