Magadzirirwo ekugadzirisa akagadzirwa kune ese anotsigirwa PostgreSQL mapazi: 14.3, 13.7, 12.11, 11.16 uye 10.22. Iyo 10.x bazi rave kusvika kumagumo ekutsigirwa (kuvandudzwa kuchagadzirwa kusvika munaNovember 2022). Kuburitswa kwezvigadziriso zvebazi re11.x kuchagara kusvika Mbudzi 2023, 12.x kusvika Mbudzi 2024, 13.x kusvika Mbudzi 2025, 14.x kusvika Mbudzi 2026.
Idzi shanduro itsva dzinopa zvinopfuura makumi mashanu zvigadziriso uye kubvisa kusagadzikana kweCVE-50-2022 kwakabatana nekugona kunzvenga kuparadzaniswa kwekuita basa rakasarudzika Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER uye pg_amcheck. Anorwisa ane mvumo yekugadzira zvinhu zvisiri zvenguva pfupi mune chero hurongwa hwekuchengetera zvinogona kukonzera zvisina tsarukano SQL mabasa kuti aitwe nemidzi ropafadzo apo mushandisi ane rombo ari kuita mashandiro ari pamusoro anokanganisa chinhu cheanorwisa. Kunyanya, kushandiswa kwekusagadzikana kunogona kuitika panguva yekuchenesa otomatiki kwedhatabhesi kana iyo autovacuum handler ichiitwa.
Kana iyo yekuvandudza isingagoneke, iyo nzira yekuvharisa nyaya ndeye kudzima autovacuum uye kusaita REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, uye CLUSTER mashandiro semudzi mushandisi, uye kwete kumhanya pg_amcheck kana kudzoreredza zvirimo kubva kune backup yakagadzirwa nepg_dump. . Kuita VACUUM kunoonekwa kwakachengeteka, sezvakaita chero murairo wekuraira, chero bedzi zvinhu zviri kugadziriswa zviri zvevashandisi vanovimbwa.
Dzimwe shanduko mukuburitswa kutsva dzinosanganisira kuvandudza iyo JIT kodhi kuti ishande neLLVM 14, ichibvumira kushandiswa kwedatabase.schema.table templates mu psql, pg_dump uye pg_amcheck utilities, kugadzirisa matambudziko anotungamirira kuhuori hweGiST indexes pamusoro pe ltree columns, zvisiri izvo. kutenderedzwa kwehunhu mufomati epoch yakatorwa kubva kuinterval data, isiriyo yekuronga mashandiro kana uchishandisa asynchronous kure mibvunzo, kurongeka zvisirizvo kwemitsara yematafura kana uchishandisa CLUSTER kutaura pane indexes ane makiyi ekutaura, kurasikirwa kwedata nekuda kwekuregedzerwa kusiri kujairika pakarepo mushure. kugadzira iyo GiST yakarongwa index, yakafa panguva yekudzima partitioned index, nhangemutange mamiriro pakati peiyo DROP TABLESPACE mashandiro uye cheki.
Uyezve, tinogona kucherechedza kusunungurwa kwepg_ivm 1.0 yekuwedzera nekushandiswa kweIVM (Incremental View Maintenance) tsigiro yePostgreSQL 14. IVM inopa imwe nzira yekuvandudza maonero akaitwa, inonyanya kushanda kana kuchinja kuchikanganisa chikamu chiduku chemaonero. IVM inobvumira maonero enyama kuti avandudzwe ipapo nekungowedzera shanduko, pasina kuverengera maonero uchishandisa iyo REFRESH MATERIALIZED VIEW mashandiro.
Source: opennet.ru