An ƙirƙiri sabunta sabuntawa don duk rassan PostgreSQL masu goyan bayan: 14.3, 13.7, 12.11, 11.16 da 10.22. Reshen 10.x yana gabatowa ƙarshen tallafi (za a samar da sabuntawa har zuwa Nuwamba 2022). Sakin sabuntawa na reshen 11.x zai kasance har zuwa Nuwamba 2023, 12.x har zuwa Nuwamba 2024, 13.x har zuwa Nuwamba 2025, 14.x har zuwa Nuwamba 2026.
Sabbin sigogin suna ba da gyare-gyare sama da 50 kuma suna kawar da raunin CVE-2022-1552 da ke da alaƙa da ikon keɓance keɓantawar aiwatar da ayyukan gata Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER da pg_amcheck. Mai kai hari tare da ikon ƙirƙirar abubuwan da ba na wucin gadi ba a cikin kowane tsarin ajiya na iya haifar da aiwatar da ayyukan SQL na sabani tare da tushen gata yayin da mai amfani mai gata yana aiwatar da ayyukan da ke sama waɗanda ke shafar abin maharin. Musamman ma, yin amfani da raunin na iya faruwa a lokacin tsaftace bayanai ta atomatik lokacin da aka aiwatar da mai sarrafa autovacuum.
Idan sabuntawar ba zai yiwu ba, hanyar da za a bi don toshe batun shine a kashe autovacuum kuma kar a yi REINDEX, KIRKIRCIYA INDEX, REFRESH MATERIALIZED VIEW, da ayyukan CLUSTER azaman tushen mai amfani, kuma baya gudanar da pg_amcheck ko maido da abun ciki daga madadin da pg_dump ya kirkira. . Ana ɗaukar aiwatar da VACUUM mai aminci, kamar yadda kowane aiki na umarni yake, muddin abubuwan da ake sarrafa su mallakin amintattun masu amfani ne.
Sauran canje-canje a cikin sabbin abubuwan da aka fitar sun haɗa da sabunta lambar JIT don yin aiki tare da LLVM 14, ba da damar yin amfani da samfuran database.schema.table a cikin psql, pg_dump da pg_amcheck utilities, gyara matsalolin da ke haifar da cin hanci da rashawa na alamun GiST akan ginshiƙan ltree, ba daidai ba. zagayawa dabi'u a cikin tsarin zamanin da aka fitar daga bayanan tazara, aikin mai tsara ba daidai ba lokacin amfani da tambayoyin nesa na asynchronous, daidaitawar layin tebur mara daidai lokacin amfani da furcin CLUSTER akan firikwensin tare da maɓallan tushen magana, asarar bayanai saboda ƙarancin ƙarewa nan da nan bayan. gina jigon jita-jita na GiST, kulle-kulle yayin gogewa da aka raba fihirisa, yanayin tsere tsakanin aikin DROP TABLESPACE da wurin bincike.
Bugu da ƙari, za mu iya lura da sakin pg_ivm 1.0 tsawo tare da aiwatar da goyon bayan IVM (Incremental View Maintenance) don PostgreSQL 14. IVM yana ba da wata hanya ta madadin don sabunta ra'ayi na kayan aiki, mafi tasiri idan canje-canje ya shafi karamin ɓangare na ra'ayi. IVM yana ba da damar ra'ayoyin zahiri don a wartsake nan take tare da ƙarin canje-canje kawai, ba tare da sake ƙididdige ra'ayi ta amfani da aikin KYAUTA BA.
source: budenet.ru