PostgreSQL Global Development Group于2026年11月19日正式发布了数据库系统的新版本PostgreSQL 19 1。此次更新引入了用于回收磁盘空间和重组表内容的新型REPACK命令,该命令支持CONCURRENTLY选项以避免阻塞读写操作 1。在查询规划方面,新增的pg_plan_advice扩展允许控制查询规划器决策,配套的pg_stash_advice扩展则能自动应用这些规划建议 1。
性能与架构层面的改进还包括逻辑复制功能的增强,当wal_level设置为replica时,无需重启服务器即可启用逻辑复制,且现在支持序列值的逻辑复制 1。为提升一致性保障,新版本通过WAIT命令在备用服务器上实现了“读己之写”一致性 1。此外,自动化维护任务也得到优化,支持表索引的并行autovacuum,并引入基于评分系统的优先级排序机制 1。
兼容性变更方面,PostgreSQL 19移除了RADIUS支持,强制standard_conforming_strings参数始终设为on,并将默认max_locks_per_transaction值从64调整为128,同时默认禁用了JIT编译 1。安全层面,针对MD5密码认证发出警告(此前已在PG18中弃用),并增加了password_expiration_warning_threshold变量 1。其他新功能包括支持OAuth验证器的自定义认证选项、恢复对AIX平台的支持,以及COPY FROM命令支持多行头部跳过和JSON输出格式 1。数据迁移必须使用pg_dumpall、pg_upgrade或逻辑复制进行 1。
The PostgreSQL Global Development Group officially released version 19 of its database system on November 19, 2026 1. This update introduces significant architectural improvements, including a new REPACK command designed to reclaim disk space and reorganize table contents without blocking read-write operations when used with the CONCURRENTLY option 1. The release also enhances logical replication capabilities, allowing it to be enabled without restarting the server if the wal_level is set to replica, and adds support for replicating sequence values 1. Additionally, two new extensions have been added: pg_plan_advice for controlling query planner decisions and pg_stash_advice for automatically applying planning recommendations 1.
Operational consistency and maintenance automation have also been strengthened in this version. A new WAIT command now supports "read-your-writes" consistency on standby servers, while parallel autovacuum for table indexes has been introduced alongside a scoring-based priority system 1. However, the release includes several breaking compatibility changes that administrators must address: RADIUS support has been removed, JIT compilation is disabled by default, and standard_conforming_strings are now forced to always be 'on' 1. Furthermore, the default value for max_locks_per_transaction has increased from 64 to 128, and data migration requires the use of pg_dumpall, pg_upgrade, or logical replication 1. Security enhancements include warnings for MD5 password authentication, which was deprecated in version 18, and the introduction of a new variable, password_expiration_warning_threshold, to control password expiration warning thresholds 1. Other notable additions include custom OAuth validator options, restored AIX platform support, and expanded COPY FROM functionality for multi-line header skipping and JSON output formats 1.
评论
还没有评论,欢迎留下第一条。