Skip to content

Query Planning and Execution

The longest part of the book, and the one most performance questions land in: two optimizers, an executor, and the interconnect that moves tuples between segments.

  1. Chapter 17.1

    ORCA Optimizer: Entry Points and Fallback Rules

    When Cloudberry hands a query to ORCA and when it falls back to the Postgres planner — the entry path, unsupported features, and how to see the decision.

  2. Chapter 19.4

    Motion Nodes: Gather, Broadcast and Redistribute

    The five Motion types that reach the executor, what each one costs, and how to read Motion nodes in an EXPLAIN plan to spot data skew.

← All parts