Use GPORCA Optimizer
GPORCA is an enhanced query optimizer built on top of the PostgreSQL planner. It performs particularly well on multi-core architectures, and the system uses it by default where supported.
GPORCA Overview
How GPORCA relates to the Postgres planner, and when it is used by default.
GPORCA Features and Enhancements
Which types of queries and operations GPORCA handles better.
GPORCA Performance Tuning
Organized by common performance scenario, showing how GPORCA addresses each.