Hi 各位社区小伙伴们，Cloudberry Database 2024 年 5 月社区月报来啦！下面将分享下在过去的 5 月项目和社区的整体进展。马上开始！
新版发布 - 1.5.3 版本
我们努力保持每月一版的节奏，以便让社区成员体验新功能和改进。5 月底 Cloudberry Database v1.5.3 发布，本次是一个小版本更新，包含了一些提升改进、 bug 修复和文档更新。你可以查看发版说明[1]了解详情。
感谢为本次版本发布做出贡献的社区成员！
4 月底我们成功发布了 v1.5.2 版本，训练营项目[2]已经在 #422[3] 中宣布支持 Cloudberry Database v1.5.2。不过，我们将会跳过支持 v1.5.3，因为 v1.5.3 版本中的某个新增功能需要安装额外依赖（后续改进和最新主分支中已移除额外依赖），同时从 6 月份即将发布的 1.5.4 版本开始恢复支持。
亮点
在过去的周末，Cloudberry Database 连续 2 天上榜“GitHub 热门仓库” - C 语言类热门项目。特别感谢大家的支持，Cloudberry Database 关注度近期持续上升：
生态周边
PostGIS for Cloudberry Database 于近期发布，仓库位置：@cloudberrydb/postgis[4]。
PostGIS 是一款 PostgreSQL 扩展，支持对地理空间数据进行存储、索引和查询。你可以按照指南在 Cloudberry Database 上编译安装 PostGIS，后续也将推进 PostGIS 内核版本升级。
网站更新
我们目前已完成大部分网站页面的中文翻译工作，在 5 月份上线了包括支持[5]、贡献[6]、博客[7]等模块的中文翻译内容。
Pull Request 清单
• [Answer Query Using Materialized Views] Consider mutable functions and bypass expressions have no Vars for view query target. #455[8] by @avamingli
• Enhance: Add
warehouse_id
topg_stat_activity_extended
#453[9] by @lss602726449• Insert more data to make tuplestore spill in
regress/misc_jiras.sql
. #452[10] by @fanfuxiaoran• [AQUMV] Use
contain_var_clause
instead ofpull_var_clause
. #451[11] by @avamingli• CPP keywords should not be used as function/parameter names #449[12] by @jiaqizho
• [WIP] Cherry-pick GUC related code base from Greenplum [Mar 8, 2022 - Nov 25, 2022] #448[13] by @foreyes
• Add hook for exec_simple_query and support self-defined spilling memory threshold in cost module. #447[14] by @songdongxiaoa2
• [Answer Query Using Materialized Views] Support LIMIT/OFFSET/FETCH clause on origin query. #446[15] by @avamingli
• Cleanup the build tools and guide directories #445[16] by @tuhaihe
• Expand a new external var tag #443[17] by @jiaqizho
• PendingDelete: expand the pending deletes interface #442[18] by @jiaqizho
• [Answer Query Using Materialized Views] Support Postgres special grammar DISTINCT ON clause on origin query. #441[19] by @avamingli
• [WIP] Cherry-pick ResourceGroup update from Greenplum #440[20] by @foreyes
• [AQUMV] Support
DISTINCT
clause on origin query. #439[21] by @avamingli• Fix checking password file permissions in
dbconn.py
#438[22] by @fanfuxiaoran• [ORCA] Fix flaky "Invalid key is inaccessible" fallback (#15147) #437[23] by @fanfuxiaoran
• Fix motion toast error. #436[24] by @gfphoenix78
• Refactor cbload to gpdirtableload with python. #435[25] by @wenchaozhang-123
• Fix explain(locus) issues. #433[26] by @avamingli
• Cherry pick from GPDB (02/07/2022-02/28/2022) #432[27] by @avamingli
• Remove cbload relevant codes. #431[28] by @wenchaozhang-123
• checkberry gpcheckperf series updates are used to solve the problem that cbdb 1.5.2 version gpcheckperf does not display disk information #430[29] by @August-beaulo
• Update the googletest module URL #429[30] by @tuhaihe
• Add function
cbdb_relation_size
#428[31] by @fanfuxiaoran• Fix drop directory privilege check. #425[32] by @wenchaozhang-123
• Fix visimap consults for unique checks during UPDATEs #423[33] by @lss602726449
Issue 清单
• [Bug] Cannot access the code URL for googletest to result in GitHub Dependabot can't update dependencies. #427[34] by @tuhaihe
• [Bug] cbdb 1.5.2 version gpcheckperf does not display disk information #421[35] by @August-beaulo
贡献者
🎈️🎊️ 感谢以下贡献者在本月对 Cloudberry Database 的贡献：
@avamingli, @lss602726449, @fanfuxiaoran, @jiaqizho, @foreyes, @songdongxiaoa2, @tuhaihe, @gfphoenix78, @wenchaozhang-123, @August-beaulo, @vitalboyzf, @TomShawn
加入我们
Cloudberry Database 致力于打造中立、开放和友好的数据库技术社区，我们面向任何人保持开放，无论其经验水平如何。我们鼓励各种类型的贡献，无论大小多少，可参考《贡献指南》[36]查看可参与贡献的方式。
除此之外，我们为社区成员提供了丰富的交流、求助和获取反馈的渠道，可查看支持页面[37]了解详情。如有任何问题或反馈，大胆求助即可，我们乐意帮助！
加入我们，成为社区成员的一份子吧！
👇🏻️扫码加入 Cloudberry Database 交流群👇🏻️
过往月报
引用链接
[1]
发版说明: https://cloudberrydb.org/docs/releases/release-1.5.3[2]
训练营项目: https://github.com/cloudberrydb/bootcamp[3]
#422: https://github.com/orgs/cloudberrydb/discussions/422[4]
@cloudberrydb/postgis: https://github.com/cloudberrydb/postgis[5]
支持: https://cloudberrydb.org/zh/support[6]
贡献: https://cloudberrydb.org/zh/contribute#%E6%8E%A2%E7%B4%A2%E8%B4%A1%E7%8C%AE%E6%96%B9%E5%BC%8F[7]
博客: https://cloudberrydb.org/zh/blog[8]
#455: https://github.com/cloudberrydb/cloudberrydb/pull/455[9]
#453: https://github.com/cloudberrydb/cloudberrydb/pull/453[10]
#452: https://github.com/cloudberrydb/cloudberrydb/pull/452[11]
#451: https://github.com/cloudberrydb/cloudberrydb/pull/451[12]
#449: https://github.com/cloudberrydb/cloudberrydb/pull/449[13]
#448: https://github.com/cloudberrydb/cloudberrydb/pull/448[14]
#447: https://github.com/cloudberrydb/cloudberrydb/pull/447[15]
#446: https://github.com/cloudberrydb/cloudberrydb/pull/446[16]
#445: https://github.com/cloudberrydb/cloudberrydb/pull/445[17]
#443: https://github.com/cloudberrydb/cloudberrydb/pull/443[18]
#442: https://github.com/cloudberrydb/cloudberrydb/pull/442[19]
#441: https://github.com/cloudberrydb/cloudberrydb/pull/441[20]
#440: https://github.com/cloudberrydb/cloudberrydb/pull/440[21]
#439: https://github.com/cloudberrydb/cloudberrydb/pull/439[22]
#438: https://github.com/cloudberrydb/cloudberrydb/pull/438[23]
#437: https://github.com/cloudberrydb/cloudberrydb/pull/437[24]
#436: https://github.com/cloudberrydb/cloudberrydb/pull/436[25]
#435: https://github.com/cloudberrydb/cloudberrydb/pull/435[26]
#433: https://github.com/cloudberrydb/cloudberrydb/pull/433[27]
#432: https://github.com/cloudberrydb/cloudberrydb/pull/432[28]
#431: https://github.com/cloudberrydb/cloudberrydb/pull/431[29]
#430: https://github.com/cloudberrydb/cloudberrydb/pull/430[30]
#429: https://github.com/cloudberrydb/cloudberrydb/pull/429[31]
#428: https://github.com/cloudberrydb/cloudberrydb/pull/428[32]
#425: https://github.com/cloudberrydb/cloudberrydb/pull/425[33]
#423: https://github.com/cloudberrydb/cloudberrydb/pull/423[34]
#427: https://github.com/cloudberrydb/cloudberrydb/issues/427[35]
#421: https://github.com/cloudberrydb/cloudberrydb/issues/421[36]
《贡献指南》: https://cloudberrydb.org/contribute/how-to-contribute[37]
支持页面: https://cloudberrydb.org/support
Cloudberry Database 是专门面向 AI 和分析场景打造的一款开源数据库，团队由 Greenplum Database 原始开发团队成员和 PostgreSQL 贡献者组成。作为 Greenplum Database 的衍生版，Cloudberry Database 与 Greenplum Database 保持原生兼容，并能实现无缝迁移，具备更新的内核和更丰富的功能。
GitHub: https://github.com/cloudberrydb/cloudberrydb
⭐️点击「阅读原文」，关注 GitHub，点个收藏吧！⭐️
