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

Hi @KrasnovidKE
In fact, we plan to enable those features you mentioned in GPORCA in our 
roadmap. In the long term, we plan to narrow the difference between GPORCA and 
Legacy optimizer, so that there is no need for users to be torn about which 
optimizer to choose.

There are two ways:
The first is to cherry pick GPORCA's special features back to Legacy planner, 
and contribute those features to PostgreSQL, and maintain one planner finally, 
but it would take time for PostgreSQL community to accept those changes. 
Comparing benchmark(TPC-H/TPC-DS) results based on Legacy planner and GPORCA is 
the guideline for us to do the work.

Another approach is, enabling features that comes from PostgreSQL kernel 
upgrading in GPORCA. For example, clean up FIXMEs in GPORCA, enable incremental 
sort, and etc.

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

----
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