Cloudberry Database 社区简报 - 2024/5

Cloudberrydb Team

2024年6月5日

❤️ 喜欢我们？欢迎在 GitHub 上给我们的仓库 cloudberrydb/cloudberrydb 点个赞！

发布 1.5.3 版本

Cloudberry Database v1.5.3 已于近期发布，本次版本是一个小版本更新，包含了一些提升改进、 bug 修复和文档更新。你可以查看发版说明了解详情。

我们的训练营已经在 #422 中宣布支持 Cloudberry Database v1.5.2 版本，不过不会支持 v1.5.3，因为 v1.5.3 版本中的某个新增功能需要安装额外依赖（后续改进中已移除额外依赖）。训练营项目将恢复支持本月即将发布的 1.5.4 版本。

亮点

在过去的周末，Cloudberry Database 连续 2 天上榜“GitHub 热门仓库” - C 语言类热门项目。特别感谢大家的支持，Cloudberry Database 关注度近期持续上升：

生态周边

PostGIS for Cloudberry Database 于近期发布 - @cloudberrydb/postgis。PostGIS 是一款 PostgreSQL 扩展，支持对地理空间数据进行存储、索引和查询。你可以按照指南在 Cloudberry Database 上安装 PostGIS，后续我们也将推进 PostGIS 版本升级。

Pull Request 清单

[Answer Query Using Materialized Views] Consider mutable functions and bypass expressions have no Vars for view query target. #455 by @avamingli
Enhance: Add warehouse_id to pg_stat_activity_extended #453 by @lss602726449
Insert more data to make tuplestore spill in regress/misc_jiras.sql. #452 by @fanfuxiaoran
[AQUMV] Use contain_var_clause instead of pull_var_clause. #451 by @avamingli
CPP keywords should not be used as function/parameter names #449 by @jiaqizho
[WIP] Cherry-pick GUC related code base from GreenPlum [Mar 8, 2022 - Nov 25, 2022] #448 by @foreyes
Add hook for exec_simple_query and support self-defined spilling memory threshold in cost module. #447 by @songdongxiaoa2
[Answer Query Using Materialized Views] Support LIMIT/OFFSET/FETCH clause on origin query. #446 by @avamingli
Cleanup the build tools and guide directories #445 by @tuhaihe
Expand a new external var tag #443 by @jiaqizho
PendingDelete: expand the pending deletes interface #442 by @jiaqizho
[Answer Query Using Materialized Views] Support Postgres special grammar DISTINCT ON clause on origin query. #441 by @avamingli
[WIP] Cherry-pick ResourceGroup update from GreenPlum #440 by @foreyes
[AQUMV] Support DISTINCT clause on origin query. #439 by @avamingli
Fix checking password file permissions in dbconn.py #438 by @fanfuxiaoran
[ORCA] Fix flaky "Invalid key is inaccessible" fallback (#15147) #437 by @fanfuxiaoran
Fix motion toast error. #436 by @gfphoenix78
Refactor cbload to gpdirtableload with python. #435 by @wenchaozhang-123
Fix explain(locus) issues. #433 by @avamingli
Cherry pick from GPDB (02/07/2022-02/28/2022) #432 by @avamingli
Remove cbload relevant codes. #431 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 by @August-beaulo
Update the googletest module URL #429 by @tuhaihe
Add function cbdb_relation_size #428 by @fanfuxiaoran
Fix drop directory privilege check. #425 by @wenchaozhang-123
Fix visimap consults for unique checks during UPDATEs #423 by @lss602726449

Issue 清单

[Bug] Cannot access the code URL for googletest to result in GitHub Dependabot can't update dependencies. #427 by @tuhaihe
[Bug] cbdb 1.5.2 version gpcheckperf does not display disk information #421 by @August-beaulo

贡献者

🎈️🎊️ 感谢以下贡献者在本月对 Cloudberry Database 的贡献：

@avamingli, @lss602726449, @fanfuxiaoran, @jiaqizho, @foreyes, @songdongxiaoa2, @tuhaihe, @gfphoenix78, @wenchaozhang-123, @August-beaulo, @vitalboyzf, @TomShawn