对于希望从任何先前版本迁移数据的用户，需要使用pg_dumpall进行导出/恢复，或使用pg_upgrade或逻辑复制。有关迁移到新主版本的一般信息，请参见第 18.6 节。
\n版本 13 包含许多可能影响与先前版本兼容性的变更。请注意以下不兼容性：
\n对于希望从任何先前版本迁移数据的用户，需要使用pg_dumpall进行导出/恢复，或使用pg_upgrade或逻辑复制。有关迁移到新主版本的一般信息，请参见第 18.6 节。
\n版本 13 包含许多可能影响与先前版本兼容性的变更。请注意以下不兼容性：
\n将 SIMILAR TO ... ESCAPE NULL 改为返回 NULL（Tom Lane）§
这一新行为符合 SQL 规范。以前，ESCAPE 为空值时，被解释为使用默认转义字符串（反斜杠字符）。这也适用于 substring(。通过保持原函数不变，在旧视图中保留了以前的行为。text FROM pattern ESCAPE text)
使 json[b]_to_tsvector() 完整检查其 string 选项的拼写（Dominik Czarnota）§
改变非默认的effective_io_concurrency值影响并发度的方式（Thomas Munro）§
\n以前，该值在用于设置并发请求数之前会经过调整。现在直接使用该值。可以通过以下方式将旧值转换为新值：
\nSELECT round(sum(", "text": "改变非默认的effective_io_concurrency值影响并发度的方式（Thomas Munro）§ 以前，该值在用于设置并发请求数之前会经过调整。现在直接使用该值。可以通过以下方式将旧值转换为新值： SELECT round(sum(OLDVALUE / n::float)) AS newvalue FROM generate_series(1, OLDVALUE) s(n);", "title": "改变非默认的effective_io_concurrency值影响并发度的方式", "commits": ["b09ff5366"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/13.0/#id-1.11.6.29.4", "source_hash": "887d98f1c5f3458eeca123ae4b8ef91d64967e790cff24b3841e20144be679d8", "section_path": ["兼容性"], "commit_groups": [["b09ff5366"]], "identity_text": "Change the way non-default guc-effective-io-concurrency values affect concurrency (Thomas Munro) Previously, this value was adjusted before setting the number of concurrent requests. The value is now used directly. Conversion of old values to new ones can be done using: SELECT round(sum(OLDVALUE / n::float)) AS newvalue FROM generate_series(1, OLDVALUE) s(n);", "commit_aliases": ["b09ff5366"], "source_commits": ["b09ff5366"], "source_entry_id": "13.0/migration/003", "db_id": "62eeb3605c46c2db1d264b35b8f0eb40", "patch_ids": ["09811ae59f6e55e41d6231afcb24cf3b"], "statement_hash": "86f867b4d46c0f6eb3c9078cc12c90da564979ed93bf6b5d74c99015dd62daf6", "relations": [], "version": "13.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-d3d1409eb3c66993", "cves": [], "html": "OLDVALUE/ n::float)) AS newvalue FROM generate_series(1,OLDVALUE) s(n);\n
不再在pg_stat_ssl和pg_stat_gssapi系统视图中显示辅助进程（Euler Taveira）§
\n如果查询将这些视图与pg_stat_activity连接，并希望看到辅助进程，就需要使用左连接。
", "text": "不再在pg_stat_ssl和pg_stat_gssapi系统视图中显示辅助进程（Euler Taveira）§ 如果查询将这些视图与pg_stat_activity连接，并希望看到辅助进程，就需要使用左连接。", "title": "不再在pg_stat_ssl和pg_stat_gssapi系统视图中显示辅助进程", "commits": ["5c46e7d82"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/13.0/#id-1.11.6.29.4", "source_hash": "f143a020e659d77b071b21ca82777b03a4905c81240c8b6733a7b3067f59a8ed", "section_path": ["兼容性"], "commit_groups": [["5c46e7d82"]], "identity_text": "Prevent display of auxiliary processes in pg-stat-ssl-view and pg-stat-gssapi-view system views (Euler Taveira) Queries that join these views to pg-stat-activity-view and wish to see auxiliary processes will need to use left joins.", "commit_aliases": ["5c46e7d82"], "source_commits": ["5c46e7d82"], "source_entry_id": "13.0/migration/004", "db_id": "9313d0f386baf2e63f4d460b3f905624", "patch_ids": ["96747b44433d92350891ffedfc74bea6"], "statement_hash": "c8cd602d26bb43a8b55cdedc086a5b8f103cbcfcc8b07d3afe9ad23f0f0d5648", "relations": [], "version": "13.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-300271e52a32d70f", "cves": [], "html": "重命名多种等待事件以提高一致性（Fujii Masao，Tom Lane）§ § § § §
", "text": "重命名多种等待事件以提高一致性（Fujii Masao，Tom Lane）§ § § § §", "title": "重命名多种等待事件以提高一致性", "commits": ["14a910109", "1d253bae5", "3048898e7", "36ac359d3", "474e7da64"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/13.0/#id-1.11.6.29.4", "source_hash": "71f0d0c1714b7dbcd63c7a1cf2b14a54dc09ff4fd9606d66064c5f930bcc8d5d", "section_path": ["兼容性"], "commit_groups": [["14a910109"], ["1d253bae5"], ["3048898e7"], ["36ac359d3"], ["474e7da64"]], "identity_text": "Rename various wait events to improve consistency (Fujii Masao, Tom Lane)", "commit_aliases": ["14a910109", "1d253bae5", "3048898e7", "36ac359d3", "474e7da64"], "source_commits": ["14a910109", "1d253bae5", "3048898e7", "36ac359d3", "474e7da64"], "source_entry_id": "13.0/migration/005", "db_id": "f1444cb151ee5ea496b7e4b3275b2b25", "patch_ids": ["195ace185d7f5b3a4da50890b98068c0", "243bd4fa4d8a5f651aab0f2ea7eb5404", "4217cca386c79401079c66baa5b24ded", "46cc2e60fc20da950850633e14c8925c", "c638cb4d385eefbf24b61f62574666cd"], "statement_hash": "34b21a81588e567c1ea58fc48e626cb5838521aea92107512b2f2c9d37de94ef", "relations": [], "version": "13.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-315c02f83f3e1e65-1", "cves": [], "html": "修复 ALTER FOREIGN TABLE ... RENAME COLUMN，使其返回更合适的命令标签（Fujii Masao）§
以前返回 ALTER TABLE；现在返回 ALTER FOREIGN TABLE。
修复 ALTER MATERIALIZED VIEW ... RENAME COLUMN，使其返回更合适的命令标签（Fujii Masao）§
以前返回 ALTER TABLE；现在返回 ALTER MATERIALIZED VIEW。
将配置参数 wal_keep_segments 重命名为wal_keep_size（Fujii Masao）§
这决定为备库保留多少 WAL。它以 MB 为单位指定，而旧参数以文件数量指定。如果以前使用 wal_keep_segments，以下公式可以得到大致等价的设置：
wal_keep_size = wal_keep_segments * wal_segment_size (typically 16MB)\n", "text": "将配置参数 wal_keep_segments 重命名为wal_keep_size（Fujii Masao）§ 这决定为备库保留多少 WAL。它以 MB 为单位指定，而旧参数以文件数量指定。如果以前使用 wal_keep_segments，以下公式可以得到大致等价的设置： wal_keep_size = wal_keep_segments * wal_segment_size (typically 16MB)", "title": "将配置参数 wal_keep_segments 重命名为wal_keep_size", "commits": ["f5dff45962"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/13.0/#id-1.11.6.29.4", "source_hash": "5247db2ac5fe00062643e042cf5fa48abbadabf2d713b848e51877e0a199da8e", "section_path": ["兼容性"], "commit_groups": [["f5dff45962"]], "identity_text": "Rename configuration parameter wal_keep_segments to guc-wal-keep-size (Fujii Masao) This determines how much WAL to retain for standby servers. It is specified in megabytes, rather than number of files as with the old parameter. If you previously used wal_keep_segments, the following formula will give you an approximately equivalent setting: wal_keep_size = wal_keep_segments * wal_segment_size (typically 16MB)", "commit_aliases": ["f5dff45962"], "source_commits": ["f5dff45962"], "source_entry_id": "13.0/migration/008", "db_id": "87d08c201e2ac67f6d62188bb16926b9", "patch_ids": ["fea7ca80079c4413db2f8830f6353864"], "statement_hash": "83a238007d82d98ff7e12463b63c4b4c41cfe26f20e00841e3f2a08a5010dab1", "relations": [], "version": "13.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-0deec1e0e7129d4b", "cves": [], "html": "
移除使用 PostgreSQL 8.0 之前的语法定义操作符类的支持（Daniel Gustafsson）§
", "text": "移除使用 PostgreSQL 8.0 之前的语法定义操作符类的支持（Daniel Gustafsson）§", "title": "移除使用 PostgreSQL 8.0 之前的语法定义操作符类的支持", "commits": ["84eca14bc"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/13.0/#id-1.11.6.29.4", "source_hash": "74187af3391ddc0fa17fd55f5a5429942075681f777a0a8aa884e76e0ac5255e", "section_path": ["兼容性"], "commit_groups": [["84eca14bc"]], "identity_text": "Remove support for defining operator classes using pre-PostgreSQL 8.0 syntax (Daniel Gustafsson)", "commit_aliases": ["84eca14bc"], "source_commits": ["84eca14bc"], "source_entry_id": "13.0/migration/009", "db_id": "00cdd4565943a99c71ac24dd72c69a5d", "patch_ids": ["462d626bf85e27e1ecf4e17d1b973712"], "statement_hash": "4d1c6b3a631af6a14564f453c23960f5730654034dcc77957fbe83be5df44ffb", "relations": [], "version": "13.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-181ce8a6cc7d16d5", "cves": [], "html": "移除使用 PostgreSQL 7.3 之前的语法定义外键约束的支持（Daniel Gustafsson）§
", "text": "移除使用 PostgreSQL 7.3 之前的语法定义外键约束的支持（Daniel Gustafsson）§", "title": "移除使用 PostgreSQL 7.3 之前的语法定义外键约束的支持", "commits": ["e58a59975"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/13.0/#id-1.11.6.29.4", "source_hash": "62c50582b07ca26907178805fd3733688c10bafc434eaeb087814b47ff5198bd", "section_path": ["兼容性"], "commit_groups": [["e58a59975"]], "identity_text": "Remove support for defining foreign key constraints using pre-PostgreSQL 7.3 syntax (Daniel Gustafsson)", "commit_aliases": ["e58a59975"], "source_commits": ["e58a59975"], "source_entry_id": "13.0/migration/010", "db_id": "a4731981520d809b1764f36804869b0f", "patch_ids": ["b01af42c52dd802bb31bd86bdef135c6"], "statement_hash": "d1988126fb6693abe4be81ca0189d490c9b271a8b56ba72b11a717bc61458ea2", "relations": [], "version": "13.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-a4c99539e3f91994", "cves": [], "html": "移除对 PostgreSQL 7.3 之前的服务器所使用的 \"opaque\" 伪类型的支持（Daniel Gustafsson）§
", "text": "移除对 PostgreSQL 7.3 之前的服务器所使用的 \"opaque\" 伪类型的支持（Daniel Gustafsson）§", "title": "移除对 PostgreSQL 7.3 之前的服务器所使用的 \"opaque\" 伪类型的支持", "commits": ["bb03010b9"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/13.0/#id-1.11.6.29.4", "source_hash": "62be98f085cfb7121765762115068cf66f6e71ff82615faf7b3aabfbf4026cd8", "section_path": ["兼容性"], "commit_groups": [["bb03010b9"]], "identity_text": "Remove support for \"opaque\" pseudo-types used by pre-PostgreSQL 7.3 servers (Daniel Gustafsson)", "commit_aliases": ["bb03010b9"], "source_commits": ["bb03010b9"], "source_entry_id": "13.0/migration/011", "db_id": "a17abaa2942f10365a93775b57760c98", "patch_ids": ["841feb81d4817adce792d43370b2b3a1"], "statement_hash": "6d8b1f94d19be6214cb12adaf11ef0b636519d57ceb8e6d43819cb6d5457a05b", "relations": [], "version": "13.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-e0e2f90b4addfeae", "cves": [], "html": "移除对升级未打包扩展（9.1 之前的扩展）的支持（Tom Lane）§
\nCREATE EXTENSION 不再支持 FROM 选项。任何仍使用未打包扩展的安装实例，都应在更新到 PostgreSQL 13 之前，将这些扩展升级为已打包的版本。
移除对时区数据库中 posixrules 文件的支持（Tom Lane）§
IANA 的时区工作组已弃用此特性，这意味着它将在未来几年中逐渐从系统的时区数据库中消失。为避免时区数据更新意外引发行为变化，我们从版本 13 开始移除了 PostgreSQL 对此特性的支持。这只影响缺少显式夏令时切换规则的 POSIX 风格时区指定的行为；以前可以通过安装自定义 posixrules 文件来确定切换规则，现在则使用硬编码规则。对于受影响的安装实例，建议改用地理时区名称。
在ltree中，当 lquery 模式包含相邻的带花括号星号时，例如 *{2}.*{3}，将其正确解释为 *{5}（Nikita Glukhov）§
修复pageinspect的 bt_metap()，使其返回更合适、不易溢出的数据类型（Peter Geoghegan）§
允许在更多情况下进行分区剪枝（Yuzuko Hosoya，Amit Langote，Álvaro Herrera）§ §
", "text": "允许在更多情况下进行分区剪枝（Yuzuko Hosoya，Amit Langote，Álvaro Herrera）§ §", "title": "允许在更多情况下进行分区剪枝", "commits": ["4e85642d9", "815ef2f56"], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.2", "source_hash": "64c3c2751270ec5e94aa97d9bdd63bf4965d68adef735cf6f469eecb0a903365", "section_path": ["服务器", "分区"], "commit_groups": [["4e85642d9"], ["815ef2f56"]], "identity_text": "Allow pruning of partitions to happen in more cases (Yuzuko Hosoya, Amit Langote, Álvaro Herrera)", "commit_aliases": ["4e85642d9", "815ef2f56"], "source_commits": ["4e85642d9", "815ef2f56"], "source_entry_id": "13.0/changes/001", "db_id": "1163eca048c7512a1194c404ff4a5d31", "patch_ids": ["8d707c3ed0d6ed27bbc2208ab0715fe4", "be2d57e2e5b19a51edc2d004e9edbae8"], "statement_hash": "80cae61bcf28137813bdf2ee17baac735061de0f672b9bc52d324b7dfd2e7bdd", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-a718c78c5f565762", "cves": [], "html": "允许在更多情况下进行逐分区连接（Ashutosh Bapat，Etsuro Fujita，Amit Langote，Tom Lane）§ §
\n例如，即使分区边界并不完全匹配，现在也可以在分区表之间进行逐分区连接。
", "text": "允许在更多情况下进行逐分区连接（Ashutosh Bapat，Etsuro Fujita，Amit Langote，Tom Lane）§ § 例如，即使分区边界并不完全匹配，现在也可以在分区表之间进行逐分区连接。", "title": "允许在更多情况下进行逐分区连接", "commits": ["981643dcd", "c8434d64c"], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.2", "source_hash": "51285655786ce74d28ff0a20fd74ffd1cf0653a8b0dcc273c218ca53b5b410e4", "section_path": ["服务器", "分区"], "commit_groups": [["981643dcd"], ["c8434d64c"]], "identity_text": "Allow partitionwise joins to happen in more cases (Ashutosh Bapat, Etsuro Fujita, Amit Langote, Tom Lane) For example, partitionwise joins can now happen between partitioned tables even when their partition bounds do not match exactly.", "commit_aliases": ["981643dcd", "c8434d64c"], "source_commits": ["981643dcd", "c8434d64c"], "source_entry_id": "13.0/changes/002", "db_id": "013e9e4c0c64877c23c756c68b800b84", "patch_ids": ["5510e3129a6cd5fd7303183bb169773b", "cea05edc62e6634bae9280680618d3e9"], "statement_hash": "97d3c09ac8016dd55ea466ff69ec48804edf66491d17f9a611dda4ab420aca60", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-672ee0b9193bfb24", "cves": [], "html": "支持分区表上的行级 BEFORE 触发器（Álvaro Herrera）§
但是，不允许此类触发器改变目标分区。
", "text": "支持分区表上的行级 BEFORE 触发器（Álvaro Herrera）§ 但是，不允许此类触发器改变目标分区。", "title": "支持分区表上的行级 BEFORE 触发器", "commits": ["487e9861d"], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.2", "source_hash": "7375c39dfdea7a22eda5060d1e383b507617eda7f4c53dbaa92837c2c26ec4b2", "section_path": ["服务器", "分区"], "commit_groups": [["487e9861d"]], "identity_text": "Support row-level BEFORE triggers on partitioned tables (Álvaro Herrera) However, such a trigger is not allowed to change which partition is the destination.", "commit_aliases": ["487e9861d"], "source_commits": ["487e9861d"], "source_entry_id": "13.0/changes/003", "db_id": "abb3546ba651a44c0b85673ae967e58b", "patch_ids": ["13594f035854cbbbd68f0945daceb87f"], "statement_hash": "b8576476e5ca0bb20544cc08df083f8993b8a732cbfaff7c89be1f618cfe841a", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-765158cb68dd9e47", "cves": [], "html": "允许通过发布对分区表进行逻辑复制（Amit Langote）§ §
\n以前，必须逐个复制分区。现在可以显式发布分区表，从而自动发布其所有分区。添加或移除分区时，也会将其相应地添加到发布或从发布中移除。CREATE PUBLICATION 的 publish_via_partition_root 选项控制分区变更是作为分区自身的变更发布，还是作为父表的变更发布。
允许逻辑复制写入订阅者上的分区表（Amit Langote）§
\n以前，订阅者只能将接收到的行写入非分区表。
", "text": "允许逻辑复制写入订阅者上的分区表（Amit Langote）§ 以前，订阅者只能将接收到的行写入非分区表。", "title": "允许逻辑复制写入订阅者上的分区表", "commits": ["f1ac27bfd"], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.2", "source_hash": "4f2d505a3c5fd9289ae421e32aa70368ab94cb0444fe7a3a546be1a91a291340", "section_path": ["服务器", "分区"], "commit_groups": [["f1ac27bfd"]], "identity_text": "Allow logical replication into partitioned tables on subscribers (Amit Langote) Previously, subscribers could only receive rows into non-partitioned tables.", "commit_aliases": ["f1ac27bfd"], "source_commits": ["f1ac27bfd"], "source_entry_id": "13.0/changes/005", "db_id": "29b3866c33eac57d46f54be9cf89ac2f", "patch_ids": ["81816bd4b7a1cf1504a8ef1ca01d9b07"], "statement_hash": "4893e4d4af22c64f70d9da6c3a93060c2ef4d24884e77428adf6910bba7ba642", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-a1565a98a769b9ff", "cves": [], "html": "允许在分区表达式中使用整行变量（即 table.*）（Amit Langote）§
更高效地存储 B-树索引中的重复项（Anastasia Lubennikova，Peter Geoghegan）§
\n这通过只存储一次重复键，使低基数列能够高效地使用 B-树索引。使用pg_upgrade升级的用户，需要执行 REINDEX 才能让现有索引使用这一特性。
允许 box 列上的 GiST 和 SP-GiST 索引支持 ORDER BY 查询（Nikita Glukhov）§ §box <-> point
允许 GIN 索引更高效地处理 tsquery 搜索中的 !（NOT）子句（Nikita Glukhov，Alexander Korotkov，Tom Lane，Julien Rouhaud）§
允许 CREATE INDEX 指定 GiST 签名长度和整数范围的最大数量（Nikita Glukhov）§
在四字节和八字节整数数组、tsvector、pg_trgm、ltree和hstore列上创建的索引，现在可以控制这些 GiST 索引参数，而不再只能使用默认值。
", "text": "允许 CREATE INDEX 指定 GiST 签名长度和整数范围的最大数量（Nikita Glukhov）§ 在四字节和八字节整数数组、tsvector、pg_trgm、ltree和hstore列上创建的索引，现在可以控制这些 GiST 索引参数，而不再只能使用默认值。", "title": "允许 CREATE INDEX 指定 GiST 签名长度和整数范围的最大数量", "commits": ["911e70207"], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.3", "source_hash": "47f7609aa0fed7770f1d7940bf6a78b2301df1870d1ef7c62d273ddf64c90ec8", "section_path": ["服务器", "索引"], "commit_groups": [["911e70207"]], "identity_text": "Allow CREATE INDEX to specify the GiST signature length and maximum number of integer ranges (Nikita Glukhov) Indexes created on four and eight-byte integer array, tsvector, pgtrgm , ltree , and hstore columns can now control these GiST index parameters, rather than using the defaults.", "commit_aliases": ["911e70207"], "source_commits": ["911e70207"], "source_entry_id": "13.0/changes/011", "db_id": "c7ba4ea9be933a69c1ae4032bdf26ff9", "patch_ids": ["5d17b7356f8a8c6cc4be66f2a9088b55"], "statement_hash": "4657e287462a6c024cbc4d7512fb6af446d72e0827a97dc15abd13095c084b98", "relations": [{"rule": 2, "type": "related", "target": "afc765d9b390c3bbd435caf0e408dff0", "evidence": {"same_day": true, "patch_ids": ["5d17b7356f8a8c6cc4be66f2a9088b55"], "ambiguous_patch_ids": ["5d17b7356f8a8c6cc4be66f2a9088b55"]}}], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "afc765d9b390c3bbd435caf0e408dff0", "kind": "related", "version": "13.0", "label": "13.0", "title": "允许索引操作符类接受参数", "evidence": {"same_day": true, "patch_ids": ["5d17b7356f8a8c6cc4be66f2a9088b55"], "ambiguous_patch_ids": ["5d17b7356f8a8c6cc4be66f2a9088b55"]}, "url": "/docs/compare/?release=13.0#13.0-00afdb908268ed96-1", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.3"}]}, {"id": "13.0-90aca664fe16e695", "cves": [], "html": "禁止将使用非默认排序规则的索引添加为表的唯一约束或主键约束（Tom Lane）§
\n索引的排序规则必须与底层列的排序规则匹配，但 ALTER TABLE 以前未检查这一点。
改进优化器对包含和匹配操作符的选择率估计（Tom Lane）§
", "text": "改进优化器对包含和匹配操作符的选择率估计（Tom Lane）§", "title": "改进优化器对包含和匹配操作符的选择率估计", "commits": ["a80818605"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.4", "source_hash": "db8598d459670ad5b71679fbbfb2011cf1b783a366e1368ef138427d63e06e8f", "section_path": ["服务器", "优化器"], "commit_groups": [["a80818605"]], "identity_text": "Improve the optimizer's selectivity estimation for containment/match operators (Tom Lane)", "commit_aliases": ["a80818605"], "source_commits": ["a80818605"], "source_entry_id": "13.0/changes/013", "db_id": "e03a2f4748c20b9fa3d57bebb562d54d", "patch_ids": ["e0a203af7ecf47c845d60dffea038bd8"], "statement_hash": "d0efeabdaee1d449eb29f81fdd08331ec5d70d7df958c8731c07e08e2e2efae9", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-97394fe02733bbe0", "cves": [], "html": "允许为扩展统计信息设置统计目标（Tomas Vondra）§
\n这通过新的命令选项 ALTER STATISTICS ... SET STATISTICS 控制。以前，它基于更通用的统计目标设置计算得出。
允许在单个查询中使用多个扩展统计对象（Tomas Vondra）§ §
", "text": "允许在单个查询中使用多个扩展统计对象（Tomas Vondra）§ §", "title": "允许在单个查询中使用多个扩展统计对象", "commits": ["aaa676187", "eae056c19"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.4", "source_hash": "a06a591b00c801eb07849c0caa2b451e1ff4837e89ae9e5aa85fc35909a5d0db", "section_path": ["服务器", "优化器"], "commit_groups": [["aaa676187"], ["eae056c19"]], "identity_text": "Allow use of multiple extended statistics objects in a single query (Tomas Vondra)", "commit_aliases": ["aaa676187", "eae056c19"], "source_commits": ["aaa676187", "eae056c19"], "source_entry_id": "13.0/changes/015", "db_id": "ea0131e2b4726edb47e2476c2d94fb81", "patch_ids": ["0517460781f8025da7b77fa6bc8064f3", "93a0e941b5a99c891e70cb6275232dfd"], "statement_hash": "6291ceaadec03b1969b571f95fe0f7c568efd1c25a1ae62e3aa6a503bf2ca415", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-35b629657ada221a", "cves": [], "html": "允许将扩展统计对象用于 OR 子句和 IN/ANY 常量列表（Pierre Ducroquet，Tomas Vondra）§ § §
如果 FROM 子句中的函数求值为常量，则允许将其上拉（内联）（Alexander Kuzmenkov，Aleksandr Parfenov）§ §
实现增量排序（James Coleman，Alexander Korotkov，Tomas Vondra）§ §
\n如果已知查询的中间结果按照所需排序顺序的一个或多个前导键排好序，则可以将前导键相同的行分批排序，只考虑剩余键即可完成额外的排序。
\n如有需要，可以使用enable_incremental_sort控制此行为。
", "text": "实现增量排序（James Coleman，Alexander Korotkov，Tomas Vondra）§ § 如果已知查询的中间结果按照所需排序顺序的一个或多个前导键排好序，则可以将前导键相同的行分批排序，只考虑剩余键即可完成额外的排序。 如有需要，可以使用enable_incremental_sort控制此行为。", "title": "实现增量排序", "commits": ["94e454cdd", "d2d8a229b"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.5", "source_hash": "7326147e882b0a4166ec3b84287d9b9d0920e4953c41bfd832ae421a2029ff7b", "section_path": ["服务器", "一般性能"], "commit_groups": [["94e454cdd"], ["d2d8a229b"]], "identity_text": "Implement incremental sorting (James Coleman, Alexander Korotkov, Tomas Vondra) If an intermediate query result is known to be sorted by one or more leading keys of a required sort ordering, the additional sorting can be done considering only the remaining keys, if the rows are sorted in batches that have equal leading keys. If necessary, this can be controlled using guc-enable-incremental-sort .", "commit_aliases": ["94e454cdd", "d2d8a229b"], "source_commits": ["94e454cdd", "d2d8a229b"], "source_entry_id": "13.0/changes/018", "db_id": "6f3fd1946c685503344ef054a587b1dd", "patch_ids": ["278a92e39d69c168ad24a9167f2174b7", "3dc77609ae64140459d9a9afec908107"], "statement_hash": "b7d27834a05b9b8046d54286391fa61e92ec190e4bfa43505d0a8604e9f4ed8c", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-7cf2b4fcd6a90e43", "cves": [], "html": "提高 inet 值的排序性能（Brandur Leach）§
", "text": "提高 inet 值的排序性能（Brandur Leach）§", "title": "提高 inet 值的排序性能", "commits": ["71dcd7438"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.5", "source_hash": "83a3067bfd228a4d71e4935e7691c9be60dd5b90024a43f53f37464ca3988502", "section_path": ["服务器", "一般性能"], "commit_groups": [["71dcd7438"]], "identity_text": "Improve the performance of sorting inet values (Brandur Leach)", "commit_aliases": ["71dcd7438"], "source_commits": ["71dcd7438"], "source_entry_id": "13.0/changes/019", "db_id": "7be3e1713fbe303ab454a9c923d9a047", "patch_ids": ["6b8159f858e88c6984f443855e76682a"], "statement_hash": "fcdbcac1c219036114076c98db61e8bfcccee2b814ca49423663db86ecc69d1c", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-15d590cb812ca7d3", "cves": [], "html": "允许hash 聚合对大型聚合结果集使用磁盘存储（Jeff Davis）§ § §
\n以前，如果预计 hash 聚合使用的内存会超过work_mem，就会避免使用它。现在，即使如此也可以选择 hash 聚合计划。如果 hash 表超过 work_mem 乘以hash_mem_multiplier的大小，就会溢写到磁盘。
这一行为通常优于旧行为：以前，一旦选择了 hash 聚合，无论 hash 表增长到多大，都会一直保留在内存中；如果规划器估计有误，它可能变得非常大。如有需要，可以通过增大 hash_mem_multiplier 来获得类似旧行为的效果。
允许插入操作也触发自动清理中的清理活动，而不再仅由更新和删除触发（Laurenz Albe，Darafei Praliaskouski）§
\n以前，仅有插入活动时会触发自动分析，但不会触发自动清理，理由是不存在需要移除的死元组。然而，清理扫描还有其他有益的副作用，例如设置页面全可见位，从而提高仅索引扫描的效率。另外，让仅插入的表接受周期性清理，有助于分散“冻结”旧元组的工作量，避免整个表同时达到防回卷阈值时，突然需要执行大量冻结工作。
\n如有需要，可以通过新参数autovacuum_vacuum_insert_threshold和autovacuum_vacuum_insert_scale_factor，或等价的表存储选项来调整此行为。
", "text": "允许插入操作也触发自动清理中的清理活动，而不再仅由更新和删除触发（Laurenz Albe，Darafei Praliaskouski）§ 以前，仅有插入活动时会触发自动分析，但不会触发自动清理，理由是不存在需要移除的死元组。然而，清理扫描还有其他有益的副作用，例如设置页面全可见位，从而提高仅索引扫描的效率。另外，让仅插入的表接受周期性清理，有助于分散“冻结”旧元组的工作量，避免整个表同时达到防回卷阈值时，突然需要执行大量冻结工作。 如有需要，可以通过新参数autovacuum_vacuum_insert_threshold和autovacuum_vacuum_insert_scale_factor，或等价的表存储选项来调整此行为。", "title": "允许插入操作也触发自动清理中的清理活动，而不再仅由更新和删除触发", "commits": ["b07642dbc"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.5", "source_hash": "d039b6b317faabbf49abde232f85e0528f56777455f2ca9be46ada3232d18fdc", "section_path": ["服务器", "一般性能"], "commit_groups": [["b07642dbc"]], "identity_text": "Allow inserts, not only updates and deletes, to trigger vacuuming activity in autovacuum (Laurenz Albe, Darafei Praliaskouski) Previously, insert-only activity would trigger auto-analyze but not auto-vacuum, on the grounds that there could not be any dead tuples to remove. However, a vacuum scan has other useful side-effects such as setting page-all-visible bits, which improves the efficiency of index-only scans. Also, allowing an insert-only table to receive periodic vacuuming helps to spread out the work of freezing old tuples, so that there is not suddenly a large amount of freezing work to do when the entire table reaches the anti-wraparound threshold all at once. If necessary, this behavior can be adjusted with the new parameters guc-autovacuum-vacuum-insert-threshold and guc-autovacuum-vacuum-insert-scale-factor , or the equivalent table storage options.", "commit_aliases": ["b07642dbc"], "source_commits": ["b07642dbc"], "source_entry_id": "13.0/changes/021", "db_id": "ff243b43c207ec3e528bcb615e41e0ad", "patch_ids": ["dd4a38c2cef7db1665e28a1a9ff16317"], "statement_hash": "a75fea2e370989e623b4dd0557b356397fde08d58f02154768c4bf5eeae19679", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-2086e47d6fa03cdd", "cves": [], "html": "增加maintenance_io_concurrency参数，以控制维护操作的 I/O 并发度（Thomas Munro）§
", "text": "增加maintenance_io_concurrency参数，以控制维护操作的 I/O 并发度（Thomas Munro）§", "title": "增加maintenance_io_concurrency参数，以控制维护操作的 I/O 并发度", "commits": ["fc34b0d9d"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.5", "source_hash": "efd0b9ce10b052bb1682f544584949baad36d92419138589c516bf10911ee3ea", "section_path": ["服务器", "一般性能"], "commit_groups": [["fc34b0d9d"]], "identity_text": "Add guc-maintenance-io-concurrency parameter to control I/O concurrency for maintenance operations (Thomas Munro)", "commit_aliases": ["fc34b0d9d"], "source_commits": ["fc34b0d9d"], "source_entry_id": "13.0/changes/022", "db_id": "295f700db62c2f12965dacb55956fa60", "patch_ids": ["12c1a95ce51d50f455dccf8066eba9e7"], "statement_hash": "1d736eb5805e08baea756c991a9fbab291d5b7e7cb5fb9f84c3ba70281036636", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-b85de750769c20fe", "cves": [], "html": "如果wal_level为 minimal，则允许在创建或重写关系的事务期间跳过 WAL 写入（Kyotaro Horiguchi）§
对于大于wal_skip_threshold的关系，会对其文件执行 fsync，而不生成 WAL。以前，只有 COPY 操作会这样处理，但其实现有一个缺陷，可能在崩溃恢复期间导致数据丢失。
提高使用大量表空间时重放 DROP DATABASE 命令的性能（Fujii Masao）§
改进对经过 TOAST 处理的值的起始字节的获取（Binguo Bao，Andrey Borodin）§
\n以前，即使已知只需要起始的一部分字节，也会完整获取压缩的行外 TOAST 值。现在，只获取足以生成结果的数据。
", "text": "改进对经过 TOAST 处理的值的起始字节的获取（Binguo Bao，Andrey Borodin）§ 以前，即使已知只需要起始的一部分字节，也会完整获取压缩的行外 TOAST 值。现在，只获取足以生成结果的数据。", "title": "改进对经过 TOAST 处理的值的起始字节的获取", "commits": ["11a078cf8"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.5", "source_hash": "1c388da4bcfbb54bdeeb8251d35ba6b66b5eb69951c3822509bad3e4ba0841a1", "section_path": ["服务器", "一般性能"], "commit_groups": [["11a078cf8"]], "identity_text": "Improve retrieval of the leading bytes of TOAST'ed values (Binguo Bao, Andrey Borodin) Previously, compressed out-of-line TOAST values were fully fetched even when it's known that only some leading bytes are needed. Now, only enough data to produce the result is fetched.", "commit_aliases": ["11a078cf8"], "source_commits": ["11a078cf8"], "source_entry_id": "13.0/changes/026", "db_id": "f5fb1b1f9ded8c1ceb227b00db1c2958", "patch_ids": ["cef0836907cdb9beac39ce5b71086988"], "statement_hash": "bc342db307b119cd9c25d5ce61994249266ffa0a3ce8a83153209bcbf0b1dccd", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-d2feeed792795170", "cves": [], "html": "提高 LISTEN/NOTIFY 的性能（Martijn van Oosterhout，Tom Lane）§ § §
加快整数到文本的转换（David Fetter）§
", "text": "加快整数到文本的转换（David Fetter）§", "title": "加快整数到文本的转换", "commits": ["1fd687a03"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.5", "source_hash": "36af82f7d62ee80b507e36be1c04de924bb9f167a72733bf906cf2a10d3d03a4", "section_path": ["服务器", "一般性能"], "commit_groups": [["1fd687a03"]], "identity_text": "Speed up conversions of integers to text (David Fetter)", "commit_aliases": ["1fd687a03"], "source_commits": ["1fd687a03"], "source_entry_id": "13.0/changes/028", "db_id": "146793203d27f4483566ccde04c0a80f", "patch_ids": ["45afb2686c385bef49fee44bcead94ed"], "statement_hash": "cb987b4d56de264131e4a585e21034140003fee4012425d64f137d8229b137a4", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-a6da1f40d67c9421", "cves": [], "html": "减少包含大量 SQL 语句的查询字符串和扩展脚本的内存用量（Amit Langote）§
", "text": "减少包含大量 SQL 语句的查询字符串和扩展脚本的内存用量（Amit Langote）§", "title": "减少包含大量 SQL 语句的查询字符串和扩展脚本的内存用量", "commits": ["b5810de3f"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.5", "source_hash": "8fb7798c19e322d4dd0521369b4269d3f226e165d46a42e66bf6eeedf484aebd", "section_path": ["服务器", "一般性能"], "commit_groups": [["b5810de3f"]], "identity_text": "Reduce memory usage for query strings and extension scripts that contain many SQL statements (Amit Langote)", "commit_aliases": ["b5810de3f"], "source_commits": ["b5810de3f"], "source_entry_id": "13.0/changes/029", "db_id": "15e468abbb5e4eccab6f4881331a59fd", "patch_ids": ["1ab927c2f38b29e4895f038a2f2ec8e2"], "statement_hash": "fef69d605d385fbcff9f772a04be8789d4733cd24dae1d94a1f66041d951ffe2", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-8954db92bf2ae4b2", "cves": [], "html": "允许 EXPLAIN、auto_explain、自动清理和pg_stat_statements跟踪 WAL 使用统计信息（Kirill Bychik，Julien Rouhaud）§ § §
允许抽样记录 SQL 语句，而不必记录全部语句（Adrien Nayrat）§
\n对于耗时超过log_min_duration_sample的语句，将按log_statement_sample_rate指定的比例记录日志。
", "text": "允许抽样记录 SQL 语句，而不必记录全部语句（Adrien Nayrat）§ 对于耗时超过log_min_duration_sample的语句，将按log_statement_sample_rate指定的比例记录日志。", "title": "允许抽样记录 SQL 语句，而不必记录全部语句", "commits": ["6e3e6cc0e"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.6", "source_hash": "100d1f479e612787e8ef6dacf4641291e7cc0aaa46bc87560848bbdf111c5a4a", "section_path": ["服务器", "监控"], "commit_groups": [["6e3e6cc0e"]], "identity_text": "Allow a sample of SQL statements, rather than all statements, to be logged (Adrien Nayrat) A guc-log-statement-sample-rate fraction of those statements taking more than guc-log-min-duration-sample duration will be logged.", "commit_aliases": ["6e3e6cc0e"], "source_commits": ["6e3e6cc0e"], "source_entry_id": "13.0/changes/031", "db_id": "cf598e0ff1ed5c6895694ec0468b72fa", "patch_ids": ["d42d5bf0a2809f3449a7fdf44b63bd36"], "statement_hash": "64e01dd1f610133710962064b5af48ec6117ad653650460f9708d279b8b41a9c", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-45b357ebf41f9dea", "cves": [], "html": "将后端类型添加到 csvlog 日志输出中，并允许选择将其加入log_line_prefix日志输出（Peter Eisentraut）§
", "text": "将后端类型添加到 csvlog 日志输出中，并允许选择将其加入log_line_prefix日志输出（Peter Eisentraut）§", "title": "将后端类型添加到 csvlog 日志输出中，并允许选择将其加入log_line_prefix日志输出", "commits": ["70a7b4776"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.6", "source_hash": "286f96e316ce9805db24da0ccaed504a25d16433ac06fb901d54b2facf785992", "section_path": ["服务器", "监控"], "commit_groups": [["70a7b4776"]], "identity_text": "Add the backend type to csvlog and optionally guc-log-line-prefix log output (Peter Eisentraut)", "commit_aliases": ["70a7b4776"], "source_commits": ["70a7b4776"], "source_entry_id": "13.0/changes/032", "db_id": "235ce2c10b18e0cca4fef6d1580b942e", "patch_ids": ["b3bde18d195ab3e72dc9c103507df8a9"], "statement_hash": "0279638c7ed6b0977a0432345b3efaa639531996cb1b75ed5b95926de0099acf", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-fd504c5b579e31ab", "cves": [], "html": "改进对预备语句参数日志记录的控制（Alexey Bashtanov，Álvaro Herrera）§ §
\nGUC 设置log_parameter_max_length控制记录未出错语句时输出的参数值的最大长度，而log_parameter_max_length_on_error对出错语句的日志执行相同控制。以前，发生错误时从不记录预备语句的参数。
", "text": "改进对预备语句参数日志记录的控制（Alexey Bashtanov，Álvaro Herrera）§ § GUC 设置log_parameter_max_length控制记录未出错语句时输出的参数值的最大长度，而log_parameter_max_length_on_error对出错语句的日志执行相同控制。以前，发生错误时从不记录预备语句的参数。", "title": "改进对预备语句参数日志记录的控制", "commits": ["0b34e7d30", "ba79cb5dc"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.6", "source_hash": "7f237edc904bad8c0bf5ab2893ef9f4d1981a1fd2ab9c35a0b09649315e41eca", "section_path": ["服务器", "监控"], "commit_groups": [["0b34e7d30"], ["ba79cb5dc"]], "identity_text": "Improve control of prepared statement parameter logging (Alexey Bashtanov, Álvaro Herrera) The GUC setting guc-log-parameter-max-length controls the maximum length of parameter values output during logging of non-error statements, while guc-log-parameter-max-length-on-error does the same for logging of statements with errors. Previously, prepared statement parameters were never logged during errors.", "commit_aliases": ["0b34e7d30", "ba79cb5dc"], "source_commits": ["0b34e7d30", "ba79cb5dc"], "source_entry_id": "13.0/changes/033", "db_id": "0eda34f47222bdf23c7178dbd7af0d7d", "patch_ids": ["892abc33cd6c56564cf2c12133a2d045", "f081b1d898afefe2d7eb29013c75bd56"], "statement_hash": "b00d94b41be0ecba2efa1d14b97fa13f2b5cb1b4e9e93d3210706381c1da32ae", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-586da60305fb7b08", "cves": [], "html": "允许在出错后记录函数调用回溯（Peter Eisentraut，Álvaro Herrera）§ §
\n新参数backtrace_functions指定哪些 C 函数应在出错时生成回溯。
", "text": "允许在出错后记录函数调用回溯（Peter Eisentraut，Álvaro Herrera）§ § 新参数backtrace_functions指定哪些 C 函数应在出错时生成回溯。", "title": "允许在出错后记录函数调用回溯", "commits": ["71a8a4f6e", "8ff4d1277"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.6", "source_hash": "cabf22c51494731865edb0153f669c4f67bcef906a6b06ec9ede4bf55c823173", "section_path": ["服务器", "监控"], "commit_groups": [["71a8a4f6e"], ["8ff4d1277"]], "identity_text": "Allow function call backtraces to be logged after errors (Peter Eisentraut, Álvaro Herrera) The new parameter guc-backtrace-functions specifies which C functions should generate backtraces on error.", "commit_aliases": ["71a8a4f6e", "8ff4d1277"], "source_commits": ["71a8a4f6e", "8ff4d1277"], "source_entry_id": "13.0/changes/034", "db_id": "3699aac582bc0eec78d81d91995a0354", "patch_ids": ["2b80fdf05010f615558b8d50d0660b55", "65bdf4c3f4fde73434e42e2b52f30b2d"], "statement_hash": "7cbdab52fc728b1acb9d4e8935fac7e137cb73e832b5aeee1c1b420811870209", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-ff1361b3a01398ef", "cves": [], "html": "将清理的缓冲区计数器扩为 64 位，以避免溢出（Álvaro Herrera）§
", "text": "将清理的缓冲区计数器扩为 64 位，以避免溢出（Álvaro Herrera）§", "title": "将清理的缓冲区计数器扩为 64 位，以避免溢出", "commits": ["15d13e829"], "section": "服务器 / 监控", "category": "bugfix", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.6", "source_hash": "e7ad771b468244f1b6bda4035a36701e031b8fa8eb99c340dc2cdf28aeb6d1f7", "section_path": ["服务器", "监控"], "commit_groups": [["15d13e829"]], "identity_text": "Make vacuum buffer counters 64-bits wide to avoid overflow (Álvaro Herrera)", "commit_aliases": ["15d13e829"], "source_commits": ["15d13e829"], "source_entry_id": "13.0/changes/035", "db_id": "66d40f6696228d548d1e3c049c034faa", "patch_ids": ["9ab19debd02d99f33901d8bd052a90c6"], "statement_hash": "a9f6ab10bce886b9cdab2527b5d0ac7a46e36bf00130974a62b0adf41efaca5a", "relations": [], "version": "13.0", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-52a0b2a9e74f9722", "cves": [], "html": "向pg_stat_activity添加 leader_pid，以报告并行工作进程的领导者进程（Julien Rouhaud）§
增加系统视图 pg_stat_progress_basebackup，以报告流式基础备份的进度（Fujii Masao）§
增加系统视图 pg_stat_progress_analyze，以报告 ANALYZE 进度（Álvaro Herrera，Tatsuro Yamada，Vinayak Pokale）§
增加系统视图 pg_shmem_allocations，以显示共享内存使用情况（Andres Freund，Robert Haas）§
增加系统视图 pg_stat_slru，以监控内部 SLRU 缓存（Tomas Vondra）§
允许将track_activity_query_size设置为最高 1MB（Vyacheslav Makarov）§
\n以前的最大值为 100kB。
", "text": "允许将track_activity_query_size设置为最高 1MB（Vyacheslav Makarov）§ 以前的最大值为 100kB。", "title": "允许将track_activity_query_size设置为最高 1MB", "commits": ["814727858"], "section": "服务器 / 系统视图", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.7", "source_hash": "c88a542e752b5c2dc9dcdda9577ba71511df010d224db0cd9a584896e22284c7", "section_path": ["服务器", "系统视图"], "commit_groups": [["814727858"]], "identity_text": "Allow guc-track-activity-query-size to be set as high as 1MB (Vyacheslav Makarov) The previous maximum was 100kB.", "commit_aliases": ["814727858"], "source_commits": ["814727858"], "source_entry_id": "13.0/changes/041", "db_id": "1170c2e60e7bbe067fa09f4e9a55b00a", "patch_ids": ["bf97a0a3c183a355a1d122307df06933"], "statement_hash": "cf8794c0b094a8c67e221836d2a4030b0980db77036b83a8229ae1ceba7c8134", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-1b8f0faedc891254", "cves": [], "html": "使用 posix_fallocate() 创建 DSM 段时报告等待事件（Thomas Munro）§
增加等待事件 VacuumDelay，以报告基于代价的清理延迟（Justin Pryzby）§
", "text": "增加等待事件 VacuumDelay，以报告基于代价的清理延迟（Justin Pryzby）§", "title": "增加等待事件 VacuumDelay，以报告基于代价的清理延迟", "commits": ["cedffbdb8"], "section": "服务器 / 等待事件", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.8", "source_hash": "5773676cc2f68f1e0dbd1e2163ea9b22673b4de138de51352f7e2b25741756c4", "section_path": ["服务器", "等待事件"], "commit_groups": [["cedffbdb8"]], "identity_text": "Add wait event VacuumDelay to report on cost-based vacuum delay (Justin Pryzby)", "commit_aliases": ["cedffbdb8"], "source_commits": ["cedffbdb8"], "source_entry_id": "13.0/changes/043", "db_id": "f8e060090e970c464b4288abe46d6d5f", "patch_ids": ["37e1b1003b1d18374b97562b7bc17a9b"], "statement_hash": "7bc8ff86a40914648be320bdce08e73d9848768f2d359beea99252d39313dc8c", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-a64b2a48663380a1", "cves": [], "html": "为 WAL 归档和恢复暂停增加等待事件（Fujii Masao）§
\n新增事件为 BackupWaitWalArchive 和 RecoveryPause。
", "text": "为 WAL 归档和恢复暂停增加等待事件（Fujii Masao）§ 新增事件为 BackupWaitWalArchive 和 RecoveryPause。", "title": "为 WAL 归档和恢复暂停增加等待事件", "commits": ["b8e20d6da"], "section": "服务器 / 等待事件", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.8", "source_hash": "e96b3f4bbe439ca9ed1fb70f6a06424c4b82bf8776ac994ee2ad39f768498b8a", "section_path": ["服务器", "等待事件"], "commit_groups": [["b8e20d6da"]], "identity_text": "Add wait events for WAL archive and recovery pause (Fujii Masao) The new events are BackupWaitWalArchive and RecoveryPause.", "commit_aliases": ["b8e20d6da"], "source_commits": ["b8e20d6da"], "source_entry_id": "13.0/changes/044", "db_id": "3c5c0ec2c2eaaf0e60de9d8776cca018", "patch_ids": ["6fe0a06951d273b69d16762c4bbd476d"], "statement_hash": "1455246aa9e8be1b2c6db7f90fd462c183efc2b262421b54a0f53189470dcd8d", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-3c2868ca5caef8a8", "cves": [], "html": "增加等待事件 RecoveryConflictSnapshot 和 RecoveryConflictTablespace，以监控恢复冲突（Masahiko Sawada）§
", "text": "增加等待事件 RecoveryConflictSnapshot 和 RecoveryConflictTablespace，以监控恢复冲突（Masahiko Sawada）§", "title": "增加等待事件 RecoveryConflictSnapshot 和 RecoveryConflictTablespace，以监控恢复冲突", "commits": ["18808f8c8"], "section": "服务器 / 等待事件", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.8", "source_hash": "548d1dd2d926b717d99f3836ed6e79841853ca9e3fc9ec2ada1a41ce520853e9", "section_path": ["服务器", "等待事件"], "commit_groups": [["18808f8c8"]], "identity_text": "Add wait events RecoveryConflictSnapshot and RecoveryConflictTablespace to monitor recovery conflicts (Masahiko Sawada)", "commit_aliases": ["18808f8c8"], "source_commits": ["18808f8c8"], "source_entry_id": "13.0/changes/045", "db_id": "18551dad406ad2db47d34eac3fe960a8", "patch_ids": ["f6119c017b405cdac8f6d130d83da14f"], "statement_hash": "60b28341cf367db6caaa1a879ab3c02364e4bb58eee1c4efb0f3edb7f66c70e9", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-06d77f031c9ce92f", "cves": [], "html": "提高基于 BSD 的系统上的等待事件性能（Thomas Munro）§
", "text": "提高基于 BSD 的系统上的等待事件性能（Thomas Munro）§", "title": "提高基于 BSD 的系统上的等待事件性能", "commits": ["815c2f097"], "section": "服务器 / 等待事件", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.8", "source_hash": "69f83a91fc14e426f8beffe2317bdab23f2bcb05549e2273d8cc94a01c924b43", "section_path": ["服务器", "等待事件"], "commit_groups": [["815c2f097"]], "identity_text": "Improve performance of wait events on BSD-based systems (Thomas Munro)", "commit_aliases": ["815c2f097"], "source_commits": ["815c2f097"], "source_entry_id": "13.0/changes/046", "db_id": "49a30a50342df4fd32c125ea122f1a25", "patch_ids": ["7997291c64481ef3186b842291852cf4"], "statement_hash": "300271c104184e5ec2c00e0c6dc5a11c973212edbcb91fd4f7dd8000e2526019", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-ce4ef8ca83cd7206", "cves": [], "html": "只允许超级用户查看ssl_passphrase_command设置（Insung Moon）§
\n此项修改出于安全考虑。
", "text": "只允许超级用户查看ssl_passphrase_command设置（Insung Moon）§ 此项修改出于安全考虑。", "title": "只允许超级用户查看ssl_passphrase_command设置", "commits": ["d9249441e"], "section": "服务器 / Authentication", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.9", "source_hash": "226c42b74a60629e3f8a4260a367987baac11178c074d5f8aa01046752e6fc79", "section_path": ["服务器", "Authentication"], "commit_groups": [["d9249441e"]], "identity_text": "Allow only superusers to view the guc-ssl-passphrase-command setting (Insung Moon) This was changed as a security precaution.", "commit_aliases": ["d9249441e"], "source_commits": ["d9249441e"], "source_entry_id": "13.0/changes/047", "db_id": "c66ac81f2a3b5ecd323a61be808b8429", "patch_ids": ["5280dc5a8da5303479b58c8240552d8c"], "statement_hash": "9c0220af1b7541e620bd0ca827dcfbb7c50c38d697dc0fcd4e076808b3d60681", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-4f65efe7f0f9e292", "cves": [], "html": "将服务器加密连接默认允许的最低 TLS 版本从 1.0 改为 1.2（Peter Eisentraut）§
\n可以通过ssl_min_protocol_version控制这一选择。
", "text": "将服务器加密连接默认允许的最低 TLS 版本从 1.0 改为 1.2（Peter Eisentraut）§ 可以通过ssl_min_protocol_version控制这一选择。", "title": "将服务器加密连接默认允许的最低 TLS 版本从 1.0 改为 1.2", "commits": ["b1abfec82"], "section": "服务器 / Authentication", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.9", "source_hash": "c6b0eba6301163530b5745be783c8877ab471814003afbd69cf45f845c9037c9", "section_path": ["服务器", "Authentication"], "commit_groups": [["b1abfec82"]], "identity_text": "Change the server's default minimum TLS version for encrypted connections from 1.0 to 1.2 (Peter Eisentraut) This choice can be controlled by guc-ssl-min-protocol-version .", "commit_aliases": ["b1abfec82"], "source_commits": ["b1abfec82"], "source_entry_id": "13.0/changes/048", "db_id": "5c2c5a268df7491419c32bc517eaea8c", "patch_ids": ["7ad6a5fe72361815924c7802609eaf1c"], "statement_hash": "4a13db69ffd2882e8200179c884898dae52dc72e16d20356bf6f7195e2c9f608", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-8baf37c1017aee58", "cves": [], "html": "收紧关于只读事务模式下允许执行哪些实用命令的规则（Robert Haas）§
\n此项修改还增加了可在并行查询中运行的实用命令数量。
", "text": "收紧关于只读事务模式下允许执行哪些实用命令的规则（Robert Haas）§ 此项修改还增加了可在并行查询中运行的实用命令数量。", "title": "收紧关于只读事务模式下允许执行哪些实用命令的规则", "commits": ["2eb34ac36"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.10", "source_hash": "38e74dfdae557f021130443065eb136f078a15ff7eb2847bbbb73910f765b401", "section_path": ["服务器", "服务器配置"], "commit_groups": [["2eb34ac36"]], "identity_text": "Tighten rules on which utility commands are allowed in read-only transaction mode (Robert Haas) This change also increases the number of utility commands that can run in parallel queries.", "commit_aliases": ["2eb34ac36"], "source_commits": ["2eb34ac36"], "source_entry_id": "13.0/changes/049", "db_id": "3f841bd64c40391a956b84092c26442f", "patch_ids": ["7d03e2a8274f02d98945329edc68e378"], "statement_hash": "8fe790f3c0f31459a2487610657bbf8256e98f5e3f53a9a453f354afdb4e3a57", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-c73013e1bc78e314", "cves": [], "html": "允许在服务器启动后修改allow_system_table_mods（Peter Eisentraut）§
", "text": "允许在服务器启动后修改allow_system_table_mods（Peter Eisentraut）§", "title": "允许在服务器启动后修改allow_system_table_mods", "commits": ["c4a7a392e"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.10", "source_hash": "12b0ba5414b928e3869101f3390ccee89605a91c8904cce92c42c501494fc396", "section_path": ["服务器", "服务器配置"], "commit_groups": [["c4a7a392e"]], "identity_text": "Allow guc-allow-system-table-mods to be changed after server start (Peter Eisentraut)", "commit_aliases": ["c4a7a392e"], "source_commits": ["c4a7a392e"], "source_entry_id": "13.0/changes/050", "db_id": "9e89d87637b1b9e7d2afa6f5a00ae036", "patch_ids": ["cd9fcb222f261787497a20ccb7db1cd7"], "statement_hash": "740b7abc54511ea4ef9b23e51c8b02d585bcb76088b628e407a6a3aa43c2b817", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-ae1223a4f885c222", "cves": [], "html": "在设置allow_system_table_mods时，禁止非超级用户修改系统表（Peter Eisentraut）§
\n以前，如果在服务器启动时设置了allow_system_table_mods，非超级用户就可以对系统表执行 INSERT/UPDATE/DELETE 命令。
在 Windows 上启用 Unix 域套接字支持（Peter Eisentraut）§
", "text": "在 Windows 上启用 Unix 域套接字支持（Peter Eisentraut）§", "title": "在 Windows 上启用 Unix 域套接字支持", "commits": ["8f3ec75de"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.3.10", "source_hash": "870ffbbc6dd8154cef58e9ddf5f2b6e790b52111b54f0fa717ae17d70f1aca5f", "section_path": ["服务器", "服务器配置"], "commit_groups": [["8f3ec75de"]], "identity_text": "Enable support for Unix-domain sockets on Windows (Peter Eisentraut)", "commit_aliases": ["8f3ec75de"], "source_commits": ["8f3ec75de"], "source_entry_id": "13.0/changes/052", "db_id": "085a6be2139c683f39bc852acb6047da", "patch_ids": ["2df2d63d3558909645f3e95415869b78"], "statement_hash": "bc449d57dbff88a63bd227b82e80cc902427f599b4f3f72d74542af75a9cbf0d", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-c4986c9592f7281e", "cves": [], "html": "允许通过重载更改流复制配置设置（Sergei Kornilov）§
\n以前，更改primary_conninfo和primary_slot_name需要重启服务器。
", "text": "允许通过重载更改流复制配置设置（Sergei Kornilov）§ 以前，更改primary_conninfo和primary_slot_name需要重启服务器。", "title": "允许通过重载更改流复制配置设置", "commits": ["1e6148032"], "section": "流复制和恢复", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.4", "source_hash": "8b377a2a3c1cdc3523750f5f949de1ecf799d56c0dbcce8ec4bc8f63270a197b", "section_path": ["流复制和恢复"], "commit_groups": [["1e6148032"]], "identity_text": "Allow streaming replication configuration settings to be changed by reload (Sergei Kornilov) Previously, a server restart was required to change guc-primary-conninfo and guc-primary-slot-name .", "commit_aliases": ["1e6148032"], "source_commits": ["1e6148032"], "source_entry_id": "13.0/changes/053", "db_id": "d0505e2cb7f102e3e085be5d4d522af6", "patch_ids": ["b24cedea135a297c03667904d6bfe734"], "statement_hash": "463baf5e6ec87607839da705f542525b6a3154b4c33c9ef9f7a9c28bb01ee40d", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-c883484ddbcb0521", "cves": [], "html": "允许 WAL 接收进程在未指定永久复制槽时使用临时复制槽（Peter Eisentraut，Sergei Kornilov）§ §
\n可以使用wal_receiver_create_temp_slot启用此行为。
", "text": "允许 WAL 接收进程在未指定永久复制槽时使用临时复制槽（Peter Eisentraut，Sergei Kornilov）§ § 可以使用wal_receiver_create_temp_slot启用此行为。", "title": "允许 WAL 接收进程在未指定永久复制槽时使用临时复制槽", "commits": ["092c6936d", "329730827"], "section": "流复制和恢复", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.4", "source_hash": "6418c303e2a89e7b07e7524311a5c1adbf78f7d60f8eba946dff4f942940d46f", "section_path": ["流复制和恢复"], "commit_groups": [["092c6936d"], ["329730827"]], "identity_text": "Allow WAL receivers to use a temporary replication slot when a permanent one is not specified (Peter Eisentraut, Sergei Kornilov) This behavior can be enabled using guc-wal-receiver-create-temp-slot .", "commit_aliases": ["092c6936d", "329730827"], "source_commits": ["092c6936d", "329730827"], "source_entry_id": "13.0/changes/054", "db_id": "ea2877c8cb768c4a3911e75b41113785", "patch_ids": ["3c629804e6f984eceaf172deb0a1589d", "de0e9551aee5abf4bbafd350c8d5c725"], "statement_hash": "cc6cafbb7486fa67f5b8d9adcb065a330360a8dbf8fe764f77d20ce2cfa198f3", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-0594c433c92f0e46", "cves": [], "html": "允许通过max_slot_wal_keep_size限制复制槽的 WAL 存储量（Kyotaro Horiguchi）§
\n需要超过此值的复制槽会被标记为无效。
", "text": "允许通过max_slot_wal_keep_size限制复制槽的 WAL 存储量（Kyotaro Horiguchi）§ 需要超过此值的复制槽会被标记为无效。", "title": "允许通过max_slot_wal_keep_size限制复制槽的 WAL 存储量", "commits": ["c65507763"], "section": "流复制和恢复", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.4", "source_hash": "870d0258609dbf9104424fc8cf7f075fc96c798f19ac27cf3d63e28bbd48fc70", "section_path": ["流复制和恢复"], "commit_groups": [["c65507763"]], "identity_text": "Allow WAL storage for replication slots to be limited by guc-max-slot-wal-keep-size (Kyotaro Horiguchi) Replication slots that would require exceeding this value are marked invalid.", "commit_aliases": ["c65507763"], "source_commits": ["c65507763"], "source_entry_id": "13.0/changes/055", "db_id": "110211fc7e7685a87adb6710b56b43e5", "patch_ids": ["60c0ed98bb39ff47b8b77fc8c96f0458"], "statement_hash": "916f9b60abad1762852445e4836b01f37ed5b1596ea142fda4a335c6368c40b0", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-4c444aeb4e44e9d7", "cves": [], "html": "允许备库提升取消任何已请求的暂停（Fujii Masao）§
\n以前，备库处于暂停状态时无法提升。
", "text": "允许备库提升取消任何已请求的暂停（Fujii Masao）§ 以前，备库处于暂停状态时无法提升。", "title": "允许备库提升取消任何已请求的暂停", "commits": ["496ee647e"], "section": "流复制和恢复", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.4", "source_hash": "b908fa6dc2dd2e7573a2aae30f1cdfc5227684b6a98a4220951455485d848f45", "section_path": ["流复制和恢复"], "commit_groups": [["496ee647e"]], "identity_text": "Allow standby promotion to cancel any requested pause (Fujii Masao) Previously, promotion could not happen while the standby was in paused state.", "commit_aliases": ["496ee647e"], "source_commits": ["496ee647e"], "source_entry_id": "13.0/changes/056", "db_id": "f85af48367bb3e0eb4f9b26373696b68", "patch_ids": ["7162fd0b5dda9a3a9555ae9ffcb3a29b"], "statement_hash": "05d0f6083463f1395bd4d594aa8309af8f8c37e1011c001ce0d7924ac24c8d10", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-77bbff998a726842", "cves": [], "html": "如果恢复未到达指定的恢复目标，则产生错误（Leif Gunnar Erlandsen，Peter Eisentraut）§
\n以前，即使未到达目标，备库也会在到达 WAL 末尾时自行提升。
", "text": "如果恢复未到达指定的恢复目标，则产生错误（Leif Gunnar Erlandsen，Peter Eisentraut）§ 以前，即使未到达目标，备库也会在到达 WAL 末尾时自行提升。", "title": "如果恢复未到达指定的恢复目标，则产生错误", "commits": ["dc788668b"], "section": "流复制和恢复", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.4", "source_hash": "a4242e1d543af272ba3ca66e31dcea62ead47c486b8920f817a540d124a83f00", "section_path": ["流复制和恢复"], "commit_groups": [["dc788668b"]], "identity_text": "Generate an error if recovery does not reach the specified recovery target (Leif Gunnar Erlandsen, Peter Eisentraut) Previously, a standby would promote itself upon reaching the end of WAL, even if the target was not reached.", "commit_aliases": ["dc788668b"], "source_commits": ["dc788668b"], "source_entry_id": "13.0/changes/057", "db_id": "77b80acc34a77ffea5bc5dc1b6d4bb95", "patch_ids": ["043d34097516e02b303b661eb5f157cc"], "statement_hash": "41149dd4a61e3bdf7ede3011b3776e9576e65e503f2a7a1b6e74fb33867d2c37", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-d02a302fadd64751", "cves": [], "html": "允许控制逻辑解码在溢写到磁盘之前可以使用多少内存（Tomas Vondra，Dilip Kumar，Amit Kapila）§
\n这由logical_decoding_work_mem控制。
", "text": "允许控制逻辑解码在溢写到磁盘之前可以使用多少内存（Tomas Vondra，Dilip Kumar，Amit Kapila）§ 这由logical_decoding_work_mem控制。", "title": "允许控制逻辑解码在溢写到磁盘之前可以使用多少内存", "commits": ["cec2edfa7"], "section": "流复制和恢复", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.4", "source_hash": "41a5662f166bb1635058f113c68f1c893ab8086221871e957115c781dacb8272", "section_path": ["流复制和恢复"], "commit_groups": [["cec2edfa7"]], "identity_text": "Allow control over how much memory is used by logical decoding before it is spilled to disk (Tomas Vondra, Dilip Kumar, Amit Kapila) This is controlled by guc-logical-decoding-work-mem .", "commit_aliases": ["cec2edfa7"], "source_commits": ["cec2edfa7"], "source_entry_id": "13.0/changes/058", "db_id": "7ccd917692de25d8ae4dd65d0306be35", "patch_ids": ["a532f21cdbf2e4ad880e24f2b6e4d871"], "statement_hash": "96de4a3584ba794d000c1756787dc0644dbcf908172edfb04b8958c27ac6474a", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-71f98bc622cbce98", "cves": [], "html": "允许在 WAL 引用无效页面时仍继续恢复（Fujii Masao）§
\n可以使用ignore_invalid_pages启用此功能。
", "text": "允许在 WAL 引用无效页面时仍继续恢复（Fujii Masao）§ 可以使用ignore_invalid_pages启用此功能。", "title": "允许在 WAL 引用无效页面时仍继续恢复", "commits": ["41c184bc6"], "section": "流复制和恢复", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.4", "source_hash": "6ec200812b6ad4cec0918c3f9b747705f82eb5085ba0276a1d6f5ecde78d267f", "section_path": ["流复制和恢复"], "commit_groups": [["41c184bc6"]], "identity_text": "Allow recovery to continue even if invalid pages are referenced by WAL (Fujii Masao) This is enabled using guc-ignore-invalid-pages .", "commit_aliases": ["41c184bc6"], "source_commits": ["41c184bc6"], "source_entry_id": "13.0/changes/059", "db_id": "a973ea53ebce821fb732b93cfef17dbb", "patch_ids": ["8a817a60461bc1bb19f7799d2c329690"], "statement_hash": "265a9f63d0731f9c9381933d095869d8f52f32b13691b0e87d141379cf5a4db9", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-d08d6af9ae56c8c0", "cves": [], "html": "允许 VACUUM 并行处理一个表的各个索引（Masahiko Sawada，Amit Kapila）§
新增的 PARALLEL 选项控制此行为。
允许 FETCH FIRST 使用 WITH TIES 返回与最后一个结果行的排序值相同的所有额外行（Surafel Temesgen）§
在 EXPLAIN 的 BUFFER 输出中报告规划期间的缓冲区使用情况（Julien Rouhaud）§
使 CREATE TABLE LIKE 将 CHECK 约束的 NO INHERIT 属性传递给所创建的表（Ildar Musin，Chris Travers）§
对分区表使用 LOCK TABLE 时，不检查子表上的权限（Amit Langote）§
允许向标识列插入时使用 OVERRIDING USER VALUE（Dean Rasheed）§
增加 ALTER TABLE ... DROP EXPRESSION，以允许移除列的 GENERATED 属性（Peter Eisentraut）§
修复多步骤 ALTER TABLE 命令中的缺陷（Tom Lane）§
IF NOT EXISTS 子句现在按预期工作：如果列已存在，就不会执行派生操作（例如创建索引）。另外，将相关操作合并到一条 ALTER TABLE 中的某些情况，以前无法正常工作，现在也已可用。
增加用于重命名视图列的 ALTER VIEW 语法（Fujii Masao）§
以前已经可以重命名视图列，但必须写成 ALTER TABLE RENAME COLUMN，这令人困惑。
增加 ALTER TYPE 选项，以修改基础类型的 TOAST 属性和支持函数（Tomas Vondra，Tom Lane）§
增加 CREATE DATABASE 的 LOCALE 选项（Peter Eisentraut）§
这将现有的 LC_COLLATE 和 LC_CTYPE 选项合并为单个选项。
允许 DROP DATABASE 断开正在使用目标数据库的会话，以使删除成功（Pavel Stehule，Amit Kapila）§
这通过 FORCE 选项启用。
增加结构成员 tg_updatedcols，使 C 语言更新触发器能够知道哪些列被更新（Peter Eisentraut）§
增加多态数据类型，供要求参数类型兼容的函数使用（Pavel Stehule）§
\n新增数据类型为 anycompatible、anycompatiblearray、anycompatiblenonarray 和 anycompatiblerange。
增加 SQL 数据类型 xid8，以对外提供 FullTransactionId（Thomas Munro）§
现有的 xid 数据类型只有四字节，因此不包含事务纪元。
增加数据类型 regcollation 及相关函数，以表示排序规则对象的 OID（Julien Rouhaud）§
在某些情况下使用 glibc 版本作为排序规则版本标识符（Thomas Munro）§
\n如果 glibc 版本发生变化，将发出警告，提示依赖排序规则的索引可能损坏。
", "text": "在某些情况下使用 glibc 版本作为排序规则版本标识符（Thomas Munro）§ 如果 glibc 版本发生变化，将发出警告，提示依赖排序规则的索引可能损坏。", "title": "在某些情况下使用 glibc 版本作为排序规则版本标识符", "commits": ["d5ac14f9c"], "section": "数据类型", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.6", "source_hash": "88fdf729ffed84b75085cc232b2b803d7fa7047bd499dd3d01c14c514f0c60e0", "section_path": ["数据类型"], "commit_groups": [["d5ac14f9c"]], "identity_text": "Use the glibc version in some cases as a collation version identifier (Thomas Munro) If the glibc version changes, a warning will be issued about possible corruption of collation-dependent indexes.", "commit_aliases": ["d5ac14f9c"], "source_commits": ["d5ac14f9c"], "source_entry_id": "13.0/changes/076", "db_id": "2112991b419924b3c9cce1c25a99b003", "patch_ids": ["dd8938ae23058a0c2360546e02ccde5f"], "statement_hash": "510169bca5deb6093d9d2446f57efad54e9e515e11f02d10feb2ff5aec787541", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-93a5b7a8fe2a314b", "cves": [], "html": "增加 Windows 上的排序规则版本支持（Thomas Munro）§
", "text": "增加 Windows 上的排序规则版本支持（Thomas Munro）§", "title": "增加 Windows 上的排序规则版本支持", "commits": ["352f6f2df"], "section": "数据类型", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.6", "source_hash": "f57ec1495bdec4185ecebbf0268db20021bb74709d940f241a3d6df45980796a", "section_path": ["数据类型"], "commit_groups": [["352f6f2df"]], "identity_text": "Add support for collation versions on Windows (Thomas Munro)", "commit_aliases": ["352f6f2df"], "source_commits": ["352f6f2df"], "source_entry_id": "13.0/changes/077", "db_id": "5876645bd72a51f36c3b30f431806d2d", "patch_ids": ["579e9e0e30f65b8135af1391d8f77abc"], "statement_hash": "1010e98f9be3c000eaf6586981afde64f65de803b8e85baf09fce89610b8e53f", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-dbf1c697d2a7896a", "cves": [], "html": "允许通过后缀记法提取 ROW 表达式的成员（Tom Lane）§
例如，(ROW(4, 5.0)).f1 现在返回 4。
增加 jsonb_set() 的另一个版本，改进对 NULL 的处理（Andrew Dunstan）§
新函数 jsonb_set_lax() 根据请求处理值为 NULL 的新值：将指定键设为 JSON null、删除该键、抛出异常，或返回未经修改的 jsonb 值。
增加 jsonpath 的 .datetime() 方法（Nikita Glukhov，Teodor Sigaev，Oleg Bartunov，Alexander Korotkov）§
此函数允许将 JSON 值转换为时间戳，随后即可在 jsonpath 表达式中处理这些时间戳。此项修改还增加了支持时区感知输出的 jsonpath 函数。
增加 SQL 函数 NORMALIZE()，以规范化 Unicode 字符串，并增加 IS NORMALIZED 来检查是否已规范化（Peter Eisentraut）§
为 pg_lsn 增加 min() 和 max() 聚合（Fabrízio de Royes Mello）§
这些聚合在监控查询中特别有用。
", "text": "为 pg_lsn 增加 min() 和 max() 聚合（Fabrízio de Royes Mello）§ 这些聚合在监控查询中特别有用。", "title": "为 pg_lsn 增加 min() 和 max() 聚合", "commits": ["313f87a17"], "section": "函数", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.7", "source_hash": "0db90e1d5d7f0c0d3ac48485aea537c933467addc708dcb35625ef7da45424b0", "section_path": ["函数"], "commit_groups": [["313f87a17"]], "identity_text": "Add min() and max() aggregates for pg_lsn (Fabrízio de Royes Mello) These are particularly useful in monitoring queries.", "commit_aliases": ["313f87a17"], "source_commits": ["313f87a17"], "source_entry_id": "13.0/changes/082", "db_id": "8275cf4baee9025dd4071968c61fa1a3", "patch_ids": ["1e0bf1ac81a6ea2abc9254b35d3ba621"], "statement_hash": "06932c69ae6af7967400d799d342082fcbd48cdb2c584041e9e473e7624d7aa1", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-f4d4dc34e5a3ad8a", "cves": [], "html": "允许Unicode 转义，例如 E'\\u 或 nnnn'U&'\\，指定数据库编码中可用的任何字符，即使数据库编码不是 UTF-8（Tom Lane）§nnnn'
允许 to_date() 和 to_timestamp() 识别非英语的月份名和星期名（Juan José Santamaría Flecha，Tom Lane）§
可识别的名称与 to_char() 使用相同格式模式输出的名称相同。
增加日期时间格式模式 FF1 – FF6，以指定输入或输出 1 到 6 位小数秒（Alexander Korotkov，Nikita Glukhov，Teodor Sigaev，Oleg Bartunov）§
这些模式可用于 to_char()、to_timestamp() 和 jsonpath 的 .datetime()。
增加日期时间格式模式 SSSSS，作为 SSSS 的 SQL 标准别名（Nikita Glukhov，Alexander Korotkov）§
增加函数 gen_random_uuid()，以生成版本 4 UUID（Peter Eisentraut）§
以前，UUID 生成函数只在外部模块uuid-ossp和pgcrypto中提供。
", "text": "增加函数 gen_random_uuid()，以生成版本 4 UUID（Peter Eisentraut）§ 以前，UUID 生成函数只在外部模块uuid-ossp和pgcrypto中提供。", "title": "增加函数 gen_random_uuid()，以生成版本 4 UUID", "commits": ["5925e5549"], "section": "函数", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.7", "source_hash": "ac35620caa4b27676c709d82c8aa359cfe0b27223b7a352899ce0726c2f21257", "section_path": ["函数"], "commit_groups": [["5925e5549"]], "identity_text": "Add function gen_random_uuid() to generate version-4 UUIDs (Peter Eisentraut) Previously UUID generation functions were only available in the external modules uuid-ossp and pgcrypto .", "commit_aliases": ["5925e5549"], "source_commits": ["5925e5549"], "source_entry_id": "13.0/changes/087", "db_id": "b895a2216a6fbafd2e9584a71512f72a", "patch_ids": ["008ef746edcac5ea010a7840277bc9e8"], "statement_hash": "70b08cf8aaf86d4997741eafa69741f0d4e3fbb2c9ce210f1030b44672280c08", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-e17b1dc3e662582b", "cves": [], "html": "增加最大公约数（gcd）和最小公倍数（lcm）函数（Vik Fearing）§
提高 numeric 类型的平方根（sqrt）和自然对数（ln）函数的性能与精度（Dean Rasheed）§ §
增加函数 min_scale()，返回完整精确表示 numeric 值所需的小数点右侧位数（Pavel Stehule）§
增加函数 trim_scale()，通过移除尾随零来减少 numeric 值的小数位数（Pavel Stehule）§
例如，以前只支持 point <-> line，现在 line <-> point 也可以使用。
为所有事务 ID 函数创建 xid8 版本（Thomas Munro）§
为保持向后兼容，基于 xid 的旧函数仍然存在。
允许 get_bit() 和 set_bit() 设置 bytea 值前 256MB 之外的位（Movead Li）§
增加移除对象对扩展依赖的能力（Álvaro Herrera）§
\n对象可以是函数、物化视图、索引或触发器。语法为 ALTER .. NO DEPENDS ON。
提高简单 PL/pgSQL 表达式的性能（Tom Lane，Amit Langote）§
", "text": "提高简单 PL/pgSQL 表达式的性能（Tom Lane，Amit Langote）§", "title": "提高简单 PL/pgSQL 表达式的性能", "commits": ["8f59f6b9c"], "section": "PL/pgSQL", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.8", "source_hash": "fef034fc384239ae81bc57badf4a3f53ed3f1cff36c8e4a983a925832d54f7c8", "section_path": ["PL/pgSQL"], "commit_groups": [["8f59f6b9c"]], "identity_text": "Improve performance of simple PL/pgSQL expressions (Tom Lane, Amit Langote)", "commit_aliases": ["8f59f6b9c"], "source_commits": ["8f59f6b9c"], "source_entry_id": "13.0/changes/097", "db_id": "8f89720feb19b5bdc7b3b9316bfeaed5", "patch_ids": ["5bf3da4f0c7583e8af2b90ca94950312"], "statement_hash": "da8e765a847eaaa711d902826c067d6f040dd1c5bc893875ba6ab9c96d8629e4", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-bcaf8f58a17f0e20", "cves": [], "html": "提高使用不可变表达式的 PL/pgSQL 函数的性能（Konstantin Knizhnik）§
", "text": "提高使用不可变表达式的 PL/pgSQL 函数的性能（Konstantin Knizhnik）§", "title": "提高使用不可变表达式的 PL/pgSQL 函数的性能", "commits": ["73b06cf89"], "section": "PL/pgSQL", "category": "performance", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.8", "source_hash": "e16affb9acc0e30dd9fc80152b49345f5ce62ff9abbc85520e8acdc44a88d408", "section_path": ["PL/pgSQL"], "commit_groups": [["73b06cf89"]], "identity_text": "Improve performance of PL/pgSQL functions that use immutable expressions (Konstantin Knizhnik)", "commit_aliases": ["73b06cf89"], "source_commits": ["73b06cf89"], "source_entry_id": "13.0/changes/098", "db_id": "601d18df39f6fe9eb0f6845f49fd9db6", "patch_ids": ["b28c98e3d3eb4a7bc10f2854d5f13eb9"], "statement_hash": "76c3c98ec148604f1b92b8f8214374a460a9437adb53471e998ae5aaa5cc0603", "relations": [], "version": "13.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-6404888b77813a9e", "cves": [], "html": "允许 libpq 客户端要求加密连接使用通道绑定（Jeff Davis）§
\n使用 libpq 连接参数 channel_binding，会强制 TLS 连接的另一端证明它知道用户的密码。这可以防止中间人攻击。
增加 libpq 连接参数，以控制加密连接允许的最低和最高 TLS 版本（Daniel Gustafsson）§ § §
\n这些设置为ssl_min_protocol_version和ssl_max_protocol_version。默认最低 TLS 版本为 1.2（这与以前的发行版相比是行为上的变化）。
", "text": "增加 libpq 连接参数，以控制加密连接允许的最低和最高 TLS 版本（Daniel Gustafsson）§ § § 这些设置为ssl_min_protocol_version和ssl_max_protocol_version。默认最低 TLS 版本为 1.2（这与以前的发行版相比是行为上的变化）。", "title": "增加 libpq 连接参数，以控制加密连接允许的最低和最高 TLS 版本", "commits": ["16412c784", "401aad670", "ff8ca5fad"], "section": "客户端接口", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.9", "source_hash": "35fffb26a2ce704c32ea19b3b43ba67b08b072eaa638c10eb7532c529516f44e", "section_path": ["客户端接口"], "commit_groups": [["16412c784"], ["401aad670"], ["ff8ca5fad"]], "identity_text": "Add libpq connection parameters to control the minimum and maximum TLS version allowed for an encrypted connection (Daniel Gustafsson) The settings are libpq-connect-ssl-min-protocol-version and libpq-connect-ssl-max-protocol-version . By default, the minimum TLS version is 1.2 (this represents a behavioral change from previous releases).", "commit_aliases": ["16412c784", "401aad670", "ff8ca5fad"], "source_commits": ["16412c784", "401aad670", "ff8ca5fad"], "source_entry_id": "13.0/changes/100", "db_id": "b2061230e314e9b97b573426b6bc998e", "patch_ids": ["2fb69012a9c8fc5e21c858b7ae376efc", "7ae6f7c4f45089dd492095aa73afbd08", "ccada3aceda9d729a68ab473dab9f02f"], "statement_hash": "45a565ef4e4fbe6d41bfffc7bde611fed7d3c98799a5babb8d1a496a8d7bc4b8", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-7e889dff0f79f62c-1", "cves": [], "html": "允许使用密码解锁客户端证书（Craig Ringer，Andrew Dunstan）§
\n这通过 libpq 的sslpassword连接参数启用。
", "text": "允许使用密码解锁客户端证书（Craig Ringer，Andrew Dunstan）§ 这通过 libpq 的sslpassword连接参数启用。", "title": "允许使用密码解锁客户端证书", "commits": ["4dc635521"], "section": "客户端接口", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.9", "source_hash": "8494c571bea8695d1b0b5052a4158447e415127228eb213f0a11819b329097ee", "section_path": ["客户端接口"], "commit_groups": [["4dc635521"]], "identity_text": "Allow use of passwords to unlock client certificates (Craig Ringer, Andrew Dunstan) This is enabled by libpq's libpq-connect-sslpassword connection parameter.", "commit_aliases": ["4dc635521"], "source_commits": ["4dc635521"], "source_entry_id": "13.0/changes/101", "db_id": "63d663543f6b2bad3d2cb1c709d02275", "patch_ids": ["125812cd74c1177693fadf7c4dda3015"], "statement_hash": "5d036d32a87dbf32687c88326321ca93f1c9332b0472fdfca3a20866009015aa", "relations": [{"rule": 2, "type": "related", "target": "e9eb620782f51d1813d3481eb51968a1", "evidence": {"same_day": true, "patch_ids": ["125812cd74c1177693fadf7c4dda3015"], "ambiguous_patch_ids": ["125812cd74c1177693fadf7c4dda3015"]}}], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "e9eb620782f51d1813d3481eb51968a1", "kind": "related", "version": "13.0", "label": "13.0", "title": "允许 libpq 使用 DER 编码的客户端证书", "evidence": {"same_day": true, "patch_ids": ["125812cd74c1177693fadf7c4dda3015"], "ambiguous_patch_ids": ["125812cd74c1177693fadf7c4dda3015"]}, "url": "/docs/compare/?release=13.0#13.0-7e889dff0f79f62c-2", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.9"}]}, {"id": "13.0-7e889dff0f79f62c-2", "cves": [], "html": "允许 libpq 使用 DER 编码的客户端证书（Craig Ringer，Andrew Dunstan）§
", "text": "允许 libpq 使用 DER 编码的客户端证书（Craig Ringer，Andrew Dunstan）§", "title": "允许 libpq 使用 DER 编码的客户端证书", "commits": ["4dc635521"], "section": "客户端接口", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.9", "source_hash": "c32cc10501e0cf1f1c8395892cc9123a45372885d97ab0a2a3d32dc45b57ab2a", "section_path": ["客户端接口"], "commit_groups": [["4dc635521"]], "identity_text": "Allow libpq to use DER-encoded client certificates (Craig Ringer, Andrew Dunstan)", "commit_aliases": ["4dc635521"], "source_commits": ["4dc635521"], "source_entry_id": "13.0/changes/102", "db_id": "e9eb620782f51d1813d3481eb51968a1", "patch_ids": ["125812cd74c1177693fadf7c4dda3015"], "statement_hash": "3808aa96751956de2c6fbc6a0d078638cbda3dff179a0fe4f1a19df58ae6525d", "relations": [{"rule": 2, "type": "related", "target": "63d663543f6b2bad3d2cb1c709d02275", "evidence": {"same_day": true, "patch_ids": ["125812cd74c1177693fadf7c4dda3015"], "ambiguous_patch_ids": ["125812cd74c1177693fadf7c4dda3015"]}}], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "63d663543f6b2bad3d2cb1c709d02275", "kind": "related", "version": "13.0", "label": "13.0", "title": "允许使用密码解锁客户端证书", "evidence": {"same_day": true, "patch_ids": ["125812cd74c1177693fadf7c4dda3015"], "ambiguous_patch_ids": ["125812cd74c1177693fadf7c4dda3015"]}, "url": "/docs/compare/?release=13.0#13.0-7e889dff0f79f62c-1", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.9"}]}, {"id": "13.0-632a7900ad27530a", "cves": [], "html": "修复 ecpg 的 EXEC SQL elif 指令，使其正确工作（Tom Lane）§
以前，它的行为与 endif 后跟 ifdef 相同，因此即使同一 if 结构中的前一个分支已成功匹配，也不会阻止展开 elif 分支或后续分支。
将事务状态（%x）添加到 psql 的默认提示符中（Vik Fearing）§
允许 psql 的次级提示符为空白，但与主提示符具有相同宽度（Thomas Munro）§
\n这通过将 PROMPT2 设为 %w 实现。
允许 psql 的 \\g 和 \\gx 命令只在该条命令执行期间更改 \\pset 输出选项（Tom Lane）§
此特性允许使用 \\g (expand=on) 这样的语法，它等价于 \\gx。
增加用于显示操作符类和操作符族的 psql 命令（Sergey Cherkashin，Nikita Glukhov，Alexander Korotkov）§
\n新增命令为 \\dAc、\\dAf、\\dAo 和 \\dAp。
在 psql 的 \\dt+ 及相关命令中显示表的持久性（David Fetter）§
在详细模式下，表、索引和视图的显示会指出对象是永久的、临时的，还是不记录 WAL 的。
", "text": "在 psql 的 \\dt+ 及相关命令中显示表的持久性（David Fetter）§ 在详细模式下，表、索引和视图的显示会指出对象是永久的、临时的，还是不记录 WAL 的。", "title": "在 psql 的 \\dt+ 及相关命令中显示表的持久性", "commits": ["9a2ea6183"], "section": "客户端应用程序 / psql", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.10.2", "source_hash": "e143aa743720e8199850b9442cb33349aad5c2ed60ea09213f2b0e3848b773de", "section_path": ["客户端应用程序", "psql"], "commit_groups": [["9a2ea6183"]], "identity_text": "Show table persistence in psql's \\dt+ and related commands (David Fetter) In verbose mode, the table/index/view shows if the object is permanent, temporary, or unlogged.", "commit_aliases": ["9a2ea6183"], "source_commits": ["9a2ea6183"], "source_entry_id": "13.0/changes/108", "db_id": "6f6d44f72bf0bbc1c441f9cb9a4f9c8b", "patch_ids": ["c603a6c62664bdd10f820d7ae11cff05"], "statement_hash": "8394b8907b9992d05332f0f23a67bcdca294ea0ebac95988b2ff901bf47ceee1", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-d0d90c43e9dca9f2", "cves": [], "html": "改进 psql 的 \\d 对 TOAST 表的输出（Justin Pryzby）§
修复 psql 的 \\e 命令之后的重新显示（Tom Lane）§
退出编辑器时，如果查询不以分号或 \\g 结尾，现在会显示查询缓冲区的内容。
向 psql 增加 \\warn 命令（David Fetter）§
这与 \\echo 类似，但文本发送到 stderr，而非 stdout。
将 PostgreSQL 主页添加到命令行 --help 输出中（Peter Eisentraut）§
允许 pgbench 对其 “accounts” 表进行分区（Fabien Coelho）§
\n这使分区性能测试成为可能。
", "text": "允许 pgbench 对其 “accounts” 表进行分区（Fabien Coelho）§ 这使分区性能测试成为可能。", "title": "允许 pgbench 对其 “accounts” 表进行分区", "commits": ["b1c1aa531"], "section": "客户端应用程序 / pgbench", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.10.3", "source_hash": "a5d38636a9e6c7d86c32756a19e044c8cb7ce2c7f3f5275333e9a29ece860134", "section_path": ["客户端应用程序", "pgbench"], "commit_groups": [["b1c1aa531"]], "identity_text": "Allow pgbench to partition its accounts table (Fabien Coelho) This allows performance testing of partitioning.", "commit_aliases": ["b1c1aa531"], "source_commits": ["b1c1aa531"], "source_entry_id": "13.0/changes/113", "db_id": "064e91af88fce042108cacfb8ed313c9", "patch_ids": ["c31078be79e92c2b34f4685aff171b05"], "statement_hash": "96ae3a13edacb89a470b7525d74b2cc8978d357dd34c6eb8dd596c53e97b4cfb", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-1ea069328f8d78ab", "cves": [], "html": "增加 pgbench 命令 \\aset，其行为类似 \\gset，但适用于多个查询（Fabien Coelho）§
允许 pgbench 在服务器端而非客户端生成初始数据（Fabien Coelho）§
", "text": "允许 pgbench 在服务器端而非客户端生成初始数据（Fabien Coelho）§", "title": "允许 pgbench 在服务器端而非客户端生成初始数据", "commits": ["a386942bd"], "section": "客户端应用程序 / pgbench", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.10.3", "source_hash": "43b1b8055199c7d7db103701562927f4bba23bd5cfe92ee5215dae15374c002c", "section_path": ["客户端应用程序", "pgbench"], "commit_groups": [["a386942bd"]], "identity_text": "Allow pgbench to generate its initial data server-side, rather than client-side (Fabien Coelho)", "commit_aliases": ["a386942bd"], "source_commits": ["a386942bd"], "source_entry_id": "13.0/changes/115", "db_id": "d8a049bdffb6a4c7b1af5bc4fef34349", "patch_ids": ["52d3a39512179aed4a9d17c212e850c6"], "statement_hash": "b548584f4f0145b38775c3d015075e4658c0658cd572238800b0e905f83a45dc", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-2b6a4db5d3833fc0", "cves": [], "html": "允许 pgbench 使用 --show-script 选项显示脚本内容（Fabien Coelho）§
为基础备份生成备份清单，并验证备份（Robert Haas）§ §
\n新工具pg_verifybackup可以验证备份。
", "text": "为基础备份生成备份清单，并验证备份（Robert Haas）§ § 新工具pg_verifybackup可以验证备份。", "title": "为基础备份生成备份清单，并验证备份", "commits": ["0d8c9c121", "dbc60c559"], "section": "服务器应用程序", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.11", "source_hash": "ca9a227f3c0a1556f0aa8bbb6b000c3259ec72fadc756887d5790edd6bce5ad2", "section_path": ["服务器应用程序"], "commit_groups": [["0d8c9c121"], ["dbc60c559"]], "identity_text": "Generate backup manifests for base backups, and verify them (Robert Haas) A new tool pg_verifybackup can verify backups.", "commit_aliases": ["0d8c9c121", "dbc60c559"], "source_commits": ["0d8c9c121", "dbc60c559"], "source_entry_id": "13.0/changes/117", "db_id": "7e168c434b0f06a691ace1ef649379d7", "patch_ids": ["6da64c4453212bb182dc8e0e28205bb5", "ea2237512a068d9c4709b84e1e7070f7"], "statement_hash": "7519c80336ab84aae7decbeed5a137d95c7bc7cfb62ba3410c6a0334b6455b25", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-941f448487f0103f", "cves": [], "html": "使pg_basebackup默认估计备份总大小（Fujii Masao）§
\n这一计算使 pg_stat_progress_basebackup 能够显示进度。如果不需要，可以使用 --no-estimate-size 选项禁用它。以前，只有使用 --progress 选项时才会进行这一计算。
为pg_rewind增加配置备库的选项（Paul Guo，Jimmy Yih，Ashwin Agrawal）§
\n这与pg_basebackup的 --write-recovery-conf 选项一致。
允许 pg_rewind 使用目标集群的restore_command获取所需的 WAL（Alexey Kondratov）§
\n这通过 -c/--restore-target-wal 选项启用。
使 pg_rewind 在回退之前自动运行崩溃恢复（Paul Guo，Jimmy Yih，Ashwin Agrawal）§
\n可以使用 --no-ensure-shutdown 禁用此行为。
增加 pg_waldump 报告的 PREPARE TRANSACTION 相关信息（Fujii Masao）§
增加pg_waldump选项 --quiet，以抑制非错误输出（Andres Freund，Robert Haas）§
增加pg_dump选项 --include-foreign-data，以转储外部服务器上的数据（Luis Carril）§
允许 vacuumdb 运行的清理命令以并行模式执行（Masahiko Sawada）§
\n这通过新增的 --parallel 选项启用。
允许 reindexdb 并行运行（Julien Rouhaud）§
\n并行模式通过新增的 --jobs 选项启用。
允许 dropdb 断开正在使用目标数据库的会话，以使删除成功（Pavel Stehule）§
\n这通过 -f 选项启用。
从 createuser 中移除 --adduser 和 --no-adduser（Alexander Lakhin）§
长期以来，用于此目的的推荐选项是 --superuser 和 --no-superuser。
运行 pg_upgrade 时，将pg_upgrade程序所在的目录用作默认的 --new-bindir 设置（Daniel Gustafsson）§
向文档中增加术语表（Corey Huinker，Jürgen Purtz，Roger Harkavy，Álvaro Herrera）§
", "text": "向文档中增加术语表（Corey Huinker，Jürgen Purtz，Roger Harkavy，Álvaro Herrera）§", "title": "向文档中增加术语表", "commits": ["347d2b07f"], "section": "文档", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.12", "source_hash": "37adbae3b11977d931c014ce0b77e2cd51a5b3bf71a7378b0d9c0bdb66d9dd96", "section_path": ["文档"], "commit_groups": [["347d2b07f"]], "identity_text": "Add a glossary to the documentation (Corey Huinker, Jürgen Purtz, Roger Harkavy, Álvaro Herrera)", "commit_aliases": ["347d2b07f"], "source_commits": ["347d2b07f"], "source_entry_id": "13.0/changes/130", "db_id": "2240fd9dfe6b4dc32875c5bf072b8098", "patch_ids": ["65034c8fc7cdbd3cb42d9e839ee218e2"], "statement_hash": "e1f3a24249d42323b50a6e41095e028ef548928e7787052fffa6c70ef55de59a", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-f164e1f783aacc21", "cves": [], "html": "重新编排包含函数和操作符信息的表格，使其更加清晰（Tom Lane）§
", "text": "重新编排包含函数和操作符信息的表格，使其更加清晰（Tom Lane）§", "title": "重新编排包含函数和操作符信息的表格，使其更加清晰", "commits": ["e894c6183"], "section": "文档", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.12", "source_hash": "ac7090c930e1b84faee3fcd46d2ebbe355dfddff54e7b59190df7caa0a907a7e", "section_path": ["文档"], "commit_groups": [["e894c6183"]], "identity_text": "Reformat tables containing function and operator information for better clarity (Tom Lane)", "commit_aliases": ["e894c6183"], "source_commits": ["e894c6183"], "source_entry_id": "13.0/changes/131", "db_id": "f69910a35b7439f8fa9ce317d2b9251e", "patch_ids": ["8e680b8aca8108fea9462f08ad794d90"], "statement_hash": "8ea9d80e34ddc46ed942be2a7330b98a427fa0d1fa1c650a731eab0361f4f4e4", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-01d3ad5747a4ed96", "cves": [], "html": "升级为使用 DocBook 4.5（Peter Eisentraut）§
", "text": "升级为使用 DocBook 4.5（Peter Eisentraut）§", "title": "升级为使用 DocBook 4.5", "commits": ["416c75cf3"], "section": "文档", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.12", "source_hash": "7431cf194031abf6ca9e87aff2b7d5c3c26611f265da0183921b95195615d351", "section_path": ["文档"], "commit_groups": [["416c75cf3"]], "identity_text": "Upgrade to use DocBook 4.5 (Peter Eisentraut)", "commit_aliases": ["416c75cf3"], "source_commits": ["416c75cf3"], "source_entry_id": "13.0/changes/132", "db_id": "bf061c98a7ea40e51d14c03e137e4732", "patch_ids": ["cc25551a4108902bf884d70829608d8a"], "statement_hash": "af9ec1e59738ec44bfe8a6a6764c46949be80af7475906660de5bef31cb38ef5", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-43c29a2a8f7af362", "cves": [], "html": "增加使用 Visual Studio 2019 构建的支持（Haribabu Kommi）§
", "text": "增加使用 Visual Studio 2019 构建的支持（Haribabu Kommi）§", "title": "增加使用 Visual Studio 2019 构建的支持", "commits": ["2b1394fc2"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "e2fb2e0bbca80a8de1683e4ed9189cf2cc74e044fc3d1e3430926f53fec95223", "section_path": ["源代码"], "commit_groups": [["0ce8e49b2", "2b1394fc2", "3337fd192", "721963f24", "78aaffd28", "d49c127d9", "f2d069ce9"]], "identity_text": "Add support for building on Visual Studio 2019 (Haribabu Kommi)", "commit_aliases": ["0ce8e49b2", "2b1394fc2", "3337fd192", "721963f24", "78aaffd28", "d49c127d9", "f2d069ce9"], "source_commits": ["2b1394fc2"], "source_entry_id": "13.0/changes/133", "db_id": "1db6a4dc5fd31f460b731b1b06a65ee3", "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "481b1aff61124bb29e863026ed09b4adb38f03e95ca1f3d448c868977775d623", "relations": [{"rule": 2, "type": "related", "target": "0e81425d9ba9c954cffb7949ff2b81c0", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}}, {"rule": 2, "type": "related", "target": "21e7e56d3db692178fb7d0bd54fe6e57", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}}, {"rule": 2, "type": "related", "target": "4b8c493fb7f376ba153f22dbdad54767", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}}, {"rule": 2, "type": "related", "target": "632436228109ad3b9a3483b7759ec462", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}}, {"rule": 2, "type": "related", "target": "f70b8de3c87cd0730cef6bf5df43d9ae", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}}], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "21e7e56d3db692178fb7d0bd54fe6e57", "kind": "related", "version": "11.5", "label": "11.5", "title": "支持使用 Microsoft Visual Studio 2019 构建 Postgres", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}, "url": "/docs/compare/?release=11.5#11.5-f1148e4d286e76c6", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "4b8c493fb7f376ba153f22dbdad54767", "kind": "related", "version": "10.10", "label": "10.10", "title": "支持使用 Microsoft Visual Studio 2019 构建 Postgres", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}, "url": "/docs/compare/?release=10.10#10.10-f1148e4d286e76c6", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "0e81425d9ba9c954cffb7949ff2b81c0", "kind": "related", "version": "9.6.15", "label": "9.6.15", "title": "支持用 Microsoft Visual Studio 2019 构建 Postgres", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}, "url": "/docs/compare/?release=9.6.15#9.6.15-c2b8949f97b08580", "source_url": "/docs/release/9.6.15/#id-1.11.6.14.5"}, {"db_id": "f70b8de3c87cd0730cef6bf5df43d9ae", "kind": "related", "version": "9.5.19", "label": "9.5.19", "title": "支持用 Microsoft Visual Studio 2019 构建 Postgres", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}, "url": "/docs/compare/?release=9.5.19#9.5.19-c2b8949f97b08580", "source_url": "/docs/release/9.5.19/#id-1.11.6.11.5"}, {"db_id": "632436228109ad3b9a3483b7759ec462", "kind": "related", "version": "9.4.24", "label": "9.4.24", "title": "支持用 Microsoft Visual Studio 2019 构建 Postgres", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}, "url": "/docs/compare/?release=9.4.24#9.4.24-c2b8949f97b08580", "source_url": "/docs/release/9.4.24/#id-1.11.6.7.6"}]}, {"id": "13.0-ca32fd49818d2061", "cves": [], "html": "增加 MSYS2 构建支持（Peter Eisentraut）§
", "text": "增加 MSYS2 构建支持（Peter Eisentraut）§", "title": "增加 MSYS2 构建支持", "commits": ["e975c1a60"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "6da6784a968148eba20483e3efdec1672be76123dca73d3a154de9500513ac7f", "section_path": ["源代码"], "commit_groups": [["e975c1a60"]], "identity_text": "Add build support for MSYS2 (Peter Eisentraut)", "commit_aliases": ["e975c1a60"], "source_commits": ["e975c1a60"], "source_entry_id": "13.0/changes/134", "db_id": "370f422ca6be7838ad4f7fbefcca9e00", "patch_ids": ["a222cb0a884ea510345ee54c176cd3de"], "statement_hash": "8861fe3f276b193a7729f27367de147395219662d5fc4c5ad5287a8e900b9d76", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-2544f04f14529dc1", "cves": [], "html": "为 Power PC 编译器增加 compare_exchange 和 fetch_add 的汇编代码（Noah Misch）§
", "text": "为 Power PC 编译器增加 compare_exchange 和 fetch_add 的汇编代码（Noah Misch）§", "title": "为 Power PC 编译器增加 compare_exchange 和 fetch_add 的汇编代码", "commits": ["30ee5d17c"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "255590438a184c91540dbfb26f3552d43df63b9ad061299280d2f2b98bdd1462", "section_path": ["源代码"], "commit_groups": [["30ee5d17c"]], "identity_text": "Add compare_exchange and fetch_add assembly language code for Power PC compilers (Noah Misch)", "commit_aliases": ["30ee5d17c"], "source_commits": ["30ee5d17c"], "source_entry_id": "13.0/changes/135", "db_id": "15cb8a42f97fccc83cdd627e7c6a54ef", "patch_ids": ["eef117609fcb36e5f6c4ef7593d69309"], "statement_hash": "2fad93aeacc0b91105fedb50bb3cb2a2ed163b4e9bbc7fe07873fe3d37ef4781", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-d3e33be8a08e1469", "cves": [], "html": "更新全文检索使用的 Snowball 词干分析器词典（Panagiotis Mavrogiorgos）§
\n这增加了希腊语词干提取，并改进了丹麦语和法语的词干提取。
", "text": "更新全文检索使用的 Snowball 词干分析器词典（Panagiotis Mavrogiorgos）§ 这增加了希腊语词干提取，并改进了丹麦语和法语的词干提取。", "title": "更新全文检索使用的 Snowball 词干分析器词典", "commits": ["7b925e127"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "8e99b77e06e86d319d0355af9ebad8ce515900c6a69953dd0737e953e666dd29", "section_path": ["源代码"], "commit_groups": [["7b925e127"]], "identity_text": "Update Snowball stemmer dictionaries used by full text search (Panagiotis Mavrogiorgos) This adds Greek stemming and improves Danish and French stemming.", "commit_aliases": ["7b925e127"], "source_commits": ["7b925e127"], "source_entry_id": "13.0/changes/136", "db_id": "0c3c005c0137b4f6e3f7e103610a9af9", "patch_ids": ["87fca4c3a8b8d97b0599c970f30a03f4"], "statement_hash": "454366a0ef64e015a2dd858db9bf5ea4f7611c40e672656b77f379d114432e12", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-cb7922c2dbac6d0e", "cves": [], "html": "移除对 Windows 2000 的支持（Michael Paquier）§
", "text": "移除对 Windows 2000 的支持（Michael Paquier）§", "title": "移除对 Windows 2000 的支持", "commits": ["e2e02191e"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "d826258d64a2c8f0c649e1cd3b757d7367105100a84abda2cd5a1b13817796ba", "section_path": ["源代码"], "commit_groups": [["e2e02191e"]], "identity_text": "Remove support for Windows 2000 (Michael Paquier)", "commit_aliases": ["e2e02191e"], "source_commits": ["e2e02191e"], "source_entry_id": "13.0/changes/137", "db_id": "6a1c31c14dc67c9c187a4251eb651989", "patch_ids": ["73e715ecae5c63c09956fae4bba397a4"], "statement_hash": "13839f479a004b762e41ff36cb7133d1c78d1bea4104ee6c9503902cd18826e5", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-972dfeb292bf9c24", "cves": [], "html": "移除对非 ELF 的 BSD 系统的支持（Peter Eisentraut）§
", "text": "移除对非 ELF 的 BSD 系统的支持（Peter Eisentraut）§", "title": "移除对非 ELF 的 BSD 系统的支持", "commits": ["c72f9b950"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "0ee65b16d886d8e37ac884832f4b829954d1722baed261d76e072a3ca787ddb8", "section_path": ["源代码"], "commit_groups": [["c72f9b950"]], "identity_text": "Remove support for non-ELF BSD systems (Peter Eisentraut)", "commit_aliases": ["c72f9b950"], "source_commits": ["c72f9b950"], "source_entry_id": "13.0/changes/138", "db_id": "bbd4151cda8896a6c73f9c6e165f76fa", "patch_ids": ["a0c8bd40d481c1fc24ce4a75eced5e6a"], "statement_hash": "5a6aa6ace7eaeb47a37ccd2a31f570ac010c52315807dca44ca583edc51adf6f", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-8cd8e4061be4b8f5", "cves": [], "html": "移除对 Python 2.5.X 及更早版本的支持（Peter Eisentraut）§
", "text": "移除对 Python 2.5.X 及更早版本的支持（Peter Eisentraut）§", "title": "移除对 Python 2.5.X 及更早版本的支持", "commits": ["37f21ed13"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "a5fee622f4138694914aff897cc2f3fb250aee508d28cdcf72daa7129b16adaa", "section_path": ["源代码"], "commit_groups": [["37f21ed13"]], "identity_text": "Remove support for Python versions 2.5.X and earlier (Peter Eisentraut)", "commit_aliases": ["37f21ed13"], "source_commits": ["37f21ed13"], "source_entry_id": "13.0/changes/139", "db_id": "acbb5cfb620aa45879b0b12b85775290", "patch_ids": ["12eb5ae6d1e0e8a4ebad01b5cd118bbb"], "statement_hash": "44ccd7ce3c944936a762ce3bae99bf632a27c7529b259f51e9e7e924fd763dee", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-70467a059f75fbad", "cves": [], "html": "移除对 OpenSSL 0.9.8 和 1.0.0 的支持（Michael Paquier）§
", "text": "移除对 OpenSSL 0.9.8 和 1.0.0 的支持（Michael Paquier）§", "title": "移除对 OpenSSL 0.9.8 和 1.0.0 的支持", "commits": ["7b283d0e1"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "bd03c8f1ce2eb4ba45779d5a12bc04630cdeff1432f80ea63153b061be29f221", "section_path": ["源代码"], "commit_groups": [["7b283d0e1"]], "identity_text": "Remove support for OpenSSL 0.9.8 and 1.0.0 (Michael Paquier)", "commit_aliases": ["7b283d0e1"], "source_commits": ["7b283d0e1"], "source_entry_id": "13.0/changes/140", "db_id": "e816cdaf6407b8bb526aaf8a8059439e", "patch_ids": ["5675f3e49bb5093ef339f9034032d537"], "statement_hash": "6bf158447308f0405867ba0f8e74897340e29fb76b7199dc170e9b9199389e61", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-47bc59439febf2d9", "cves": [], "html": "移除 configure 选项 --disable-float8-byval 和 --disable-float4-byval（Peter Eisentraut）§ §
这些内容曾用于兼容某些版本零 C 函数，但那些函数已不再受支持。
", "text": "移除 configure 选项 --disable-float8-byval 和 --disable-float4-byval（Peter Eisentraut）§ § 这些内容曾用于兼容某些版本零 C 函数，但那些函数已不再受支持。", "title": "移除 configure 选项 --disable-float8-byval 和 --disable-float4-byval", "commits": ["2e4db241b", "4513d8b07"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "5d4709133c6411130ae0ae01c76fb76a6a21dec287fc4e0f0418e01acaf48536", "section_path": ["源代码"], "commit_groups": [["2e4db241b"], ["4513d8b07"]], "identity_text": "Remove configure options --disable-float8-byval and --disable-float4-byval (Peter Eisentraut) These were needed for compatibility with some version-zero C functions, but those are no longer supported.", "commit_aliases": ["2e4db241b", "4513d8b07"], "source_commits": ["2e4db241b", "4513d8b07"], "source_entry_id": "13.0/changes/141", "db_id": "c1b496f2458af3a94ba223eff21c1362", "patch_ids": ["585b70c91cf2f1c95454b7ac7e9fed04", "84ce571e5a93a239d3cc7d06a19e8edd"], "statement_hash": "d38171c935857423547798c35f561acd76586d907b9023259abd4ecd4f7e05df", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-d5c5dbf4056c38b3", "cves": [], "html": "将查询字符串传递给规划器钩子函数（Pascal Legrand，Julien Rouhaud）§
", "text": "将查询字符串传递给规划器钩子函数（Pascal Legrand，Julien Rouhaud）§", "title": "将查询字符串传递给规划器钩子函数", "commits": ["6aba63ef3"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "6c15c7562ae972bac196cf42835ba1f7719a21b5890d44a681c6f2ce6a14e1ab", "section_path": ["源代码"], "commit_groups": [["6aba63ef3"]], "identity_text": "Pass the query string to planner hook functions (Pascal Legrand, Julien Rouhaud)", "commit_aliases": ["6aba63ef3"], "source_commits": ["6aba63ef3"], "source_entry_id": "13.0/changes/142", "db_id": "dc6fed588e14e6d9c861d11ef45909a3", "patch_ids": ["5218616d82ff64d233870e404adfee5c"], "statement_hash": "a450489572fa0be4d6e23b5cdf965953ef61bbc532c33e5338618484d58a3952", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-0000ae20363b4ea6", "cves": [], "html": "增加 TRUNCATE 命令钩子（Yuli Khodorkovskiy）§
增加 TLS 初始化钩子（Andrew Dunstan）§
", "text": "增加 TLS 初始化钩子（Andrew Dunstan）§", "title": "增加 TLS 初始化钩子", "commits": ["896fcdb23"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "1256699ad51ed30cf523d556a7b44d675945090135410d2789d9cf92dc7506ac", "section_path": ["源代码"], "commit_groups": [["896fcdb23"]], "identity_text": "Add TLS init hook (Andrew Dunstan)", "commit_aliases": ["896fcdb23"], "source_commits": ["896fcdb23"], "source_entry_id": "13.0/changes/144", "db_id": "7924824da56b15ba8ad07d040c105e52", "patch_ids": ["59f92279b9435b581feb8f5e6f0b8ca6"], "statement_hash": "b7bb72c21c01704790b65028ad5b683adbda8b01d0aa1b792dfccfd01daac91a", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-6e6a37a416507205", "cves": [], "html": "允许在不预定义 Unix 域套接字目录的情况下构建（Peter Eisentraut）§
", "text": "允许在不预定义 Unix 域套接字目录的情况下构建（Peter Eisentraut）§", "title": "允许在不预定义 Unix 域套接字目录的情况下构建", "commits": ["a9cff89f7"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "71b20597c6eaf4d27a7663159269e3f4847522c4e6d9865c99cb76b460c4b566", "section_path": ["源代码"], "commit_groups": [["a9cff89f7"]], "identity_text": "Allow building with no predefined Unix-domain socket directory (Peter Eisentraut)", "commit_aliases": ["a9cff89f7"], "source_commits": ["a9cff89f7"], "source_entry_id": "13.0/changes/145", "db_id": "e330e1db883ac8c39801eb2c59c34ea4", "patch_ids": ["c701d482df08c3651cec820cef231962"], "statement_hash": "9301f64264dc830d6b2ea15780df4a01191dac3d5d3248b9877e38473f998bec", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-8ea52b99bc827607", "cves": [], "html": "降低 Unix 平台上 SysV 资源键冲突的概率（Tom Lane）§
", "text": "降低 Unix 平台上 SysV 资源键冲突的概率（Tom Lane）§", "title": "降低 Unix 平台上 SysV 资源键冲突的概率", "commits": ["7de19fbc0"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "9a7f57141b86bd7a614154dc366ed846cd039386427dd4b1fd50a1ad5aa9b073", "section_path": ["源代码"], "commit_groups": [["7de19fbc0"]], "identity_text": "Reduce the probability of SysV resource key collision on Unix platforms (Tom Lane)", "commit_aliases": ["7de19fbc0"], "source_commits": ["7de19fbc0"], "source_entry_id": "13.0/changes/146", "db_id": "07e16210a12341289ce3fe2be7322aba", "patch_ids": ["2dbfea94d296ec2e8807f887d180bb9d"], "statement_hash": "4cd5308e87b99af23099513276a18d63676ce880fc435fae7b4e519b7c6f392c", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-8e20d7979e06ff21", "cves": [], "html": "使用操作系统函数可靠地擦除包含敏感信息的内存（Peter Eisentraut）§
\n例如，可用它清除存储在内存中的密码。
", "text": "使用操作系统函数可靠地擦除包含敏感信息的内存（Peter Eisentraut）§ 例如，可用它清除存储在内存中的密码。", "title": "使用操作系统函数可靠地擦除包含敏感信息的内存", "commits": ["74a308cf5"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "51c505a954d65e7c2a216353d0dd8ae47515d27123f41329eb7eb5d5073632b0", "section_path": ["源代码"], "commit_groups": [["74a308cf5"]], "identity_text": "Use operating system functions to reliably erase memory that contains sensitive information (Peter Eisentraut) For example, this is used for clearing passwords stored in memory.", "commit_aliases": ["74a308cf5"], "source_commits": ["74a308cf5"], "source_entry_id": "13.0/changes/147", "db_id": "09341b3c48612368dc02e043f6c89402", "patch_ids": ["7a43a16c83f9718468bbad7ec76fe898"], "statement_hash": "d0165d965bce608050bd67ef9b1c375bb4242840595bed14a3b8ca5df919290e", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-60aa1b2b38a37e5d", "cves": [], "html": "增加 headerscheck 脚本以测试 C 头文件的兼容性（Tom Lane）§
将内部列表实现为数组，而不再采用单元链表（Tom Lane）§
\n这提高了访问大量对象的查询的性能。
", "text": "将内部列表实现为数组，而不再采用单元链表（Tom Lane）§ 这提高了访问大量对象的查询的性能。", "title": "将内部列表实现为数组，而不再采用单元链表", "commits": ["1cff1b95a"], "section": "源代码", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13", "source_hash": "97379c0a18578f43de9968e4883627e462d1cb65a0af79b9b24b09b775fc4a02", "section_path": ["源代码"], "commit_groups": [["1cff1b95a"]], "identity_text": "Implement internal lists as arrays, rather than a chain of cells (Tom Lane) This improves performance for queries that access many objects.", "commit_aliases": ["1cff1b95a"], "source_commits": ["1cff1b95a"], "source_entry_id": "13.0/changes/149", "db_id": "6c0132cf968ad5627ce8cd83f77457a0", "patch_ids": ["208c2f9eb2b7167d3fa9173057b469c3"], "statement_hash": "caf9801dd9b374f965a91b2f2c196ad9579a47681d86dc3192a2504080f17611", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-d438a0e2943979f6", "cves": [], "html": "修改 TS_execute() 的 API（Tom Lane，Pavel Borisov）§ §
TS_execute 回调现在必须提供三值（是、否、可能）逻辑。现在默认准确计算 NOT 查询。
拥有数据库级 CREATE 权限的用户，即使不是超级用户，也可以在数据库中安装这类扩展。此项修改还移除了 pg_pltemplate 系统目录。
允许非超级用户不使用密码就连接到postgres_fdw外部服务器（Craig Ringer）§
\n具体来说，允许超级用户将某个用户映射的 password_required 设置为 false。仍须注意防止非超级用户使用超级用户凭据连接到外部服务器。
允许 postgres_fdw 使用证书认证（Craig Ringer）§
\n不同用户可以使用不同证书。
", "text": "允许 postgres_fdw 使用证书认证（Craig Ringer）§ 不同用户可以使用不同证书。", "title": "允许 postgres_fdw 使用证书认证", "commits": ["f5fd995a1"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.14", "source_hash": "cc4fc45a4787970a479564d80749f8893fc09523c3b03ed0c0e8bd04b3f232db", "section_path": ["附加模块"], "commit_groups": [["f5fd995a1"]], "identity_text": "Allow postgres_fdw to use certificate authentication (Craig Ringer) Different users can use different certificates.", "commit_aliases": ["f5fd995a1"], "source_commits": ["f5fd995a1"], "source_entry_id": "13.0/changes/153", "db_id": "e3157a621bfc4b0e48d8d1968be62a5d", "patch_ids": ["fb541ac14495efce2c844284cdb033bc"], "statement_hash": "2882d2fb2887bd01d52ce7612ecb61c312d203d5b8733db1f9e8edcde7dabc04", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-b7c34f1acd2466d6", "cves": [], "html": "允许sepgsql控制对 TRUNCATE 命令的访问（Yuli Khodorkovskiy）§
增加扩展bool_plperl，以在 SQL 布尔值和 PL/Perl 布尔值之间进行双向转换（Ivan Panchenko）§
", "text": "增加扩展bool_plperl，以在 SQL 布尔值和 PL/Perl 布尔值之间进行双向转换（Ivan Panchenko）§", "title": "增加扩展bool_plperl，以在 SQL 布尔值和 PL/Perl 布尔值之间进行双向转换", "commits": ["36058a3c5"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.14", "source_hash": "5d7cfef8f8ee67a8e6325180eba4c6d0cead7c1a497accc70f96c11a80ca24f8", "section_path": ["附加模块"], "commit_groups": [["36058a3c5"]], "identity_text": "Add extension bool_plperl which transforms SQL booleans to/from PL/Perl booleans (Ivan Panchenko)", "commit_aliases": ["36058a3c5"], "source_commits": ["36058a3c5"], "source_entry_id": "13.0/changes/155", "db_id": "e2a47dde31dcea2d1e8e1f21c50dfb94", "patch_ids": ["8e7fa16296712d228a9d562996648c1b"], "statement_hash": "cc15f6c126ea53e9687f3eac3e78edfdf3754da6f74d3ef398b75e15140dcf57", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-ca38fa185a19eba9", "cves": [], "html": "使pg_stat_statements将 SELECT ... FOR UPDATE 命令与不带 FOR UPDATE 的命令分别处理（Andrew Gierth，Vik Fearing）§
允许 pg_stat_statements 选择性地跟踪语句的规划时间（Julien Rouhaud，Pascal Legrand，Thomas Munro，Fujii Masao）§ §
\n以前只跟踪执行时间。
", "text": "允许 pg_stat_statements 选择性地跟踪语句的规划时间（Julien Rouhaud，Pascal Legrand，Thomas Munro，Fujii Masao）§ § 以前只跟踪执行时间。", "title": "允许 pg_stat_statements 选择性地跟踪语句的规划时间", "commits": ["17e032822", "8d459762b"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.14", "source_hash": "c43392615420cb2e615056351f336ea6c7dc56e7c5e8997893d81c200cf544e9", "section_path": ["附加模块"], "commit_groups": [["17e032822"], ["8d459762b"]], "identity_text": "Allow pg_stat_statements to optionally track the planning time of statements (Julien Rouhaud, Pascal Legrand, Thomas Munro, Fujii Masao) Previously only execution time was tracked.", "commit_aliases": ["17e032822", "8d459762b"], "source_commits": ["17e032822", "8d459762b"], "source_entry_id": "13.0/changes/157", "db_id": "5d4c20dbfae566a19499635a43943294", "patch_ids": ["2c5084b85da3e647e08bfdd0949d7ed1", "3ce97064db6107eb46a4cf9416f445a9"], "statement_hash": "798ac47e4ca60267a53260d14a1e9913cd7f7e515021e697ad83c33bd0757327", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-e5d101191efbc29b", "cves": [], "html": "全面修改ltree的 lquery 语法，使其对 NOT（!）的处理更符合逻辑（Filip Rembialkowski，Tom Lane，Nikita Glukhov）§ §
另外，允许非 * 查询使用数值范围（{}）指定匹配次数。
", "text": "全面修改ltree的 lquery 语法，使其对 NOT（!）的处理更符合逻辑（Filip Rembialkowski，Tom Lane，Nikita Glukhov）§ § 另外，允许非 * 查询使用数值范围（{}）指定匹配次数。", "title": "全面修改ltree的 lquery 语法，使其对 NOT（!）的处理更符合逻辑", "commits": ["17ca06799", "70dc4c509"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.14", "source_hash": "3eee185aa8d93d9282095b18b9316f7b73ba6839ea6e2c88446538346894583f", "section_path": ["附加模块"], "commit_groups": [["17ca06799"], ["70dc4c509"]], "identity_text": "Overhaul ltree 's lquery syntax to treat NOT (!) more logically (Filip Rembialkowski, Tom Lane, Nikita Glukhov) Also allow non-* queries to use a numeric range ({}) of matches.", "commit_aliases": ["17ca06799", "70dc4c509"], "source_commits": ["17ca06799", "70dc4c509"], "source_entry_id": "13.0/changes/158", "db_id": "70f81e7572d95dace13b3cf504b4612c", "patch_ids": ["6925289a401f13c6df7995360bded879", "d3dd33143ab2863e9c9673bc18a6bc05"], "statement_hash": "22365ce49d9c77f4f74a8efeee702a7f2f3d8158b6a80d4b51553a56a5072bd4", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-6c3865bd757acf5a", "cves": [], "html": "增加ltree、lquery 和 ltxtquery 类型的二进制 I/O 支持（Nino Floris）§
", "text": "增加ltree、lquery 和 ltxtquery 类型的二进制 I/O 支持（Nino Floris）§", "title": "增加ltree、lquery 和 ltxtquery 类型的二进制 I/O 支持", "commits": ["949a9f043"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.14", "source_hash": "21d3f497c9f17a1198f45b40c83c86511179765bf400809fc71e0789bf05bbf9", "section_path": ["附加模块"], "commit_groups": [["949a9f043"]], "identity_text": "Add support for binary I/O of ltree , lquery, and ltxtquery types (Nino Floris)", "commit_aliases": ["949a9f043"], "source_commits": ["949a9f043"], "source_entry_id": "13.0/changes/159", "db_id": "2671eb7c64d86775cff93261b04c61a0", "patch_ids": ["58c90a47b20b30cbcdc987c0dd4dea07"], "statement_hash": "6cf5e2ef1d7ae0753b1505cd03dc1c8b90725578d183f98e930b79a1612dafe2", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-ad3e0a0cf22c6630", "cves": [], "html": "为dict_int增加忽略整数符号的选项（Jeff Janes）§
", "text": "为dict_int增加忽略整数符号的选项（Jeff Janes）§", "title": "为dict_int增加忽略整数符号的选项", "commits": ["806eb92c0"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.14", "source_hash": "44bf0ca73b1b426d259e70056de603377ec83ecfe4fddd49345ea64cf59bf5e1", "section_path": ["附加模块"], "commit_groups": [["806eb92c0"]], "identity_text": "Add an option to dict-int to ignore the sign of integers (Jeff Janes)", "commit_aliases": ["806eb92c0"], "source_commits": ["806eb92c0"], "source_entry_id": "13.0/changes/160", "db_id": "44aabb206a20b32186ddf62c0b047a9b", "patch_ids": ["b3f5128246ff6f4045eb16bb3fab2076"], "statement_hash": "d37349f2a1060cb9cd7cb657bab11feb78f1f88693590c956c14e3f28735beda", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.0-0c6beecc75a6005c", "cves": [], "html": "增加adminpack函数 pg_file_sync()，以允许对文件执行 fsync（Fujii Masao）§
增加pageinspect函数，以人类可读的格式输出 t_infomask/t_infomask2 值（Craig Ringer，Sawada Masahiko，Michael Paquier）§ §
向 pageinspect 输出添加 B-树索引去重处理相关列（Peter Geoghegan）§
", "text": "向 pageinspect 输出添加 B-树索引去重处理相关列（Peter Geoghegan）§", "title": "向 pageinspect 输出添加 B-树索引去重处理相关列", "commits": ["93ee38ead"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.14", "source_hash": "cbb64b3dff00a5a6fc40e97c9d55296797e5a1b0cebc0f81918e7188054c0b7b", "section_path": ["附加模块"], "commit_groups": [["93ee38ead"]], "identity_text": "Add B-tree index de-duplication processing columns to pageinspect output (Peter Geoghegan)", "commit_aliases": ["93ee38ead"], "source_commits": ["93ee38ead"], "source_entry_id": "13.0/changes/163", "db_id": "041795569921cacf25aa797cddc22cad", "patch_ids": ["393828c4dc0d508952768c2ef5de29bc"], "statement_hash": "a98a59c909ab09b9d13421b88dad7f90614afedfff6b88fb5e421a44baa4894f", "relations": [], "version": "13.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}]}], "stats": [{"key": "all", "label": "全部变更", "count": 178}, {"key": "feature", "label": "新功能", "count": 143}, {"key": "bugfix", "label": "BUG 修复", "count": 4}, {"key": "security", "label": "安全相关", "count": 0}, {"key": "performance", "label": "性能改进", "count": 16}, {"key": "compatibility", "label": "兼容性变化", "count": 15}, {"key": "improvement", "label": "其他改进", "count": 0}], "total": 178, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 178, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}