Izibuyekezo zokulungisa zenziwe kuwo wonke amagatsha asekelwayo e-PostgreSQL: 14.2, 13.6, 12.10, 11.15 kanye no-10.20, alungisa amaphutha angu-55 akhonjwe ezinyangeni ezintathu ezedlule. Phakathi kwezinye izinto, silungise izinkinga, ezimweni ezingavamile, eziholele ekukhohlakaleni kwenkomba lapho sishintsha amaketango angu-HOT (inqwaba kuphela) phakathi nomsebenzi we-VACUUM noma lapho senza umsebenzi we-REINDEX CONCURRENTLY kuma-index kumathebula asebenzisa indlela yokugcina ye-TOAST.
Kulungiswe ukuphahlazeka lapho kusetshenziswa i-ALTER STATISTICS nalapho kubuyiswa idatha enezinhlobo zamabanga amaningi. Iziphazamisi kumhleli wemibuzo ezibangele imiphumela engalungile zilungisiwe. Ukuvuza kwenkumbulo engaguquki lapho kubuyekezwa izinkomba kusetshenziswa izisho nalapho kwenziwa UKUBUYISA KUKABUSHA OKUNOMNIKAZI WOKUSEBENZA enanini elikhulu lezinto. Ukwakhiwa kwezibalo ezithuthukisiwe zamatafula ahlukene kunikezwa.
Ukwengeza, singaqaphela ukukhululwa kwensiza yokuma kabusha, ekuvumela ukuthi wenze izibuyekezo eziyinkimbinkimbi ku-schema sedatha ku-PostgreSQL ngaphandle kokumisa umsebenzi, ngaphansi kwezimo ezijwayelekile ezidinga izinguquko ezenziwa ngesandla kanye nokuvalwa kwesikhashana kwezinsizakalo usebenzisa i-database. Uhlelo lokusebenza lwenza kube lula ukushintsha kusuka kusikimu sedatha esidala siye kwesisha ngaphandle kokuvinjwa isikhathi eside futhi ngaphandle kokuphazamisa umjikelezo wokucubungula isicelo. Insiza idala ngokuzenzakalelayo ukubukwa kwethebula izinhlelo zokusebenza eziqhubeka nokusebenza ngakho phakathi nokuthuthwa kwe-schema sedatha, futhi ilungiselela izingcipho ezihumusha imisebenzi yokwengeza nokususa idatha phakathi kwezikimu ezindala nezintsha.
Ngakho-ke, uma usebenzisa i-reshape ngesikhathi sokufuduka, i-schema endala nentsha ihlala itholakala ngesikhathi esifanayo futhi izinhlelo zokusebenza zingadluliselwa kancane kancane ku-schema esisha ngaphandle kokumisa umsebenzi (kwingqalasizinda enkulu, izibambi zingashintshwa kancane kancane kusukela endala kuya entsha). Uma ukuthuthwa kwezinhlelo zokusebenza ku-schema esisha sekuqediwe, ukubuka nezibangeli ezidalwe ukuze kugcinwe ukusekelwa kwe-schema esidala ziyasuswa. Uma izinkinga ngezinhlelo zokusebenza zikhonjwa ngesikhathi sokuthutha, ungakwazi ukubuyisela emuva ushintsho lwe-schema bese ubuyela esimweni esidala.
Source: opennet.ru