Izibuyekezo zokulungisa zenziwe kuwo wonke amagatsha e-PostgreSQL asekelwe: 14.3, 13.7, 12.11, 11.16 kanye no-10.22. Igatsha le-10.x selisondela ekupheleni kosekelo (izibuyekezo zizokwenziwa kuze kube uNovemba 2022). Ukukhishwa kwezibuyekezo zegatsha le-11.x kuzohlala kuze kube nguNovemba 2023, 12.x kuze kube uNovemba 2024, 13.x kuze kube uNovemba 2025, 14.x kuze kube uNovemba 2026.
Izinguqulo ezintsha zinikeza ukulungiswa okungaphezu kuka-50 futhi zisuse ukuba sengozini kwe-CVE-2022-1552 okuhlobene nekhono lokudlula ukuhlukaniswa kokwenziwa kwemisebenzi eyilungelo i-Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER kanye ne-pg_amcheck. Umhlaseli onegunya lokudala izinto okungezona zesikhashana kunoma isiphi isikimu sesitoreji angabangela imisebenzi ye-SQL engaqondakali ukuthi yenziwe ngamalungelo ezimpande kuyilapho umsebenzisi okhethekile enza imisebenzi engenhla ethinta into yomhlaseli. Ikakhulukazi, ukuxhashazwa kokuba sengozini kungenzeka ngesikhathi sokuhlanza okuzenzakalelayo kwesizindalwazi lapho isibambi se-autovacuum sisetshenziswa.
Uma isibuyekezo singenzeki, indlela yokulungisa inkinga iwukukhubaza i-autovacuum futhi ungenzi REINDEX, CREATE INDEX, REFRESS MATERIALIZED VIEW, kanye nemisebenzi ye-CLUSTER njengomsebenzisi wempande, futhi ungasebenzisi i-pg_amcheck noma ukubuyisela okuqukethwe okuvela kusipele esidalwe ngu-pg_dump. . Ukwenza i-VACUUM kuthathwa njengokuphephile, njenganoma yimuphi umsebenzi womyalo, inqobo nje uma izinto ezicutshungulwayo zingezabasebenzisi abathenjwayo.
Ezinye izinguquko ekukhishweni okusha zihlanganisa ukubuyekeza ikhodi ye-JIT ukuze isebenze ne-LLVM 14, ukuvumela ukusetshenziswa kwezifanekiso ze-database.schema.table kuzinsiza ze-psql, pg_dump kanye ne-pg_amcheck, ukulungisa izinkinga eziholela ekonakaleni kwezinkomba ze-GiST phezu kwamakholomu e-ltree, okungalungile. ukufinyezwa kwamanani ngefomethi yenkathi ekhishwe kudatha yesikhawu, ukusebenza kwesihleli okungalungile lapho kusetshenziswa imibuzo ekude engavumelaniyo, ukuhlelwa okungalungile kwemigqa yethebula lapho kusetshenziswa isisho se-CLUSTER kuzinkomba ezinokhiye abasuselwe ekukhulumeni, ukulahleka kwedatha ngenxa yokunqanyulwa okungavamile ngokushesha ngemva kwalokho. kwakha inkomba ye-GiST ehlungiwe, i-deadlock ngesikhathi sokususwa kwe-partitioned index, isimo somjaho phakathi komsebenzi we-DROP TABLESPACE nendawo yokuhlola.
Ukwengeza, singaqaphela ukukhululwa kwesandiso se-pg_ivm 1.0 ngokuqaliswa kokusekelwa kwe-IVM (I-Incremental View Maintenance) ye-PostgreSQL 14. I-IVM inikeza enye indlela yokubuyekeza ukubuka okuphathekayo, okusebenza kangcono uma izinguquko zithinta ingxenye encane yokubuka. I-IVM ivumela ukubukwa okuphathekayo ukuthi kuvuselelwe ngokushesha ngezinguquko ezikhuphukayo kuphela, ngaphandle kokubala kabusha ukubuka kusetshenziswa ukusebenza KWE-REFRESID MATERIALIZED VIEW.
Source: opennet.ru