{"id":95202,"date":"2020-09-26T13:42:02","date_gmt":"2020-09-26T11:42:02","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/postgresql-13"},"modified":"2020-09-26T13:42:02","modified_gmt":"2020-09-26T11:42:02","slug":"postgresql-13","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/news\/postgresql-13","title":{"rendered":"Postgresql 13","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

24. septembra t\u00edm v\u00fdvoj\u00e1rov ozn\u00e1mil vydanie novej verzie Postgresql s \u010d\u00edslom 13. V tomto vydan\u00ed sa okrem in\u00e9ho zamerali na zv\u00fd\u0161enie v\u00fdkonnosti, zr\u00fdchlenie vn\u00fatorn\u00fdch servisn\u00fdch slu\u017eieb a zjednodu\u0161enie moniturovania datab\u00e1zy, ako aj na spo\u013eahlivej\u0161\u00ed pr\u00edstupov\u00fd kontroln\u00fd syst\u00e9m.<\/p>\n

Pokra\u010dovala pr\u00e1ca na optimaliz\u00e1cii indexovania tabuliek z h\u013eadiska spracovania duplicitn\u00fdch z\u00e1znamov v bin\u00e1rnych stromoch indexov, \u010do umo\u017enilo nielen zr\u00fdchlenie vykon\u00e1vania dotazov, ale aj zmen\u0161enie diskov\u00e9ho priestoru obsaden\u00e9ho indexom.
\nOkrem toho bol pridan\u00fd algoritmus inkrement\u00e1ln\u00e9ho triedenia, ktor\u00fd ur\u00fdch\u013euje op\u00e4tovn\u00e9 triedenie u\u017e zoraden\u00fdch \u00fadajov z predch\u00e1dzaj\u00facich krokov a pri niektor\u00fdch dotazoch je mo\u017en\u00e9 ur\u00fdchli\u0165 vykon\u00e1vanie pomocou novej roz\u0161\u00edrenej \u0161tatistiky (cez pr\u00edkaz CREATE STATISTICS) pri v\u00fdpo\u010dte efekt\u00edvnej\u0161ieho krokov\u00e9ho pl\u00e1nu.
\nTie\u017e bolo optimalizovan\u00e9 vykon\u00e1vanie dotazov s n\u00e1kladnou agreg\u00e1ciou \u00fadajov prostredn\u00edctvom \u0161ir\u0161ieho vyu\u017e\u00edvania hashovej agreg\u00e1cie a presunut\u00edm \u010dasti agregovan\u00fdch \u00fadajov na disk, ak sa nezmestia do pam\u00e4te. Zaznamen\u00e1va sa v\u00fdznamn\u00e9 zv\u00fd\u0161enie r\u00fdchlosti spojenia tabuliek umiestnen\u00fdch na r\u00f4znych oddieloch.<\/p>\n

Bola vykonan\u00e1 zna\u010dn\u00e1 pr\u00e1ca aj na zjednodu\u0161en\u00ed \u00fadr\u017eby a spr\u00e1vy datab\u00e1z PostgreSQL. Vstavan\u00e1 \u00faloha \u201ev\u00e1kuovania\u201c, t.j. vyu\u017eitia uvo\u013enen\u00e9ho diskov\u00e9ho priestoru po odstr\u00e1nen\u00ed alebo prep\u00edsan\u00ed riadkov, sa teraz m\u00f4\u017ee vykon\u00e1va\u0165 v paraleln\u00fdch vl\u00e1knach a administr\u00e1tor m\u00e1 mo\u017enos\u0165 uvies\u0165 ich po\u010det. Okrem toho boli pridan\u00e9 nov\u00e9 n\u00e1stroje na monitorovanie aktu\u00e1lnej aktivity datab\u00e1zy a bolo zabr\u00e1nenej chyb\u00e1m pri synchroniz\u00e1cii protokolov predbe\u017en\u00e9ho z\u00e1pisu medzi hlavn\u00fdm serverom a replikami, \u010do mohlo vies\u0165 k konfliktom pri vyp\u00ednan\u00ed replik alebo naru\u0161i\u0165 integritu distribuovanej datab\u00e1zy po ich obnove na z\u00e1klade \u00fadajov z protokolu.<\/p>\n

Medzi novinkami pre v\u00fdvoj\u00e1rov patr\u00ed funkcia datetime(), ktor\u00e1 prev\u00e1dza r\u00f4zne \u0161tandardn\u00e9 form\u00e1ty z\u00e1pisu \u010dasu na vstavan\u00fd typ PostgreSQL; pr\u00edstupn\u00e1 z krabice je funkcia generovania UUID v4 gen_random_uuid(); normaliz\u00e1cia pr\u00e1ce s unicode; flexibilnej\u0161\u00ed syst\u00e9m distrib\u00facie d\u00e1t tabuliek na prepojen\u00fdch sie\u0165ov\u00fdch uzloch datab\u00e1zy s plnohodnotnou replik\u00e1ciou na logickej \u00farovni a \u010fal\u0161ie zmeny v dopytoch a nov\u00fdch dostupn\u00fdch pre repliky sp\u00fa\u0161\u0165a\u010doch.<\/p>\n

Kontrola pr\u00edstupu k datab\u00e1ze je hl\u00e1sen\u00e1 ako jeden z k\u013e\u00fa\u010dov\u00fdch komponentov syst\u00e9mu a v novej verzii boli v tejto oblasti vykonan\u00e9 ve\u013ek\u00e9 pokroky. Teraz m\u00f4\u017ee in\u0161tal\u00e1ciu roz\u0161\u00edren\u00ed aplikova\u0165 len privilegovan\u00fd pou\u017e\u00edvate\u013e (superuser). Be\u017en\u00ed pou\u017e\u00edvatelia si bud\u00fa m\u00f4c\u0165 in\u0161talova\u0165 len tie roz\u0161\u00edrenia, ktor\u00e9 s\u00fa ozna\u010den\u00e9 ako d\u00f4veryhodn\u00e9, alebo mal\u00fa skupinu roz\u0161\u00edren\u00ed, ktor\u00e9 sa pova\u017euj\u00fa za d\u00f4veryhodn\u00e9 predvolene (napr\u00edklad pgcrypto, tablefunc alebo hstore). Pri overovan\u00ed pou\u017e\u00edvate\u013eov pomocou mechanizmu SCRAM (pri pr\u00e1ci cez ovl\u00e1da\u010d libpq) sa teraz vy\u017eaduje \u201epripojenie kan\u00e1la\u201c a obalov\u00e1 funkcia pre extern\u00e9 \u00fadaje postgres_fdw od verzie 13 podporuje autoriz\u00e1ciu cez certifik\u00e1t.<\/p>\n

<\/p>\n

Pozn\u00e1mky k vydaniu<\/a><\/p>\n

<\/noindex><\/noindex>
\n<\/p>\n

Str\u00e1nka na stiahnutie<\/a><\/p>\n

<\/noindex><\/p>\n

Zdroj: linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

24 \u0441\u0435\u043d\u0442\u044f\u0431\u0440\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u043e\u0432 \u0441\u043e\u043e\u0431\u0449\u0438\u043b\u0430 \u043e \u0432\u044b\u0445\u043e\u0434\u0435 \u043e\u0447\u0435\u0440\u0435\u0434\u043d\u043e\u0433\u043e \u0440\u0435\u043b\u0438\u0437\u0430 Postgresql \u043f\u043e\u0434 \u043d\u043e\u043c\u0435\u0440\u043e\u043c 13. \u0412 \u043d\u043e\u0432\u043e\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0435 \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435, \u0441\u0440\u0435\u0434\u0438 \u043f\u0440\u043e\u0447\u0435\u0433\u043e, \u0431\u044b\u043b\u043e \u0443\u0434\u0435\u043b\u0435\u043d\u043e \u043f\u043e\u0432\u044b\u0448\u0435\u043d\u0438\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438, \u0443\u0441\u043a\u043e\u0440\u0435\u043d\u0438\u044e \u0432\u043d\u0443\u0442\u0440\u0435\u043d\u043d\u0438\u0445 \u0441\u043b\u0443\u0436\u0431 \u043e\u0431\u0441\u043b\u0443\u0436\u0438\u0432\u0430\u043d\u0438\u044f \u0438 \u0443\u043f\u0440\u043e\u0449\u0435\u043d\u0438\u044e \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0430\u0437\u044b, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0431\u043e\u043b\u0435\u0435 \u043d\u0430\u0434\u0435\u0436\u043d\u043e\u043c\u0443 \u043a\u043e\u043d\u0442\u0440\u043e\u043b\u044e \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u0441\u0438\u0441\u0442\u0435\u043c\u0435. \u041f\u0440\u043e\u0434\u043e\u043b\u0436\u0438\u043b\u0430\u0441\u044c \u0440\u0430\u0431\u043e\u0442\u0430 \u043d\u0430\u0434 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u0438\u043d\u0434\u0435\u043a\u0441\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 \u043f\u043b\u0430\u043d\u0435 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0441\u0440\u0435\u0434\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u0438\u0440\u0443\u0435\u043c\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0434\u0432\u043e\u0438\u0447\u043d\u044b\u0445 […]<\/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-95202","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\udd47Postgresql 13 | ProHoster","description":"24. septembra t\u00edm v\u00fdvoj\u00e1rov ozn\u00e1mil vydanie \u010fal\u0161ej verzie PostgreSQL pod \u010d\u00edslom 13.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/postgresql-13","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\udd47Postgresql 13 | ProHoster","og:description":"24 \u0441\u0435\u043d\u0442\u044f\u0431\u0440\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u043e\u0432 \u0441\u043e\u043e\u0431\u0449\u0438\u043b\u0430 \u043e \u0432\u044b\u0445\u043e\u0434\u0435 \u043e\u0447\u0435\u0440\u0435\u0434\u043d\u043e\u0433\u043e \u0440\u0435\u043b\u0438\u0437\u0430 Postgresql \u043f\u043e\u0434 \u043d\u043e\u043c\u0435\u0440\u043e\u043c 13.","og:url":"https:\/\/prohoster.info\/sk\/blog\/news\/postgresql-13","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":"2020-09-26T11:42:02+00:00","article:modified_time":"2020-09-26T11:42:02+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"95202","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":null,"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":"2021-02-28 10:25:24","updated":"2022-10-03 07:46:19","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\/95202","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=95202"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/95202\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=95202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=95202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=95202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}