Dianjin Wang
09/01/2023, 9:23 AMGitHub
09/05/2023, 5:28 AMgp_role
are added. The implementation will be trifold:
• Code
• int
-typed global variable GpSegmentCount
(I start to think this isn't a good name, I'll replace it once I come up with a better one) will be added to cache getgpsegmentCount
value at the initialization time. This value is to support IS_SINGLENODE
and IS_UTILITY_OR_SINGLENODE
macros.
• all branch and assertions w.r.t. utility
mode will be expanded to Gp_role == GP_ROLE_UTILITY || IS_SINGLENODE()
• Script
• we plan to use the already baked NUM_PRIMARY_MIRROR_PAIRS=0
to support create singlenode deployment in all scripts and commands (gpstop
, gpstart
, etc.)
• user can reliably detect whether the remote is in singlenode or not by select case when count(*) = 0 then true else false end as is_singlenode from gp_segment_configuration where content != -1;
• Test
• The most challenging and irksome part of this PR is how to handle tests. Many tests in regress
relies on test plan which surely is different under singlenode mode and isolation2
tests often require concurrent semantic and utility mode (-1U
, 1U
, etc.) that singlenode does't support. My initial proposal is to make those tests that behave differently on singlenode have their own copy of the expected file and change test suite (e.g., isolation2/sql_isolation_testcase.py
) to adapt it according to which mode the remote is running at. But I don't know whether this would work. Plus, many details are yet to be determined.
FAQ
• Q: How is singlenode differs from the already-supported utility
mode?
A: To use utility
mode one still needs to create a multi-segment cluster, and then connects to one of them using -c gp_role=utility
. This is different from singlenode
because the latter requires no segment at all from the ground up. Regarding code changes, as described above, they're mostly identical. There're a few cases where singlenode
mode behaves different from utility
mode and thus need special care, but they're generally rare.
Rollout/Adoption Plan
No response
Are you willing to submit a PR?
☑︎ Yes I am willing to submit a PR!
cloudberrydb/cloudberrydbDianjin Wang
09/06/2023, 4:32 PMweiyi
09/07/2023, 2:22 AMGitHub
09/12/2023, 7:55 AMGitHub
09/14/2023, 3:24 AMGitHub
10/08/2023, 1:38 AMDianjin Wang
10/10/2023, 1:46 AMzhjwpku
10/10/2023, 3:29 AMzhjwpku
10/10/2023, 3:32 AMzhjwpku
10/10/2023, 3:34 AMDianjin Wang
10/11/2023, 7:30 AMGitHub
10/18/2023, 8:58 AMFelix from Geoview
10/21/2023, 4:10 PMGitHub
11/14/2023, 10:21 AMcbdb-sandbox▾
jian
11/15/2023, 9:23 AMjian
11/16/2023, 1:23 AMCREATE INDEX ... CONCURRENTLY
. your doc only mentioned base on PG14.Dianjin Wang
12/12/2023, 2:36 AMGitHub
01/02/2024, 10:24 AMGitHub
01/22/2024, 7:01 AMGitHub
02/02/2024, 8:13 AMgpbackup for Cloudberry Database
release v1.0.3 is out, you can download the latest from its GitHub repo.
Contributors
🎈🎊 Thanks to the following contributors for helping make Cloudberry Database better this month:
@jiaqizho, @yjhjstz, @wenchaozhang-123, @lss602726449, @avamingli, @Ray-Eldath, @shmiwy, @congxuebin, @liyxbeijing, @Dianjin Wang, @TomShawn, @IdaLee666, @vitalboyzfJoin 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! * * * Slack Twitter WeChat Website Youtube Discussions Want to try it out quickly? Follow our Bootcamp program to get started with the Cloudberry Database Sandbox. cloudberrydb/cloudberrydb
GitHub
02/23/2024, 6:03 AMGitHub
03/04/2024, 7:14 AM@HuSen8891, @Ray-Eldath, @jiaqizho, @gfphoenix78, @Zhangbaowen-Hashdata, @Dianjin Wang, @TomShawn, @vitalboyzfJoin 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 Newsletters • #378 * * * Slack Twitter WeChat Website Youtube Discussions Want to try it out quickly? Follow our Bootcamp program to get started with the Cloudberry Database Sandbox. cloudberrydb/cloudberrydb
GitHub
03/25/2024, 1:36 AMGitHub
03/25/2024, 1:39 AMGitHub
04/02/2024, 10:47 AM@smartyhero, @Light-City, @jiaqizho, @HuSen8891, @lss602726449, @wenchaozhang-123, @gfphoenix78,@vitalboyzf, @TomShawn, @my-ship-itJoin 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 Newsletters • #389 • #378 cloudberrydb/cloudberrydb
GitHub
04/23/2024, 6:13 AMGitHub
04/28/2024, 6:31 AMshareinput_Xslice_dsm_handle_ptr
and shareinput_Xslice_hash
non-static by @shmiwy in #361
• Fix AO/AOCS insertDesc memory issue. by @avamingli in #365
• As ci will failed in upterm stage, revert it now. by @wenchaozhang-123 in #371
• Fix CopyCreateStmtFields, lost intoPolicy field. by @yjhjstz in #372
• Fix configue not consistent with configure.ac by @lss602726449 in #373
• gpssh: removing b and \r getting added to command output by @wenchaozhang-123 in #355
• Don't inherit parent's reloptions if child partition's AM differs by @yjhjstz in #375
• Fix: unstable ao vacuum icw test by @jiaqizho in #376
• Fix shell script involves demo cluster by @gfphoenix78 in #377
• Extend a new AM method to do acquire sample rows. by @wenchaozhang-123 in #374
• [AQUMV] Use view's TupleDesc to construct final columns. by @avamingli in #366
• Fix CREATE TYPE in namespace pg_ext_aux by @gfphoenix78 in #380
• Feature: add tests and benchmark in interconnect module by @jiaqizho in #384
• Fix: initialize parallel_workers to zero for CdbPathLocus_HashedOJ by @HuSen8891 in #387
• Add new callback 'scan_flags' for table access method by @HuSen8891 in #391
• Export numeric structure and interface to public by @jiaqizho in #392
• Move preloaded interconnect to the header file by @gfphoenix78 in #388
• Add inline function 'table_scan_flags' for table AM to get the flags. by @HuSen8891 in #395
• Enhancement: Add gpshrink to support elastic scaling by @lss602726449 in #393
• Fix: redefined sm4 in pgcrypto and backend/crypto by @jiaqizho in #394
• Revert #201 partially by @Ray-Eldath in #386
• Offload entry root slice to QE by @Ray-Eldath in #385
🙌🏻 New Contributors
• @shmiwy made their first contribution in #361
🧑🏻💻 Contributors
Thanks to all the contributors to make this release happen: @avamingli, @gfphoenix78, @shmiwy, @wenchaozhang-123, @yjhjstz, @lss602726449, @jiaqizho, @HuSen8891, @Ray-Eldath 👍
Full Changelog: 1.5.1...1.5.2
* * *
This discussion was created from the release v1.5.2.
cloudberrydb/cloudberrydbGitHub
05/08/2024, 2:39 AMGitHub
05/13/2024, 8:49 AM