Re: [D] Are there any plans to further develop GPORCA to support all query performance optimizations? [cloudberry]

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

Re: [D] Cloudberry Database Roadmap 2024 [cloudberry]

GitHub user adar604 added a comment to the discussion: Cloudberry Database Roadmap 2024 Cart GitHub link: https://github.com/apache/cloudberry/discussions/369#discussioncomment-11448825 This is an automatically sent email for dev@cloudberry.apache.org. To unsubscribe, please send an em

Re: [D] Cloudberry Database Roadmap 2024 [cloudberry]

GitHub user tuhaihe added a comment to the discussion: Cloudberry Database Roadmap 2024 Hi everyone, since Cloudberry has joined the ASF Incubator, the new roadmap for Cloudberry is now up for discussion. We welcome your feedback: https://lists.apache.org/thread/wo1lsly8h7q8c4sxrwpw73ylbnzrcw

Re: [D] Enable answer query using Materialized View for external table. [cloudberry]

GitHub user adar604 added a comment to the discussion: Enable answer query using Materialized View for external table. > GitHub link: https://github.com/apache/cloudberry/discussions/693#discussioncomment-11448973 This is an automatically sent email for dev@cloudberry.apache.org. T

Re: [D] Enable answer query using Materialized View for external table. [cloudberry]

GitHub user adar604 edited a comment on the discussion: Enable answer query using Materialized View for external table. Adar604 GitHub link: https://github.com/apache/cloudberry/discussions/693#discussioncomment-11448973 This is an automatically sent email for dev@cloudberry.apache.org.

Re: [D] Enable answer query using Materialized View for external table. [cloudberry]

GitHub user adar604 added a comment to the discussion: Enable answer query using Materialized View for external table. ⁹ŕ GitHub link: https://github.com/apache/cloudberry/discussions/693#discussioncomment-11448982 This is an automatically sent email for dev@cloudberry.apache.org. To un

Re: [D] [Ideas] Optimize SQL: select distinct count(a) from t1; [cloudberry]

GitHub user avamingli closed a discussion: [Ideas] Optimize SQL: select distinct count(a) from t1; ### Description User has a auto-generated SQL by 3rd-party like: ```sql select DISTINCT count(distinct a) form t1; ``` However, for such query: Aggregate SQL without Group by, there is one row

Re: [D] [Ideas] Optimize SQL: select distinct count(a) from t1; [cloudberry]

GitHub user avamingli closed the discussion with a comment: [Ideas] Optimize SQL: select distinct count(a) from t1; Implemented by #685 . GitHub link: https://github.com/apache/cloudberry/discussions/677#discussioncomment-11456468 This is an automatically sent email for dev@cloudberry.a