{"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\/ro\/blog\/news\/obnovlenie-postgresql-vypusk-reshape-utility-dlya-migraczii-na-novuyu-shemu-bez-ostanovki-raboty","title":{"rendered":"Actualizare PostgreSQL. Lansarea reshape, utilitar pentru migrarea la noua schem\u0103 f\u0103r\u0103 a opri func\u021bionarea","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

S-au format actualiz\u0103ri corective pentru toate ramurile suportate ale PostgreSQL: 14.2, 13.6, 12.10, 11.15 \u0219i 10.20, \u00een care au fost corectate 55 de erori identificate \u00een ultimele trei luni. Printre acestea, au fost rezolvate problemele care, \u00een circumstan\u021be rare, duceau la deteriorarea indexurilor \u00een timpul modific\u0103rii lan\u021burilor HOT (heap-only tuple) \u00een timpul execu\u021biei opera\u021biei VACUUM sau \u00een timpul execu\u021biei opera\u021biei REINDEX CONCURRENTLY pentru indexurile tabelelor, \u00een care este utilizat mecanismul de stocare TOAST. <\/p>\n

Au fost remediate \u00eencheierile nea\u0219teptate \u00een timpul execu\u021biei ALTER STATISTICS \u0219i \u00een timpul extragerii datelor cu tipuri multirange. \u00cen planificatorul de interog\u0103ri au fost eliminate erorile care duceau la returnarea rezultatelor incorecte. Au fost eliminate scurgerile de memorie \u00een timpul actualiz\u0103rii indicilor pe baza expresiilor \u0219i \u00een timpul execut\u0103rii opera\u021biunii «REASSIGN OWNED BY» pe un num\u0103r mare de obiecte. A fost asigurat\u0103 construirea de statistici extinse pentru tabelele segmentate. <\/p>\n

\u00cen plus, se remarc\u0103 lansarea utilitarului reshape, care permite efectuarea actualiz\u0103rilor complexe ale schemei de date \u00een PostgreSQL f\u0103r\u0103 \u00eentreruperea func\u021bion\u0103rii, ceea ce \u00een condi\u021bii normale necesit\u0103 modific\u0103ri manuale \u0219i oprirea temporar\u0103 a serviciilor care folosesc baza de date. Utilitarul permite tranzi\u021bia de la vechea schem\u0103 de date la nou\u0103 f\u0103r\u0103 bloc\u0103ri prelungite \u0219i f\u0103r\u0103 a \u00eentrerupe ciclul de procesare a interog\u0103rilor. Utilitarul creeaz\u0103 automat vederi ale tabelelor cu care aplica\u021biile continu\u0103 s\u0103 lucreze \u00een timpul migra\u021biei schemei de date, precum \u0219i configureaz\u0103 declan\u0219atoare care traduc opera\u021biile de ad\u0103ugare \u0219i \u0219tergere a datelor \u00eentre vechea \u0219i noua schem\u0103. <\/p>\n

Astfel, utiliz\u00e2nd reshape \u00een timpul migra\u021biei, vechea \u0219i noua schem\u0103 r\u0103m\u00e2n disponibile simultan, permi\u021b\u00e2nd aplica\u021biilor s\u0103 fie treptat migrate la noua schem\u0103 f\u0103r\u0103 oprirea func\u021bion\u0103rii (\u00een infrastructuri mari, procesatorii pot fi \u00eenlocui\u021bi treptat de la vechi la noi). Dup\u0103 finalizarea tranzi\u021biei aplica\u021biilor la noua schem\u0103, vederile \u0219i declan\u0219atoarele create pentru a p\u0103stra suportul pentru vechea schem\u0103 sunt eliminate. \u00cen cazul identific\u0103rii problemelor cu aplica\u021biile \u00een timpul migra\u021biei, se poate anula modificarea schemei \u0219i reveni la starea anterioar\u0103.
\n
Sursa: opennet.ro<\/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\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\udd47Actualizare PostgreSQL. Lansare reshape, utilitar pentru migrarea la noua schem\u0103 f\u0103r\u0103 a opri func\u021bionarea | ProHoster","description":"S-au format actualiz\u0103ri corective pentru toate ramurile suportate ale PostgreSQL: 14.2, 13.6, 12.10, 11.15 \u0219i 10.20, \u00een care au fost corectate 55 de erori identificate \u00een ultimele trei luni.","canonical_url":"https:\/\/prohoster.info\/ro\/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":"ro_RO","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\/ro\/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\/ro\/wp-json\/wp\/v2\/posts\/103298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=103298"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/103298\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=103298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=103298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=103298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}