Replies: 3 comments 4 replies
-
|
Thanks for the proposal. I think it is doable for ORCA, and would bring noticeable performance improvement for ORCA plan. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
In fact, we would need to add severals transforms and a new CDistributionSpec. |
Beta Was this translation helpful? Give feedback.
4 replies
-
|
milestone 1: #1398 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Proposers
@yjhjstz
Proposal Status
Under Discussion
Abstract
ORCA (Pivotal Query Optimizer) currently has limited parallel planning capabilities, This creates an inconsistency where:
Motivation
Extend ORCA to generate parallel execution plans that align with PostgreSQL's parallel planning approach, while maintaining
compatibility with Cloudberry's MPP architecture.
Implementation
Extend ORCA's path generation to create parallel-aware operators:
Implement parallel join strategies similar to PostgreSQL:
// Parallel hash join with shared hash table
class CPhysicalParallelHashJoin : public CPhysicalHashJoin {
// Enable parallel-aware hash table sharing
// Handle worker coordination for hash table building
// Manage locus for HashedWorkers distribution
};
Enhance ORCA's cost model to account for parallel execution:
Rollout/Adoption Plan
Benefits
Are you willing to submit a PR?
Beta Was this translation helpful? Give feedback.
All reactions