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