{"id":105303,"date":"2022-10-13T21:36:41","date_gmt":"2022-10-13T19:36:41","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-postgresql-15"},"modified":"2022-10-13T21:36:41","modified_gmt":"2022-10-13T19:36:41","slug":"reliz-subd-postgresql-15","status":"publish","type":"post","link":"https:\/\/prohoster.info\/pt\/blog\/news\/reliz-subd-postgresql-15","title":{"rendered":"Lan\u00e7amento do SGBD PostgreSQL 15","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Ap\u00f3s um ano de desenvolvimento, uma nova ramifica\u00e7\u00e3o est\u00e1vel do SGBD PostgreSQL 15 foi lan\u00e7ada. Atualiza\u00e7\u00f5es para a nova ramifica\u00e7\u00e3o ser\u00e3o lan\u00e7adas ao longo de cinco anos at\u00e9 novembro de 2027.     <\/p>\n<p>Principais novidades:  <\/p>\n<ul>\n<li class=\"l\"> Foi adicionada a suporte ao comando SQL \u00abMERGE\u00bb, semelhante \u00e0 express\u00e3o \u00abINSERT \u2026 ON CONFLICT\u00bb. O MERGE permite criar express\u00f5es SQL condicionais que combinam em uma \u00fanica express\u00e3o as opera\u00e7\u00f5es INSERT, UPDATE e DELETE. Por exemplo, com o MERGE \u00e9 poss\u00edvel realizar a fus\u00e3o de duas tabelas, inserindo registros faltantes e atualizando os existentes. MERGE INTO customer_account ca USING recent_transactions t ON t.customer_id = ca.customer_id WHEN MATCHED THEN UPDATE SET balance = balance + transaction_value WHEN NOT MATCHED THEN INSERT (customer_id, balance) VALUES (t.customer_id, t.transaction_value);\n<li class=\"l\"> Os algoritmos de ordena\u00e7\u00e3o de dados em mem\u00f3ria e em disco foram significativamente aprimorados. Dependendo do tipo de dados, os testes mostram um aumento na velocidade de ordena\u00e7\u00e3o de 25% a 400%.\n<li class=\"l\"> A execu\u00e7\u00e3o das fun\u00e7\u00f5es de janela utilizando row_number(), rank(), dense_rank() e count() foi acelerada.\n<li class=\"l\"> Implementada a possibilidade de execu\u00e7\u00e3o paralela de consultas com a express\u00e3o \u00abSELECT DISTINCT\u00bb.\n<li class=\"l\"> No mecanismo de conex\u00e3o a tabelas externas Foreign Data Wrapper (postgres_fdw), foi implementado suporte a commits ass\u00edncronos al\u00e9m da funcionalidade de processamento ass\u00edncrono de consultas a servidores externos j\u00e1 adicionada anteriormente.\n<li class=\"l\"> Adicionada a capacidade de aplicar os algoritmos LZ4 e Zstandard (zstd) para compress\u00e3o de logs WAL de transa\u00e7\u00f5es, o que, em certas cargas, permite aumentar o desempenho e economizar espa\u00e7o em disco. Para reduzir o tempo de recupera\u00e7\u00e3o ap\u00f3s falhas, foi adicionado suporte para a extra\u00e7\u00e3o antecipada de p\u00e1ginas mencionadas no log WAL.\n<li class=\"l\"> Na ferramenta pg_basebackup, foi adicionada a suporte para compress\u00e3o de arquivos de backup no lado do servidor, utilizando m\u00e9todos gzip, LZ4 ou zstd. Foi fornecida a possibilidade de usar m\u00f3dulos pr\u00f3prios para arquivamento, evitando a necessidade de executar comandos shell. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/pt\/server\/dts-los-angeles\/\"   title=\"servidor\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3862\">servidor<\/a>Adicionada uma s\u00e9rie de novas fun\u00e7\u00f5es para manipula\u00e7\u00e3o de strings usando express\u00f5es regulares: regexp_count(), regexp_instr(), regexp_like() e regexp_substr().\n<li class=\"l\"> Na fun\u00e7\u00e3o range_agg(), foi adicionada a capacidade de agregar tipos multidiapas\u00f3nicos (\"multirange\").\n<li class=\"l\"> Na fun\u00e7\u00e3o range_agg() foi adicionada a possibilidade de agregar tipos de m\u00faltiplos intervalos (\u00abmultirange\u00bb).\n<li class=\"l\"> Foi introduzido o modo security_invoker, permitindo a cria\u00e7\u00e3o de vis\u00f5es executadas com os direitos do usu\u00e1rio que invoca, e n\u00e3o do criador da vis\u00e3o.\n<li class=\"l\"> A replica\u00e7\u00e3o l\u00f3gica agora suporta a filtragem de linhas e a defini\u00e7\u00e3o de listas de colunas, permitindo ao remetente selecionar um subconjunto de dados da tabela para replica\u00e7\u00e3o. Al\u00e9m disso, na nova vers\u00e3o, a gest\u00e3o de conflitos foi simplificada, por exemplo, agora \u00e9 poss\u00edvel ignorar transa\u00e7\u00f5es conflitantes e desativar automaticamente a assinatura ao detectar um erro. A replica\u00e7\u00e3o l\u00f3gica agora permite o uso de commits de duas fases (2PC).\n<li class=\"l\"> Adicionado um novo formato de log \u2014 jsonlog, que armazena informa\u00e7\u00f5es de forma estruturada, utilizando o formato JSON.\n<li class=\"l\"> O administrador agora pode delegar a usu\u00e1rios permiss\u00f5es espec\u00edficas para alterar certos par\u00e2metros. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/pt\/server\/\"   title=\"configura\u00e7\u00f5es do servidor\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"999\">configura\u00e7\u00f5es do servidor<\/a> PostgreSQL.\n<li class=\"l\"> Na utilidade psql foi adicionado suporte \u00e0 pesquisa de informa\u00e7\u00f5es sobre configura\u00e7\u00f5es (pg_settings) atrav\u00e9s do comando \u00ab\\dconfig\u00bb.\n<li class=\"l\"> Implementado o uso de mem\u00f3ria compartilhada para acumula\u00e7\u00e3o de estat\u00edsticas do servidor, eliminando a necessidade de um processo separado para coleta de estat\u00edsticas e descarregamento peri\u00f3dico para o disco.\n<li class=\"l\">  Foi disponibilizada a possibilidade de uso padr\u00e3o das localiza\u00e7\u00f5es ICU \u00abICU Collation\u00bb, anteriormente como local padr\u00e3o s\u00f3 era poss\u00edvel utilizar localiza\u00e7\u00f5es libc.\n<li class=\"l\"> Foi introduzida a extens\u00e3o integrada pg_walinspect, que permite inspecionar o conte\u00fado de arquivos de logs WAL usando consultas SQL.\n<li class=\"l\"> Para o esquema public, as permiss\u00f5es para executar o comando CREATE foram revogadas de todos os usu\u00e1rios, exceto o propriet\u00e1rio do BD.\n<li class=\"l\"> No PL\/Python foi removido o suporte ao Python 2. O modo exclusivo de backup obsoleto (\u00abexclusive backup\u00bb) foi eliminado.    <\/ul>\n<p>Acrescentando: Das 19:00 \u00e0s 20:00 (MSK) haver\u00e1 um webinar para discutir as mudan\u00e7as da nova vers\u00e3o com Pavel Luzanov (Postgres Professional). Para aqueles que n\u00e3o puderem se juntar \u00e0 transmiss\u00e3o ao vivo, est\u00e1 dispon\u00edvel a grava\u00e7\u00e3o da palestra de junho de Pavel \u00abPostgreSQL 15: MERGE e muito mais\u00bb no PGConf.Russia.<br \/>\n<br \/>Fonte: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=57914\">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 15. \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 2027 \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 SQL-\u043a\u043e\u043c\u0430\u043d\u0434\u044b &#171;MERGE&#187;, \u043d\u0430\u043f\u043e\u043c\u0438\u043d\u0430\u044e\u0449\u0435\u0439 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435 &#171;INSERT &#8230; ON CONFLICT&#187;. MERGE \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0443\u0441\u043b\u043e\u0432\u043d\u044b\u0435 SQL-\u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f, \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u044f\u044e\u0449\u0438\u0435 \u0432 \u043e\u0434\u043d\u043e\u043c \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 INSERT, UPDATE \u0438 DELETE. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 MERGE \u043c\u043e\u0436\u043d\u043e [&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-105303","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - 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 15. \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 2027 \u0433\u043e\u0434\u0430.\" \/>\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\/pt\/blog\/news\/reliz-subd-postgresql-15\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_PT\" \/>\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 15 | 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 15. \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 2027 \u0433\u043e\u0434\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/pt\/blog\/news\/reliz-subd-postgresql-15\" \/>\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=\"2022-10-13T19:36:41+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-10-13T19:36:41+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\udd47Lan\u00e7amento do sistema gerenciador de banco de dados PostgreSQL 15 | ProHoster","description":"Ap\u00f3s um ano de desenvolvimento, uma nova vers\u00e3o est\u00e1vel do sistema gerenciador de banco de dados PostgreSQL 15 foi lan\u00e7ada. Atualiza\u00e7\u00f5es para esta nova vers\u00e3o ser\u00e3o lan\u00e7adas ao longo de cinco anos, at\u00e9 novembro de 2027.","canonical_url":"https:\/\/prohoster.info\/pt\/blog\/news\/reliz-subd-postgresql-15","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pt_PT","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 15 | 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 15. \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 2027 \u0433\u043e\u0434\u0430.","og:url":"https:\/\/prohoster.info\/pt\/blog\/news\/reliz-subd-postgresql-15","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-10-13T19:36:41+00:00","article:modified_time":"2022-10-13T19:36:41+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"105303","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":"2026-02-08 21:30:13","updated":"2026-02-22 15:31:03","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/105303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/comments?post=105303"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/105303\/revisions"}],"predecessor-version":[{"id":162390,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/105303\/revisions\/162390"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=105303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=105303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=105303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}