{"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\/sv\/blog\/news\/postgresql-13","title":{"rendered":"Postgresql 13","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Den 24 september meddelade utvecklarteamet om lanseringen av den senaste versionen av Postgresql, nummer 13. I den nya utg\u00e5van lades fokus, bland annat, p\u00e5 att f\u00f6rb\u00e4ttra prestandan, snabba upp interna underh\u00e5llstj\u00e4nster och f\u00f6renkla \u00f6vervakningen av databasen samt att skapa en mer p\u00e5litlig \u00e5tkomstkontroll till systemet.<\/p>\n<p>Arbetet med att optimera indexeringen av tabeller fortsatte, s\u00e4rskilt n\u00e4r det g\u00e4ller att hantera dubbletter bland de indexerade uppgifterna i bin\u00e4ra indextr\u00e4d. Detta har gjort det m\u00f6jligt att inte bara p\u00e5skynda utf\u00f6randet av f\u00f6rfr\u00e5gningar utan \u00e4ven att minska det utrymme som indexet tar upp p\u00e5 disken.<br \/>\nDessutom har en algoritm f\u00f6r inkrementell sortering lagts till, d\u00e4r om-sortering av redan sorterade data fr\u00e5n tidigare steg g\u00e5r snabbare. Vissa f\u00f6rfr\u00e5gningar kan ocks\u00e5 snabbas upp genom att anv\u00e4nda den nya utvidgade statistiken (via kommandot CREATE STATISTICS) vid ber\u00e4kningen av en mer effektiv steg-f\u00f6r-steg-plan.<br \/>\nDessutom har utf\u00f6randet av f\u00f6rfr\u00e5gningar med kostsam datainsamling optimerats genom ett bredare utnyttjande av hash-aggregat och genom att skicka en del av de aggregerade uppgifterna till disken om de inte f\u00e5r plats i minnet. Det har noterats en betydande \u00f6kning av hastigheten vid sammanfogning av tabeller som finns p\u00e5 olika partitioner.<\/p>\n<p>Mycket arbete har ocks\u00e5 utf\u00f6rts f\u00f6r att f\u00f6renkla underh\u00e5ll och administration av Postgresql-databaser. Den inbyggda uppgiften \"vakuumering\", det vill s\u00e4ga anv\u00e4ndning av frigjort diskutrymme efter borttagning eller omskrivning av rader, kan nu utf\u00f6ras i parallella tr\u00e5dar, och administrat\u00f6ren har m\u00f6jlighet att ange antalet dessa tr\u00e5dar. Ut\u00f6ver detta har nya verktyg f\u00f6r \u00f6vervakning av den aktuella databasen aktivering lagts till, och fel vid synkronisering av skrivloggar mellan master och repliker har f\u00f6rhindrats, vilket annars kunde leda till konflikter vid avst\u00e4ngning av repliker eller skada integriteten f\u00f6r den distribuerade databasen efter deras \u00e5terst\u00e4llande baserat p\u00e5 loggdata.<\/p>\n<p>Bland nyheterna f\u00f6r utvecklare finns funktionen datetime(), som omvandlar olika standardformat f\u00f6r tidsangivelser till Postgresql:s inbyggda typ; en tillg\u00e4nglig funktion f\u00f6r att generera UUID v4 gen_random_uuid(); normalisering av arbetet med Unicode; ett mer flexibelt system f\u00f6r f\u00f6rdelning av tabelldata p\u00e5 l\u00e4nkade n\u00e4tverksnoder med fullst\u00e4ndig replikering p\u00e5 logisk niv\u00e5, samt andra f\u00f6r\u00e4ndringar i f\u00f6rfr\u00e5gningar och nya tillg\u00e4ngliga triggers f\u00f6r replikat.<\/p>\n<p>\u00c5tkomstkontroll till databasen anges som en av de centrala komponenterna i systemet, och i den nya versionen har stora framsteg gjorts p\u00e5 detta omr\u00e5de. Nu kan installation av till\u00e4gg till databasen endast utf\u00f6ras av en privilegierad anv\u00e4ndare (superuser). Normala anv\u00e4ndare kan ist\u00e4llet endast installera de till\u00e4gg som markerats av dem som betrodda, eller en liten upps\u00e4ttning till\u00e4gg som anses vara betrodda som standard (till exempel pgcrypto, tablefunc eller hstore). Vid autentisering av anv\u00e4ndare med hj\u00e4lp av SCRAM-mekanismen (n\u00e4r du arbetar via libpq-drivrutinen) kr\u00e4vs nu \"kanalbindning\", och wrapper-funktionen f\u00f6r externa data postgres_fdw st\u00f6der sedan version 13 autentisering via certifikat.<\/p>\n<p><noindex><noindex><\/p>\n<p><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/13\/release-13.html\">Uppdateringsanteckningar<\/a><\/p>\n<p><\/noindex><\/noindex><br \/>\n<noindex><\/p>\n<p><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/download\/\">Nedladdningssida<\/a><\/p>\n<p><\/noindex><\/p>\n<p>K\u00e4lla: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"http:\/\/www.linux.org.ru\/news\/opensource\/15914558\">linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>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 [&hellip;]<\/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<!-- All in One SEO 5.0.5.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"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.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sv\/blog\/news\/postgresql-13\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sv_SE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47Postgresql 13 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sv\/blog\/news\/postgresql-13\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-09-26T11:42:02+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-09-26T11:42:02+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Postgresql 13 | ProHoster","description":"Den 24 september meddelade utvecklingsteamet att den senaste versionen av Postgresql, nummer 13, har sl\u00e4ppts.","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/news\/postgresql-13","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sv_SE","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\/sv\/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\/sv\/wp-json\/wp\/v2\/posts\/95202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=95202"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/95202\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=95202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=95202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=95202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}