GitHub user avamingli added a comment to the discussion: Are there any plans to 
further develop GPORCA to support all query performance optimizations?


> However, this legacy optimizer produces extremely complex and generally poor 
> plans for large queries compared to GPORCA.

Max and I previously discussed a related topic and plan to enhance our AQUMV 
feature to support complex SQL queries. Specifically, we aim to ensure that all 
examples from TPC-DS can utilize the AQUMV functionality. 
This will greatly address the efficiency issues related to complex queries, 
especially in cases like those in TPC-DS.

Additionally, we intend to support two different optimizers so that users can 
quickly obtain query results regardless of which one they choose to use.

This is a complex and long-term task, and it is already on my list of plans.

GitHub link: 
https://github.com/apache/cloudberry/discussions/729#discussioncomment-11379885

----
This is an automatically sent email for dev@cloudberry.apache.org.
To unsubscribe, please send an email to: dev-unsubscr...@cloudberry.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@cloudberry.apache.org
For additional commands, e-mail: dev-h...@cloudberry.apache.org

Reply via email to