- QA - mailweb.opengauss.org

【列存表使用列属性compress_mode=DELTA】社区问题单非问题公示
by 陈栋 03 Nov '22

03 Nov '22

hi，@zdai96 针对问题单：https://gitee.com/opengauss/openGauss-server/issues/I5XOTQ?from=proje… 我认为这是非问题，理由如下操作的SQL非批量插入，而是点插。列存表存储结构决定了不适合使用点插，每次insert会使用一个新的CU，因此对存储空间占用巨大。列存表适用场景见ht… 正确的insert语句为 insert into t1 select generate_series(1,10000000); 这里再解释一下为什么点插语句int和float类型存储空间占用区别巨大。列存表分为CU和CUDESC，前者是最小的列存单元，存储列存的数据；后者存储CU对应的一些信息，是行存表。每一个CU都对应CUDESC中的一行记录，这一行数据中除了CU的基本信息，还有min/max的字段，用于加速查询。点插情况下int是一种特殊的类型，其max/min值与数据值相同，在本例中可以直接插入CUDESC内，通过min/max就可以把值取出来了，因此不会生成CU。而代码中限制了float没有min、max值，即使点插情况下也会生成CU（这里又有delta表概念，本例中未开启，因此不考虑），所以存储空间占用较大。借用@pengjiong的例子，其中插入了100w条数据，float和int相比占用的CUDESC相同，但是float比int多生成了100w个CU，每个CU大小为8K，因此存储空间多了7813MB。如果对回复本身没有异议的话，该issue将于下周四关闭。

1 0

QA sig组例会
by openGauss conference 28 Oct '22

28 Oct '22

您好！ openGauss QA SIG 邀请您参加 2022-10-28 17:00 召开的Zoom会议(自动录制) 会议主题：QA sig组例会会议链接：https://us06web.zoom.us/j/83933400253?pwd=ZDhlQXNXT3lTbXpKUldvaENnaS8rQT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/QA-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss QA SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-10-28 17:00, The subject of the conference is QA sig组例会, You can join the meeting at https://us06web.zoom.us/j/83933400253?pwd=ZDhlQXNXT3lTbXpKUldvaENnaS8rQT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/QA-meetings More information: https://opengauss.org/en/

1 0

QA sig组例会
by openGauss conference 21 Oct '22

21 Oct '22

您好！ openGauss QA SIG 邀请您参加 2022-10-21 15:00 召开的Zoom会议(自动录制) 会议主题：QA sig组例会会议链接：https://us06web.zoom.us/j/89409423688?pwd=Q2xYMDBDL0FuUUJYQ3pHV0NVYmk2QT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/QA-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss QA SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-10-21 15:00, The subject of the conference is QA sig组例会, You can join the meeting at https://us06web.zoom.us/j/89409423688?pwd=Q2xYMDBDL0FuUUJYQ3pHV0NVYmk2QT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/QA-meetings More information: https://opengauss.org/en/

2 1

QA sig组例会
by openGauss conference 30 Sep '22

30 Sep '22

您好！ openGauss QA SIG 邀请您参加 2022-09-30 10:00 召开的Zoom会议(自动录制) 会议主题：QA sig组例会会议内容：本次会议只对伙伴提交的测试报告进行评审，请其他议题挪到节后会议链接：https://us06web.zoom.us/j/87201530944?pwd=NVZxWk1lWE5VbWF0a1pINE1uaDBWUT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/QA-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss QA SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-09-30 10:00, The subject of the conference is QA sig组例会, Summary: 本次会议只对伙伴提交的测试报告进行评审，请其他议题挪到节后 You can join the meeting at https://us06web.zoom.us/j/87201530944?pwd=NVZxWk1lWE5VbWF0a1pINE1uaDBWUT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/QA-meetings More information: https://opengauss.org/en/

1 0

答复: [ReleaseManagement] openGauss 3.1.0创新版本发布评审
by Fengwei (Will) 27 Sep '22

27 Sep '22

