GitHub user avamingli added a comment to the discussion: [Ideas] Shall we 
enable answer_query_using_materialized_views by default in v2.0?

Yes, this is an inevitable trade-off. However, compared to the significant time 
and resource savings provided by AQUMV—especially when handling large-scale 
data and SQL queries involving aggregations—the additional planning time is 
negligible.

In fact, after merging https://github.com/apache/cloudberry/pull/1117, the 
planning time has already been drastically reduced from 78.942 ms to just 1.6 
ms, making the impact minimal. 
Additionally, we have ongoing plans for further optimizations. Therefore, this 
will not be a concern in practice.

GitHub link: 
https://github.com/apache/cloudberry/discussions/1142#discussioncomment-13386135

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