Zosintha zowongolera zapangidwira nthambi zonse za PostgreSQL: 14.3, 13.7, 12.11, 11.16 ndi 10.22. Nthambi ya 10.x ikuyandikira kumapeto kwa chithandizo (zosintha zidzapangidwa mpaka November 2022). Kutulutsidwa kwa zosintha za nthambi ya 11.x kupitilira mpaka Novembala 2023, 12.x mpaka Novembala 2024, 13.x mpaka Novembala 2025, 14.x mpaka Novembala 2026.
Mitundu yatsopanoyi imapereka zosintha zopitilira 50 ndikuchotsa chiwopsezo cha CVE-2022-1552 chokhudzana ndi kuthekera kodutsa kudzipatula kuchita ntchito zamwayi Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER ndi pg_amcheck. Wowukira yemwe ali ndi mphamvu zopanga zinthu zosakhalitsa m'dongosolo lililonse losungira atha kuchititsa kuti ntchito za SQL zizichitidwa mwamwayi pomwe wogwiritsa ntchito mwamwayi akuchita zomwe zili pamwambapa zomwe zimakhudza zomwe woukirayo. Makamaka, kugwiritsa ntchito chiwopsezochi kumatha kuchitika poyeretsa nkhokwe zokha pomwe chowongolera cha autovacuum chikuchitidwa.
Ngati zosintha sizitheka, njira yothetsera vutoli ndikuletsa autovacuum ndikusachita REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, ndi CLUSTER ntchito ngati mizu, osayendetsa pg_amcheck kapena kubwezeretsa zomwe zili muzosunga zobwezeretsera zomwe zidapangidwa ndi pg_dump. . Kuchita VACUUM kumaonedwa kuti ndi kotetezeka, monga momwe zilili ndi lamulo lililonse, malinga ngati zinthu zomwe zikukonzedwa zili ndi ogwiritsa ntchito odalirika.
Zosintha zina pazotulutsa zatsopano zikuphatikiza kukonzanso kachidindo ka JIT kuti igwire ntchito ndi LLVM 14, kulola kugwiritsa ntchito ma templates a database.schema.table muzothandizira za psql, pg_dump ndi pg_amcheck, kukonza mavuto omwe amatsogolera ku ziphuphu za index za GiST pamizere ya ltree, zolakwika. kuzunguliridwa kwa zikhalidwe mumtundu wa nthawi yotengedwa kuchokera ku data yanthawi yayitali, kusanja kwanthawi yolakwika mukamagwiritsa ntchito mafunso akutali, kusanja kolakwika kwa mizere ya tebulo mukamagwiritsa ntchito mawu a CLUSTER pama index okhala ndi makiyi otengera mawu, kutayika kwa data chifukwa cha kuthetsedwa kwachilendo pambuyo pake. kupanga cholozera chosankhidwa cha GiST, kutsekeka panthawi yochotsa magawo ogawa, mtundu wamtundu pakati pa ntchito ya DROP TABLESPACE ndi poyang'anira.
Kuonjezera apo, tikhoza kuzindikira kumasulidwa kwa pg_ivm 1.0 yowonjezera ndi kukhazikitsidwa kwa IVM (Incremental View Maintenance) chithandizo cha PostgreSQL 14. IVM imapereka njira ina yosinthira maonekedwe a thupi, ogwira mtima kwambiri ngati kusintha kumakhudza gawo laling'ono la malingaliro. IVM imalola kuti mawonedwe aumunthu atsitsimutsidwe nthawi yomweyo ndi kusintha kowonjezereka, popanda kuwerengeranso mawonekedwe pogwiritsa ntchito REFRESH MATERIALIZED VIEW.
Source: opennet.ru