{"id":184329,"date":"2026-11-20T03:36:27","date_gmt":"2026-11-20T01:36:27","guid":{"rendered":"https:\/\/prohoster.info\/blog\/news\/reliz-subd-postgresql-19"},"modified":"2026-11-20T03:36:30","modified_gmt":"2026-11-20T01:36:30","slug":"postgresql-19-released","status":"publish","type":"post","link":"https:\/\/prohoster.info\/pt\/blog\/news\/postgresql-19-released","title":{"rendered":"Lan\u00e7amento do SGBD PostgreSQL 19","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Ap\u00f3s um ano de desenvolvimento, uma nova vers\u00e3o est\u00e1vel do sistema de gerenciamento de banco de dados PostgreSQL 19 foi lan\u00e7ada. Atualiza\u00e7\u00f5es para esta nova vers\u00e3o ser\u00e3o disponibilizadas ao longo de cinco anos, at\u00e9 novembro de 2031. O suporte para PostgreSQL 14.x, a vers\u00e3o mais antiga ainda suportada, foi encerrado este m\u00eas. O lan\u00e7amento foi publicado quase dois meses depois da data originalmente planejada devido a um fluxo at\u00edpico de relat\u00f3rios de bugs, identificados atrav\u00e9s da an\u00e1lise de c\u00f3digo com ferramentas de IA.       <\/p>\n<p>Principais novidades:     <\/p>\n<ul>\n<li class=\"l\"> A implementa\u00e7\u00e3o do subsistema de entrada\/sa\u00edda ass\u00edncrona foi aprimorada, permitindo aumentar a largura de banda de entrada\/sa\u00edda e eliminar lat\u00eancias. Na implementa\u00e7\u00e3o universal de AIO (io_method=worker), foi adicionada a capacidade de aumentar ou reduzir automaticamente o n\u00famero de processos manipuladores de entrada\/sa\u00edda em fun\u00e7\u00e3o da carga. Foram propostos par\u00e2metros para definir o n\u00famero m\u00ednimo e m\u00e1ximo de processos manipuladores, bem como o tempo limite de inatividade antes de encerrar e o intervalo de atraso antes do in\u00edcio dos processos: io_min_workers, io_max_workers, io_worker_idle_timeout e io_worker_launch_interval.\n<p>Al\u00e9m disso, o planejador de leitura antecipada aplicado no AIO \u00e9 otimizado para melhorar o desempenho de consultas que requerem o carregamento de grandes volumes de dados do disco. A otimiza\u00e7\u00e3o \u00e9 realizada por meio da defini\u00e7\u00e3o adaptativa do n\u00famero aceit\u00e1vel de opera\u00e7\u00f5es de leitura antecipada, dependendo da natureza e do tamanho da consulta (por exemplo, para opera\u00e7\u00f5es de varredura em grandes tabelas e \u00edndices, agora mais dados s\u00e3o carregados do disco com anteced\u00eancia). Para analisar a execu\u00e7\u00e3o de opera\u00e7\u00f5es de entrada\/sa\u00edda em modo ass\u00edncrono, a comanda 'EXPLAIN ANALYZE' recebeu a op\u00e7\u00e3o 'IO'.      <\/p>\n<li class=\"l\"> Foram adicionadas as extens\u00f5es pg_plan_advice e pg_stash_advice para passar ao planejador de consultas par\u00e2metros de dica na mini-linguagem 'plan advice', permitindo influenciar a escolha dos planos de execu\u00e7\u00e3o, fixar planos escolhidos e experimentar com diferentes planos. Para obter uma lista de par\u00e2metros selecionados pelo planejador ao executar a consulta, a comanda EXPLAIN recebeu a op\u00e7\u00e3o 'PLAN_ADVICE', e para definir seus pr\u00f3prios par\u00e2metros antes da execu\u00e7\u00e3o da consulta, pode-se usar a express\u00e3o 'SET pg_plan_advice.advice = 'string com a lista de par\u00e2metros''. A extens\u00e3o pg_stash_advice complementa o pg_plan_advice com capacidades para vincular par\u00e2metros a identificadores de consultas, evitando a necessidade de adicion\u00e1-los antes de cada consulta. EXPLAIN (COSTS OFF, PLAN_ADVICE) SELECT * FROM join_fact f JOIN join_dim d ON f.dim_id = d.id; ... Gerado Planejamento de Dicas: JOIN_ORDER(f d) HASH_JOIN(d) SEQ_SCAN(f d) NO_GATHER(f d) SET pg_plan_advice.advice = 'JOIN_ORDER(f d) NO_GATHER(f d)';\n<li class=\"l\"> O processo de ativa\u00e7\u00e3o autom\u00e1tica da limpeza (autovacuum) agora permite o uso paralelo de v\u00e1rios manipuladores durante a limpeza de \u00edndices. O n\u00famero de manipuladores pode ser configurado pela op\u00e7\u00e3o autovacuum_max_parallel_workers. Novas op\u00e7\u00f5es autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight e autovacuum_analyze_score_weight foram adicionadas para determinar a prioridade da limpeza das tabelas.\n<li class=\"l\"> Uma nova estrat\u00e9gia de limpeza foi implementada, permitindo reduzir a carga de trabalho futura, ao atualizar o mapa de visibilidade das p\u00e1ginas durante a varredura das tabelas ao executar consultas SELECT, sem esperar pela execu\u00e7\u00e3o do comando VACUUM.\n<li class=\"l\"> Foi adicionada um novo comando SQL 'REPACK' para reconstruir tabelas com menos sobrecarga. O comando REPACK reescreve completamente todo o conte\u00fado da tabela em um novo arquivo no disco, permitindo ao sistema operacional recuperar espa\u00e7o em disco ocupado por blocos n\u00e3o utilizados. Ao contr\u00e1rio do comando 'VACUUM FULL', que imp\u00f5e um bloqueio r\u00edgido durante a reescrita, o comando REPACK tem a op\u00e7\u00e3o 'CONCURRENTLY', que permite que a tabela seja utilizada por outras transa\u00e7\u00f5es durante a reempacotagem. Diferente da extens\u00e3o pg_repack, o REPACK \u00e9 significativamente mais r\u00e1pido, pois n\u00e3o anexa gatilhos adicionais \u00e0 tabela, mas n\u00e3o suporta o processamento de tabelas totalmente particionadas.\n<li class=\"l\"> A performance boost of up to two times for INSERT operations on tables where records are checked by foreign keys (Foreign Key). The acceleration is achieved by utilizing the index for verifying foreign keys, which eliminates the need for a resource-intensive internal query to the table.\n<li class=\"l\"> No planejador de consultas, foi implementado o reconhecimento de opera\u00e7\u00f5es Anti-Join (determina\u00e7\u00e3o de linhas da primeira tabela para as quais n\u00e3o existem correspond\u00eancias na segunda tabela) em consultas complexas com &#171;LEFT JOIN&#187; e consultas com express\u00f5es &#171;NOT IN&#187; para ativar otimiza\u00e7\u00f5es espec\u00edficas. A aplica\u00e7\u00e3o da ordena\u00e7\u00e3o incremental foi ampliada. Foi adicionada a otimiza\u00e7\u00e3o &#171;eager aggregation&#187;, que realiza opera\u00e7\u00f5es de agrega\u00e7\u00e3o na fase anterior \u00e0 fus\u00e3o das tabelas para reduzir o n\u00famero de linhas processadas durante a fus\u00e3o. A execu\u00e7\u00e3o paralela de opera\u00e7\u00f5es de varredura sequencial foi acelerada (parallel seq scan). Foram implementadas as transforma\u00e7\u00f5es das constru\u00e7\u00f5es &#171;IS DISTINCT FROM&#187; e &#171;IS NOT DISTINCT FROM&#187; para express\u00f5es com os operadores &#171;&lt;&gt;&#187; e &#171;=&#187;, se ambos os operandos n\u00e3o puderem aceitar o valor NULL.\n<li class=\"l\"> The efficiency of notification delivery has been improved using the NOTIFY command in multi-channel notification configurations. A map of channels is now stored in shared memory, allowing targeted access only to backends subscribed to a given channel.\n<li class=\"l\"> No comando &#171;INSERT&#187;, foi adicionada a suporte \u00e0 express\u00e3o ON CONFLICT DO SELECT &#8230; RETURNING, que retorna registros caso n\u00e3o seja poss\u00edvel adicion\u00e1-los via &#171;INSERT&#187;, al\u00e9m das express\u00f5es &#171;ON CONFLICT DO NOTHING\/UPDATE&#187;, que ignoram silenciosamente conflitos durante a inser\u00e7\u00e3o ou realizam atualiza\u00e7\u00f5es em vez de inser\u00e7\u00f5es.\n<li class=\"l\"> Support for outputting data in JSON format has been added to the COPY command.\n<li class=\"l\"> The SQL\/JSON language has gained string handling methods lower(), upper(), replace(), split_part(), and btrim().\n<li class=\"l\"> Nas fun\u00e7\u00f5es de janela lead(), lag(), first_value(), last_value() e nth_value(), foi adicionada a suporte da express\u00e3o &#171;IGNORE NULLS&#187; para pular valores NULL.\n<li class=\"l\"> Foi adicionada o comando &#171;WAIT FOR LSN&#187;, que na replica\u00e7\u00e3o ass\u00edncrona permite pausar uma consulta SELECT no servidor replicado para evitar a sa\u00edda de dados desatualizados at\u00e9 que as mudan\u00e7as do servidor principal sejam aplicadas. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/pt\/server\/dts-los-angeles\/\"   title=\"servidor\" data-wpil-keyword-link=\"linked\">servidor<\/a>, corresponding to a specific LSN position (Log Sequence Number) in the WAL log.\n<li class=\"l\"> A fun\u00e7\u00e3o random() agora suporta os tipos date e timestamp para a gera\u00e7\u00e3o de datas e horas aleat\u00f3rias dentro de um intervalo definido.\n<li class=\"l\"> Adicionada a possibilidade de criar fun\u00e7\u00f5es em PL\/Python para gatilhos de eventos (event trigger).\n<li class=\"l\"> Suporte adicionado para conex\u00f5es de rede. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/pt\/server\/\"   title=\"servidor\" data-wpil-keyword-link=\"linked\">servidor<\/a> Adicionada a compatibilidade com a extens\u00e3o TLS SNI (Server Name Indication) para a utiliza\u00e7\u00e3o de certificados TLS vinculados aos nomes de host acessados pelo cliente ao estabelecer uma conex\u00e3o criptografada usando um \u00fanico endere\u00e7o IP.\n<li class=\"l\"> Um novo par\u00e2metro password_expiration_warning_threshold foi adicionado ao arquivo de configura\u00e7\u00e3o postgresql.conf, permitindo configurar um aviso sobre a proximidade da expira\u00e7\u00e3o da senha.\n<li class=\"l\"> A exibi\u00e7\u00e3o de avisos ao usar o algoritmo MD5 na autentica\u00e7\u00e3o, que est\u00e1 obsoleto, agora est\u00e1 ativada por padr\u00e3o. O par\u00e2metro md5_password_warnings foi adicionado para desativar esses avisos.\n<li class=\"l\"> Foram adicionadas as vis\u00f5es: &#171;pg_stat_lock&#187; para visualizar estat\u00edsticas acumuladas sobre bloqueios relacionadas aos tipos de bloqueios; &#171;pg_stat_recovery&#187; para obter informa\u00e7\u00f5es sobre o estado das opera\u00e7\u00f5es de recupera\u00e7\u00e3o; &#171;pg_stat_autovacuum_scores&#187; para determinar a prioridade do processamento de tabelas no autovacuum. Uma coluna &#171;stats_reset&#187; foi adicionada em muitas vis\u00f5es do sistema, refletindo o \u00faltimo hor\u00e1rio de limpeza dos contadores. Na vis\u00e3o &#171;pg_stat_progress_vacuum&#187; e na &#171;pg_stat_progress_analyze&#187;, uma coluna &#171;started_by&#187; foi acrescentada, mostrando o iniciador da opera\u00e7\u00e3o. Na vis\u00e3o pg_stat_progress_vacuum foi adicionada uma coluna &#171;mode&#187;, refletindo o modo de limpeza aplicado.\n<li class=\"l\"> Adicionada a capacidade de definir n\u00edveis m\u00ednimos de criticidade das mensagens de log (log_min_messages) relacionados aos tipos de processos.\n<li class=\"l\"> Na estat\u00edstica exibida ap\u00f3s as opera\u00e7\u00f5es VACUUM e ANALYZE, bem como na visualiza\u00e7\u00e3o &#171;pg_stat_wal&#187;, foram adicionadas informa\u00e7\u00f5es sobre o tamanho das p\u00e1ginas completas gravadas no log WAL, o que facilita a an\u00e1lise das causas do crescimento excessivo do log WAL (\u00e9 poss\u00edvel entender se o aumento est\u00e1 relacionado ao uso do par\u00e2metro full_page_writes).\n<li class=\"l\"> O mecanismo de replica\u00e7\u00e3o l\u00f3gica implementou suporte para replicar valores de sequ\u00eancias (SEQUENCE), que podem ser publicados com o comando &#171;CREATE PUBLICATION&#187; usando a express\u00e3o &#171;FOR ALL SEQUENCES&#187;.\n<li class=\"l\"> Adicionado a sintaxe &#171;CREATE PUBLICATION &#8230; EXCEPT&#187; para replica\u00e7\u00e3o de todas as tabelas, exceto as explicitamente indicadas.\n<li class=\"l\"> Adicionada a express\u00e3o &#171;CREATE SUBSCRIPTION &#8230; SERVER&#187;, permitindo criar assinaturas de replica\u00e7\u00e3o l\u00f3gica, obtendo configura\u00e7\u00f5es de conex\u00e3o de um servidor externo.\n<li class=\"l\"> Adicionada a possibilidade de habilitar a replica\u00e7\u00e3o l\u00f3gica a quente, sem reiniciar o servidor, mesmo que o par\u00e2metro &#171;wal_level&#187; esteja definido como &#171;replica&#187; em vez de &#171;logical&#187;. Para determinar o n\u00edvel efetivo de log, que n\u00e3o est\u00e1 ligado \u00e0 configura\u00e7\u00e3o wal_level no arquivo de configura\u00e7\u00e3o, foi adicionado o par\u00e2metro &#171;effective_wal_level&#187;.\n<li class=\"l\"> No mecanismo de conex\u00e3o de tabelas externas Foreign Data Wrapper (postgres_fdw), foram implementadas funcionalidades para passar opera\u00e7\u00f5es com arrays para o servidor remoto e foi adicionada a op\u00e7\u00e3o import_stats para importar estat\u00edsticas de tabelas de um servidor externo ao executar o comando ANALYZE, aumentando a efici\u00eancia do planejamento local da execu\u00e7\u00e3o de consultas.\n<li class=\"l\"> A compila\u00e7\u00e3o JIT est\u00e1 desabilitada por padr\u00e3o, pois o ganho de desempenho que ela proporciona \u00e9 principalmente para consultas anal\u00edticas pesadas, enquanto em cargas de trabalho OLTP comuns pode resultar em quedas de desempenho devido a falhas na previs\u00e3o dos recursos necess\u00e1rios para a execu\u00e7\u00e3o das consultas.\n<li class=\"l\">  Para aumentar o desempenho da compress\u00e3o e descompress\u00e3o de tabelas TOAST, o par\u00e2metro &#171;default_toast_compression&#187; foi definido como &#171;lz4&#187;.\n<li class=\"l\"> O suporte \u00e0 autentica\u00e7\u00e3o usando o protocolo RADIUS foi removido.\n<li class=\"l\"> No comando &#171;vacuumdb &#8212;analyze-only&#187;, a an\u00e1lise de tabelas particionadas \u00e9 habilitada por padr\u00e3o.<\/ul>\n<p>Devido a problemas identificados na fase final de testes, algumas funcionalidades apresentadas na vers\u00e3o beta n\u00e3o foram inclu\u00eddas no lan\u00e7amento, como a sintaxe &#171;GROUP BY ALL&#187;, suporte a formatos de sa\u00edda n\u00e3o textuais no pg_dumpall, SQL\/PGQ para consultas em grafo, habilita\u00e7\u00e3o de suporte a somas de verifica\u00e7\u00e3o a quente sem reinicializa\u00e7\u00e3o e reatribui\u00e7\u00e3o, express\u00e3o &#171;FOR PORTION OF&#187; em UPDATE e DELETE, express\u00f5es &#171;ALTER TABLE &#8230; MERGE PARTITIONS&#187; e &#171;ALTER TABLE &#8230; SPLIT PARTITIONS&#187; para reorganiza\u00e7\u00e3o de tabelas particionadas, defini\u00e7\u00e3o de LC_COLLATE como &#171;C&#187; para o processo postmaster e novas fun\u00e7\u00f5es pg_get_role_ddl(), pg_get_tablespace_ddl() e pg_get_database_ddl(). O patrocinador da not\u00edcia \u00e9 a empresa Hi-Squared, desenvolvedora da plataforma Low Code XSQUARE baseada em PostgreSQL (publicidade, LLC &#171;Hi-Squared&#187;, INN 7718990614).<br \/>\n<br \/>Fonte: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=66693\">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 19. \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 2031 \u0433\u043e\u0434\u0430. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 PostgreSQL 14.x, \u0441\u0430\u043c\u043e\u0439 \u0441\u0442\u0430\u0440\u043e\u0439 \u0438\u0437 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a, \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0430 \u0432 \u044d\u0442\u043e\u043c \u043c\u0435\u0441\u044f\u0446\u0435. \u0420\u0435\u043b\u0438\u0437 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u043f\u043e\u0447\u0442\u0438 \u043d\u0430 \u0434\u0432\u0430 \u043c\u0435\u0441\u044f\u0446\u0430 \u043f\u043e\u0437\u0434\u043d\u0435\u0435 \u0438\u0437\u043d\u0430\u0447\u0430\u043b\u044c\u043d\u043e \u043d\u0430\u043c\u0435\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u0430\u0442\u044b \u0438\u0437-\u0437\u0430 \u043d\u0435\u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e \u043f\u0440\u043e\u0448\u043b\u044b\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u043c \u043f\u043e\u0442\u043e\u043a\u0430 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439 \u043e\u0431 \u043e\u0448\u0438\u0431\u043a\u0430\u0445, \u0432\u044b\u044f\u0432\u043b\u0435\u043d\u043d\u044b\u0445 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-184329","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=\"\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 19. \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 2031 \u0433\u043e\u0434\u0430.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Alexander Kovalev\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/pt\/blog\/news\/postgresql-19-released\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\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 19 | 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 19. \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 2031 \u0433\u043e\u0434\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/pt\/blog\/news\/postgresql-19-released\" \/>\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=\"2026-11-20T01:36:27+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-11-20T01:36:30+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Lan\u00e7amento do SGBD PostgreSQL 19 | ProHoster","description":"Ap\u00f3s um ano de desenvolvimento, foi publicada uma nova vers\u00e3o est\u00e1vel do SGBD PostgreSQL 19. Atualiza\u00e7\u00f5es para a nova vers\u00e3o ser\u00e3o lan\u00e7adas durante cinco anos, at\u00e9 novembro de 2031.","canonical_url":"https:\/\/prohoster.info\/pt\/blog\/news\/postgresql-19-released","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 19 | 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 19. \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 2031 \u0433\u043e\u0434\u0430.","og:url":"https:\/\/prohoster.info\/pt\/blog\/news\/postgresql-19-released","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":"2026-11-20T01:36:27+00:00","article:modified_time":"2026-11-20T01:36:30+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/184329","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/comments?post=184329"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/184329\/revisions"}],"predecessor-version":[{"id":184330,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/184329\/revisions\/184330"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=184329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=184329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=184329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}