Ngo-September 24, ithimba lezokuthuthukiswa limemezele ukukhululwa kwenombolo elandelayo yokukhululwa kwe-Postgresql 13. Ukukhululwa okusha kugxile, phakathi kwezinye izinto, ekuthuthukiseni ukusebenza, ukusheshisa izinsizakalo zokugcinwa kwangaphakathi kanye nokwenza lula ukuqapha kwedatha, kanye nokulawulwa kokufinyelela kwesistimu okuthembekile.
Umsebenzi waqhubeka ekuthuthukiseni inkomba yethebula mayelana nokucubungula izimpinda phakathi kwedatha enenkomba ezihlahleni zenkomba kanambambili, okwenze kwaba nokwenzeka hhayi kuphela ukusheshisa ukukhishwa kwemibuzo, kodwa nokunciphisa isikhala sediski esithathwe inkomba.
Ukwengeza, i-algorithm yokuhlunga ekhuphukayo yengeziwe, lapho ukuhlunga okuphindaphindiwe kwedatha osekuhlungwe ezinyathelweni ezedlule kusebenza ngokushesha, futhi eminye imibuzo ingasheshiswa ngokusebenzisa izibalo ezinwetshiwe (ngomyalo we-CREATE STATISTICS) lapho kubalwa isinyathelo esisebenza ngempumelelo kakhudlwana- uhlelo lwesinyathelo ngesinyathelo.
Ukwenziwa kwemibuzo ngokuhlanganisa idatha ebizayo nakho kuthuthukiswe ngokusebenzisa kakhulu ukuhlanganiswa okushesha kanye nokulahla ingxenye yedatha ehlanganisiwe kudiski uma ingangeni ku-RAM. Kukhona ukwanda okuphawulekayo kwejubane lokuxhuma amatafula atholakala kuma-partitions ahlukene.
Mkhulu umsebenzi owenziwe ukwenza lula ukugcinwa nokuphathwa kolwazi lwe-Postgresql. Umsebenzi owakhelwe ngaphakathi we-"vacuuming", okungukuthi, ukusebenzisa isikhala sediski samahhala ngemuva kokususa noma ukubhala kabusha imigqa, manje ungenziwa ngezintambo ezifanayo, futhi umlawuli manje unethuba lokucacisa inombolo yabo. Ngaphezu kwalokhu, amathuluzi amasha engeziwe okuqapha umsebenzi wamanje wesizindalwazi futhi amaphutha avinjiwe lapho kuvumelanisa amarekhodi arekhodiwe ngaphambilini phakathi kwenkosi ne-replicas, okungaholela ezingxabanweni lapho ama-replicas enqanyulwa noma ephula ubuqotho berekhodi. isizindalwazi esabalalisiwe ngemva kokubuyiselwa ngokusekelwe kudatha yelogi.
Phakathi kwezinto ezintsha zonjiniyela, kufanelekile ukugqamisa umsebenzi we-datetime(), oguqula amafomethi ahlukahlukene okurekhoda esikhathi abe ohlotsheni lwe-Postgresql olwakhelwe ngaphakathi; Umsebenzi wokukhiqiza we-UUID v4 otholakala ngaphandle kwebhokisi elithi gen_random_uuid(); ukujwayelekile komsebenzi nge-Unicode; isistimu evumelana nezimo kakhulu yokusabalalisa idatha yetafula kumanodi enethiwekhi axhunyiwe esizindalwazi ngokuphindaphinda okugcwele ezingeni elinengqondo, kanye nezinye izinguquko emibuzweni kanye nezibangeli ezintsha ezitholakalayo zokuphindaphinda.
Ukulawulwa kokufinyelela kusizindalwazi kushiwo njengenye yezingxenye ezibalulekile zesistimu, futhi inguqulo entsha yenza izinyathelo ezinkulu eziya phambili kulokhu. Manje umsebenzisi onenhlanhla kuphela (i-superuser) ongafaka izandiso kusizindalwazi. Ngesikhathi esifanayo, abasebenzisi abajwayelekile bazokwazi ukufaka kuphela lezo zandiso abazimake njengezithenjwayo, noma isethi encane yezandiso ezibhekwa njengezithenjwa ngokuzenzakalelayo (isibonelo, pgcrypto, tablefunc noma hstore). Lapho uqinisekisa abasebenzisi kusetshenziswa indlela ye-SCRAM (uma usebenza ngomshayeli we-libpq), "ukubopha isiteshi" manje kuyadingeka, nomsebenzi wokusonga wedatha yenkampani yangaphandle i-postgres_fdw evela kunguqulo 13 isekela ukugunyazwa kwesitifiketi.
Source: linux.org.ru