2022年10月13日 · PostgreSQL 15 builds on the performance improvements of recent releases with noticeable gains for managing workloads in both local and distributed deployments, including improved sorting. This release improves the developer experience with the addition of the popular MERGE command, and adds more capabilities for observing the state of the database.

2025年2月13日 · This release contains a variety of fixes from 15.10. For information about new features in major release 15, see Section E.13.

使用 pg_dumpall 进行转储/恢复，或者使用 pg_upgrade 或逻辑复制来迁移数据，以便从任何之前的版本迁移数据。 参见 第 19.6 节 了解有关迁移到新主要版本的一般信息。

2023年11月9日 · 这个版本包含了从15.4版本中的各种修复。 有关主要版本15中新功能的信息，请参见 第 E.8 节。 E.3.1. 升级到版本15.5. 对于运行15.X版本的用户，不需要进行dump/restore操作。 然而，已经发现了几个错误，可能导致某些类型的索引产生错误的搜索结果或者效率低下。 建议在安装此更新后对可能受影响的索引进行 REINDEX。 请参阅下面的第四至第七个变更日志条目。 另外，如果您正在从早于15.4版本升级，请参见 第 E.4 节。 E.3.2. 变更. 这个错误导致一 …

Following CommitFests were for PostgreSQL 15 code submissions: Note that the March CommitFest generally stays open a few days beyond the official end date until feature freeze is announced, usually in early April. rc1 (REL_15_RC1) - commit 6abbd212 (2022-09-26); announcement (2022-09-29): PostgreSQL 15 RC 1 Released!

这里补充一点， 2023-11-09, PGDG 发布了 PG15 系列的最新版本 PostgreSQL 15.5，修复了 3 个安全漏洞和 55 个 bug，详情可参考 Release Notes. 从 yum 升级到 dnf 后，引入了新的模块化概念，我们可以通过配置 module 来覆盖 appstream 以获取软件包更新。 直接通过 dnf module install 安装 PG 15： Last metadata expiration check: 2:01:54 ago on Wed 22 Nov 2023 07:33:15 AM UTC. Dependencies resolved.

2025年2月20日 · PostgreSQL 15 contains many new features and enhancements, including: Support for the SQL MERGE command. Selective publication of tables' contents within logical replication publications, through the ability to specify column lists and row filter conditions. More options for compression, including support for Zstandard (zstd) compression.

The release notes contain the significant changes in each PostgreSQL release, with major features and migration issues listed at the top. The release notes do not contain changes that affect only a few users or changes that are internal and therefore not user-visible.

1. What Is PostgreSQL? 2. A Brief History of PostgreSQL. 3. Conventions. 4. Further Information. 5. Bug Reporting Guidelines. 1. Getting Started. 2. The SQL Language. 3. Advanced Features. II. The SQL Language. 4. SQL Syntax. 5. Data Definition. 6. Data Manipulation. 7. Queries. 8. Data Types. 9. Functions and Operators. 10. Type Conversion. 11.

2023年2月15日 · We are excited to announce PostgreSQL 15 is available in beta on Heroku, bringing a number of notable feature and performance improvements to our managed PostgreSQL database service. The beta provides customers who want to try out the new release an easy way to do so.