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 scale.