PostgreSQL’s analytical extensions—pg_duckdb, Citus Columnar, TigerData Columnar—push it beyond OLTP, but how far does that go in practice? We benchmark these approaches against specialized OLAP engines on TPC-DS, ClickBench, and real-world queries, showing where PostgreSQL competes and where dedicated systems still win, plus a framework for deciding which your workload needs.
Daniel started his career as PhD student in the area of cloud computing with a focus on distributed databases in the cloud. Further interests cover cloud orchestration, model-driven engineering, and performance evaluations of distributed systems. After completing his PhD, Daniel has co-founded the Benchmarking-as-a-Service platform benchANT where he is responsible for the product development.
