{"id":38636,"date":"2019-10-31T22:24:58","date_gmt":"2019-10-31T19:24:58","guid":{"rendered":"https:\/\/prohoster.info\/blog\/reliz-subd-postgresql-12\/"},"modified":"2019-10-31T22:24:58","modified_gmt":"2019-10-31T19:24:58","slug":"reliz-subd-postgresql-12","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-postgresql-12","title":{"rendered":"Sl\u00e4pp av databashanteraren PostgreSQL 12","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Efter ett \u00e5rs utveckling <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/about\/news\/1976\/\">i sin helhet i \"Vladikavkaz Mathematical Journal\".<\/a><\/noindex> Den nya stabila versionen av databashanteraren PostgreSQL 12. Uppdateringar f\u00f6r denna version <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/support\/versioning\/\">kommer att sl\u00e4ppas<\/a><\/noindex> under de kommande fem \u00e5ren fram till november 2024. <\/p>\n<p>Huvud <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/static\/release-12.html\">nyheter<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> St\u00f6d f\u00f6r &#171; tillagd<noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/ddl-generated-columns.html\">ber\u00e4knade kolumner<\/a><\/noindex>&#171;, vars v\u00e4rde ber\u00e4knas utifr\u00e5n uttryck som t\u00e4cker v\u00e4rden fr\u00e5n andra kolumner i samma tabell (analogt med vyer, men f\u00f6r enskilda kolumner). De genererade kolumnerna kan vara av tv\u00e5 typer &#8212; lagrade och virtuella. I det f\u00f6rsta fallet ber\u00e4knas v\u00e4rdet vid till\u00e4gg eller \u00e4ndring av data, medan det i det andra fallet g\u00f6rs vid varje l\u00e4sning baserat p\u00e5 det aktuella tillst\u00e5ndet f\u00f6r andra kolumner. F\u00f6r n\u00e4rvarande st\u00f6der PostgreSQL endast lagrade genererade kolumner;\n<li class=\"l\"> M\u00f6jligheten att utf\u00f6ra databasfr\u00e5gor fr\u00e5n JSON-dokument med hj\u00e4lp av <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/functions-json.html#FUNCTIONS-SQLJSON-PATH\">Path-uttryck<\/a><\/noindex>, som liknar <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/XPath\">XPath<\/a><\/noindex> och \u00e4r definierade i standarden SQL\/JSON. F\u00f6r att f\u00f6rb\u00e4ttra effektiviteten i bearbetning av s\u00e5dana uttryck f\u00f6r dokument som lagras i JSONB-format anv\u00e4nds existerande indexeringsmetoder;\n<li class=\"l\"> Som standard aktiveras JIT-kompilatorn (Just-in-Time) baserat p\u00e5 LLVM f\u00f6r att p\u00e5skynda utf\u00f6randet av vissa uttryck under SQL-fr\u00e5gor. Till exempel kan JIT till\u00e4mpas f\u00f6r att snabba upp utf\u00f6randet av uttryck inom &#171;WHERE&#187;-block, i m\u00e5l-listor, aggregatuttryck och vissa interna operationer;\n<li class=\"l\"> Prestanda f\u00f6r indexering har \u00f6kat avsev\u00e4rt. B-tree-index \u00e4r optimerade f\u00f6r att fungera under f\u00f6rh\u00e5llanden med frekventa f\u00f6r\u00e4ndringar av indexen &#8212; tester av TPC-C visar en allm\u00e4n prestanda\u00f6kning och en minskning av diskutrymmesf\u00f6rbrukningen med i genomsnitt 40%. \u00d6verheaden vid generering av Write Ahead Logging (WAL) har minskat f\u00f6r typerna av index GiST, GIN och SP-GiST. F\u00f6r GiST har m\u00f6jligheten att skapa omslagsindex (genom uttryck INCLUDE) lagts till, vilket inkluderar ytterligare kolumner. I operationen <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/sql-createstatistics.html\">CREATE STATISTICS<\/a><\/noindex> har st\u00f6d f\u00f6r statistik om de mest typiska v\u00e4rdena (MCV) lagts till, vilket m\u00f6jligg\u00f6r generation av mer optimala fr\u00e5geplaner vid anv\u00e4ndning av oj\u00e4mt f\u00f6rdelade kolumner;\n<li class=\"l\"> Implementeringen av partitionering har optimerats f\u00f6r f\u00f6rfr\u00e5gningar som omfattar tabeller med tusentals sektioner, men som begr\u00e4nsar sig till att v\u00e4lja en begr\u00e4nsad m\u00e4ngd data. Prestandan f\u00f6r att l\u00e4gga till data i partitionerade tabeller har \u00f6kat genom operationer som INSERT och COPY, och m\u00f6jligheten att l\u00e4gga till nya sektioner via &#171;ALTER TABLE ATTACH PARTITION&#187; har s\u00e4kerst\u00e4llts utan att blockera utf\u00f6randet av f\u00f6rfr\u00e5gningar;\n<li class=\"l\"> St\u00f6d f\u00f6r automatisk inline-utveckling av generella tabelluttryck (<noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/queries-with.html\">Common Table Expression<\/a><\/noindex>, CTE) har lagts till, vilket m\u00f6jligg\u00f6r anv\u00e4ndning av tempor\u00e4ra namngivna resultatsatser som definieras med hj\u00e4lp av kommandot WITH. Inline-utveckling \u00f6kar prestandan hos de flesta fr\u00e5gor, men till\u00e4mpas f\u00f6r n\u00e4rvarande endast f\u00f6r icke-rekursiva CTE;\n<li class=\"l\"> St\u00f6d f\u00f6r <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/collation.html#COLLATION-NONDETERMINISTIC\">icke-deterministiska<\/a><\/noindex> lokalens egenskaper &#171;Collation&#187;, vilket g\u00f6r det m\u00f6jligt att ange regler f\u00f6r sortering och metoder f\u00f6r matchning med h\u00e4nsyn till betydelsen av tecken (till exempel, vid sortering av numeriska v\u00e4rden beaktas n\u00e4rvaron av minus och punkt f\u00f6re numret och olika s\u00e4tt att skriva, medan j\u00e4mf\u00f6relse inte tar h\u00e4nsyn till teckenstorlek och f\u00f6rekomsten av accenttecken);\n<li class=\"l\"> St\u00f6d f\u00f6r flerfaktorsautentisering av klient har lagts till, d\u00e4r autentisering i pg_hba.conf kan kombinera autentisering med SSL-certifikat (clientcert=verify-full) med en ytterligare autentiseringsmetod, s\u00e5som scram-sha-256;\n<li class=\"l\"> St\u00f6d f\u00f6r kryptering av kommunikationskanalen vid autentisering via <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/gssapi-auth.html\">GSSAPI<\/a><\/noindex>, b\u00e5de p\u00e5 klientsidan och serversidan;\n<li class=\"l\"> St\u00f6d f\u00f6r att definiera LDAP-servrar baserat p\u00e5 &#171;DNS SRV&#187;-poster har lagts till, om PostgreSQL har kompilerats med OpenLDAP;\n<li class=\"l\"> En operation &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/sql-reindex.html#SQL-REINDEX-CONCURRENTLY\">REINDEX CONCURRENTLY<\/a><\/noindex>\u00bb f\u00f6r att omstrukturera index utan att blockera skrivoperationer till indexet;\n<li class=\"l\"> En ny kommando har lagts till <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/app-pgchecksums.html\">pg_checksums<\/a><\/noindex>, som g\u00f6r det m\u00f6jligt att sl\u00e5 p\u00e5 och av kontrollsumma-checken f\u00f6r data sidor f\u00f6r en befintlig databas (denna operation st\u00f6ddes tidigare endast under initialiseringen av databasen);\n<li class=\"l\"> Uppvisande av en progressindikator f\u00f6r operationer som CREATE INDEX, REINDEX, CLUSTER, VACUUM FULL och pg_checksums har s\u00e4kerst\u00e4llts;\n<li class=\"l\"> Ett nytt kommando har lagts till \u00ab<noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/tableam.html\">CREATE ACCESS METHOD<\/a><\/noindex>\u00bb f\u00f6r att ansluta till hanterare f\u00f6r nya lagringsmetoder f\u00f6r tabeller, optimerade f\u00f6r olika specifika uppgifter. F\u00f6r n\u00e4rvarande \u00e4r den enda inbyggda \u00e5tkomstmetoden f\u00f6r tabeller \u00abheap\u00bb;\n<li class=\"l\"> Konfigurationsfilen recovery.conf har slagits samman med postgresql.conf. Som indikatorer f\u00f6r att g\u00e5 in i \u00e5terst\u00e4llningsl\u00e4ge efter en krasch anv\u00e4nds nu <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/12\/runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVE-RECOVERY\">man<\/a><\/noindex> filerna recovery.signal och standby.signal.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>K\u00e4lla: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=51604\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 12. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0443\u0442 \u0432\u044b\u0445\u043e\u0434\u0438\u0442\u044c \u0432 \u0442\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u044f\u0442\u0438 \u043b\u0435\u0442 \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2024 \u0433\u043e\u0434\u0430. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043d\u043e\u0432\u0448\u0435\u0441\u0442\u0432\u0430: \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 &#171;\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u043c\u044b\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432&#171;, \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0432\u044b\u0447\u0438\u0441\u043b\u044f\u0435\u0442\u0441\u044f \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f, \u043e\u0445\u0432\u0430\u0442\u044b\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0434\u0440\u0443\u0433\u0438\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0432 \u0442\u043e\u0439 \u0436\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 (\u0430\u043d\u0430\u043b\u043e\u0433 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u0439, \u043d\u043e \u0434\u043b\u044f \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432). \u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u043c\u044b\u0435 \u0441\u0442\u043e\u043b\u0431\u0446\u044b \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c \u0434\u0432\u0443\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-38636","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 12.\" \/>\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\/reliz-subd-postgresql-12\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\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\udd47\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 PostgreSQL 12 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 12.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-postgresql-12\" \/>\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=\"2019-10-31T19:24:58+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:24:58+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\udd47Lansering av databashanteringssystemet PostgreSQL 12 | ProHoster","description":"Efter ett \u00e5rs utveckling har en ny stabil version av databashanteringssystemet PostgreSQL 12 publicerats.","canonical_url":"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-postgresql-12","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\udd47\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 PostgreSQL 12 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 12.","og:url":"https:\/\/prohoster.info\/sv\/blog\/news\/reliz-subd-postgresql-12","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":"2019-10-31T19:24:58+00:00","article:modified_time":"2019-10-31T19:24:58+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"38636","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":"2026-01-23 22:52:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:06:23","updated":"2026-01-23 22:52: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\/38636","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=38636"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/38636\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=38636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=38636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=38636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}