I-Microsoft ye-Citus Data ikhuphe i-Citus 13.0, i-DBMS esasazwayo eyongeziweyo kwi-PostgreSQL 17. I-Citus yenza ukulinganisa okuthe tye kwe-PostgreSQL kwi-cluster kwi-hardware yempahla kwaye ivumela idatha ukuba isasazwe kuzo zonke iindawo ngokusebenzisa i-sharding, kunye ne-column-level kunye ne-scheme-based partitioning. Kwizicelo, iqela leCitus livela njengeseva enkulu yePostgreSQL, idibanisa izixhobo zeendawo eziyenzayo. Ikhowudi ibhalwe ngo-C kwaye isasazwe phantsi kwelayisensi ye-AGPLv3.
Ukwahlula kukuvumela ukuba uququzelele ukugcinwa komthamo omkhulu kakhulu wedatha, ubungakanani obupheleleyo obudlula ngokuphawulekayo ukugcinwa kwendawo yendawo nganye yeenqununu zeqela. Iitheyibhile zomntu ngamnye zinokunyanzelwa ukuba ziphindaphinde kuzo zonke iindawo ukukhawulezisa ukudibanisa imisebenzi kunye nemisebenzi ebalulekileyo yangaphandle. Ukugcina isithuba sedisk, idatha esasazwa kwiinodi ezahlukeneyo ingagcinwa kwifom ecinezelweyo.
Imibuzo esasazwayo inokuthunyelwa kuyo nayiphi na i-node kwiqela, kodwa ulawulo kunye nokuguqulwa kwe-schema yedatha kufuneka kwenziwe kuphela nge-node yokulungelelanisa i-cluster. Izicelo ezifunyenwe kubathengi zisasazwa phakathi kweenodi eziyimfuneko kwaye, ukuba zigubungela iindawo ezininzi, ukuqhutyelwa kwazo kuhambelana. Iqela linokwandiswa njengoko ubungakanani bedatha egciniweyo bukhula ngokongeza iindawo ezongezelelweyo kunye nokuqalisa ukulinganisa kwakhona.
Amatyala aqhelekileyo okusetyenziswa kweCitus aquka ukuqhuba imibuzo yohlalutyo kunye nokucubungula idatha eninzi yochungechunge lwexesha (umz., iilogs okanye ukuvota imeko yesensor). ICitus ikwafanelekile ukuphucula iziseko zophuhliso ezikhoyo ngokusekelwe kwisixhobo esinye. umncedisi I-PostgreSQL, apho ukusebenza kunye nomthamo wokugcina izinto unganelanga ngenxa yokwanda komthwalo womsebenzi okanye umthamo wedatha engenayo. Usebenzisa izixhobo zePatroni, ungenza uqwalaselo olunyamezela iimpazamo ngee-nodes eziphindaphindwayo ezinokuthi zithathe indawo yee-nodes eziphambili xa zingasebenzi.
Utshintsho kukhupho lweCitus 13.0:
- Ukutshintshela kwi-PostgreSQL 17 yesebe.
- Ukukwazi ukusebenzisa i-JSON_TABLE () umsebenzi kwimibuzo esasaziweyo ukuguqula idatha ukusuka kwifomati ye-JSON ukuya kumelo olunxulumeneyo olungasetyenzwa njengeetafile ze-PostgreSQL eziqhelekileyo.
- Inkxaso ka "HLANGANISA ... XA UNGATSHATSHISISWA NOMTHOMBO" isintaksi.
- Ukukwazi ukuchaza indlela yofikelelo kwiitheyibhile ezahluliweyo kusetyenziswa inkcazo ethi "YEKA ITHEYIBHILE … UKUSEBENZISA", kunye nokutshintsha indlela yofikelelo usebenzisa u-"ALTER TABILE ... SETHA INDLELA YOKUFIKELELA".
- Inkxaso eyongeziweyo yokuchaza iikholamu zesazisi ezenziwe ngokuzenzekelayo kwiitheyibhile ezahluliweyo.
- Ivunyelwe ukusebenzisa izithintelo zokungabandakanyi kwiitheyibhile ezahluliweyo ezisasaziweyo.
- Iingxaki ngongqamaniso lweendima phakathi kweenodi ziye zasonjululwa.
- Ukuhanjiswa kwedatha okuphuculweyo yokwahlula xa wongeza iindawo ezintsha kwiqela.
- I-"MEMORY" kunye ne "SERIALIZE" iinketho zongezwe kumyalelo othi "CHAZA", enokusetyenziswa ukumisela ubungakanani bememori esetyenzisiweyo kunye nexesha elichithwe ukuguqula idatha yokuhanjiswa kwinethiwekhi.
umthombo: opennet.ru
