Hacker Afternoon Tea

Mar 30, 2022 · Databases

Understanding Citus Distributed PostgreSQL: Query Processing Architecture

The article explains how a Citus cluster—comprising a coordinator and multiple workers—splits and routes SQL queries, detailing the distributed planner, executor, push‑pull handling of subqueries/CTEs, and a step‑by‑step EXPLAIN walkthrough of a top‑20 page‑views query.