FeatureFuel
1

Feature request: Support pg_orca (Cascades-style query optimizer) as an alternative PostgreSQL optimizer

Source: supabase/supabase#49794 · opened by @yjhjstz
Feature request Is your feature request related to a problem? PostgreSQL's built-in planner occasionally produces suboptimal plans for complex analytical queries (multi-way joins, subqueries, CTEs). A new open-source extension, [pg_orca]( is a PostgreSQL port of the ORCA query optimizer — a Cascades-style, cost-based optimizer — and could offer significant performance improvements for such workloads. Describe the solution you'd like It would be great if Supabase could evaluate and support pg_orca as an optional optimizer for Postgres projects, e.g.: • Making the extension available via the Supabase dashboard (Database > Extensions) and in hosted Postgres images • Allowing users to enable/disable it per database or per session • Documentation on when it helps (analytical / join-heavy workloads) vs. when the default planner is fine Describe alternatives you've considered • Sticking with the stock PostgreSQL planner (status…

No pledges yet. Be the first to back this.

Make a pledge

Pledge your monetary support if this feature is added.

$

Comments

No comments yet.

Replying to

Add a comment

What do you think about this feature request?


Similar requests