{"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\/sk\/blog\/news\/obnovlenie-postgresql-vypusk-reshape-utility-dlya-migraczii-na-novuyu-shemu-bez-ostanovki-raboty","title":{"rendered":"Aktualiz\u00e1cia PostgreSQL. Vydanie reshape, n\u00e1stroja na migr\u00e1ciu na nov\u00fa sch\u00e9mu bez preru\u0161enia prev\u00e1dzky.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Boli vytvoren\u00e9 opravn\u00e9 aktualiz\u00e1cie pre v\u0161etky podporovan\u00e9 vetvy PostgreSQL: 14.2, 13.6, 12.10, 11.15 a 10.20, v ktor\u00fdch bolo opraven\u00fdch 55 ch\u00fdb zisten\u00fdch za posledn\u00e9 tri mesiace. Medzi in\u00fdm boli odstr\u00e1nen\u00e9 probl\u00e9my, ktor\u00e9 pri zriedkav\u00fdch okolnostiach sp\u00f4sobovali po\u0161kodenie indexov pri zmene re\u0165azcov HOT (heap-only tuple) po\u010das vykon\u00e1vania oper\u00e1cie VACUUM alebo pri vykon\u00e1van\u00ed oper\u00e1cie REINDEX CONCURRENTLY pre indexy tabuliek, v ktor\u00fdch sa pou\u017e\u00edva mechanizmus ukladania TOAST. <\/p>\n

Opravy havarijn\u00fdch ukon\u010den\u00ed pri vykon\u00e1van\u00ed ALTER STATISTICS a pri z\u00edskavan\u00ed \u00fadajov s multirange typmi. V pl\u00e1nova\u010di dotazov boli odstr\u00e1nen\u00e9 chyby, ktor\u00e9 viedli k nespr\u00e1vnym v\u00fdsledkom. Eliminovali sa \u00faniky pam\u00e4te pri aktualiz\u00e1cii indexov na z\u00e1klade v\u00fdrazov a pri vykon\u00e1van\u00ed oper\u00e1cie 'REASSIGN OWNED BY' nad ve\u013ek\u00fdm po\u010dtom objektov. Bol zabezpe\u010den\u00fd roz\u0161\u00edren\u00fd \u0161tatistick\u00fd preh\u013ead pre segmentovan\u00e9 tabu\u013eky. <\/p>\n

Dodato\u010dne je mo\u017en\u00e9 spomen\u00fa\u0165 vydanie n\u00e1stroja reshape, ktor\u00fd umo\u017e\u0148uje vykon\u00e1va\u0165 zlo\u017eit\u00e9 aktualiz\u00e1cie sch\u00e9my \u00fadajov v PostgreSQL bez preru\u0161enia prev\u00e1dzky, \u010do obvykle vy\u017eaduje manu\u00e1lne vykon\u00e1vanie zmien a do\u010dasn\u00e9 pozastavenie prev\u00e1dzky slu\u017eieb pou\u017e\u00edvaj\u00facich datab\u00e1zu. N\u00e1stroj umo\u017e\u0148uje prechod zo starej sch\u00e9my \u00fadajov na nov\u00fa bez dlhodob\u00fdch blok\u00e1d a bez preru\u0161enia cyklu spracovania dotazov. N\u00e1stroj automaticky vytv\u00e1ra poh\u013eady na tabu\u013eky, s ktor\u00fdmi aplik\u00e1cie na\u010falej pracuj\u00fa po\u010das migr\u00e1cie sch\u00e9my \u00fadajov, a tie\u017e nastavuje sp\u00fa\u0161\u0165a\u010de, ktor\u00e9 pren\u00e1\u0161aj\u00fa oper\u00e1cie pridania a odstr\u00e1nenia d\u00e1t medzi starou a novou sch\u00e9mou. <\/p>\n

Tak\u017ee pri pou\u017eit\u00ed reshape po\u010das migr\u00e1cie zosta\u0148\u00fa star\u00e1 a nov\u00e1 sch\u00e9ma s\u00fa\u010dasne dostupn\u00e9 a aplik\u00e1cie je mo\u017en\u00e9 postupne prepn\u00fa\u0165 na nov\u00fa sch\u00e9mu bez preru\u0161enia prev\u00e1dzky (v ve\u013ek\u00fdch infra\u0161trukt\u00farach je mo\u017en\u00e9 po etap\u00e1ch nahr\u00e1dza\u0165 spracovate\u013eov zo star\u00fdch na nov\u00e9). Po ukon\u010den\u00ed prechodu aplik\u00e1ci\u00ed na nov\u00fa sch\u00e9mu s\u00fa poh\u013eady a sp\u00fa\u0161\u0165a\u010de vytvoren\u00e9 na zachovanie podpory starej sch\u00e9my odstr\u00e1nen\u00e9. V pr\u00edpade odhalenia probl\u00e9mov s aplik\u00e1ciami po\u010das migr\u00e1cie je mo\u017en\u00e9 vr\u00e1ti\u0165 zmenu sch\u00e9my a vr\u00e1ti\u0165 sa k star\u00e9mu 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\udd47Aktualiz\u00e1cia PostgreSQL. Verzia reshape, n\u00e1stroj na migr\u00e1ciu na nov\u00fa sch\u00e9mu bez preru\u0161enia prev\u00e1dzky | ProHoster","description":"Boli vytvoren\u00e9 opravn\u00e9 aktualiz\u00e1cie pre v\u0161etky podporovan\u00e9 vetvy PostgreSQL: 14.2, 13.6, 12.10, 11.15 a 10.20, v ktor\u00fdch bolo opraven\u00fdch 55 ch\u00fdb zisten\u00fdch za posledn\u00e9 tri mesiace.","canonical_url":"https:\/\/prohoster.info\/sk\/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":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/103298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=103298"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/103298\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=103298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=103298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=103298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}