GitHub user KrasnovidKE closed a discussion: Are there any plans to further 
develop GPORCA to support all query performance optimizations?

The query performance optimizations listed below (taken from the documentation 
at https://cloudberry.apache.org/docs/performance/) work exclusively for the 
Postgres query optimizer AKA Legacy Optimizer:
- Parallel Queries Execution
- Aggregation pushdown
- IndexScan on AO Tables
- RuntimeFilter

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

So is it planned to improve GPORCA or maybe there are plans to somehow improve 
Legacy optimizer?

In short, the question can be generalized to a request to disclose plans for 
the future of both optimizers


GitHub link: https://github.com/apache/cloudberry/discussions/729

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