9月29日上午9:30 RM sig组联合docs和QA sig组在在社区召开openGauss 3.1.0创新版本发布评审会议，欢迎大家到时接入参加。 -----原始约会----- 发件人: openGauss conference [mailto:public@opengauss.org] 发送时间: 2022年9月27日 16:09 收件人: releasemanagement(a)opengauss.org 主题: [ReleaseManagement] openGauss 3.1.0创新版本发布评审时间: 2022年9月29日星期四 9:30-11:30(UTC+08:00) 北京，重庆，香港特别行政区，乌鲁木齐。地点: 您好！ openGauss ReleaseManagement SIG 邀请您参加 2022-09-29 09:30 召开的Zoom会议(自动录制) 会议主题：openGauss 3.1.0创新版本发布评审会议链接：https://us06web.zoom.us/j/85687568143?pwd=S0Q3ZkI5OUxkMkxsWUxTUFQxcWVJdz09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/ReleaseManagement-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss ReleaseManagement SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-09-29 09:30, The subject of the conference is openGauss 3.1.0创新版本发布评审, You can join the meeting at https://us06web.zoom.us/j/85687568143?pwd=S0Q3ZkI5OUxkMkxsWUxTUFQxcWVJdz09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/ReleaseManagement-meetings More information: https://opengauss.org/en/

1 0

QA sig组例会
by openGauss conference 27 Sep '22

27 Sep '22

您好！ openGauss QA SIG 邀请您参加 2022-09-27 10:00 召开的Zoom会议(自动录制) 会议主题：QA sig组例会会议链接：https://us06web.zoom.us/j/83577936335?pwd=cCs2YU1aanBCWkMzRzdLTU51WWI0UT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/QA-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss QA SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-09-27 10:00, The subject of the conference is QA sig组例会, You can join the meeting at https://us06web.zoom.us/j/83577936335?pwd=cCs2YU1aanBCWkMzRzdLTU51WWI0UT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/QA-meetings More information: https://opengauss.org/en/

2 1

FW: Welcome to the "QA" mailing list
by 王伟 19 Sep '22

19 Sep '22

