Kwanan nan An buɗe PostgreSQL labarai cewa ya fitar da sabuntawa da yawa gyara ga duk rassan PostgreSQL da ake tallafawa a halin yanzu, waɗanda ke sigar 14.3, 13.7, 12.11, 11.16, da 10.22.
Sabbin nau'ikan bayar da gyara fiye da 50 wanda wasu daga cikin waɗannan batutuwan na iya shafar wasu nau'ikan tallafin PostgreSQL.
- Matsalar da za ta iya haifar da cin hanci da rashawa na GiST a kan ltreecolumns. Bayan haɓakawa, kuna buƙatar sake yin fihirisa fihirisar GiST akan ginshiƙan.
- Gyara don zagaye mara daidai lokacin da ake fitar da kimar zamanin daga nau'ikan tazara.
- Gyara don fitowar da ba daidai ba don timestamptz da timetzen table_to_xmlschema() iri.
- Kafaffen kurakuran da ke da alaƙa da batun mai tsarawa wanda ya shafi tambayoyin nesa masu kama da juna.
- Gyara zuwa ALTER FUNCTION don tallafawa canza dabi'ar daidaitacce na aiki da SET jerin masu canji a cikin umarni ɗaya.
- Gyara don rarraba layuka na tebur ba daidai ba lokacin da ake amfani da CLUSTER akan fihirisar wacce maɓallin farko shine furci.
- Yana magance haɗarin gazawar kullewa lokacin da aka raba fihirisa.
- Gyara yanayin tsere tsakanin DROP TABLESPACE da wuraren bincike waɗanda zasu iya kasa cire duk matattun fayiloli daga kundin adireshin tebur.
- Yana gyara matsala mai yuwuwa tare da gazawar bayan umarnin TRUNCATE wanda ya mamaye wurin bincike.
- Kafaffen bug PANIC: xlog flush buƙatun bai gamsu ba yayin gabatarwar jiran aiki lokacin da ya ɓace ci gaba da log ɗin WAL.
- Gyara yuwuwar kulle-kulle ta atomatik a cikin rigingimu masu zafi mai zafi.
Bayan haka, waɗannan sabbin sigogin gyara kuma suna magance raunin CVE-2022-1552 masu alaƙa da ikon ketare keɓantawar aiwatar da ayyuka masu gata Autovacuum, REINDEX, KIRKIRO INDEX, KYAUTA KYAUTA, CLUSTER, da pg_amcheck.
An ambaci cewa game da raunin da aka warware a cikin waɗannan sigogin gyara, an gano matsalar yarda mai kai hari abin da ikon ƙirƙirar abubuwan da ba na ɗan lokaci ba a cikin kowane tsari Sabar ajiya na iya aiwatar da ayyuka na SQL na sabani tare da gatan mai amfani yayin da mai gata yana yin ayyukan da ke sama waɗanda ke shafar abin maharin.
Ko da cin gajiyar raunin na iya faruwa lokacin da aka share bayanan ta atomatik lokacin da direban autovacuum ke aiki.
Idan ba za ku iya yin sabuntawa ba, a matsayin hanyar warware matsalar, iya kashe injin injin atomatik kuma rashin yin REINDEX, CREATE INDEX, REFRESH MATERIALIZED View, da CLUSTER ayyuka a matsayin tushen mai amfani kuma baya gudanar da aikin pg_amcheck kuma baya dawo da abubuwan da ke cikin ajiyar ajiyar da pg_dump ya kirkira.
Ana ɗaukar aiwatar da VACUUM lafiya, kamar yadda ake amfani da kowane aiki na umarni, idan abubuwan da ake sarrafa su na amintattun masu amfani ne.
Sauran canje-canje a cikin sababbin sigogin sun haɗa da sabunta lambar JIT don aiki tare da LLVM 14, ba da damar yin amfani da tsarin ƙima na ƙima a cikin tsarin zamanin da aka dawo daga nau'in bayanan tazara, halayen shirye-shiryen da ba daidai ba lokacin amfani da tambayoyin nesa ba daidai ba, daidaitawar layin tebur mara daidai lokacin amfani da CLUSTER na furci akan maƙasudin tushen magana, asarar bayanai akan ya fado kai tsaye bayan gina ma'aunin GiST da aka jera, ƙarewar sharewar fihirisa da aka raba, yanayin tsere tsakanin aikin DROP TABLESPACE da matsayi (checkpoint) .
Bugu da ƙari, ƙaddamar da pg_ivm 1.0 tsawo tare da aiwatar da goyon bayan IVM (Incremental View Maintenance) don PostgreSQL 14 za a iya haskakawa. .
IVM tana ba da damar sabunta ra'ayoyin zahiri nan take tare da ƙarin canje-canje kawai da aka yi amfani da su, ba tare da sake ƙididdige ra'ayi ba, wanda aka yi ta amfani da aikin "REFRESH MATERIALIZED VIEW".
A ƙarshe, idan kuna sha'awar ƙarin sani game da wannan sabon sigar, zaku iya duba cikakkun bayanai A cikin mahaɗin mai zuwa.