{"id":103298,"date":"2022-02-11T15:36:48","date_gmt":"2022-02-11T13:36:48","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/obnovlenie-postgresql-vypusk-reshape-utility-dlya-migraczii-na-novuyu-shemu-bez-ostanovki-raboty"},"modified":"2022-02-11T15:36:48","modified_gmt":"2022-02-11T13:36:48","slug":"obnovlenie-postgresql-vypusk-reshape-utility-dlya-migraczii-na-novuyu-shemu-bez-ostanovki-raboty","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/obnovlenie-postgresql-vypusk-reshape-utility-dlya-migraczii-na-novuyu-shemu-bez-ostanovki-raboty","title":{"rendered":"P\u00ebrdit\u00ebsim p\u00ebr PostgreSQL. Publikimi reshape, nj\u00eb utilitar p\u00ebr migrimin n\u00eb nj\u00eb skem\u00eb t\u00eb re pa ndaluar funksionimin","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Jan\u00eb formuar p\u00ebrdit\u00ebsime korrigjuese p\u00ebr t\u00eb gjitha deg\u00ebt e mb\u00ebshtetura t\u00eb PostgreSQL: 14.2, 13.6, 12.10, 11.15 dhe 10.20, n\u00eb t\u00eb cilat jan\u00eb rregulluar 55 gabime, t\u00eb zbuluara gjat\u00eb tri muajve t\u00eb fundit. N\u00eb mesin e tyre jan\u00eb eliminuar probleme q\u00eb shkaktonin, n\u00eb rrethana t\u00eb rralla, d\u00ebmtimin e indekseve gjat\u00eb ndryshimit t\u00eb vargjeve HOT (heap-only tuple) gjat\u00eb kryerjes s\u00eb operacionit VACUUM ose gjat\u00eb kryerjes s\u00eb operacionit REINDEX CONCURRENTLY p\u00ebr indekset n\u00eb tabelat q\u00eb p\u00ebrdorin mekanizmin e ruajtjes TOAST. <\/p>\n
Janulluar p\u00ebrfundimet emergjente gjat\u00eb ekzekutimit t\u00eb ALTER STATISTICS dhe gjat\u00eb nxjerrjes s\u00eb t\u00eb dh\u00ebnave me tipe multirange. N\u00eb planifikuesin e k\u00ebrkesave jan\u00eb eliminuar gabimet q\u00eb \u00e7onin n\u00eb rezultat\u00eb t\u00eb pasakt\u00eb. Janulluar rrjedhjet e memories gjat\u00eb p\u00ebrdit\u00ebsimit t\u00eb indekseve sipas shprehjeve dhe gjat\u00eb ekzekutimit t\u00eb operacionit «REASSIGN OWNED BY» mbi nj\u00eb num\u00ebr t\u00eb madh objektesh. Siguruar nd\u00ebrtimi i statistikave t\u00eb avancuara p\u00ebr tabelat e segmentuara. <\/p>\n
Sidoqoft\u00eb, mund t\u00eb theksohet publikimi i utilitetit reshape, i cili lejon p\u00ebrdit\u00ebsime t\u00eb komplikuara t\u00eb skem\u00ebs s\u00eb t\u00eb dh\u00ebnave n\u00eb PostgreSQL pa ndaluar pun\u00ebn, t\u00eb cilat n\u00eb kushte normale k\u00ebrkojn\u00eb ndryshime manuale dhe ndalesa t\u00eb p\u00ebrkohshme t\u00eb sh\u00ebrbimeve q\u00eb p\u00ebrdorin DB. Utiliteti ofron mund\u00ebsin\u00eb e kalimit nga nj\u00eb skem\u00eb e vjet\u00ebr e t\u00eb dh\u00ebnave n\u00eb nj\u00eb t\u00eb re pa bllokime t\u00eb gjata dhe pa nd\u00ebrprer\u00eb ciklin e p\u00ebrpunimit t\u00eb pyetjeve. Utiliteti krijon automatikisht pamjet e tabelave, me t\u00eb cilat aplikacionet vazhdojn\u00eb t\u00eb punojn\u00eb gjat\u00eb migrimit t\u00eb skem\u00ebs s\u00eb t\u00eb dh\u00ebnave dhe gjithashtu konfiguroni triggere q\u00eb transmetojn\u00eb operacionet e shtimit dhe fshirjes s\u00eb t\u00eb dh\u00ebnave midis skemave t\u00eb vjetra dhe t\u00eb reja. <\/p>\n
Prandaj, gjat\u00eb p\u00ebrdorimit t\u00eb reshape gjat\u00eb migrimit, skema e vjet\u00ebr dhe ajo e re q\u00ebndrojn\u00eb t\u00eb dyja t\u00eb disponueshme dhe aplikacionet mund t\u00eb kalojn\u00eb gradualisht n\u00eb skem\u00ebn e re pa ndalur pun\u00ebn (n\u00eb infrastrukturat e m\u00ebdha mund t\u00eb z\u00ebvend\u00ebsohen gradualisht p\u00ebrpunuesit nga t\u00eb vjetrit n\u00eb t\u00eb rinjt\u00eb). Pas p\u00ebrfundimit t\u00eb kalimit t\u00eb aplikacioneve n\u00eb skem\u00ebn e re, pamjet dhe triggat e krijuara p\u00ebr t\u00eb mbajtur mb\u00ebshtetje p\u00ebr skem\u00ebn e vjet\u00ebr hiqen. N\u00eb rast se hasen probleme me aplikacionet gjat\u00eb migrimit, mund t\u00eb anullohet ndryshimi i skem\u00ebs dhe t\u00eb kthehet n\u00eb gjendjen e vjet\u00ebr. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"