PCFET0NUWVBFIGh0bWw+PGh0bWw+PGhlYWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1 UeXBl IiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPjwvbWF0YT48c3R5bGUgdHl wZT0i dGV4dC9jc3MiPgoqIHtib3gtc2l6aW5nOmJvcmRlci1ib3g7fQpib2R5IHtmb250LWZhbWl seTog Q2FsaWJyaTt9Cjwvc3R5bGU+PC9oZWFkPjxib2R5PjxkaXY+PGRpdiBpZD0iZm9jdXMiPjx kaXY+ PGJyPjxicj48YnI+PGJyPjxicj48L2Rpdj48L2Rpdj48L2Rpdj48ZGl2PjwvZGl2PjxkaXY gaWQ9 InNpZ25hdHVyZSI+PGhyIHN0eWxlPSJib3JkZXItdG9wOmRvdHRlZCAxcHgiPjxicj7njov kvJ8g V2VpIFdhbmc8YnI+TW9iaWxlOiArODYtMTgyOTIwMTYyOTk8YnI+TWFpbDogd2Vpd2FuZ2F yQGlz b2Z0c3RvbmUuY29tPGJyPjxicj48L2Rpdj48ZGl2IG5hbWU9IkFueU9mZmljZS1CYWNrZ3J vdW5k LUltYWdlIiBzdHlsZT0iYm9yZGVyLXRvcDoxcHggc29saWQgI0I1QzRERjtwYWRkaW5nOjh weDsg YmFja2dyb3VuZC1pbWFnZTp1cmwoZGF0YTppbWFnZS9wbmc7YmFzZTY0LGlWQk9SdzBLR2d vQUFB QU5TVWhFVWdBQUFBRUFBQUJCQ0FZQUFBQVFUYzdsQUFBQUNYQklXWE1BQUFzVEFBQUxFd0V BbXB3 WUFBQUFCR2RCVFVFQUFMR09mUHRSa3dBQUFDQmpTRkpOQUFCNkpRQUFnSU1BQVBuL0FBQ0E 2UUFB ZFRBQUFPcGdBQUE2bUFBQUYyK1NYOFZHQUFBQU4wbEVRVlI0Mm1KNDh1N1BmeVlHQm9aL2N PSXZL Z3NiOFFlVmhaLzRqWVg3R3dzWHB4aCtnZ2hUY0xvRko0SG1TMndFVWxnQkJnQWpQa05SUWx HUGZB QUFBQUJKUlU1RXJrSmdnZz09KTsgYmFja2dyb3VuZC1yZXBlYXQ6IHJlcGVhdC14OyI+PGR pdiBz dHlsZT0id29yZC1icmVhazpicmVhay1hbGw7Ij48Yj7lj5Hku7bkurrvvJo8L2I+cWEtcmV xdWVz dCAmbHQ7cWEtcmVxdWVzdEBvcGVuZ2F1c3Mub3JnJmd0OzwvZGl2PjxkaXYgc3R5bGU9Ind vcmQt YnJlYWs6YnJlYWstYWxsOyI+PGI+5pS25Lu25Lq677yaPC9iPk5vbmUgJmx0O3dlaXdhbmd hckBp c29mdHN0b25lLmNvbSZndDs8L2Rpdj48ZGl2IHN0eWxlPSJ3b3JkLWJyZWFrOmJyZWFrLWF sbDsi PjxiPuaXtiDpl7TvvJo8L2I+MjAyMi0wOS0xNCAxNDo0ODowNDwvZGl2PjxkaXYgc3R5bGU 9Indv cmQtYnJlYWs6YnJlYWstYWxsOyI+PGI+5Li7IOmimO+8mjwvYj5XZWxjb21lIHRvIHRoZSA iUUEi IG1haWxpbmcgbGlzdDwvZGl2PjxkaXY+PGJyPjwvZGl2PjwvZGl2PjxkaXYgbmFtZT0ibWF pbF9o aXN0X2NvbnRlbnQiIHN0eWxlPSJ3b3JkLXdyYXA6YnJlYWstd29yZDsiPuasoui/juS9v+e UqOKA nFFB4oCd6YKu5Lu25YiX6KGo77yBPGJyPjxicj7opoHpgJrov4fmraTliJfooajkuqTmtYH vvIzo r7flj5HpgIHnlLXlrZDpgq7ku7boh7M6PGJyPjxicj4gJm5ic3A7Jm5ic3A7Jm5ic3A7PGE gaHJl Zj0ibWFpbHRvOnFhQG9wZW5nYXVzcy5vcmciPnFhQG9wZW5nYXVzcy5vcmc8L2E+PGJyPjx icj7l j5bmtojorqLpmIXmiJbosIPmlbTpgInpobnor7flj5HpgIHnlLXlrZDpgq7ku7boh7M6PGJ yPjxi cj4gJm5ic3A7Jm5ic3A7Jm5ic3A7PGEgaHJlZj0ibWFpbHRvOnFhLWxlYXZlQG9wZW5nYXV zcy5v cmciPnFhLWxlYXZlQG9wZW5nYXVzcy5vcmc8L2E+PGJyPjxicj7lnKjkuLvpopjmiJbmraP mlofk uK3kvb/nlKgiaGVscCLkuIDor40o5LiN5YyF5ous5byV5Y+3KSwg5oKo5bCG5Lya5pS25Yi w5LiA 5p2h5bim5pyJ6K+05piO55qE5L+h5oGv44CC5pu05pS5PGJyPuiuvue9rumcgOimgeeUqOW IsOWv huegge+8jOS9huWHuuS6juWuieWFqOiAg+iZke+8jOatpOWkhOS4jeWMheaLrOatpOWvhue ggeOA guWmguaenOaCqOW/mOiusOS6huWvhuegge+8jOWImemcgOimgSDpgJrov4fnvZHnu5znlKj miLfn lYzpnaLph43nva7lr4bnoIHjgII8YnI+PGJyPjxicj48YnI+PGJyPjxicj5XZWxjb21lIHR vIHRo ZSAiUUEiIG1haWxpbmcgbGlzdCE8YnI+PGJyPlRvIHBvc3QgdG8gdGhpcyBsaXN0LCBzZW5 kIHlv dXIgZW1haWwgdG86PGJyPjxicj4gJm5ic3A7PGEgaHJlZj0ibWFpbHRvOnFhQG9wZW5nYXV zcy5v cmciPnFhQG9wZW5nYXVzcy5vcmc8L2E+PGJyPjxicj5Zb3UgY2FuIHVuc3Vic2NyaWJlIG9 yIG1h a2UgYWRqdXN0bWVudHMgdG8geW91ciBvcHRpb25zIHZpYSBlbWFpbCBieTxicj5zZW5kaW5 nIGEg bWVzc2FnZSB0bzo8YnI+PGJyPiAmbmJzcDs8YSBocmVmPSJtYWlsdG86cWEtbGVhdmVAb3B lbmdh dXNzLm9yZyI+cWEtbGVhdmVAb3BlbmdhdXNzLm9yZzwvYT48YnI+PGJyPndpdGggdGhlIHd vcmQg J2hlbHAnIGluIHRoZSBzdWJqZWN0IG9yIGJvZHkgKGRvbid0IGluY2x1ZGUgdGhlPGJyPnF 1b3Rl cyksIGFuZCB5b3Ugd2lsbCByZWNlaXZlIGEgbWVzc2FnZSB3aXRoIGluc3RydWN0aW9ucy4 gJm5i c3A7WW91IHdpbGw8YnI+bmVlZCB5b3VyIHBhc3N3b3JkIHRvIGNoYW5nZSB5b3VyIG9wdGl vbnMs IGJ1dCBmb3Igc2VjdXJpdHkgcHVycG9zZXMsPGJyPnRoaXMgcGFzc3dvcmQgaXMgbm90IGl uY2x1 ZGVkIGhlcmUuICZuYnNwO0lmIHlvdSBoYXZlIGZvcmdvdHRlbiB5b3VyPGJyPnBhc3N3b3J kLCB5 b3Ugd2lsbCBuZWVkIHRvIHJlc2V0IGl0IHZpYSB0aGUgd2ViIFVJLjwvZGl2PjwvYm9keT4 8L2h0 bWw+

