{"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\/cs\/blog\/news\/obnovlenie-postgresql-vypusk-reshape-utility-dlya-migraczii-na-novuyu-shemu-bez-ostanovki-raboty","title":{"rendered":"Aktualizace PostgreSQL. Vyd\u00e1n\u00ed reshape, n\u00e1stroj pro migraci na nov\u00e9 sch\u00e9ma bez zastaven\u00ed provozu","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Byly vytvo\u0159eny opravn\u00e9 aktualizace pro v\u0161echny podporovan\u00e9 verze PostgreSQL: 14.2, 13.6, 12.10, 11.15 a 10.20, kter\u00e9 opravily 55 chyb zji\u0161t\u011bn\u00fdch za posledn\u00ed t\u0159i m\u011bs\u00edce. Mezi nimi byly odstran\u011bny probl\u00e9my, kter\u00e9 za v\u00fdjime\u010dn\u00fdch okolnost\u00ed vedly k po\u0161kozen\u00ed index\u016f p\u0159i zm\u011bn\u011b \u0159et\u011bzc\u016f HOT (heap-only tuple) b\u011bhem operace VACUUM nebo p\u0159i prov\u00e1d\u011bn\u00ed operace REINDEX CONCURRENTLY pro indexy tabulek, kter\u00e9 pou\u017e\u00edvaj\u00ed mechanismus ukl\u00e1d\u00e1n\u00ed TOAST. <\/p>\n

Byly odstran\u011bny havarijn\u00ed ukon\u010den\u00ed p\u0159i prov\u00e1d\u011bn\u00ed ALTER STATISTICS a p\u0159i extrakci dat s multirange typy. V pl\u00e1nova\u010di dotaz\u016f byly odstran\u011bny chyby, kter\u00e9 vedly k nespr\u00e1vn\u00fdm v\u00fdsledk\u016fm. Byly odstran\u011bny \u00faniky pam\u011bti p\u0159i aktualizaci index\u016f podle v\u00fdraz\u016f a p\u0159i prov\u00e1d\u011bn\u00ed operace «REASSIGN OWNED BY» na velk\u00e9m po\u010dtu objekt\u016f. Bylo zaji\u0161t\u011bno vytv\u00e1\u0159en\u00ed roz\u0161\u00ed\u0159en\u00e9 statistiky pro segmentovan\u00e9 tabulky. <\/p>\n

D\u00e1le lze zm\u00ednit vyd\u00e1n\u00ed n\u00e1stroje reshape, kter\u00fd umo\u017e\u0148uje prov\u00e1d\u011bt slo\u017eit\u00e9 aktualizace datov\u00e9ho sch\u00e9matu v PostgreSQL, kter\u00e9 za b\u011b\u017en\u00fdch podm\u00ednek vy\u017eaduj\u00ed manu\u00e1ln\u00ed \u00fapravy a do\u010dasn\u00e9 zastaven\u00ed provozu slu\u017eeb vyu\u017e\u00edvaj\u00edc\u00edch DB. N\u00e1stroj umo\u017e\u0148uje p\u0159echod ze star\u00e9ho datov\u00e9ho sch\u00e9matu na nov\u00e9 bez dlouh\u00fdch blokac\u00ed a bez p\u0159eru\u0161en\u00ed zpracov\u00e1n\u00ed dotaz\u016f. N\u00e1stroj automaticky vytv\u00e1\u0159\u00ed pohledy tabulek, se kter\u00fdmi aplikace pokra\u010duj\u00ed v pr\u00e1ci b\u011bhem migrace datov\u00e9ho sch\u00e9matu, a tak\u00e9 konfiguruje spou\u0161t\u011b\u010de, kter\u00e9 p\u0159en\u00e1\u0161ej\u00ed operace p\u0159id\u00e1v\u00e1n\u00ed a odstra\u0148ov\u00e1n\u00ed dat mezi star\u00fdm a nov\u00fdm sch\u00e9matem. <\/p>\n

Tak b\u011bhem migrace s pou\u017eit\u00edm reshape z\u016fst\u00e1vaj\u00ed star\u00e9 a nov\u00e9 sch\u00e9ma dostupn\u00e9 sou\u010dasn\u011b a aplikace mohou b\u00fdt postupn\u011b p\u0159evedeny na nov\u00e9 sch\u00e9ma bez zastaven\u00ed provozu (ve velk\u00fdch infrastruktur\u00e1ch lze postupn\u011b nahrazovat zpracovatele ze star\u00fdch na nov\u00e9). Po dokon\u010den\u00ed p\u0159evodu aplikac\u00ed na nov\u00e9 sch\u00e9ma jsou pohledy a spou\u0161t\u011b\u010de vytvo\u0159en\u00e9 pro udr\u017een\u00ed podpory star\u00e9ho sch\u00e9matu odstran\u011bny. V p\u0159\u00edpad\u011b zji\u0161t\u011bn\u00ed probl\u00e9m\u016f s aplikacemi b\u011bhem migrace lze zm\u011bnu sch\u00e9matu zru\u0161it a vr\u00e1tit se zp\u011bt k p\u016fvodn\u00edmu stavu.
\n
Zdroj: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0421\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a PostgreSQL: 14.2, 13.6, 12.10, 11.15 \u0438 10.20, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0438\u0441\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u043e 55 \u043e\u0448\u0438\u0431\u043e\u043a, \u0432\u044b\u044f\u0432\u043b\u0435\u043d\u043d\u044b\u0445 \u0437\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 \u0442\u0440\u0438 \u043c\u0435\u0441\u044f\u0446\u0430. \u0412 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0443\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u044b \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b, \u043f\u0440\u0438\u0432\u043e\u0434\u0438\u0432\u0448\u0438\u0435 \u043f\u0440\u0438 \u0440\u0435\u0434\u043a\u043e\u043c \u0441\u0442\u0435\u0447\u0435\u043d\u0438\u0438 \u043e\u0431\u0441\u0442\u043e\u044f\u0442\u0435\u043b\u044c\u0441\u0442\u0432 \u043a \u043f\u043e\u0432\u0440\u0435\u0436\u0434\u0435\u043d\u0438\u044e \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432 \u043f\u0440\u0438 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0438 \u0446\u0435\u043f\u043e\u0447\u0435\u043a HOT (heap-only tuple) \u0432\u043e \u0432\u0440\u0435\u043c\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 VACUUM \u0438\u043b\u0438 \u043f\u0440\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 REINDEX CONCURRENTLY \u0434\u043b\u044f […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-103298","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Aktualizace PostgreSQL. Verze reshape, n\u00e1stroj pro migraci na novou sch\u00e9ma bez p\u0159eru\u0161en\u00ed provozu | ProHoster","description":"Byly vytvo\u0159eny opravn\u00e9 aktualizace pro v\u0161echny podporovan\u00e9 v\u011btve PostgreSQL: 14.2, 13.6, 12.10, 11.15 a 10.20, ve kter\u00fdch bylo opraveno 55 chyb zji\u0161t\u011bn\u00fdch za posledn\u00ed t\u0159i m\u011bs\u00edce.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/obnovlenie-postgresql-vypusk-reshape-utility-dlya-migraczii-na-novuyu-shemu-bez-ostanovki-raboty","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 PostgreSQL. \u0412\u044b\u043f\u0443\u0441\u043a reshape, \u0443\u0442\u0438\u043b\u0438\u0442\u044b \u0434\u043b\u044f \u043c\u0438\u0433\u0440\u0430\u0446\u0438\u0438 \u043d\u0430 \u043d\u043e\u0432\u0443\u044e \u0441\u0445\u0435\u043c\u0443 \u0431\u0435\u0437 \u043e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u0440\u0430\u0431\u043e\u0442\u044b | ProHoster","og:description":"\u0421\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a PostgreSQL: 14.2, 13.6, 12.10, 11.15 \u0438 10.20, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0438\u0441\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u043e 55 \u043e\u0448\u0438\u0431\u043e\u043a, \u0432\u044b\u044f\u0432\u043b\u0435\u043d\u043d\u044b\u0445 \u0437\u0430 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 \u0442\u0440\u0438 \u043c\u0435\u0441\u044f\u0446\u0430.","og:url":"https:\/\/prohoster.info\/cs\/blog\/news\/obnovlenie-postgresql-vypusk-reshape-utility-dlya-migraczii-na-novuyu-shemu-bez-ostanovki-raboty","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2022-02-11T13:36:48+00:00","article:modified_time":"2022-02-11T13:36:48+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"103298","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2022-02-11 13:37:46","updated":"2022-10-02 03:34:35","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/103298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=103298"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/103298\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=103298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=103298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=103298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}