Zosintha zowongolera zapangidwira nthambi zonse zothandizidwa za PostgreSQL: 14.2, 13.6, 12.10, 11.15 ndi 10.20, zomwe zimakonza zolakwika 55 zomwe zadziwika m'miyezi itatu yapitayi. Mwa zina, takonza mavuto omwe, muzochitika zosawerengeka, adayambitsa katangale posintha maunyolo a HOT (mulu wokha wa tuple) panthawi ya VACUUM kapena pochita ntchito ya REINDEX CONCURRENTLY pa ma index pa matebulo omwe amagwiritsa ntchito makina osungira TOAST.
Zowonongeka zokhazikika pochita ALTER STATISTICS komanso pobweza data yokhala ndi mitundu yosiyanasiyana. Ziphuphu mu query planner zomwe zidapangitsa zotsatira zolakwika zakonzedwa. Kukumbukira kosasunthika kumadontha mukamakonza ma index pogwiritsa ntchito mawu komanso pochita RESSIGN OWNED BY operation pa zinthu zambiri. Kupanga ziwerengero zapamwamba zamagome amagulu kumaperekedwa.
Kuphatikiza apo, titha kuzindikira kutulutsidwa kwa ntchito yokonzanso, yomwe imakupatsani mwayi wosintha zovuta pa schema ya data mu PostgreSQL popanda kuyimitsa ntchito, zomwe nthawi zonse zimafunikira kusintha kwapamanja ndikutseka kwakanthawi kwa ntchito pogwiritsa ntchito database. Zomwe zimagwiritsidwa ntchito zimapangitsa kuti zitheke kusintha kuchokera ku ndondomeko yakale ya deta kupita ku yatsopano popanda kutsekereza kwautali komanso popanda kusokoneza ndondomeko yopempha. Chidachi chimapanga mawonedwe a tebulo omwe mapulogalamu akupitiriza kugwira nawo ntchito panthawi yosuntha schema, komanso amakonza zoyambitsa zomwe zimamasulira ntchito zowonjezera ndi kuchotsa deta pakati pa schemas akale ndi atsopano.
Choncho, pogwiritsira ntchito reshape panthawi yakusamuka, schema yakale ndi yatsopano imakhalabe nthawi yomweyo ndipo mapulogalamu amatha kusamutsidwa pang'onopang'ono ku schema yatsopano popanda kuyimitsa ntchito (muzinthu zazikulu, ogwira ntchito amatha kusinthidwa pang'onopang'ono kuchokera ku zakale kupita ku zatsopano). Kusamuka kwa mapulogalamu kupita ku schema yatsopano kumalizidwa, malingaliro ndi zoyambitsa zomwe zimapangidwira kuti zithandizire schema yakale zimachotsedwa. Ngati mavuto omwe ali ndi mapulogalamu azindikiridwa panthawi yakusamuka, mutha kusintha kusintha kwa schema ndikubwerera ku chikhalidwe chakale.
Source: opennet.ru