1 0

QA sig例会
by openGauss conference 17 Sep '22

17 Sep '22

您好！ openGauss QA SIG 邀请您参加 2022-09-16 15:00 召开的Zoom会议(自动录制) 会议主题：QA sig例会会议链接：https://us06web.zoom.us/j/87252220318?pwd=TnM1WVlXTE5vNUV3Z2FvVzZ5K2FBUT09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/QA-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss QA SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-09-16 15:00, The subject of the conference is QA sig例会, You can join the meeting at https://us06web.zoom.us/j/87252220318?pwd=TnM1WVlXTE5vNUV3Z2FvVzZ5K2FBUT09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/QA-meetings More information: https://opengauss.org/en/

2 1

申请DataStudio 适配dbe_pldebugger以及存储过程覆盖项目测试方案评审
by Alice 15 Sep '22

15 Sep '22

dear sir，我司申请9/16进行DataStudio 适配dbe_pldebugger以及存储过程覆盖项目测试方案评审（上周五在9/16的申报议题中编辑，但未收到会议通知），请帮忙处理，谢谢 —————————————————————— Best wishes. 王海琴 Suzhou Wangman Information Technology Co., Ltd. Mob: 18962553497 E-mail: Alice(a)workingman.cn

1 0

2022.9.14 openGauss TC例会
by openGauss conference 14 Sep '22

14 Sep '22

您好！ openGauss TC SIG 邀请您参加 2022-09-14 10:50 召开的Zoom会议(自动录制) 会议主题：2022.9.14 openGauss TC例会会议链接：https://us06web.zoom.us/j/83392226982?pwd=NXdPbVhlbGtWcFFsMUVBTWY2UmRIZz09 温馨提醒：建议接入会议后修改参会人的姓名，也可以使用您在gitee.com的ID 提前申报议题请编辑：https://etherpad.opengauss.org/p/TC-meetings 更多资讯尽在：https://opengauss.org/zh/ Hello! openGauss TC SIG invites you to attend the Zoom conference(auto recording) will be held at 2022-09-14 10:50, The subject of the conference is 2022.9.14 openGauss TC例会, You can join the meeting at https://us06web.zoom.us/j/83392226982?pwd=NXdPbVhlbGtWcFFsMUVBTWY2UmRIZz09. Note: You are advised to change the participant name after joining the conference or use your ID at gitee.com. Add topics: https://etherpad.opengauss.org/p/TC-meetings More information: https://opengauss.org/en/

1 0