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