August 2024 - Cloudberry Database Community Newsletter

[tuhaihe]

Note

❤️ Cloudberry Database? Giving it a ⭐ on the cloudberrydb/cloudberrydb repo!

New Release

At the early beginning of this September, we've just released Cloudberry Database v1.6.0. It's packed with amazing features and improvements. This release has more than 60 incredible contributors from our Cloudberry community and upstream projects. Thanks to them for making this release happen.👏

In this release, we also have Rocky Linux el8 & el9 RPMs (including gpbackup), Platform Extension Framework (PXF) RPM, Postgres HLL, Vector (experimental) RPMs and so much more!

You can see the full changelog here 1.5.4...1.6.0, and download it here: https://github.com/cloudberrydb/cloudberrydb/releases/tag/1.6.0.

Bootcamp

Here are some recent notable updates for our Bootcamp program:

• Supporting the latest Cloudberry Database v1.6.0.
• Also, it now supports multi-container deployments! Shout out to @antoniopetrole for his great work!

Welcome to create your sandbox based on Docker quickly: https://github.com/cloudberrydb/bootcamp.

Pull Requests

• Cherry-pick VACUUM stats & Vacuum progress related commits. #611 by @reshke
• Fix: could not pull up equivalence class using projected target list #606 by @yjhjstz
• Fix volatile EquivalenceClass has no sortref. #604 by @avamingli
• Cherry-pick ORCA InPlaceUpdate implementation #603 by @foreyes
• Fix writable CTE cause wrong matview data status. #602 by @avamingli
• Send rows in binary mode for ANALYZE #601 by @Light-City
• Update check.c: fixed Cloudberry incorrect references #600 by @reshke
• Fix pg_upgrade version parsing when upgrading from Greenplum #599 by @reshke
• Fix serialization of expr AEXPR_NOT_DISTINCT. #598 by @avamingli
• Fix pxf_fragment.c compilation failure #590 by @Terry1504
• Forbid inherits tables to store into gp_matview_aux. #587 by @avamingli
• Enable fsync=on by default in gpAux/gpdemo/gpdemo-defaults.sh #585 by @yjhjstz
• Fix writable rules on table has relative matview. #584 by @avamingli
• Change temp table name used to IMMV to some less frequent sequence of… #581 by @reshke
• Cherry pick commits related to recent RESGROUP v2 merge.  #579 by @reshke
• Add FIXME about redundant param from 'ivm_visible_in_prestate' call. #578 by @reshke
• [AQUMV] Check relation actually has children when view matching. #577 by @avamingli
• Rephrase comment for deferred IVM case #576 by @reshke
• Doc: update the alter table help command content #574 by @EcaleD
• Support lock directory table. #572 by @wenchaozhang-123
• Cherry-pick commits from GPDB, for psycopg2 #571 by @reshke
• Fix bug with base relation truncate for IMMV #570 by @reshke
• Suppress compile-time error in SparseData.h #566 by @reshke
• [ORCA]: fallback to postgres optimizer when NL inner plan is index scan #565 by @gfphoenix78
• Update appendonlywriter.c: fix debug message #564 by @reshke
• Support distributed by clause specification when Create MV if not exists #563 by @reshke
• Fix: Add ao_unique_index_build test in greenplum_schedule #562 by @lss602726449
• create test cases for upgrading compatibility validation #560 by @congxuebin
• Update the image to Rockylinux8 to ensure the normal operation of CI #556 by @Zhangbaowen-Hashdata
• CREATE FOREIGN TABLE LIKE. #554 by @avamingli
• Implement READ_STRING_FIELD_NULL serializable read function. #553 by @wenchaozhang-123
• Fix: free tupleDesc on commit or abort transcation. #551 by @yjhjstz
• Fix copy some directory table to problems. #550 by @wenchaozhang-123

Issues

• [Bug] optimizer query plan cloudberry vs greenplum #609 by @aeschbacherEUF
• [Bug] expect index scan get seq scan when explain query with parallel retrieve cursor #607 by @congxuebin
• [Bug] Type conversion error : could not pull up equivalence class using projected target list (pathkeys.c:1596) #605 by @willmkonos
• [Bug] Error found by sqlancer #596 by @shmiwy
• [Bug] Unable to understand A_Expr node #595 by @shmiwy
• [Bug] Error detected by sqlancer #594 by @shmiwy
• [Bug] volatile EquivalenceClass has no sortref #593 by @shmiwy
• [Bug] compile warning due to cherry-pick lost some commits #586 by @avamingli
• [Bug] Compilation Failure in pxf_fdw Due to PG_VERSION_NUM Update and --enable-pxf Option #583 by @edespino
• [Bug] Matview Up-go-date maintenance feature is broken.  #582 by @reshke
• Catalog changes between minor releases?  #580 by @reshke
• [Bug] brin index related, could not read block xxx in file when insert after cbdb binary swap #558 by congxuebin
• [Bug] relcache reference leak, related to ao unique index, when repeated update  #557 by @congxuebin
• [Bug] --disable-faultinjector option causes compilation failure #555 by @congxuebin
• [Bug] After creating an incremental materialized view, inserting about ten rows of data into the base table may result in an abnormal disconnection of the database connection. #552 by @csuopen

GitHub Discussions

• [Proposal] [Proposal] Improve greenplum diagnostics #614 by @leborchuk
• [Proposal] Potential Proposal: Cloudberry DB Extension Compatibility Framework #612 by @edespino
• [Proposal] [Proposal] Cloudberry Open Source Release Plan for Version 1.6.0 #592 by @edespino
• [Proposal] [Proposal] Adopting a PostgreSQL-Style Branching Strategy with Semantic Versioning (SemVer) for the Cloudberry Project #591 by @edespino
• [Proposal] 希望能提供容灾功能 #559 by @dbbao
• [Feature requests] Backup/Restore database #597 by @leborchuk
• [Feature requests] [Ideas] Support Aggregation pushdown while using outer joins #561 by @foreyes
• [Q&A] What is PAX table access method? #610 by @reshke

Website

This month, we added new documents to our website, including system utility, SQL, built-in functions, etc. We also added some index pages to help you get a quick overview of the documents, as they have a lot of sections. Thanks @TomShawn @dnbnero @EcaleD @csuopen @tuhaihe @vitalboyzf for their contributions to the website.

New tool for Cloudberry Database

One more repo has been public to access recently - pgvector for Cloudberry!

You can get the source code here: https://github.com/cloudberrydb/pgvector, and download the rpm package from the release page: https://github.com/cloudberrydb/cloudberrydb/releases/tag/1.6.0.

Blog

• Review blog for the first-ever in-person Cloudberry Database Meetup in Beijing 2024, see on LinkedIn.

Join us

The Cloudberry Database community welcomes everyone to contribute, regardless of their level of experience. We encourage all types of contributions, no matter how small. Our contribution guide is available to help you get started with the process.

In addition, we offer various channels for community members to discuss, seek help, provide feedback, and chat. You can find support here. Let us know if you have any questions or feedback - we're always here to help!

Join us and be part of our community!

Past Newsletter

• July 2024 - Cloudberry Database Community Newsletter #588
• June 2024 - Cloudberry Database Community Newsletter #513
• May 2024 - Cloudberry Database Community Newsletter #457
• April 2024 - Cloudberry Database Community Newsletter #419
• March 2024 - Cloudberry Database Community Newsletter #402
• February 2024 - Cloudberry Database Community Newsletter #389
• January 2024 - Cloudberry Database Community Newsletter #378

---