Uhlaziyo oluchanekileyo lwenziwe kuwo onke amasebe e-PostgreSQL axhaswayo: 14.3, 13.7, 12.11, 11.16 kunye ne-10.22. Isebe le-10.x lisondela esiphelweni senkxaso (uhlaziyo luya kuveliswa kude kube nguNovemba 2022). Ukukhutshwa kohlaziyo lwesebe le-11.x kuya kuhlala kude kube nguNovemba 2023, 12.x kude kube ngoNovemba 2024, 13.x kude kube ngoNovemba 2025, 14.x kude kube ngoNovemba 2026.
Iinguqulelo ezintsha zibonelela ngolungiso olungaphezulu kwe-50 kunye nokuphelisa ubuthathaka be-CVE-2022-1552 ehambelana nokukwazi ukudlula ukwahlukaniswa kokwenziwa kwemisebenzi enelungelo I-Autovacuum, i-REINDEX, YENZA ISIHLOMELO, HLAZIYA UMBONO WEMATERIALIZED, CLUSTER kunye pg_amcheck. Umhlaseli onegunya lokudala izinto ezingezizo ezexeshana kulo naluphi na ugcino lweskimu kunokubangela ukuba imisebenzi yeSQL engenamkhethe yenziwe ngamalungelo engcambu ngelixa umsebenzisi onelungelo esenza imisebenzi engasentla echaphazela into yomhlaseli. Ngokukodwa, ukuxhaphazwa kobuthathaka kunokwenzeka ngexesha lokucocwa ngokuzenzekelayo kwesiseko sedatha xa i-autovacuum handler isenziwa.
Ukuba uhlaziyo alwenzeki, umsebenzi wokuvala umba kukuvala i-autovacuum kwaye ungenzi iREINDEX, YENZA ISIKHOKELO, HLAZIYA MATERIALIZED VIEW, kunye nemisebenzi ye-CLUSTER njengomsebenzisi weengcambu, kwaye ungaqhubeki pg_amcheck okanye ubuyisele umxholo ovela kugcino owenziwe ngu pg_dump. . Ukuphumeza i-VACUUM kuthathwa njengekhuselekile, njengawo nawuphi na umsebenzi womyalelo, nje ukuba izinto ezicutshungulwayo zingabasebenzisi abathembekileyo.
Olunye utshintsho kukukhutshwa okutsha kubandakanya ukuhlaziywa kwekhowudi ye-JIT ukuze isebenze kunye ne-LLVM 14, ukuvumela ukusetyenziswa kwe-database.schema.table templates kwi-psql, pg_dump kunye ne-pg_amcheck eziluncedo, ukulungisa iingxaki ezikhokelela kukonakala kwezalathiso ze-GiST kwiikholamu ze-ltree, ezingalunganga. ukujikeleziswa kwamaxabiso kwifomathi yexesha elithatyathwe kwidatha yekhefu, ukusebenza ngokungalunganga komcwangcisi xa usebenzisa imibuzo ekude engahambelaniyo, ukuhlelwa ngendlela engafanelekanga kwemigca yetafile xa usebenzisa inkcazo ye-CLUSTER kwizalathisi ezinezitshixo ezisekelwe kwintetho, ilahleko yedatha ngenxa yokupheliswa okungaqhelekanga ngoko nangoko emva koko. ukwakhiwa kwesalathiso esihleliweyo se-GiST, ukuvalwa ngexesha lokucinywa kwesalathiso esahluliweyo, imeko yogqatso phakathi komsebenzi we-DROP TABLESPACE kunye nendawo yokukhangela.
Ukongezelela, sinokuqaphela ukukhululwa kwe-pg_ivm 1.0 yokwandiswa kunye nokuphunyezwa kwe-IVM (I-Incremental View Maintenance) inkxaso ye-PostgreSQL 14. I-IVM inikeza enye indlela yokuhlaziya iimbono ezibonakalayo, ezisebenzayo ngakumbi ukuba utshintsho luchaphazela inxalenye encinci yembono. I-IVM ivumela iimbono ezibonakalayo ukuba zihlaziywe ngoko nangoko ngotshintsho olongezelelekileyo kuphela, ngaphandle kokubala kwakhona imbono usebenzisa i-REFRESH MATERIALIZED VIEW operation.
umthombo: opennet.ru