📝️ What's Changed (Pull Request list)
- Enhance: Add warehouse_id to pg_stat_activity_extended by @lss602726449 in #453
- Modify the orca optimizer's processing of unionall distribution strat… by @Light-City in #399
- Update the location of python-dependencies.txt by @Zhangbaowen-Hashdata in #460
- Add hook for exec_simple_query and support self-defined spilling memory threshold in cost module. by @songdongxiaoa2 in #447
- Fix compile error that pipe is redefined by @gfphoenix78 in #349
- [AQUMV] Use contain_var_clause instead of pull_var_clause. by @avamingli in #451
- directory_table: matchignore & remove meta-command username output by @edespino in #464
- Enhance: Add hook to support different way to create/drop/alter wareh… by @lss602726449 in #462
- Fix: replace gpscp with gpsync in ext fts by @jiaqizho in #470
- Re-used index after ALTER COLUMN TYPE shouldn't change relfilenode by @lss602726449 in #474
- Cherry-pick Resgroup related code from GreenPlum [Mar 2, 2022 - Feb 7, 2023] by @foreyes in #448
- Add weekly build and release process by @Zhangbaowen-Hashdata in #459
- [Answer Query Using Materialized Views] Consider mutable functions and bypass expressions have no Vars for view query target. by @avamingli in #455
- [AQUMV] Expose the function adjust view query and varno fix. by @avamingli in #469
- Modify weekly build release details by @Zhangbaowen-Hashdata in #477
- Call the query_info_collect_hook directly if expection happens by @foreyes in #481
- Fix record password_history when the role is not allowed to use profile. by @wenchaozhang-123 in #480
- Resolve inconsistent result issue in gpdtm_plpgsql test case by @congxuebin in #491
- Fix cbdb ci not running properly by @Zhangbaowen-Hashdata in #497
- cherry-pick: Work around spurious compiler warning in inet operators by @gfphoenix78 in #499
- Add LoongArch(loongarch64) support to s_lock.h by @wangzw in #500
- Implement some feature of directory table. by @wenchaozhang-123 in #484
- Fix copy to replicated table display copy number is incorrect. by @wenchaozhang-123 in #498
- Fix the correct size of memory block in bitmapinsert by @gfphoenix78 in #495
- re-enable the external FTS ICW by @jiaqizho in #483
- Fix ignore of direct table test files. by @avamingli in #502
- Fix gpinitsystem by @fanfuxiaoran in #490
- Fix compile errors detected by gcc 12 by @gfphoenix78 in #503
- Fix bsearch compare function in guc.c by @gfphoenix78 in #507
- [Unstable cases]Fix Some commands forgot to mark meta track. by @avamingli in #505
- Fix compile error in c++20 by @gfphoenix78 in #510
- change AOCO_Compression test case to validate pg_relation_size and get_ao_compression_ratio within ±10% expected range by @congxuebin in #493
- Maintain materialized view data status. by @avamingli in #501
- Define EXT_OID_START to suggest oid range for extensions. by @avamingli in #514
- Ignore pg_upgrade to make CI happy. by @avamingli in #515
- Reduce flakiness in test fts_segment_reset by @jiaqizho in #518
- make gp_dqa test case stable by @congxuebin in #521
- Doc: list more tools for Cloudberry Database by @tuhaihe in #523
- Fix copy to directory table always return 1. by @wenchaozhang-123 in #522
- Reimplement copy from directory table. by @wenchaozhang-123 in #527
- Add materialized view relative triggers case in SingleNode mode. by @avamingli in #517
- [Answer Query Using Materialized Views] Refactor view query target list process. by @avamingli in #525
- Implementation of Tag. by @wenchaozhang-123 in #444
- Fix segfilecount of AO/AOCO when bulk insertion: COPY by @avamingli in #530
- Feature: Update orafce to 4.9 and enhance it by @foreyes in #524
- [AQUMV]Allow to use normal materialized views to answer query. by @avamingli in #528
- Support copy from directory table for entry distribution policy. by @wenchaozhang-123 in #533
- Small README.md improvement. by @reshke in #534
- Use FDW to query multiple servers as shards by @oppenheimer01 in #320
- Add an option in psql to avoid encoding issues on some platforms by @gfphoenix78 in #535
- Refactor cbdb_log to use vfprintf by @ruhuang2001 in #506
- Update aocsam.c: fix safeFSWriteSize arg type by @reshke in #540
- Update the image to Rockylinux8 to ensure the normal operation of CI by @Zhangbaowen-Hashdata in #556
- Remove unsupported AC_FUNC_FSEEKO macro by @gfphoenix78 in #543
- adjust test cases for the cloudberrydb binary swap test by @congxuebin in #537
- CREATE FOREIGN TABLE LIKE. by @avamingli in #554
- Enable SingleQE join with SegmentGeneralWorkers by @avamingli in #327
- Use syscache lookup in ShouldUseReservedSegno by @gongxun0928 in #541
- Implement READ_STRING_FIELD_NULL serializable read function. by @wenchaozhang-123 in #553
- Fix: free tupleDesc on commit or abort transcation. by @yjhjstz in #551
- Update appendonlywriter.c: fix debug message by @reshke in #564
- Fix crash of COPY FROM on AO/AOCO/PAX partition tables. by @avamingli in #549
- Fix: Add ao_unique_index_build test in greenplum_schedule by @lss602726449 in #562
- Fix copy some directory table to problems. by @wenchaozhang-123 in #550
- Fix bug with base relation truncate for IMMV by @reshke in #570
- Suppress compile-time error in SparseData.h by @reshke in #566
- Support lock directory table. by @wenchaozhang-123 in #572
- Doc: update the alter table help command content by @EcaleD in #574
- Cherry-pick Resgroup V2 and toolkit from GPDB by @jiaqizho in #531
- Fix: no need to do the qual-clause twice by @jiaqizho in #396
- [ORCA]: fallback to postgres optimizer when NL inner plan is index scan by @gfphoenix78 in #565
- Add FIXME about redundant param from 'ivm_visible_in_prestate' call. by @reshke in #578
- Support distributed by clause specification when Create MV if not exists by @reshke in #563
- Cherry pick commits related to recent RESGROUP v2 merge. by @reshke in #579
- Change temp table name used to IMMV to some less frequent sequence of… by @reshke in #581
- Rephrase comment for deferred IVM case by @reshke in #576
- Fix pxf_fragment.c compilation failure by @Terry1504 in #590
- Fix pg_upgrade version parsing when upgrading from Greenplum by @reshke in #599
- Enable fsync=on by default in gpAux/gpdemo/gpdemo-defaults.sh by @yjhjstz in #585
- Fix serialization of expr AEXPR_NOT_DISTINCT. by @avamingli in #598
- Forbid inherits tables to store into gp_matview_aux. by @avamingli in #587
- [AQUMV] Check relation actually has children when view matching. by @avamingli in #577
- Update check.c: fixed Cloudberry incorrect references by @reshke in #600
- Fix writable rules on table has relative matview. by @avamingli in #584
- Fix writable CTE cause wrong matview data status. by @avamingli in #602
- Send rows in binary mode for ANALYZE by @Light-City in #601
- Enable the resgroup test cases in CI by @jiaqizho in #539
- Fix: could not pull up equivalence class using projected target list by @yjhjstz in #606
- Remove cbdb weekly and release workflows. by @edespino in #615
Full Changelog: 1.5.4...1.6.0
🙌🏻️ New Contributors
- @Light-City made their first contribution in #399
- @songdongxiaoa2 made their first contribution in #447
- @edespino made their first contribution in #464
- @congxuebin made their first contribution in #491
- @wangzw made their first contribution in #500
- @reshke made their first contribution in #534
- @oppenheimer01 made their first contribution in #320
- @ruhuang2001 made their first contribution in #506
- @EcaleD made their first contribution in #574
- @Terry1504 made their first contribution in #590
🧑🏻💻 Contributors
👍 Thanks to all the contributors to make this release happen:
@Aegeaner, @EcaleD, @Light-City, @RMTT, @SmartKeyerror, @Tao-T, @Terry1504, @Zhangbaowen-Hashdata, @adam8157, @airfan1994, @andr-sokolov, @ashwinstar, @avamingli, @beeender, @bmdoil, @charliettxx, @congxuebin, @dgkimura, @dh-cloud, @divyeshddv, @dreamedcheng, @edespino, @eespino, @fairyfar, @fanfuxiaoran, @foreyes, @gfphoenix78, @gongxun0928, @gpopt, @higuoxing, @huansong, @hyongtao-db, @jchampio, @jiaqizho, @jimmyyih, @kainwen, @l-wang, @lss602726449, @oppenheimer01, @reshke, @ruhuang2001, @songdongxiaoa2, @soumyadeep2007, @thedanhoffman, @tuhaihe, @wangzw, @wenchaozhang-123, @yanwr1, @yaowangm, @yjhjstz, @zhrt123, @zxuejing
🧂🧪 Try out Cloudberry Database via building one Docker-based Sandbox, which is tailored to help you gain a basic understanding of Cloudberry Database's capabilities and features a range of materials, including tutorials, sample code, and crash courses.