Emva phantse konyaka wophuhliso ukukhutshwa kwenguqulelo entsha yesebe elizinzileyo kwabhengezwa ye-DBMS IPostgreSQL 14 ohlaziyo lwesebe elitsha liza kupapashwa iminyaka emihlanu kude kube nguNovemba 2026.
Kulabo abangaqhelekanga ngePostgreSQL, kuya kufuneka uyazi ukuba yaziwa ngokuba yiPostgres kunye Le yinkqubo yolawulo lwesiseko sedatha (I-RDBMS) simahla, vula umthombo, ejolise ekunikezeleni ngesiseko sedatha ngokubhekisele kukolula nokuthobela imigangatho yobugcisa.
Yenzelwe ukuphatha imisebenzi eyahlukeneyo, Ukusuka koomatshini abalula ukuya kwiindawo zokugcina idatha okanye iinkonzo zewebhu ezinabasebenzisi abaninzi ngaxeshanye.
Yintoni entsha kwiPostgreSQL 14?
Kule nguqulo intsha Uhlobo lwenkcazo yoluhlu yosapho lwandisiwe ngeentlobo ezintsha "zoluhlu" vumela oko Chaza uluhlu lwezinto ezi-odolo ezingadluliyo. Ukongeza kuhlobo ngalunye lwoluhlu olukhoyo, kucetyiswa uhlobo lwalo lwamanqanaba amaninzi. Ukusetyenziswa kweentlobo ezintsha kwenza lula ukuyilwa kwemibuzo elawula ukulandelelana okunzima kwamanqanaba.
Kwakhona amandla andisiwe kulungelelwaniso olusasaziweyo ezibandakanya iiseva ezininzi zePostgreSQL. Ekumiliseleni ukuphindaphinda okunengqiqo, kunokwenzeka ukusasaza intengiselwano eqhubekayo, enokuthi ukuphucula kakhulu ukusebenza kokuphindaphindeka yeentengiselwano ezinkulu. Ukongeza, ukucwangciswa kokuvakala kwedatha efika ngexesha lokuphindaphinda okunengqiqo kulungiselelwe.
Ukongeza yongeze inkxaso yokusebenza kwicala lomxhasi . . Imowudi ikwanceda ukukhawulezisa umsebenzi kunxibelelwano nokulibaziseka ixesha elide ekuhanjisweni kwephakheji.
Inkqubo yangaphandle yesikhongozeli sedatha (zithuba_fdwUkuqhagamshela iitafile zangaphandle kongeze inkxaso kulungelelwaniso lwemibuzo, ngoku esebenza kuphela xa uqhagamshela kwezinye iiseva zePostgreSQL. Izithuba_fdw yongeza inkxaso yokongeza idatha kwiitafile zangaphandle kwimowudi yebatch kunye nokubanakho ukungenisa ngaphakathi iitafile ezahlulwe ngokukhankanya umyalelo "WOKUTHENGISWA KWAMANYE AMAZWE SCHEMA".
Kwakhona, ulungiselelo lwenziwe ekuphunyezweni komsebenzi weVACUUM (Ukuqokelelwa kwenkunkuma kunye nokupakisha ukugcina idiski), yongeze "imo yonxunguphalo" ukutsiba imisebenzi engafunekiyo yokusonga ukuba iimeko zentengiselwano zesazisi ziyenziwa kwaye zincitshisiwe ngaphezulu xa kusenziwa isalathiso se-B-Tree. Ukwenziwa komsebenzi "WOKUHLAWULELA", oqokelela amanani ekusebenzeni kwesiseko sedatha, kukhawuleziswe kakhulu.
Kwelinye icala, kuyacaciswa ukuba izixhobo zandisiwe ukubeka esweni ukusebenza kwe-DBMS, kuhle se ukongeza iimbono ukulandela inkqubela yomyalelo "COPY", manani malunga nokuphindaphindeka kweendawo zokubeka kunye nomsebenzi wentengiselwano yeWAL.
KwiPostgreSQL 14 sinokuyifumana loo nto yongeze amandla okwenza ngokwezifiso indlela yoxinzelelo esetyenziswe kwinkqubo ye TOAST, inoxanduva lokugcina idatha enkulu enjengeebhloko zombhalo okanye ulwazi lwejiyometri. Ukongeza kwindlela yoxinzelelo lwe-pglz, i-TOAST ngoku inokusebenzisa i-LZ4 algorithm.
Yongezwe Ukulungiswa kweshedyuli yombuzo ukuphucula ukuqhubekeka kombuzo kunye nokuphucula ukwenziwa kwempumlo ngaxeshanye kweerekhodi ezilandelelanayo, ukwenziwa kwemibuzo ngokuhambelana kwi-PL / pgSQL kusetyenziswa umyalelo othi "BUYISA UMBUZO" kunye nokwenziwa kwemibuzo ngaxeshanye kwi- "REFRESH MATERIALIZED VIEW".
Olunye utshintsho ezibalaseleyo:
- Inkxaso eyongezelelweyo ye-caching iye yaphunyezwa ukuphucula ukusebenza kweendibano zesetyhula ezihlanganisiweyo (joyina).
- Ukulungiswa kwenzelwe ukuphucula ukusebenza kweenkqubo ezilayishwe kakhulu eziphethe inani elikhulu lonxibelelwano. Kwezinye iimvavanyo, ukusebenza kuye kwaphindaphindeka.
- Ukusebenza kwesalathiso semithi ye-B kuphuculwe kwaye umba wokukhula kwesalathiso xa iitafile zihlala zihlaziywa zisonjululwe.
- Iinkcukacha-manani ezandisiweyo ngoku zinokusetyenziselwa ukwandisa amabinzana kunye neentlobo zokunyusa ezinokusetyenziselwa ukwandisa imisebenzi yeewindows.
Okokugqibela sUkuba unomdla wokwazi okungakumbi ngayo, ungajonga iinkcukacha Kule khonkco ilandelayo.