对于希望从任何以前的版本迁移数据的人来说，需要使用pg_dumpall进行转储/恢复，或者使用pg_upgrade或逻辑复制。有关迁移到新主要版本的通用信息，请参阅第 18.6 节。
\n版本 18 包含许多可能影响与以前版本兼容性的更改。请注意以下不兼容项：
\n对于希望从任何以前的版本迁移数据的人来说，需要使用pg_dumpall进行转储/恢复，或者使用pg_upgrade或逻辑复制。有关迁移到新主要版本的通用信息，请参阅第 18.6 节。
\n版本 18 包含许多可能影响与以前版本兼容性的更改。请注意以下不兼容项：
\n将initdb默认更改为启用数据校验和（Greg Sabino Mullane）§
\n可以使用新的 initdb 选项 --no-data-checksums 禁用校验和。pg_upgrade要求匹配集簇校验和设置，因此这个新选项对于升级不带校验和的旧集簇很有用。
更改时区缩写处理（Tom Lane）§
\n系统现在将优先考虑当前会话的时区缩写，然后检查服务器变量timezone_abbreviations。以前是先检查 timezone_abbreviations。
对 MD5 密码的支持将在未来的主要版本中移除。CREATE ROLE和ALTER ROLE现在在设置 MD5 密码时会发出弃用警告。可以通过将md5_password_warnings参数设置为 off 来禁用这些警告。
更改VACUUM和ANALYZE以处理父表的继承子表（Michael Harris）§
\n可以使用新的 ONLY 选项执行以前的行为。
防止 COPY FROM 在读取 CSV 文件时将 \\. 视为文件结束标记（Daniel Vérité, Tom Lane）§ §
psql在从 STDIN 读取 CSV 文件时仍会将 \\. 视为文件结束标记。较旧的 psql 客户端连接到 PostgreSQL 18 服务器时，可能会在 \\copy 上遇到问题。此版本还强制要求 \\. 必须单独出现在一行中。
禁止不记录 WAL 的分区表（Michael Paquier）§
\n以前 ALTER TABLE SET [UN]LOGGED 不执行任何操作，并且创建不记录 WAL 的分区表也不会导致其子表不记录 WAL。
让 AFTER 触发器以触发器事件排队时处于活动状态的角色身份执行（Laurenz Albe）§
以前，此类触发器以执行时（例如，在COMMIT时）处于活动状态的角色身份运行。这对于在排队时间和事务提交之间角色发生变化的情况很重要。
", "text": "让 AFTER 触发器以触发器事件排队时处于活动状态的角色身份执行（Laurenz Albe）§ 以前，此类触发器以执行时（例如，在COMMIT时）处于活动状态的角色身份运行。这对于在排队时间和事务提交之间角色发生变化的情况很重要。", "title": "让 AFTER 触发器以触发器事件排队时处于活动状态的角色身份执行", "commits": ["01463e1cc"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/18.0/#RELEASE-18-MIGRATION", "source_hash": "f10785acbe9b26f28a8c98e9a00c1d2a4e8afa8c0b7f7291f990211dfc079f53", "section_path": ["兼容性"], "commit_groups": [["01463e1cc"]], "identity_text": "Execute AFTER triggers as the role that was active when trigger events were queued (Laurenz Albe) Previously such triggers were run as the role that was active at trigger execution time (e.g., at sql-commit ). This is significant for cases where the role is changed between queue time and transaction commit.", "commit_aliases": ["01463e1cc"], "source_commits": ["01463e1cc"], "source_entry_id": "18.0/migration/007", "db_id": "ae8521434650fe5524c9fcaa38acac84", "patch_ids": ["917ba717810e74a1c7c638690cf0f5eb"], "statement_hash": "f0612c07183e11ac71073f5d359d3b0a521ebcc0822d94befe83c23059d03016", "relations": [], "version": "18.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-607cc591e9d82ae8", "cves": [], "html": "移除GRANT/REVOKE中不起作用的规则权限支持（Fujii Masao）§
\n这些权限自 PostgreSQL 8.2 起就已不起作用。
", "text": "移除GRANT/REVOKE中不起作用的规则权限支持（Fujii Masao）§ 这些权限自 PostgreSQL 8.2 起就已不起作用。", "title": "移除GRANT/REVOKE中不起作用的规则权限支持", "commits": ["fefa76f70"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/18.0/#RELEASE-18-MIGRATION", "source_hash": "db08cd3d3ddd023cec8d6165fd052ba6e7d655cc958d6c238b6f02af024dc1a1", "section_path": ["兼容性"], "commit_groups": [["fefa76f70"]], "identity_text": "Remove non-functional support for rule privileges in sql-grant / sql-revoke (Fujii Masao) These have been non-functional since PostgreSQL 8.2.", "commit_aliases": ["fefa76f70"], "source_commits": ["fefa76f70"], "source_entry_id": "18.0/migration/008", "db_id": "421b9236b8ba45e9981de4acb0936336", "patch_ids": ["1a39a92752613c9674e39e99f119c2de"], "statement_hash": "9a9f6ec57f00ae867aca818ec5c55d43899650a49ee6ab2ce0bed4d154bb41b9", "relations": [], "version": "18.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-558a645d00b3f47b", "cves": [], "html": "移除列 pg_backend_memory_contexts.parent（Melih Mutlu）§
由于添加了 pg_backend_memory_contexts.path，不再需要此列。
将 pg_backend_memory_contexts.level 和 pg_log_backend_memory_contexts() 更改为从1开始（Melih Mutlu, Atsushi Torikoshi, David Rowley, Fujii Masao）§ § §
这些以前是从零开始的。
", "text": "将 pg_backend_memory_contexts.level 和 pg_log_backend_memory_contexts() 更改为从1开始（Melih Mutlu, Atsushi Torikoshi, David Rowley, Fujii Masao）§ § § 这些以前是从零开始的。", "title": "将 pg_backend_memory_contexts.level 和 pg_log_backend_memory_contexts() 更改为从1开始", "commits": ["32d3ed816", "706cbed35", "d9e03864b"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/18.0/#RELEASE-18-MIGRATION", "source_hash": "50bbd1729e746a694a3df7d491e7ab79d0b57696ebbb5127fdc124520b03ee7c", "section_path": ["兼容性"], "commit_groups": [["32d3ed816"], ["706cbed35"], ["d9e03864b"]], "identity_text": "Change pg_backend_memory_contexts.level and pg_log_backend_memory_contexts() to be one-based (Melih Mutlu, Atsushi Torikoshi, David Rowley, Fujii Masao) These were previously zero-based.", "commit_aliases": ["32d3ed816", "706cbed35", "d9e03864b"], "source_commits": ["32d3ed816", "706cbed35", "d9e03864b"], "source_entry_id": "18.0/migration/010", "db_id": "b8c57d935d8b183f9ee20e7477f90abd", "patch_ids": ["3d61500ab7649ba207c5b4742ce83946", "845864cc388c5f840e08c3fdf9f3032a", "eaa8db2e49e44f9880c123bf159cab42"], "statement_hash": "c56bfdda9e9b110545ab282f1be71da486fd1e7af030b2a5c125fe4d37560c98", "relations": [{"rule": 2, "type": "related", "target": "7ed5d279df474d7ce518a2cd605d091d", "evidence": {"same_day": true, "patch_ids": ["eaa8db2e49e44f9880c123bf159cab42"]}}], "version": "18.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": [{"db_id": "7ed5d279df474d7ce518a2cd605d091d", "kind": "related", "version": "18.0", "label": "18.0", "title": "添加列 pg_backend_memory_contexts.path 以显示内存上下文父级", "evidence": {"same_day": true, "patch_ids": ["eaa8db2e49e44f9880c123bf159cab42"]}, "url": "/docs/compare/?release=18.0#18.0-dab03b5c77d56e2b", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING"}]}, {"id": "18.0-63b962f0125472b6", "cves": [], "html": "更改全文检索，使其使用数据库集簇默认排序规则提供程序来读取配置文件和词典，而不再始终使用 libc（Peter Eisentraut）§
\n如果数据库集簇默认使用的非 libc 排序规则提供程序（例如 ICU、builtin）对 LC_CTYPE 所处理字符的处理方式与 libc 不同，那么某些全文检索函数以及pg_trgm扩展的行为可能会发生变化。使用pg_upgrade升级此类数据库集簇时，建议在升级后重新索引所有与全文检索和pg_trgm相关的索引。
", "text": "更改全文检索，使其使用数据库集簇默认排序规则提供程序来读取配置文件和词典，而不再始终使用 libc（Peter Eisentraut）§ 如果数据库集簇默认使用的非 libc 排序规则提供程序（例如 ICU、builtin）对 LC_CTYPE 所处理字符的处理方式与 libc 不同，那么某些全文检索函数以及pg_trgm扩展的行为可能会发生变化。使用pg_upgrade升级此类数据库集簇时，建议在升级后重新索引所有与全文检索和pg_trgm相关的索引。", "title": "更改全文检索，使其使用数据库集簇默认排序规则提供程序来读取配置文件和词典，而不再始终使用 libc", "commits": ["fb1a18810f0"], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/18.0/#RELEASE-18-MIGRATION", "source_hash": "e3ce56b4fc2a72cd171306a24ddd0b8daecb530f1409e98a57781871e32f9519", "section_path": ["兼容性"], "commit_groups": [["fb1a18810f0"]], "identity_text": "Change full text search to use the default collation provider of the cluster to read configuration files and dictionaries, rather than always using libc (Peter Eisentraut) Clusters that default to non-libc collation providers (e.g., ICU, builtin) that behave differently than libc for characters processed by LC_CTYPE could observe changes in behavior of some full-text search functions, as well as the pgtrgm extension. When upgrading such clusters using pgupgrade , it is recommended to reindex all indexes related to full-text search and pg_trgm after the upgrade.", "commit_aliases": ["fb1a18810f0"], "source_commits": ["fb1a18810f0"], "source_entry_id": "18.0/migration/011", "db_id": "14f7ec96f489178a5ba54f0173a2002a", "patch_ids": ["d34589a0ca33552be8913ecb392dc365"], "statement_hash": "0d016706c1da5d040bed5653360eaa27ed050c9172ff53f737e1221153008011", "relations": [], "version": "18.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-cd59818e7d0a3dc5", "cves": [], "html": "自动删除一些不必要的表自连接（Andrey Lepikhov, Alexander Kuzmenkov, Alexander Korotkov, Alena Rybakina）§
\n可以使用服务器变量enable_self_join_elimination禁用此优化。
", "text": "自动删除一些不必要的表自连接（Andrey Lepikhov, Alexander Kuzmenkov, Alexander Korotkov, Alena Rybakina）§ 可以使用服务器变量enable_self_join_elimination禁用此优化。", "title": "自动删除一些不必要的表自连接", "commits": ["fc069a3a6"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "40c3196e66530b1ad6c86357db78c6683c075a289ecc4fdc11ccdd15d42dafad", "section_path": ["服务器", "优化器"], "commit_groups": [["fc069a3a6"]], "identity_text": "Automatically remove some unnecessary table self-joins (Andrey Lepikhov, Alexander Kuzmenkov, Alexander Korotkov, Alena Rybakina) This optimization can be disabled using server variable guc-enable-self-join-elimination .", "commit_aliases": ["fc069a3a6"], "source_commits": ["fc069a3a6"], "source_entry_id": "18.0/changes/001", "db_id": "e93aac468afc7b983da5961bc89a6570", "patch_ids": ["f4668f24b918872b344ea179b57163cf"], "statement_hash": "235c5aa78ae11057e82ffcaba18192f08d816b80c7a4abeb2ccab576de5173f7", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-d69dbbb16cde79f1", "cves": [], "html": "将一些 IN (VALUES ...) 转换为 x = ANY ... 以获得更好的优化器统计信息（Alena Rybakina, Andrei Lepikhov）§
允许将 OR 子句转换为数组以加快索引处理（Alexander Korotkov, Andrey Lepikhov）§
加快 INTERSECT、EXCEPT、窗口聚合和视图列别名的处理速度（Tom Lane, David Rowley）§ § § §
允许 SELECT DISTINCT 的键在内部重新排序以避免排序（Richard Guo）§
可以使用enable_distinct_reordering禁用此优化。
", "text": "允许 SELECT DISTINCT 的键在内部重新排序以避免排序（Richard Guo）§ 可以使用enable_distinct_reordering禁用此优化。", "title": "允许 SELECT DISTINCT 的键在内部重新排序以避免排序", "commits": ["a8ccf4e93"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "0b3d9b69f68103fec0e196e120de31d7d5ccbd1c26beea05060ff6a886ab9130", "section_path": ["服务器", "优化器"], "commit_groups": [["a8ccf4e93"]], "identity_text": "Allow the keys of SELECT DISTINCT to be internally reordered to avoid sorting (Richard Guo) This optimization can be disabled using guc-enable-distinct-reordering .", "commit_aliases": ["a8ccf4e93"], "source_commits": ["a8ccf4e93"], "source_entry_id": "18.0/changes/005", "db_id": "e1633e7353cb2e283e589f245c02709b", "patch_ids": ["2a4dc17b68562e6259b7bb1052fff9ad"], "statement_hash": "8e10ed699456a43e5c53f99fc9ddb0ec2951686ee8551c8e706fbd1d1b10766c", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-41f66034d93a7cf1", "cves": [], "html": "忽略功能上依赖于其他列的 GROUP BY 列（Zhang Mingli, Jian He, David Rowley）§
如果 GROUP BY 子句包含唯一索引的所有列以及同一表的其他列，则这些其他列是冗余的，可以从分组中删除。对于非延迟主键，这已经成立。
允许将作用于 GROUPING SETS 的某些 HAVING 子句下推到 WHERE 子句（Richard Guo）§ § § §
这允许更早地进行行过滤。此版本还修复了一些以前返回不正确结果的 GROUPING SETS 查询。
改进 generate_series() 使用 numeric 和 timestamp 值时的行数估计（David Rowley, Song Jinzhou）§ §
允许优化器使用 Right Semi Join 计划（Richard Guo）§
半连接用于查找是否存在至少一个匹配项。
", "text": "允许优化器使用 Right Semi Join 计划（Richard Guo）§ 半连接用于查找是否存在至少一个匹配项。", "title": "允许优化器使用 Right Semi Join 计划", "commits": ["aa86129e1"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "619b5f1bfc705891d795ac9ab763f6362d300120b9a2d649250a5fb0fe617a45", "section_path": ["服务器", "优化器"], "commit_groups": [["aa86129e1"]], "identity_text": "Allow the optimizer to use Right Semi Join plans (Richard Guo) Semi-joins are used when needing to find if there is at least one match.", "commit_aliases": ["aa86129e1"], "source_commits": ["aa86129e1"], "source_entry_id": "18.0/changes/009", "db_id": "f76a8468845b91ddcffeaa33fa3400a0", "patch_ids": ["79e6e1842e88c7f535ade4eaba7be513"], "statement_hash": "117c31abccc7e061fab7475bec0bdf75e420f53925d5e95de87e71dad3cea951", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-b111a6a6d4309764", "cves": [], "html": "", "text": "允许合并连接使用增量排序（Richard Guo）§", "title": "允许合并连接使用增量排序", "commits": ["828e94c9d"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "232faeb186a197cb2d471ce89d7969bca2593ea44e545f90f86f5ec9974800b1", "section_path": ["服务器", "优化器"], "commit_groups": [["828e94c9d"]], "identity_text": "Allow merge joins to use incremental sorts (Richard Guo)", "commit_aliases": ["828e94c9d"], "source_commits": ["828e94c9d"], "source_entry_id": "18.0/changes/010", "db_id": "7e8d7bcff75eca9f6d3794b3ed0388fb", "patch_ids": ["22cb8f9f6594048e5c90b7c0a948ea39"], "statement_hash": "c730545e91cae06688ba34e2ac9097a5800e1f311eaa283af2f272f7a1ac2767", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-d6e730c654f94a8c", "cves": [], "html": "提高访问多个分区的查询规划效率（Ashutosh Bapat, Yuya Watari, David Rowley）§ §
", "text": "提高访问多个分区的查询规划效率（Ashutosh Bapat, Yuya Watari, David Rowley）§ §", "title": "提高访问多个分区的查询规划效率", "commits": ["88f55bc97", "d69d45a5a"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "7cec6b7a3c4b0b96689bd0d68404844c350a00677ea88e38b124b1582f228d77", "section_path": ["服务器", "优化器"], "commit_groups": [["88f55bc97"], ["d69d45a5a"]], "identity_text": "Improve the efficiency of planning queries accessing many partitions (Ashutosh Bapat, Yuya Watari, David Rowley)", "commit_aliases": ["88f55bc97", "d69d45a5a"], "source_commits": ["88f55bc97", "d69d45a5a"], "source_entry_id": "18.0/changes/011", "db_id": "6365c622e7f4156b307f731e72d9a3de", "patch_ids": ["15b3816633681459d9dd93e64a48ce0d", "ba8aa7045b27e8a9467ad9df65f2a614"], "statement_hash": "abf3aa0c2277a1dc8d9ddb61b3ffe1d2c987f7e7d4295a9d96f9ad75fa3f8e2a", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-efaad36fa63a27ed", "cves": [], "html": "在更多情况下允许分区连接，并减少其内存使用（Richard Guo, Tom Lane, Ashutosh Bapat）§ §
", "text": "在更多情况下允许分区连接，并减少其内存使用（Richard Guo, Tom Lane, Ashutosh Bapat）§ §", "title": "在更多情况下允许分区连接，并减少其内存使用", "commits": ["513f4472a", "9b282a935"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "cccb81e8d167297ee2b086955ed9914693ecfdb1803b07df4ff007a993b1d1bd", "section_path": ["服务器", "优化器"], "commit_groups": [["513f4472a"], ["9b282a935"]], "identity_text": "Allow partitionwise joins in more cases, and reduce its memory usage (Richard Guo, Tom Lane, Ashutosh Bapat)", "commit_aliases": ["513f4472a", "9b282a935"], "source_commits": ["513f4472a", "9b282a935"], "source_entry_id": "18.0/changes/012", "db_id": "e1323b3c594bfa821577fa9462f03cdb", "patch_ids": ["2ff70c110f54ba540a2cece6e3a512cd", "dd416b1d8a4d68e28e16f90c7055e0bb"], "statement_hash": "40327e199cf2577490955fbcc74c05fe2901108bec3acfe4621734a986af7685", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-77174da6fc6ed32b", "cves": [], "html": "改进分区查询的代价估算（Nikita Malakhov, Andrei Lepikhov）§
", "text": "改进分区查询的代价估算（Nikita Malakhov, Andrei Lepikhov）§", "title": "改进分区查询的代价估算", "commits": ["fae535da0"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "ad72fe467357e9b21f201ea22bac15faa0c66b16f28d43cb9b3f490b554ae9db", "section_path": ["服务器", "优化器"], "commit_groups": [["fae535da0"]], "identity_text": "Improve cost estimates of partition queries (Nikita Malakhov, Andrei Lepikhov)", "commit_aliases": ["fae535da0"], "source_commits": ["fae535da0"], "source_entry_id": "18.0/changes/013", "db_id": "c65e9805a7d1ddaa6d1373559e4cc29f", "patch_ids": ["61b7fea36f21c950e67f8bac538e8fce"], "statement_hash": "a36db3cf18d61186e69ff7181df62ed65dd845c1892191555ce2f6c4eecb52bd", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-3ca09b45eac4204e", "cves": [], "html": "改进 SQL 语言函数的计划缓存（Alexander Pyhalov, Tom Lane）§ §
", "text": "改进 SQL 语言函数的计划缓存（Alexander Pyhalov, Tom Lane）§ §", "title": "改进 SQL 语言函数的计划缓存", "commits": ["09b07c295", "0dca5d68d"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "624d5ebd4fbd3484e763f4ffd477ed7308b2ba7c3b507bfe163d59e440d1c9f2", "section_path": ["服务器", "优化器"], "commit_groups": [["09b07c295"], ["0dca5d68d"]], "identity_text": "Improve SQL-language function plan caching (Alexander Pyhalov, Tom Lane)", "commit_aliases": ["09b07c295", "0dca5d68d"], "source_commits": ["09b07c295", "0dca5d68d"], "source_entry_id": "18.0/changes/014", "db_id": "de187fd5833da9236d39e17a824451c0", "patch_ids": ["254214644dc444095fdc1eed63435eea", "aca8b43ca22cd7e20074fc7a0a7722ba"], "statement_hash": "146626d1f5aff4758ae17dc01f8d5f905420813c8aeb98087d9ca08c5471eb23", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-96d708124ad44b45", "cves": [], "html": "改进禁用优化器功能的处理（Robert Haas）§
", "text": "改进禁用优化器功能的处理（Robert Haas）§", "title": "改进禁用优化器功能的处理", "commits": ["e22253467"], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "3ac7c9a012dfeb824499ec299452a4443f811573d8cdc48a32a87591feb62e84", "section_path": ["服务器", "优化器"], "commit_groups": [["e22253467"]], "identity_text": "Improve handling of disabled optimizer features (Robert Haas)", "commit_aliases": ["e22253467"], "source_commits": ["e22253467"], "source_entry_id": "18.0/changes/015", "db_id": "6af674fe85c6718d1c2ae803cc5fa2d4", "patch_ids": ["78269645a1e3bdd21fcde369b7fb1c82"], "statement_hash": "0dcbf8861cd7ba230ddcdaf5746f5f46a4f85aa3e242a34f907c8eadbc61f43c", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-f3a4d0c34bdfba51", "cves": [], "html": "允许 B-树索引的跳过扫描（Peter Geoghegan）§ §
\n这允许在更多情况下使用多列 B-树索引，例如，当第一个或较早的索引列上没有限制（或只有非等值限制），而后续索引列上存在有效限制时。
", "text": "允许 B-树索引的跳过扫描（Peter Geoghegan）§ § 这允许在更多情况下使用多列 B-树索引，例如，当第一个或较早的索引列上没有限制（或只有非等值限制），而后续索引列上存在有效限制时。", "title": "允许 B-树索引的跳过扫描", "commits": ["8a510275d", "92fe23d93"], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-INDEXES", "source_hash": "6fc7b9601b88e3906c876c63e64c4ed31901ffef59984e3a9f3c5467cf0e520e", "section_path": ["服务器", "索引"], "commit_groups": [["8a510275d"], ["92fe23d93"]], "identity_text": "Allow skip scans of btree indexes (Peter Geoghegan) This allows multi-column btree indexes to be used in more cases such as when there are no restrictions on the first or early indexed columns (or there are non-equality ones), and there are useful restrictions on later indexed columns.", "commit_aliases": ["8a510275d", "92fe23d93"], "source_commits": ["8a510275d", "92fe23d93"], "source_entry_id": "18.0/changes/016", "db_id": "d6862625b987b44876b5f8813415e301", "patch_ids": ["635b38c19244d008c0a276c87c34aabf", "e61ae831ab07aa91f44cf34554c51986"], "statement_hash": "5f70bac2450552918acb0585c69d065150051c94ca3fd7c0e78accb784965d18", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-533df00c1b04db03", "cves": [], "html": "允许非 B-树唯一索引用作分区键，并用于物化视图（Mark Dilger）§ §
\n索引类型仍必须支持相等性。
", "text": "允许非 B-树唯一索引用作分区键，并用于物化视图（Mark Dilger）§ § 索引类型仍必须支持相等性。", "title": "允许非 B-树唯一索引用作分区键，并用于物化视图", "commits": ["9d6db8bec", "f278e1fe3"], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-INDEXES", "source_hash": "48d1dc2e21671ed03ec096681269e55993854a87f636152113525b845910da6b", "section_path": ["服务器", "索引"], "commit_groups": [["9d6db8bec"], ["f278e1fe3"]], "identity_text": "Allow non-btree unique indexes to be used as partition keys and in materialized views (Mark Dilger) The index type must still support equality.", "commit_aliases": ["9d6db8bec", "f278e1fe3"], "source_commits": ["9d6db8bec", "f278e1fe3"], "source_entry_id": "18.0/changes/017", "db_id": "494315b065e8cf257c51cc573e8cd5ba", "patch_ids": ["5bf1633970b359c47772a29d428891b9", "afc683b089394ea6ac807e8fc8c1d9ac"], "statement_hash": "8627db4022a3b996448b3199a1438d065510142c1a86887f48fb1af1aa338936", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-1527473201723273", "cves": [], "html": "允许并行创建 GIN 索引（Tomas Vondra, Matthias van de Meent）§
允许对值进行排序以加快范围类型 GiST 和 B-树索引构建（Bernd Helmle）§
", "text": "允许对值进行排序以加快范围类型 GiST 和 B-树索引构建（Bernd Helmle）§", "title": "允许对值进行排序以加快范围类型 GiST 和 B-树索引构建", "commits": ["e9e7b6604"], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-INDEXES", "source_hash": "ac18bed164464842781add926baf8a19f9b384695cfa6ffc14d622e837b24226", "section_path": ["服务器", "索引"], "commit_groups": [["e9e7b6604"]], "identity_text": "Allow values to be sorted to speed range-type GiST and btree index builds (Bernd Helmle)", "commit_aliases": ["e9e7b6604"], "source_commits": ["e9e7b6604"], "source_entry_id": "18.0/changes/019", "db_id": "bb89183dc8713a98a5f1732f23ebf357", "patch_ids": ["21b0be863bb11025af07f036adc715cd"], "statement_hash": "1110884a4b4193d0fb56b65604f1f84d06c9b027816ac2b2f97f7eb335548e6f", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-ff0cc0de715bde2e", "cves": [], "html": "添加异步 I/O 子系统（Andres Freund, Thomas Munro, Nazir Bilal Yavuz, Melanie Plageman）§ § § § § § § § § § §
\n此功能允许后端排队多个读取请求，从而实现更高效的顺序扫描、位图堆扫描、清理等。这由服务器变量io_method启用，并添加了服务器变量io_combine_limit和io_max_combine_limit来控制它。这还使得不支持 fadvise() 的系统也可以将effective_io_concurrency和maintenance_io_concurrency设为大于零的值。新的系统视图 pg_aios 显示用于异步 I/O 的文件句柄。
改进访问许多关系的查询的锁定性能（Tomas Vondra）§
", "text": "改进访问许多关系的查询的锁定性能（Tomas Vondra）§", "title": "改进访问许多关系的查询的锁定性能", "commits": ["c4d5cb71d"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-PERFORMANCE", "source_hash": "166ed61e81ac65ed621694d2130b525d95cd6eabf81198d9051b9df5a5471b51", "section_path": ["服务器", "一般性能"], "commit_groups": [["c4d5cb71d"]], "identity_text": "Improve the locking performance of queries that access many relations (Tomas Vondra)", "commit_aliases": ["c4d5cb71d"], "source_commits": ["c4d5cb71d"], "source_entry_id": "18.0/changes/021", "db_id": "aff48c3c83b235bf18a030e9ccc9c3b8", "patch_ids": ["fc2837c0cff32783885ae70d5fbb55db"], "statement_hash": "bbf31aaa998b69605f19fb5f3337b504b4ae92cf39abf056f16dadd0b84efe2d", "relations": [], "version": "18.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-685db88c876114b9", "cves": [], "html": "提高哈希连接和 GROUP BY 的性能并减少内存使用（David Rowley, Jeff Davis）§ § § § §
这也改进了 EXCEPT 使用的 hash 集操作和子计划值的 hash 查找。
允许普通清理冻结某些页面，即使它们都是可见的（Melanie Plageman）§ §
\n这减少了后期全关系冻结的开销。其激进性可以通过服务器变量和每表设置vacuum_max_eager_freeze_failure_rate控制。以前，在需要冻结之前，清理从不处理所有可见页面。
", "text": "允许普通清理冻结某些页面，即使它们都是可见的（Melanie Plageman）§ § 这减少了后期全关系冻结的开销。其激进性可以通过服务器变量和每表设置vacuum_max_eager_freeze_failure_rate控制。以前，在需要冻结之前，清理从不处理所有可见页面。", "title": "允许普通清理冻结某些页面，即使它们都是可见的", "commits": ["052026c9b", "06eae9e62"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-PERFORMANCE", "source_hash": "067908e36f6001abfd9b89898d6468091c7c408aba70fd6644ef0e6e78945b17", "section_path": ["服务器", "一般性能"], "commit_groups": [["052026c9b"], ["06eae9e62"]], "identity_text": "Allow normal vacuums to freeze some pages, even though they are all-visible (Melanie Plageman) This reduces the overhead of later full-relation freezing. The aggressiveness of this can be controlled by server variable and per-table setting guc-vacuum-max-eager-freeze-failure-rate . Previously vacuum never processed all-visible pages until freezing was required.", "commit_aliases": ["052026c9b", "06eae9e62"], "source_commits": ["052026c9b", "06eae9e62"], "source_entry_id": "18.0/changes/023", "db_id": "b143946a18139ecebf85f4773c7419b5", "patch_ids": ["67ea98ee74614c1e13cce028969b4f44", "d3f807b22dffb17b1216f302711474dd"], "statement_hash": "1d01a6afb8bdd666bc7b3013928540e3f748fdac185055067dcbcfcb19976f2d", "relations": [], "version": "18.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-929700b56f096829", "cves": [], "html": "添加服务器变量vacuum_truncate以控制VACUUM期间的文件截断（Nathan Bossart, Gurjeet Singh）§
\n已经存在一个具有相同名称和行为的存储级别参数。
", "text": "添加服务器变量vacuum_truncate以控制VACUUM期间的文件截断（Nathan Bossart, Gurjeet Singh）§ 已经存在一个具有相同名称和行为的存储级别参数。", "title": "添加服务器变量vacuum_truncate以控制VACUUM期间的文件截断", "commits": ["0164a0f9e"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-PERFORMANCE", "source_hash": "3bdf7d1f300811ca038842a0cc4e774e2520f4329d021c60a179b690525ba77f", "section_path": ["服务器", "一般性能"], "commit_groups": [["0164a0f9e"]], "identity_text": "Add server variable guc-vacuum-truncate to control file truncation during sql-vacuum (Nathan Bossart, Gurjeet Singh) A storage-level parameter with the same name and behavior already existed.", "commit_aliases": ["0164a0f9e"], "source_commits": ["0164a0f9e"], "source_entry_id": "18.0/changes/024", "db_id": "d1bf74ed1cb4e3fbacc9001855d15f16", "patch_ids": ["be7bc9e56cdce4915b9e4a702d43e637"], "statement_hash": "944b8ce94c10828d6d6910957cf641b88dc95d22b1b8115647738cec01db9fbe", "relations": [], "version": "18.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-e2695fe0532b1c4e", "cves": [], "html": "将服务器变量effective_io_concurrency和maintenance_io_concurrency的默认值增加到 16（Melanie Plageman）§ §
\n这更准确地反映了现代硬件。
", "text": "将服务器变量effective_io_concurrency和maintenance_io_concurrency的默认值增加到 16（Melanie Plageman）§ § 这更准确地反映了现代硬件。", "title": "将服务器变量effective_io_concurrency和maintenance_io_concurrency的默认值增加到 16", "commits": ["cc6be07eb", "ff79b5b2a"], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-PERFORMANCE", "source_hash": "5ed1ab656f1d067bc897340478dcbb402d18bafb76ff5da9b9bec5940ff0e6da", "section_path": ["服务器", "一般性能"], "commit_groups": [["cc6be07eb"], ["ff79b5b2a"]], "identity_text": "Increase server variables guc-effective-io-concurrency 's and guc-maintenance-io-concurrency 's default values to 16 (Melanie Plageman) This more accurately reflects modern hardware.", "commit_aliases": ["cc6be07eb", "ff79b5b2a"], "source_commits": ["cc6be07eb", "ff79b5b2a"], "source_entry_id": "18.0/changes/025", "db_id": "426d3063330d1605a0f8dada895702c7", "patch_ids": ["5048dc209f8f981f9a097d9636573570", "711b2163ed88e992fa8f7ebd50bcabfe"], "statement_hash": "2388b7de66243eaf67d83494c797d6d1e1d27a9f5ff72da1c364e2e04896d1a4", "relations": [], "version": "18.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-1853092f38c97a1c", "cves": [], "html": "增加服务器变量log_connections的日志记录粒度（Melanie Plageman）§
\n此服务器变量以前仅接受布尔值；布尔值用法仍受支持。
", "text": "增加服务器变量log_connections的日志记录粒度（Melanie Plageman）§ 此服务器变量以前仅接受布尔值；布尔值用法仍受支持。", "title": "增加服务器变量log_connections的日志记录粒度", "commits": ["9219093ca"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "42fa035457ddebe4280da1ffdf030abca58669ddee1f4de16c1998a7b9a4dfb2", "section_path": ["服务器", "监控"], "commit_groups": [["9219093ca"]], "identity_text": "Increase the logging granularity of server variable guc-log-connections (Melanie Plageman) This server variable was previously only boolean, which is still supported.", "commit_aliases": ["9219093ca"], "source_commits": ["9219093ca"], "source_entry_id": "18.0/changes/026", "db_id": "ff5e5f18a1f9dca408cdf9912c05dbc0", "patch_ids": ["a7e481af208e8edfa0f5fb1487d6f5da"], "statement_hash": "bdb1f75b5ad766542e4be765b90646c65665a1de272e063859e8ddf2ad109820", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-618b0a37a5adca9c", "cves": [], "html": "添加 log_connections 选项以报告连接阶段的持续时间（Melanie Plageman）§
添加log_line_prefix转义 %L 以输出客户端IP地址（Greg Sabino Mullane）§
添加服务器变量log_lock_failures以记录锁获取失败（Yuki Seino, Fujii Masao）§ §
\n具体来说，它报告 SELECT ... NOWAIT 锁失败。
修改 pg_stat_all_tables 及其变体以报告在VACUUM、ANALYZE及其自动执行的变体中花费的时间（Sami Imseih）§
新列是 total_vacuum_time、total_autovacuum_time、total_analyze_time 和 total_autoanalyze_time。
向VACUUM和ANALYZE添加延迟时间报告（Bertrand Drouvot, Nathan Bossart）§ §
\n此信息出现在服务器日志、系统视图 pg_stat_progress_vacuum 和 pg_stat_progress_analyze 以及VACUUM和ANALYZE在 VERBOSE 模式下的输出中；必须使用服务器变量track_cost_delay_timing启用跟踪。
添加WAL、CPU以及平均读取统计信息输出到 ANALYZE VERBOSE（Anthonin Bonnefoy）§ §
添加完整WAL缓冲区计数到 VACUUM/ANALYZE (VERBOSE) 和 autovacuum 日志输出（Bertrand Drouvot）§
添加每后端 I/O 统计信息报告（Bertrand Drouvot）§ §
\n统计信息通过 pg_stat_get_backend_io() 访问。每后端 I/O 统计信息可以通过 pg_stat_reset_backend_stats() 清除。
添加 pg_stat_io 列以字节报告 I/O 活动（Nazir Bilal Yavuz）§
新列是 read_bytes、write_bytes 和 extend_bytes。op_bytes 列（始终等于 BLCKSZ）已移除。
向pg_stat_io添加WAL I/O 活动行（Nazir Bilal Yavuz, Bertrand Drouvot, Michael Paquier）§ § §
这包括WAL接收器活动以及此类写入的等待事件。
", "text": "向pg_stat_io添加WAL I/O 活动行（Nazir Bilal Yavuz, Bertrand Drouvot, Michael Paquier）§ § § 这包括WAL接收器活动以及此类写入的等待事件。", "title": "向pg_stat_io添加WAL I/O 活动行", "commits": ["4538bd3f1", "7f7f324eb", "a051e71e2"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "1073fae0e1addc89e2446fa37b2acba1f913d9723e1c4429053ee3268c3f10de", "section_path": ["服务器", "监控"], "commit_groups": [["4538bd3f1"], ["7f7f324eb"], ["a051e71e2"]], "identity_text": "Add WAL I/O activity rows to pg_stat_io (Nazir Bilal Yavuz, Bertrand Drouvot, Michael Paquier) This includes WAL receiver activity and a wait event for such writes.", "commit_aliases": ["4538bd3f1", "7f7f324eb", "a051e71e2"], "source_commits": ["4538bd3f1", "7f7f324eb", "a051e71e2"], "source_entry_id": "18.0/changes/036", "db_id": "4e8a04b21c8fb51fcf294e0a57d8462f", "patch_ids": ["0abab9a405c724624eabd4509d63171e", "3d509df32980788958c9572c50adb4fd", "bef53f830f1ba9f3cda0cc8ff4ed91e6"], "statement_hash": "c5453439738584b897b3afc314105f41051f5aa95d24752734738916b65af097", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-878674061147da87", "cves": [], "html": "更改服务器变量track_wal_io_timing以控制在pg_stat_io而不是 pg_stat_wal中跟踪WAL计时（Bertrand Drouvot）§
从 pg_stat_wal 中移除读/同步列（Bertrand Drouvot）§ §
这会移除列 wal_write、wal_sync、wal_write_time 和 wal_sync_time。
添加函数 pg_stat_get_backend_wal() 以返回每后端WAL统计信息（Bertrand Drouvot）§
每后端WAL统计信息可以通过 pg_stat_reset_backend_stats() 清除。
添加函数 pg_ls_summariesdir() 以专门列出 PGDATA/pg_wal/summaries 的内容（Yushi Ogiwara）§
添加列 pg_stat_checkpointer.num_done 以报告已完成的检查点数量（Anton A. Melnikov）§
列 num_timed 和 num_requested 同时统计已完成和已跳过的检查点。
添加列 pg_stat_checkpointer.slru_written 以报告SLRU写入的缓冲区（Nitin Jadhav）§
此外，修改检查点服务器日志消息以报告单独的共享缓冲区和SLRU缓冲区值。
", "text": "添加列 pg_stat_checkpointer.slru_written 以报告SLRU写入的缓冲区（Nitin Jadhav）§ 此外，修改检查点服务器日志消息以报告单独的共享缓冲区和SLRU缓冲区值。", "title": "添加列 pg_stat_checkpointer.slru_written 以报告SLRU写入的缓冲区", "commits": ["17cc5f666"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "e3cd14d094f854569dcf0a7ec616f689d1baac8a113db529f691cfd28c517c08", "section_path": ["服务器", "监控"], "commit_groups": [["17cc5f666"]], "identity_text": "Add column pg_stat_checkpointer.slru_written to report SLRU buffers written (Nitin Jadhav) Also, modify the checkpoint server log message to report separate shared buffer and SLRU buffer values.", "commit_aliases": ["17cc5f666"], "source_commits": ["17cc5f666"], "source_entry_id": "18.0/changes/042", "db_id": "c727bac201403ee5787ce91519d78b8f", "patch_ids": ["d6837b0ccfa7bed8d3ef332bff20c386"], "statement_hash": "d75f1cff8692d2b125311380a9eb939eed72a5eec22bed4041dad77e8aed16e7", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-830bba3026f852b8", "cves": [], "html": "添加列到 pg_stat_database 以报告并行工作者活动（Benoit Lobréau）§
新列是 parallel_workers_to_launch 和 parallel_workers_launched。
让常量列表的查询 ID 计算只考虑第一个和最后一个常量（Dmitry Dolgov, Sami Imseih）§ § §
\n查询规范化由pg_stat_statements使用。
", "text": "让常量列表的查询 ID 计算只考虑第一个和最后一个常量（Dmitry Dolgov, Sami Imseih）§ § § 查询规范化由pg_stat_statements使用。", "title": "让常量列表的查询 ID 计算只考虑第一个和最后一个常量", "commits": ["62d712ecf", "9fbd53dea", "c2da1a5d6"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "2cf9373f5b7eddab9fd5ff38dada6cd3257b8f28a837aed595560e11f200a37d", "section_path": ["服务器", "监控"], "commit_groups": [["62d712ecf"], ["9fbd53dea"], ["c2da1a5d6"]], "identity_text": "Have query id computation of constant lists consider only the first and last constants (Dmitry Dolgov, Sami Imseih) Jumbling is used by pgstatstatements .", "commit_aliases": ["62d712ecf", "9fbd53dea", "c2da1a5d6"], "source_commits": ["62d712ecf", "9fbd53dea", "c2da1a5d6"], "source_entry_id": "18.0/changes/044", "db_id": "602391884e0f9956bc8189e3df9fa46c", "patch_ids": ["5788e402f9a32d0839d25eda04d2e777", "892e3023e3eb75d6d37898823ef6e17d", "b602290e314da4eb2c893c183d542ea2"], "statement_hash": "15594176dafd96eadc8774ee3c07b03bfac584e26aab1114deaf08975c0d6fa7", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-628577c78133fcaf", "cves": [], "html": "调整查询 ID 计算以将使用相同关系名称的查询组合在一起（Michael Paquier, Sami Imseih）§
\n即使不同模式中的表具有不同的列名，这也是成立的。
", "text": "调整查询 ID 计算以将使用相同关系名称的查询组合在一起（Michael Paquier, Sami Imseih）§ 即使不同模式中的表具有不同的列名，这也是成立的。", "title": "调整查询 ID 计算以将使用相同关系名称的查询组合在一起", "commits": ["787514b30"], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "09abeab4f5099639b5d52aa31679edc914c3b3c20594c0d395bf45bf491d5e09", "section_path": ["服务器", "监控"], "commit_groups": [["787514b30"]], "identity_text": "Adjust query id computations to group together queries using the same relation name (Michael Paquier, Sami Imseih) This is true even if the tables in different schemas have different column names.", "commit_aliases": ["787514b30"], "source_commits": ["787514b30"], "source_entry_id": "18.0/changes/045", "db_id": "b3b7d2a11d4d31f38f5974d4bc93b3e3", "patch_ids": ["79273c32213aef68723d02e288664812"], "statement_hash": "4cd23dc47a6dcb75efe88b4674803607d5b63bfc8d8855e3822b801ecc934093", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-1c87b8097e5f44a6", "cves": [], "html": "添加列 pg_backend_memory_contexts.type 以报告内存上下文的类型（David Rowley）§
添加列 pg_backend_memory_contexts.path 以显示内存上下文父级（Melih Mutlu）§
添加函数 pg_get_acl() 以检索数据库访问控制详细信息（Joel Jacobson）§ §
添加函数 has_largeobject_privilege() 以检查大型对象权限（Yugo Nagata）§
允许ALTER DEFAULT PRIVILEGES定义大型对象默认权限（Takatsuka Haruka, Yugo Nagata, Laurenz Albe）§
", "text": "允许ALTER DEFAULT PRIVILEGES定义大型对象默认权限（Takatsuka Haruka, Yugo Nagata, Laurenz Albe）§", "title": "允许ALTER DEFAULT PRIVILEGES定义大型对象默认权限", "commits": ["0d6c47766"], "section": "服务器 / 权限", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PRIVILEGES", "source_hash": "4c91df429994b748ca8f11482114f697801f5b8c6c8b714ebf14f04619bf4653", "section_path": ["服务器", "权限"], "commit_groups": [["0d6c47766"]], "identity_text": "Allow sql-alterdefaultprivileges to define large object default privileges (Takatsuka Haruka, Yugo Nagata, Laurenz Albe)", "commit_aliases": ["0d6c47766"], "source_commits": ["0d6c47766"], "source_entry_id": "18.0/changes/050", "db_id": "2115b59fe3ecb850d34420db9087d6ee", "patch_ids": ["8bd885a988ec8e858d73081f630fd33d"], "statement_hash": "91512a6ced76577a52c71c7f1692309e60bb18dc1ce44331c056f04fd50fb429", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-85bb8a1c74259843", "cves": [], "html": "添加预定义角色 pg_signal_autovacuum_worker（Kirill Reshke）§
这允许向自动清理工作者发送信号。
", "text": "添加预定义角色 pg_signal_autovacuum_worker（Kirill Reshke）§ 这允许向自动清理工作者发送信号。", "title": "添加预定义角色 pg_signal_autovacuum_worker", "commits": ["ccd38024b"], "section": "服务器 / 权限", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PRIVILEGES", "source_hash": "bfdef5e379e1781509025a5997d7b24eee477202a1c63fdf10ed414f0ba7b3e4", "section_path": ["服务器", "权限"], "commit_groups": [["ccd38024b"]], "identity_text": "Add predefined role pg_signal_autovacuum_worker (Kirill Reshke) This allows sending signals to autovacuum workers.", "commit_aliases": ["ccd38024b"], "source_commits": ["ccd38024b"], "source_entry_id": "18.0/changes/051", "db_id": "20b3f6628c87707ad4d0eb8fd8768e0a", "patch_ids": ["a254744dab5b2721c5babac8740a351d"], "statement_hash": "c15408fea664f43b416b4b112fe35a5f8e4c76546718ab374fef03190e47327d", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-5ff741495e245c7b", "cves": [], "html": "添加对 OAuth 认证方法的支持（Jacob Champion, Daniel Gustafsson, Thomas Munro）§
\n这为 pg_hba.conf 添加了 oauth 认证方法、libpq OAuth 选项、一个用于加载令牌验证库的服务器变量oauth_validator_libraries，以及一个 --with-libcurl 配置标志，用于添加所需的编译时库。
添加服务器变量ssl_tls13_ciphers以允许指定多个以冒号分隔的 TLSv1.3 密码套件（Erica Zhang, Daniel Gustafsson）§
", "text": "添加服务器变量ssl_tls13_ciphers以允许指定多个以冒号分隔的 TLSv1.3 密码套件（Erica Zhang, Daniel Gustafsson）§", "title": "添加服务器变量ssl_tls13_ciphers以允许指定多个以冒号分隔的 TLSv1.3 密码套件", "commits": ["45188c2ea"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "5d256d99caaf5046100077cd472e922ae375d82b0f5b45bcfbac3a79833692b5", "section_path": ["服务器", "服务器配置"], "commit_groups": [["45188c2ea"]], "identity_text": "Add server variable guc-ssl-tls13-ciphers to allow specification of multiple colon-separated TLSv1.3 cipher suites (Erica Zhang, Daniel Gustafsson)", "commit_aliases": ["45188c2ea"], "source_commits": ["45188c2ea"], "source_entry_id": "18.0/changes/053", "db_id": "13b081fb2e1030e7c402c99be84d674e", "patch_ids": ["b918cd02542986f670ea5e4ccce7bed8"], "statement_hash": "ffe4b310bcfc2b812bd9ca43729c6e6988676e615fa96ac501930ef3cd998db9", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-065524e3b98547b4", "cves": [], "html": "将服务器变量ssl_groups的默认值更改为包含椭圆曲线 X25519（Daniel Gustafsson, Jacob Champion）§
", "text": "将服务器变量ssl_groups的默认值更改为包含椭圆曲线 X25519（Daniel Gustafsson, Jacob Champion）§", "title": "将服务器变量ssl_groups的默认值更改为包含椭圆曲线 X25519", "commits": ["daa02c6bd"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "769ef4c7a0e583d2f4cb847ab408143dd1d5d440e558c0b751debd0c43265451", "section_path": ["服务器", "服务器配置"], "commit_groups": [["daa02c6bd"]], "identity_text": "Change server variable guc-ssl-groups 's default to include elliptic curve X25519 (Daniel Gustafsson, Jacob Champion)", "commit_aliases": ["daa02c6bd"], "source_commits": ["daa02c6bd"], "source_entry_id": "18.0/changes/054", "db_id": "0ff6b951577e789ccfcf50c5fdd16250", "patch_ids": ["b6419e2ab5092340bdb51279a882c575"], "statement_hash": "79f1b0ec5dbbc9c41cfae0c653c6b8af2978a2d458009ec866463efb3c895406", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-e389dbfe8645ccad", "cves": [], "html": "将服务器变量 ssl_ecdh_curve 重命名为ssl_groups，并允许指定多个以冒号分隔的ECDH曲线（Erica Zhang, Daniel Gustafsson）§
以前的名称仍然有效。
", "text": "将服务器变量 ssl_ecdh_curve 重命名为ssl_groups，并允许指定多个以冒号分隔的ECDH曲线（Erica Zhang, Daniel Gustafsson）§ 以前的名称仍然有效。", "title": "将服务器变量 ssl_ecdh_curve 重命名为ssl_groups，并允许指定多个以冒号分隔的ECDH曲线", "commits": ["3d1ef3a15"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "69fc229fb451ba3569f10661789b08fd931063d5102c111408c2c761550da092", "section_path": ["服务器", "服务器配置"], "commit_groups": [["3d1ef3a15"]], "identity_text": "Rename server variable ssl_ecdh_curve to guc-ssl-groups and allow multiple colon-separated ECDH curves to be specified (Erica Zhang, Daniel Gustafsson) The previous name still works.", "commit_aliases": ["3d1ef3a15"], "source_commits": ["3d1ef3a15"], "source_entry_id": "18.0/changes/055", "db_id": "96a81164afdac0bf4ed0486ab950b9cc", "patch_ids": ["c2561d4875ae281fdaea78d9e93eaee2"], "statement_hash": "af282a32e71f1303e38dd9f838dce742a3ea5e5033c66e5a334acc730ab67445", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-8331e2d5ef9a11f8", "cves": [], "html": "将取消请求密钥设为 256 位（Heikki Linnakangas, Jelte Fennema-Nio）§ §
\n这只有在服务器和客户端支持本版本中引入的线协议版本3.2时才可能实现。
", "text": "将取消请求密钥设为 256 位（Heikki Linnakangas, Jelte Fennema-Nio）§ § 这只有在服务器和客户端支持本版本中引入的线协议版本3.2时才可能实现。", "title": "将取消请求密钥设为 256 位", "commits": ["9d9b9d46f", "a460251f0"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "4da7c6464ec24190e054671959a89c1342b41fd9c2df30a579e2cb4c8e608823", "section_path": ["服务器", "服务器配置"], "commit_groups": [["9d9b9d46f"], ["a460251f0"]], "identity_text": "Make cancel request keys 256 bits (Heikki Linnakangas, Jelte Fennema-Nio) This is only possible when the server and client support wire protocol version 3.2, introduced in this release.", "commit_aliases": ["9d9b9d46f", "a460251f0"], "source_commits": ["9d9b9d46f", "a460251f0"], "source_entry_id": "18.0/changes/056", "db_id": "d4bdcc752134e88e3b6f69045f91e32f", "patch_ids": ["3374f7d4348f979a16fb3f835b1434dd", "78aeb882063c4d9c0113cb769f6f63c8"], "statement_hash": "bf970fd6a3a870ec104cf3173699ac7821ccb4e686bb18b2d9050cfee203c953", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-e640f1a488be668b", "cves": [], "html": "添加服务器变量autovacuum_worker_slots以指定后台工作者的最大数量（Nathan Bossart）§
\n设置此变量后，autovacuum_max_workers可以在运行时调整到此最大值，而无需重新启动服务器。
", "text": "添加服务器变量autovacuum_worker_slots以指定后台工作者的最大数量（Nathan Bossart）§ 设置此变量后，autovacuum_max_workers可以在运行时调整到此最大值，而无需重新启动服务器。", "title": "添加服务器变量autovacuum_worker_slots以指定后台工作者的最大数量", "commits": ["c758119e5"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "cccf9f941c4560c33011e635dcab0b9c28ae26749ffd1608f7169c4ecf499acc", "section_path": ["服务器", "服务器配置"], "commit_groups": [["c758119e5"]], "identity_text": "Add server variable guc-autovacuum-worker-slots to specify the maximum number of background workers (Nathan Bossart) With this variable set, guc-autovacuum-max-workers can be adjusted at runtime up to this maximum without a server restart.", "commit_aliases": ["c758119e5"], "source_commits": ["c758119e5"], "source_entry_id": "18.0/changes/057", "db_id": "14193c2c6216dac54ee9f03d74597315", "patch_ids": ["17efa2578b6fdfca54d1895a47b5d85c"], "statement_hash": "2340cf9dd0c8914c3ae78fcca1d6cb8a3eec267275fe98352062b37d256a1302", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-42921b23820eecfb", "cves": [], "html": "允许指定触发 autovacuum 的死元组的固定数量（Nathan Bossart, Frédéric Yhuel）§
\n服务器变量是autovacuum_vacuum_max_threshold。百分比仍用于触发。
", "text": "允许指定触发 autovacuum 的死元组的固定数量（Nathan Bossart, Frédéric Yhuel）§ 服务器变量是autovacuum_vacuum_max_threshold。百分比仍用于触发。", "title": "允许指定触发 autovacuum 的死元组的固定数量", "commits": ["306dc520b"], "section": "服务器 / 服务器配置", "category": "bugfix", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "fd553683edfb9d3b450f0a00d5e58d81232bb84ff144ad688ad048e97b11922e", "section_path": ["服务器", "服务器配置"], "commit_groups": [["306dc520b"]], "identity_text": "Allow specification of the fixed number of dead tuples that will trigger an autovacuum (Nathan Bossart, Frédéric Yhuel) The server variable is guc-autovacuum-vacuum-max-threshold . Percentages are still used for triggering.", "commit_aliases": ["306dc520b"], "source_commits": ["306dc520b"], "source_entry_id": "18.0/changes/058", "db_id": "c6c8d0da14fc739954f67e4c3e8e297c", "patch_ids": ["fede0a2ed06d94a30aac6de8675efbce"], "statement_hash": "f26aed72e786336ffb0181c576796c1b0d66b6c0c79fa7ab8337a9deb9a04a70", "relations": [], "version": "18.0", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-3bae7a931bd83da1", "cves": [], "html": "更改服务器变量max_files_per_process以仅限制后端打开的文件（Andres Freund）§
\n以前，postmaster 打开的文件也计入此限制。
", "text": "更改服务器变量max_files_per_process以仅限制后端打开的文件（Andres Freund）§ 以前，postmaster 打开的文件也计入此限制。", "title": "更改服务器变量max_files_per_process以仅限制后端打开的文件", "commits": ["adb5f85fa"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "2618bfe12d00c39268c401694e59d9fad97443ba987c22b6d62e307da9068d9a", "section_path": ["服务器", "服务器配置"], "commit_groups": [["adb5f85fa"]], "identity_text": "Change server variable guc-max-files-per-process to limit only files opened by a backend (Andres Freund) Previously files opened by the postmaster were also counted toward this limit.", "commit_aliases": ["adb5f85fa"], "source_commits": ["adb5f85fa"], "source_entry_id": "18.0/changes/059", "db_id": "7d0f8a8401a0235fee5c42443323fd9f", "patch_ids": ["1253eb7b68a386abd794c882137adc02"], "statement_hash": "04e1a6687e91598505d1cd8239184c483171e03aa143374ed943a3e8b71c817c", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-0f2f3a9ba5d31cd7", "cves": [], "html": "添加服务器变量num_os_semaphores以报告所需信号量的数量（Nathan Bossart）§
\n这对于操作系统配置很有用。
", "text": "添加服务器变量num_os_semaphores以报告所需信号量的数量（Nathan Bossart）§ 这对于操作系统配置很有用。", "title": "添加服务器变量num_os_semaphores以报告所需信号量的数量", "commits": ["0dcaea569"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "9ab5511113bd82e70e3a03fc12538f6345af41f77c718778b40bf3d3a03203b6", "section_path": ["服务器", "服务器配置"], "commit_groups": [["0dcaea569"]], "identity_text": "Add server variable guc-num-os-semaphores to report the required number of semaphores (Nathan Bossart) This is useful for operating system configuration.", "commit_aliases": ["0dcaea569"], "source_commits": ["0dcaea569"], "source_entry_id": "18.0/changes/060", "db_id": "baa925cc966c3797d6c1baeb8600b3af", "patch_ids": ["7cab2bba487b8dfdc88b894d86ebcb31"], "statement_hash": "db627bdf62b6a351d882ccec445c9221ec8e4d930aed5bf5e6b0b5b611bd8094", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-911f58cd6d2f91a5", "cves": [], "html": "添加服务器变量extension_control_path以指定扩展控制文件的位置（Peter Eisentraut, Matheus Alcantara）§ §
", "text": "添加服务器变量extension_control_path以指定扩展控制文件的位置（Peter Eisentraut, Matheus Alcantara）§ §", "title": "添加服务器变量extension_control_path以指定扩展控制文件的位置", "commits": ["4f7f7b037", "81eaaa2c4"], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "9d62b8c0663f70e4f69542ec94abb0e3f367bb880d1661fa4b5ee26a52495548", "section_path": ["服务器", "服务器配置"], "commit_groups": [["4f7f7b037"], ["81eaaa2c4"]], "identity_text": "Add server variable guc-extension-control-path to specify the location of extension control files (Peter Eisentraut, Matheus Alcantara)", "commit_aliases": ["4f7f7b037", "81eaaa2c4"], "source_commits": ["4f7f7b037", "81eaaa2c4"], "source_entry_id": "18.0/changes/061", "db_id": "9a0ac630df36e673c00b61131cd0c2ff", "patch_ids": ["2c992ea1a18c7e56b1999e13915ad2f8", "95178da37b740ae32403368a9d5de091"], "statement_hash": "b2d063e72b9d991ddf32656536cdf6aa960609b5293a9f7685124d9018ed0d46", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-89dab26f6ecf89b1", "cves": [], "html": "允许使用服务器变量idle_replication_slot_timeout自动使非活动复制槽失效（Nisha Moond, Bharath Rupireddy）§
", "text": "允许使用服务器变量idle_replication_slot_timeout自动使非活动复制槽失效（Nisha Moond, Bharath Rupireddy）§", "title": "允许使用服务器变量idle_replication_slot_timeout自动使非活动复制槽失效", "commits": ["ac0e33136"], "section": "服务器 / 流复制与恢复", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-REPLICATION", "source_hash": "8c442254dde2045ae1b1e87460c9e70a650a5b8afddfac774dc1463a967d81ba", "section_path": ["服务器", "流复制与恢复"], "commit_groups": [["ac0e33136"]], "identity_text": "Allow inactive replication slots to be automatically invalidated using server variable guc-idle-replication-slot-timeout (Nisha Moond, Bharath Rupireddy)", "commit_aliases": ["ac0e33136"], "source_commits": ["ac0e33136"], "source_entry_id": "18.0/changes/062", "db_id": "7e52ed73d316bf78778f528fedb05f84", "patch_ids": ["df8d31e4efb6cb139d5c669e2215050c"], "statement_hash": "eb9a1e5c89e5b4fa71a37fedc208ddb8c2f0f95fbc1eec06821cbc772f3bd8fc", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-b0ddcd66f9a0c6c5", "cves": [], "html": "添加服务器变量max_active_replication_origins以控制最大活动复制源（Euler Taveira）§
\n这以前由max_replication_slots控制，但这个新设置允许在需要较少槽位的情况下具有更高的源计数。
", "text": "添加服务器变量max_active_replication_origins以控制最大活动复制源（Euler Taveira）§ 这以前由max_replication_slots控制，但这个新设置允许在需要较少槽位的情况下具有更高的源计数。", "title": "添加服务器变量max_active_replication_origins以控制最大活动复制源", "commits": ["04ff636cb"], "section": "服务器 / 流复制与恢复", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-REPLICATION", "source_hash": "33b1bea544f15476df511f7f493e700d5039ed734c0053ce03bf246913999aca", "section_path": ["服务器", "流复制与恢复"], "commit_groups": [["04ff636cb"]], "identity_text": "Add server variable guc-max-active-replication-origins to control the maximum active replication origins (Euler Taveira) This was previously controlled by guc-max-replication-slots , but this new setting allows a higher origin count in cases where fewer slots are required.", "commit_aliases": ["04ff636cb"], "source_commits": ["04ff636cb"], "source_entry_id": "18.0/changes/063", "db_id": "1428b3f7f6cc1a4506850622a40c3ffb", "patch_ids": ["a8c08a420a79bd1a161ea23d9bef6d71"], "statement_hash": "9e85b8d9968595a466cfb230295bcf24c446ed069e908115b73bf70ddbaf2392", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-cd9ea852d87af69a", "cves": [], "html": "允许生成列的值进行逻辑复制（Shubham Khanna, Vignesh C, Zhijie Hou, Shlok Kyal, Peter Smith）§ § § §
\n如果发布指定了列列表，则发布所有指定的列（生成的和非生成的）。如果没有指定的列列表，则发布选项 publish_generated_columns 控制是否发布生成的列。以前生成的列不进行复制，订阅者必须在可能的情况下计算值；这对于缺少此类功能的非 PostgreSQL 订阅者特别有用。
将CREATE SUBSCRIPTION流式选项的默认值从 off 更改为 parallel（Vignesh C）§
允许ALTER SUBSCRIPTION更改复制槽的两阶段提交行为（Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou）§ §
", "text": "允许ALTER SUBSCRIPTION更改复制槽的两阶段提交行为（Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou）§ §", "title": "允许ALTER SUBSCRIPTION更改复制槽的两阶段提交行为", "commits": ["1462aad2e", "4868c96bc"], "section": "服务器 / 逻辑复制", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-LOGICAL", "source_hash": "b96743f044a02e2201e5e678b547c8fdb56efd310343f8b3e4919fa6c862dfc7", "section_path": ["服务器", "逻辑复制"], "commit_groups": [["1462aad2e"], ["4868c96bc"]], "identity_text": "Allow sql-altersubscription to change the replication slot's two-phase commit behavior (Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou)", "commit_aliases": ["1462aad2e", "4868c96bc"], "source_commits": ["1462aad2e", "4868c96bc"], "source_entry_id": "18.0/changes/066", "db_id": "41cd5554ab5a99df850ddc649a630bf5", "patch_ids": ["15c1439cde9cf963e340507c56e6bd57", "fd8060f9266b72de63d063d80a6bb2f9"], "statement_hash": "4c14605560e017cf4d89bb8a33a0ab993f4a9ff353648fde85d7e88cde571530", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-9779bf86a7039bec", "cves": [], "html": "在应用逻辑复制更改时记录冲突（Zhijie Hou, Nisha Moond）§ § § § §
\n同时在 pg_stat_subscription_stats 的新列中报告。
允许生成列采用虚拟形式，并将虚拟生成列设为默认形式（Peter Eisentraut, Jian He, Richard Guo, Dean Rasheed）§ § §
\n虚拟生成列在读取时生成其值，而不是在写入时生成。写入行为仍然可以通过 STORED 选项指定。
为DML查询中的 RETURNING 添加 OLD/NEW 支持（Dean Rasheed）§
以前，RETURNING只返回INSERT和UPDATE的新值，以及DELETE的旧值；MERGE则根据实际执行的内部查询返回相应的值。新语法允许INSERT/UPDATE/DELETE/MERGE的RETURNING列表通过特殊别名old和new显式返回旧值和新值。这些别名可以重命名，以避免标识符冲突。
允许像现有本地表一样创建外部表（Zhang Mingli）§
\n语法是 CREATE FOREIGN TABLE ... LIKE。
允许 LIKE 与非确定性排序规则一起使用（Peter Eisentraut）§
允许文本位置搜索函数与非确定性排序规则一起使用（Peter Eisentraut）§
\n这些以前会生成错误。
", "text": "允许文本位置搜索函数与非确定性排序规则一起使用（Peter Eisentraut）§ 这些以前会生成错误。", "title": "允许文本位置搜索函数与非确定性排序规则一起使用", "commits": ["329304c90"], "section": "工具命令", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-UTILITY", "source_hash": "44de95f0bc4bf8dedce0af6fad80799804648813e2b8d379595f9119068daf23", "section_path": ["工具命令"], "commit_groups": [["329304c90"]], "identity_text": "Allow text position search functions with nondeterministic collations (Peter Eisentraut) These used to generate an error.", "commit_aliases": ["329304c90"], "source_commits": ["329304c90"], "source_entry_id": "18.0/changes/072", "db_id": "1633612e398b9d62fc3745ae04ffbdcb", "patch_ids": ["43d52072e1fb7ccdaab204775ce5218b"], "statement_hash": "819c561a7502a24a171a66abb4e6b6d3543683ac066ea66ccff53a0fce4befea", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-fa6e22f960ec67b4", "cves": [], "html": "添加内置排序规则提供程序 PG_UNICODE_FAST（Jeff Davis）§
此区域设置支持大小写映射，但按代码点顺序排序，而非自然语言顺序。
", "text": "添加内置排序规则提供程序 PG_UNICODE_FAST（Jeff Davis）§ 此区域设置支持大小写映射，但按代码点顺序排序，而非自然语言顺序。", "title": "添加内置排序规则提供程序 PG_UNICODE_FAST", "commits": ["d3d098316"], "section": "工具命令", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-UTILITY", "source_hash": "c67e8fc3c341be4b77ad03dc233abe7dcf8538d89e6aa0f6ccdf7ecd5fced9ee", "section_path": ["工具命令"], "commit_groups": [["d3d098316"]], "identity_text": "Add builtin collation provider PG_UNICODE_FAST (Jeff Davis) This locale supports case mapping, but sorts in code point order, not natural language order.", "commit_aliases": ["d3d098316"], "source_commits": ["d3d098316"], "source_entry_id": "18.0/changes/073", "db_id": "30595e5c571a05cc7aee9889ba3a082f", "patch_ids": ["04e3a10e98b76c4d3552450e42090216"], "statement_hash": "a2fd33890c8b434927b30005c495e84f2917c37b0d70177e7af7e169446cb0cc", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-21f4954ffd8217fb", "cves": [], "html": "允许VACUUM和ANALYZE处理分区表而不处理其子表（Michael Harris）§
\n这通过新的 ONLY 选项启用。这很有用，因为自动清理不处理分区表，只处理其子表。
添加函数以修改每关系和每列优化器统计信息（Corey Huinker）§ § §
\n这些函数是 pg_restore_relation_stats()、pg_restore_attribute_stats()、pg_clear_relation_stats() 和 pg_clear_attribute_stats()。
添加服务器变量file_copy_method以控制文件复制方法（Nazir Bilal Yavuz）§
\n这控制 CREATE DATABASE ... STRATEGY=FILE_COPY 和 ALTER DATABASE ... SET TABLESPACE 是使用文件复制还是克隆。
允许指定不重叠的 PRIMARY KEY、 UNIQUE 和外键约束（Paul A. Jungwirth）§ §
这通过 WITHOUT OVERLAPS 用于 PRIMARY KEY 和 UNIQUE，并通过 PERIOD 用于外键，所有这些都应用于最后一个指定的列。
允许将 CHECK 和外键约束指定为 NOT ENFORCED（Amul Sul）§ §
这还添加了列 pg_constraint.conenforced。
要求主键/外键关系使用确定性排序规则或相同的非确定性排序规则（Peter Eisentraut）§
\n如果这些要求不满足，pg_dump的恢复（pg_upgrade也使用）将失败；必须对模式进行更改才能使这些升级方法成功。
", "text": "要求主键/外键关系使用确定性排序规则或相同的非确定性排序规则（Peter Eisentraut）§ 如果这些要求不满足，pg_dump的恢复（pg_upgrade也使用）将失败；必须对模式进行更改才能使这些升级方法成功。", "title": "要求主键/外键关系使用确定性排序规则或相同的非确定性排序规则", "commits": ["9321d2fdf"], "section": "工具命令 / 约束", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-CONSTRAINTS", "source_hash": "2b17eb3b34045fd66a066a2076d863f0fa350f40aa79c07d72d3a50fcdeff6f3", "section_path": ["工具命令", "约束"], "commit_groups": [["9321d2fdf"]], "identity_text": "Require primary/foreign key relationships to use either deterministic collations or the the same nondeterministic collations (Peter Eisentraut) The restore of a app-pgdump , also used by pgupgrade , will fail if these requirements are not met; schema changes must be made for these upgrade methods to succeed.", "commit_aliases": ["9321d2fdf"], "source_commits": ["9321d2fdf"], "source_entry_id": "18.0/changes/079", "db_id": "68a1f7d62d756e8a62c81960b94b7516", "patch_ids": ["0ce5a6d8a11a1381cec57c4513b145b6"], "statement_hash": "2618c39bc6d6dedcb5838152a2f2578f929d0e51755b824342e7609b6456ce31", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-0bdb785dd7894611", "cves": [], "html": "将列 NOT NULL 规范存储在 pg_constraint 中（Álvaro Herrera, Bernd Helmle）§ §
这允许为 NOT NULL 约束指定名称。这还向外部表添加了 NOT NULL 约束，并向本地表添加了 NOT NULL 继承控制。
允许ALTER TABLE设置 NOT NULL 约束的 NOT VALID 属性（Rushabh Lathia, Jian He）§
允许修改 NOT NULL 约束的可继承性（Suraj Kharage, Álvaro Herrera）§ §
语法是 ALTER TABLE ... ALTER CONSTRAINT ... [NO] INHERIT。
允许分区表上的 NOT VALID 外键约束（Amul Sul）§
允许在分区表上使用 ONLY 丢弃约束（Álvaro Herrera）§
这以前被错误地禁止了。
", "text": "允许在分区表上使用 ONLY 丢弃约束（Álvaro Herrera）§ 这以前被错误地禁止了。", "title": "允许在分区表上使用 ONLY 丢弃约束", "commits": ["4dea33ce7"], "section": "工具命令 / 约束", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-CONSTRAINTS", "source_hash": "8c1219c56b3716c6e0669450727af7aed75763ee754fd98663afe83cdbb70624", "section_path": ["工具命令", "约束"], "commit_groups": [["4dea33ce7"]], "identity_text": "Allow dropping of constraints ONLY on partitioned tables (Álvaro Herrera) This was previously erroneously prohibited.", "commit_aliases": ["4dea33ce7"], "source_commits": ["4dea33ce7"], "source_entry_id": "18.0/changes/084", "db_id": "18344143b41582623ed016d08d3724f0", "patch_ids": ["e01f71769bcebafa65ea9e9facbc8f0e"], "statement_hash": "2f709f0920ff299f36d06fa6d2c5e29a93df41901d6a0aa8e7f22d2226fd478d", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-886a8aa244f2b933", "cves": [], "html": "添加 REJECT_LIMIT 以控制 COPY FROM 可以忽略的无效行数（Atsushi Torikoshi）§
这在 ON_ERROR = 'ignore' 时可用。
允许 COPY TO 从已填充的物化视图复制行（Jian He）§
添加 COPY LOG_VERBOSITY 级别 silent 以抑制被忽略行的日志输出（Atsushi Torikoshi）§
当 on_error = 'ignore' 时，此新级别会抑制与被丢弃输入行有关的消息输出。
禁止在外部表上 COPY FREEZE（Nathan Bossart）§
以前，COPY 可以工作，但 FREEZE 会被忽略，所以禁止此命令。
自动将 BUFFERS 输出包含在 EXPLAIN ANALYZE 中（Guillaume Lelarge, David Rowley）§
添加完整WAL缓冲区计数到 EXPLAIN (WAL) 输出（Bertrand Drouvot）§
在 EXPLAIN ANALYZE 中，报告每个索引扫描节点使用的索引查找次数（Peter Geoghegan）§
修改 EXPLAIN 以输出小数行计数（Ibrar Ahmed, Ilia Evdokimov, Robert Haas）§ §
在 EXPLAIN 输出中，为 Material、Window Aggregate 和通用表表达式节点添加内存和磁盘使用详情（David Rowley, Tatsuo Ishii）§ § § §
将窗口函数参数的详细信息添加到 EXPLAIN 输出（Tom Lane）§
将 Parallel Bitmap Heap Scan 工作者缓存统计信息添加到 EXPLAIN ANALYZE（David Geier, Heikki Linnakangas, Donghang Lin, Alena Rybakina, David Rowley）§
在 EXPLAIN ANALYZE 输出中指示已禁用节点（Robert Haas, David Rowley, Laurenz Albe）§ § §
改进 Unicode 全大小写映射和转换（Jeff Davis）§ §
\n这增加了进行条件和标题大小写映射的能力，以及将单个字符大小写映射到多个字符的能力。
", "text": "改进 Unicode 全大小写映射和转换（Jeff Davis）§ § 这增加了进行条件和标题大小写映射的能力，以及将单个字符大小写映射到多个字符的能力。", "title": "改进 Unicode 全大小写映射和转换", "commits": ["286a365b9", "4e7f62bc3"], "section": "数据类型", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES", "source_hash": "44c26c92986f06630e401c20db860295e1e24fcd5259ea9ea934f4bf062fdd8e", "section_path": ["数据类型"], "commit_groups": [["286a365b9"], ["4e7f62bc3"]], "identity_text": "Improve Unicode full case mapping and conversion (Jeff Davis) This adds the ability to do conditional and title case mapping, and case map single characters to multiple characters.", "commit_aliases": ["286a365b9", "4e7f62bc3"], "source_commits": ["286a365b9", "4e7f62bc3"], "source_entry_id": "18.0/changes/097", "db_id": "1b2ed6a4886122496b4235e9bc502410", "patch_ids": ["0bc695a859154bdbe2aa4141a8c131d7", "c4d90a2c6dc576697ae6803230585a80"], "statement_hash": "02776b8149a82584d272cc2094e4a669aca778c5844f65839a5f72cf0687f143", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-40f5a48bcd0f93e0", "cves": [], "html": "允许在将 jsonb null 值转换为标量类型时返回 NULL（Tom Lane）§
以前这样的转换会产生错误。
", "text": "允许在将 jsonb null 值转换为标量类型时返回 NULL（Tom Lane）§ 以前这样的转换会产生错误。", "title": "允许在将 jsonb null 值转换为标量类型时返回 NULL", "commits": ["a5579a90a"], "section": "数据类型", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES", "source_hash": "1e15ce0182df8ba9bb4f5d3c70a693a1c71b87744e48c4280afcb76462804520", "section_path": ["数据类型"], "commit_groups": [["a5579a90a"]], "identity_text": "Allow jsonb null values to be cast to scalar types as NULL (Tom Lane) Previously such casts generated an error.", "commit_aliases": ["a5579a90a"], "source_commits": ["a5579a90a"], "source_entry_id": "18.0/changes/098", "db_id": "707a9526e8d1e6416419dcc4e0f8c1fb", "patch_ids": ["f6184b101cbccd529291b34b9ea43559"], "statement_hash": "e835773742df55f58b57f5dbf777b47ddc9916b939e5f10a60426d8f63610fdd", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-ae21c8cd0f07e687", "cves": [], "html": "向 json{b}_strip_nulls 添加可选参数，以允许删除数组中的空值元素（Florents Tselai）§
添加函数 array_sort()，它对数组的第一维进行排序（Junwang Zhao, Jian He）§
添加函数 array_reverse()，它反转数组的第一维（Aleksander Alekseev）§
添加函数 reverse() 以反转 bytea 字节（Aleksander Alekseev）§
允许在整数类型和 bytea 之间进行转换（Aleksander Alekseev）§
整数值存储为 bytea 二进制补码值。
更新 Unicode 数据至 Unicode 16.0.0（Peter Eisentraut）§
", "text": "更新 Unicode 数据至 Unicode 16.0.0（Peter Eisentraut）§", "title": "更新 Unicode 数据至 Unicode 16.0.0", "commits": ["82a46cca9"], "section": "数据类型", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES", "source_hash": "7b363edbf7fc1652e00ae639f016a531400b78a1501225262fbf76a7fc2c0dd8", "section_path": ["数据类型"], "commit_groups": [["82a46cca9"]], "identity_text": "Update Unicode data to Unicode 16.0.0 (Peter Eisentraut)", "commit_aliases": ["82a46cca9"], "source_commits": ["82a46cca9"], "source_entry_id": "18.0/changes/104", "db_id": "b3a13160940dac3f7a1a1af7f4cf764d", "patch_ids": ["37e8f514959e205b0155b61312d52d56"], "statement_hash": "dc448dd80b25033f629182d9bb00f6e6eb258933e0fc988309cd3ddbaf4be408", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-ddc75ea0db8ffc49", "cves": [], "html": "", "text": "添加爱沙尼亚语的全文检索词干提取（Tom Lane）§", "title": "添加爱沙尼亚语的全文检索词干提取", "commits": ["b464e51ab"], "section": "数据类型", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES", "source_hash": "dd6878414ee23406689c7eefc1a641935c96e6bd890e0e1431ff6fd28bfca759", "section_path": ["数据类型"], "commit_groups": [["197427fb3", "7edd2cbc5", "8388cae55", "9c46d902b", "b464e51ab", "c0c364fa1"]], "identity_text": "Add full text search stemming for Estonian (Tom Lane)", "commit_aliases": ["197427fb3", "7edd2cbc5", "8388cae55", "9c46d902b", "b464e51ab", "c0c364fa1"], "source_commits": ["b464e51ab"], "source_entry_id": "18.0/changes/105", "db_id": "d02c90e2590d4a47f73a5782496b4966", "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "765cc1defacc087129eb32bf5f736de4c5be16883a95fba7b8adca47a87ce874", "relations": [{"rule": 2, "type": "related", "target": "00feddbb8384a7a8cefe4217cd497215", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "related", "target": "43dbc69a435522e8a12bbf37193bcbca", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "related", "target": "c2850458f2850974df366bef8a85488e", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "related", "target": "d6bf0f560b8ac8cad3c1d6a070b45594", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "related", "target": "fe6fa87c7f7a2f01e5226fc8b75d4395", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "fe6fa87c7f7a2f01e5226fc8b75d4395", "kind": "related", "version": "17.5", "label": "17.5", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}, "url": "/docs/compare/?release=17.5#17.5-88fad50b7b3b2e15", "source_url": "/docs/release/17.5/#RELEASE-17-5-CHANGES"}, {"db_id": "c2850458f2850974df366bef8a85488e", "kind": "related", "version": "16.9", "label": "16.9", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}, "url": "/docs/compare/?release=16.9#16.9-71f38ed0f1b64f88", "source_url": "/docs/release/16.9/#RELEASE-16-9-CHANGES"}, {"db_id": "00feddbb8384a7a8cefe4217cd497215", "kind": "related", "version": "15.13", "label": "15.13", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}, "url": "/docs/compare/?release=15.13#15.13-6fa1c30b53ef4a7a", "source_url": "/docs/release/15.13/#ZH-AUTO-RELEASE-15-SECT2-10"}, {"db_id": "d6bf0f560b8ac8cad3c1d6a070b45594", "kind": "related", "version": "14.18", "label": "14.18", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}, "url": "/docs/compare/?release=14.18#14.18-813abffbc8584526", "source_url": "/docs/release/14.18/#ZH-AUTO-RELEASE-14-SECT2-10"}, {"db_id": "43dbc69a435522e8a12bbf37193bcbca", "kind": "related", "version": "13.21", "label": "13.21", "title": "避免在 Snowball 词干提取器遇到内存不足条件时崩溃", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}, "url": "/docs/compare/?release=13.21#13.21-7de382d5402e6e82", "source_url": "/docs/release/13.21/#id-1.11.6.8.6"}]}, {"id": "18.0-b8b7af2d05807f76", "cves": [], "html": "改进 XML 错误代码以更接近SQL标准（Tom Lane）§
这些错误通过 SQLSTATE 报告。
添加函数 casefold() 以允许更复杂的忽略大小写匹配（Jeff Davis）§
这允许更准确的比较，即一个字符可以有多个大写或小写等价物，或者大写或小写转换会改变字符的数量。
", "text": "添加函数 casefold() 以允许更复杂的忽略大小写匹配（Jeff Davis）§ 这允许更准确的比较，即一个字符可以有多个大写或小写等价物，或者大写或小写转换会改变字符的数量。", "title": "添加函数 casefold() 以允许更复杂的忽略大小写匹配", "commits": ["bfc599206"], "section": "函数", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-FUNCTIONS", "source_hash": "45cb069e223659d8f877c9a2110d431b847abaa3d2bf90c2d51977f38f2e6cb4", "section_path": ["函数"], "commit_groups": [["bfc599206"]], "identity_text": "Add function casefold() to allow for more sophisticated case-insensitive matching (Jeff Davis) This allows more accurate comparisons, i.e., a character can have multiple upper or lower case equivalents, or upper or lower case conversion changes the number of characters.", "commit_aliases": ["bfc599206"], "source_commits": ["bfc599206"], "source_entry_id": "18.0/changes/107", "db_id": "b6349fdce5ba2ae112d0be3d05e38198", "patch_ids": ["0684a21f7afe3e30c9299aaa67789314"], "statement_hash": "c9d001f8f460c1f05dad5d20c8956c701fd640f0996cec7198b5decd3f545c09", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-ce3995bf22cc0e40", "cves": [], "html": "允许在数组和复合类型上进行 MIN()/MAX() 聚合（Aleksander Alekseev, Marat Buharov）§ §
向 EXTRACT() 添加 WEEK 选项（Tom Lane）§
改进 EXTRACT(QUARTER ...) 对负值的输出（Tom Lane）§
向 to_number() 添加罗马数字支持（Hunaid Sohail）§
这通过 RN 模式访问。
添加 UUID 版本7生成函数 uuidv7()（Andrey Borodin）§
此 UUID 值可按时间排序。已添加函数别名 uuidv4() 以显式生成版本4 UUID。
添加函数 crc32() 和 crc32c() 以计算CRC值（Aleksander Alekseev）§
添加数学函数 gamma() 和 lgamma()（Dean Rasheed）§
允许在 PL/pgSQL 中使用 => 语法指定具名游标参数（Pavel Stehule）§
我们以前只接受 :=。
允许 regexp_match[es]()/regexp_like()/regexp_replace()/regexp_count()/regexp_instr()/regexp_substr()/regexp_split_to_table()/regexp_split_to_array() 使用命名参数（Jian He）§
添加函数 PQfullProtocolVersion() 以报告完整的（包括次要版本）协议版本号（Jacob Champion, Jelte Fennema-Nio）§
添加 libpq 连接参数和环境变量以指定连接的最小和最大可接受协议版本（Jelte Fennema-Nio）§ §
", "text": "添加 libpq 连接参数和环境变量以指定连接的最小和最大可接受协议版本（Jelte Fennema-Nio）§ §", "title": "添加 libpq 连接参数和环境变量以指定连接的最小和最大可接受协议版本", "commits": ["285613c60", "507034910"], "section": "Libpq", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-LIBPQ", "source_hash": "dd8e24e0798022c5e49d33b8f037eae94f69ab39a4a885b8b176f5e16dbcf97e", "section_path": ["Libpq"], "commit_groups": [["285613c60"], ["507034910"]], "identity_text": "Add libpq connection parameters and environment variables to specify the minimum and maximum acceptable protocol version for connections (Jelte Fennema-Nio)", "commit_aliases": ["285613c60", "507034910"], "source_commits": ["285613c60", "507034910"], "source_entry_id": "18.0/changes/118", "db_id": "324ad8ffd0dc73072b6cae1163bbd895", "patch_ids": ["534b2c53e2e1a92c27d124b03e588165", "75729722b6f7aba5cfb305b2f8099d9d"], "statement_hash": "5bc66e57f7b5710b779499207adb20134778a80ccd962165684afde348719556", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-207d234a979be0ba", "cves": [], "html": "向客户端报告search_path更改（Alexander Kukushkin, Jelte Fennema-Nio, Tomas Vondra）§ §
", "text": "向客户端报告search_path更改（Alexander Kukushkin, Jelte Fennema-Nio, Tomas Vondra）§ §", "title": "向客户端报告search_path更改", "commits": ["0d06a7eac", "28a1121fd"], "section": "Libpq", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-LIBPQ", "source_hash": "1b3b66fd3e804bfd9a8f8eb4900833f7becb2d7ae3e27f57d8450450272b7e24", "section_path": ["Libpq"], "commit_groups": [["0d06a7eac"], ["28a1121fd"]], "identity_text": "Report guc-search-path changes to the client (Alexander Kukushkin, Jelte Fennema-Nio, Tomas Vondra)", "commit_aliases": ["0d06a7eac", "28a1121fd"], "source_commits": ["0d06a7eac", "28a1121fd"], "source_entry_id": "18.0/changes/119", "db_id": "218352fe6746ce16b55b280a597a34c3", "patch_ids": ["5ff7e1b21d24cbfadde9ec259d6a73c7", "6773d35e5f3a311c7ff50c9c2faf3885"], "statement_hash": "50991c451a4bfb5e106b4ba60fe467da4d2e687a547ce099c82004fbe44fd3e9", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-beeeaad682b3e543", "cves": [], "html": "添加 PQtrace() 输出，用于所有消息类型，包括认证（Jelte Fennema-Nio）§ § § § §
添加 libpq 连接参数 sslkeylogfile，该参数会转储SSL密钥材料（Abhishek Chanda, Daniel Gustafsson）§
这对于调试很有用。
", "text": "添加 libpq 连接参数 sslkeylogfile，该参数会转储SSL密钥材料（Abhishek Chanda, Daniel Gustafsson）§ 这对于调试很有用。", "title": "添加 libpq 连接参数 sslkeylogfile，该参数会转储SSL密钥材料", "commits": ["2da74d8d6"], "section": "Libpq", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-LIBPQ", "source_hash": "8a53c283c907184c5c28dc8b1a80814c955c04574c96f11e2d4b6d6ad07852f9", "section_path": ["Libpq"], "commit_groups": [["2da74d8d6"]], "identity_text": "Add libpq connection parameter sslkeylogfile which dumps out SSL key material (Abhishek Chanda, Daniel Gustafsson) This is useful for debugging.", "commit_aliases": ["2da74d8d6"], "source_commits": ["2da74d8d6"], "source_entry_id": "18.0/changes/121", "db_id": "dec95e8329f62b657fc15ccfb7d006fb", "patch_ids": ["5c9abb135b2e6fb82671370102be25d3"], "statement_hash": "0cbbb246f331bdcf188172740da0fa02fe152d60204197e426ec23a6c89278c5", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-f56e310a693fee70", "cves": [], "html": "修改一些 libpq 函数签名以使用 int64_t（Thomas Munro）§
这些以前使用 pg_int64，现已弃用。
允许 psql 解析、绑定和关闭命名预处理语句（Anthonin Bonnefoy, Michael Paquier）§ §
\n这通过新命令 \\parse、\\bind_named 和 \\close_prepared 完成。
添加 psql 反斜杠命令以允许发出管道查询（Anthonin Bonnefoy）§ § §
\n新命令是 \\startpipeline、\\syncpipeline、\\sendpipeline、\\endpipeline、\\flushrequest、\\flush 和 \\getresults。
允许将管道状态添加到 psql 提示符并添加相关状态变量（Anthonin Bonnefoy）§
\n新的提示符字符是 %P，新的 psql 变量是 PIPELINE_SYNC_COUNT、PIPELINE_COMMAND_COUNT 和 PIPELINE_RESULT_COUNT。
允许将连接服务名称添加到 psql 提示符或通过 psql 变量访问它（Michael Banck）§
", "text": "允许将连接服务名称添加到 psql 提示符或通过 psql 变量访问它（Michael Banck）§", "title": "允许将连接服务名称添加到 psql 提示符或通过 psql 变量访问它", "commits": ["477728b5d"], "section": "psql", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PSQL", "source_hash": "d708d70528e3a3f746395fa23b8324b7dfe19e3fa2560f0d3fb61d86a8f4af8b", "section_path": ["psql"], "commit_groups": [["477728b5d"]], "identity_text": "Allow adding the connection service name to the psql prompt or access it via psql variable (Michael Banck)", "commit_aliases": ["477728b5d"], "source_commits": ["477728b5d"], "source_entry_id": "18.0/changes/126", "db_id": "b448890a42701668cc28db2c98fe65af", "patch_ids": ["8bc6eb53f480b1773dba3d9ca6fa27ef"], "statement_hash": "b7b84052ccad3b3cdd4e58fd81d7e92d01dcd30e03a638017f02df36fe51481c", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-b431886faffda5ff", "cves": [], "html": "添加 psql 选项，在所有列表命令上使用扩展模式（Dean Rasheed）§
\n添加反斜杠后缀 x 启用此功能。
更改 psql 的\\conninfo以使用表格格式并包含更多信息（Álvaro Herrera, Maiquel Grassi, Hunaid Sohail）§
将函数的防泄漏指示器添加到 psql 的 \\df+、\\do+、\\dAo+ 和 \\dC+ 输出（Yugo Nagata）§
在 \\dP+ 中为分区关系添加访问方法详细信息（Justin Pryzby）§
将 default_version 添加到 psql \\dx 扩展输出（Magnus Hagander）§
添加 psql 变量WATCH_INTERVAL以设置默认的 \\watch 等待时间（Daniel Gustafsson）§
更改initdb默认启用校验和（Greg Sabino Mullane）§ §
\n新的 initdb 选项 --no-data-checksums 禁用校验和。
添加 initdb 选项 --no-sync-data-files 以避免同步堆/索引文件（Nathan Bossart）§
initdb 选项 --no-sync 仍然可用，以避免同步任何文件。
添加vacuumdb选项 --missing-stats-only 以仅计算缺失的优化器统计信息（Corey Huinker, Nathan Bossart）§ §
此选项只能由超级用户运行，并且只能与选项 --analyze-only 和 --analyze-in-stages 一起使用。
添加pg_combinebackup选项 -k/--link 以启用硬链接（Israel Barth Rubio, Robert Haas）§
只有某些文件可以硬链接。如果备份将独立使用，则不应使用此功能。
", "text": "添加pg_combinebackup选项 -k/--link 以启用硬链接（Israel Barth Rubio, Robert Haas）§ 只有某些文件可以硬链接。如果备份将独立使用，则不应使用此功能。", "title": "添加pg_combinebackup选项 -k/--link 以启用硬链接", "commits": ["99aeb8470"], "section": "服务器应用", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-APPS", "source_hash": "eefef01cb696f44d91b49f7817d447e5f2b2aeac8ca97a0513d80a36ce3eab22", "section_path": ["服务器应用"], "commit_groups": [["99aeb8470"]], "identity_text": "Add app-pgcombinebackup option -k/--link to enable hard linking (Israel Barth Rubio, Robert Haas) Only some files can be hard linked. This should not be used if the backups will be used independently.", "commit_aliases": ["99aeb8470"], "source_commits": ["99aeb8470"], "source_entry_id": "18.0/changes/136", "db_id": "cbac9921cfb2186e54629d635e3729f3", "patch_ids": ["b2774e6278fb43524469fa415bf7c504"], "statement_hash": "5736af1019c3d5e2bd2ae443e4a9261637afca5e0e0ff655d599e24adaf4ea01", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-ed3c2d316129795e", "cves": [], "html": "允许pg_verifybackup验证 tar 格式备份（Amul Sul）§
", "text": "允许pg_verifybackup验证 tar 格式备份（Amul Sul）§", "title": "允许pg_verifybackup验证 tar 格式备份", "commits": ["8dfd31290"], "section": "服务器应用", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-APPS", "source_hash": "e2b0d86a1a6fe34a3eaef7656a3093c8fef2bcf4bb4045b3b394c42b6e595297", "section_path": ["服务器应用"], "commit_groups": [["8dfd31290"]], "identity_text": "Allow app-pgverifybackup to verify tar-format backups (Amul Sul)", "commit_aliases": ["8dfd31290"], "source_commits": ["8dfd31290"], "source_entry_id": "18.0/changes/137", "db_id": "4a31265bb9d301899f61cbb72dc938fe", "patch_ids": ["f61db0ff36a5aaba1fefc4551593c41a"], "statement_hash": "033fcbd8882efc5f140f40a57fd1009957f6354e0fff3b3c07f05be1d2c1ce01", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-51cd1c3ad2116931", "cves": [], "html": "如果pg_rewind的 --source-server 指定了数据库名称，则在 --write-recovery-conf 输出中使用它（Masahiko Sawada）§
添加pg_resetwal选项 --char-signedness 以更改默认的 char 有符号性（Masahiko Sawada）§
添加pg_dump选项 --statistics（Jeff Davis）§ §
添加 pg_dump 和pg_dumpall选项 --sequence-data 以转储通常会被排除的序列数据（Nathan Bossart）§ §
添加pg_dump、pg_dumpall和pg_restore选项 --statistics-only、--no-statistics、--no-data 和 --no-schema（Corey Huinker, Jeff Davis）§
添加选项 --no-policies 以禁用pg_dump、pg_dumpall、pg_restore中的行级安全策略处理（Nikolay Samokhvalov）§
这对于迁移到具有不同策略的系统很有用。
", "text": "添加选项 --no-policies 以禁用pg_dump、pg_dumpall、pg_restore中的行级安全策略处理（Nikolay Samokhvalov）§ 这对于迁移到具有不同策略的系统很有用。", "title": "添加选项 --no-policies 以禁用pg_dump、pg_dumpall、pg_restore中的行级安全策略处理", "commits": ["cd3c45125"], "section": "服务器应用 / pg_dump/pg_dumpall/pg_restore", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGDUMP", "source_hash": "9231fdf3af2971c21ef9738044c6bf6fc9a4e82d61c155057f623aeacf8d1381", "section_path": ["服务器应用", "pg_dump/pg_dumpall/pg_restore"], "commit_groups": [["cd3c45125"]], "identity_text": "Add option --no-policies to disable row level security policy processing in app-pgdump , app-pg-dumpall , app-pgrestore (Nikolay Samokhvalov) This is useful for migrating to systems with different policies.", "commit_aliases": ["cd3c45125"], "source_commits": ["cd3c45125"], "source_entry_id": "18.0/changes/143", "db_id": "f65a09f6ed8414315ea3ab15d44b063d", "patch_ids": ["e8632c1f2c717fcff1a04211ab59a0c3"], "statement_hash": "c2544d757037ea2d9f0d54209afb5dfcd831c83b0fb375579be57d3ffb98b730", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-b708d651d189458f", "cves": [], "html": "允许 pg_upgrade 保留优化器统计信息（Corey Huinker, Jeff Davis, Nathan Bossart）§ § § §
\n不保留扩展统计信息。同时添加 pg_upgrade 选项 --no-statistics 以禁用统计信息保留。
允许 pg_upgrade 并行处理数据库检查（Nathan Bossart）§ § § § § § § § § § §
\n这由现有 --jobs 选项控制。
添加 pg_upgrade 选项 --swap 以交换目录而不是复制、克隆或链接文件（Nathan Bossart）§
此模式可能是最快的。
", "text": "添加 pg_upgrade 选项 --swap 以交换目录而不是复制、克隆或链接文件（Nathan Bossart）§ 此模式可能是最快的。", "title": "添加 pg_upgrade 选项 --swap 以交换目录而不是复制、克隆或链接文件", "commits": ["626d7236b"], "section": "服务器应用 / pg_upgrade", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGUPGRADE", "source_hash": "5105f96fe345879f059f5dec740fcdf62c3fb86f637efc061ea65ff41062563f", "section_path": ["服务器应用", "pg_upgrade"], "commit_groups": [["626d7236b"]], "identity_text": "Add pg_upgrade option --swap to swap directories rather than copy, clone, or link files (Nathan Bossart) This mode is potentially the fastest.", "commit_aliases": ["626d7236b"], "source_commits": ["626d7236b"], "source_entry_id": "18.0/changes/146", "db_id": "f554eecffc9529fc8a7bf5df05f1ee48", "patch_ids": ["925b13034396ed82973d22527b295ac1"], "statement_hash": "446dc8dd0a3efeea98cbe5eef953503f703ba461702c2ad5d7041434781f351e", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-d2c23c9432e26b4b", "cves": [], "html": "添加 pg_upgrade 选项 --set-char-signedness 以设置新集簇的默认 char 符号性（Masahiko Sawada）§ §
这是为了处理 PostgreSQL 18 之前集簇的默认CPU符号性与新集簇不匹配的情况。
", "text": "添加 pg_upgrade 选项 --set-char-signedness 以设置新集簇的默认 char 符号性（Masahiko Sawada）§ § 这是为了处理 PostgreSQL 18 之前集簇的默认CPU符号性与新集簇不匹配的情况。", "title": "添加 pg_upgrade 选项 --set-char-signedness 以设置新集簇的默认 char 符号性", "commits": ["1aab68059", "a8238f87f"], "section": "服务器应用 / pg_upgrade", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGUPGRADE", "source_hash": "81fc7dfeaecc0c2acbed8c77a91318171c093256de3f1c6509e4ddb9b3506a2b", "section_path": ["服务器应用", "pg_upgrade"], "commit_groups": [["1aab68059"], ["a8238f87f"]], "identity_text": "Add pg_upgrade option --set-char-signedness to set the default char signedness of new cluster (Masahiko Sawada) This is to handle cases where a pre-PostgreSQL 18 cluster's default CPU signedness does not match the new cluster.", "commit_aliases": ["1aab68059", "a8238f87f"], "source_commits": ["1aab68059", "a8238f87f"], "source_entry_id": "18.0/changes/147", "db_id": "512ccd3d1bb4f010fe11b0eb637be55c", "patch_ids": ["85f2c26487e180e9e34c5a419dbbbf35", "b55f3df554d6f4f601f40f9bd71932dc"], "statement_hash": "5d736231626605165fd5a2523999bf34662259ec86505d0abb98425210873d2d", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-d19757fdc61ec769", "cves": [], "html": "添加pg_createsubscriber选项 --all 以创建所有数据库的逻辑副本（Shubham Khanna）§
添加 pg_createsubscriber 选项 --clean 以删除发布（Shubham Khanna）§ §
添加 pg_createsubscriber 选项 --enable-two-phase 以启用预备事务（Shubham Khanna）§
添加pg_recvlogical选项 --enable-failover 以指定故障切换槽（Hayato Kuroda）§
还添加选项 --enable-two-phase 作为 --two-phase 的同义词，并弃用后者。
允许 pg_recvlogical --drop-slot 在没有 --dbname 的情况下工作（Hayato Kuroda）§
分离注入点的加载和运行（Michael Paquier, Heikki Linnakangas）§ §
\n现在可以通过 INJECTION_POINT_LOAD() 创建注入点但不运行，并且可以通过 INJECTION_POINT_CACHED() 运行这些注入点。
支持注入点中的运行时参数（Michael Paquier）§
", "text": "支持注入点中的运行时参数（Michael Paquier）§", "title": "支持注入点中的运行时参数", "commits": ["371f2db8b"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "05301770ccd349689d8b69904a931228a96e0662899a3ade25f228442b6353fc", "section_path": ["源代码"], "commit_groups": [["371f2db8b"]], "identity_text": "Support runtime arguments in injection points (Michael Paquier)", "commit_aliases": ["371f2db8b"], "source_commits": ["371f2db8b"], "source_entry_id": "18.0/changes/154", "db_id": "18e4ff23a56d78d29d6ae66814cb5956", "patch_ids": ["904e25b09a2067d4faafaee411020747"], "statement_hash": "5628295a828190147d169e94449983354f8ae8ff5a86e747e2323a9fafe55684", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-47c2086c6c32cddf", "cves": [], "html": "允许使用 IS_INJECTION_POINT_ATTACHED() 的内联注入点测试代码（Heikki Linnakangas）§
使用 SIMD（单指令多数据）改进处理长JSON字符串的性能（David Rowley）§
使用 x86 AVX-512 指令加速 CRC32C 计算（Raghuveer Devulapalli, Paul Amonson）§
", "text": "使用 x86 AVX-512 指令加速 CRC32C 计算（Raghuveer Devulapalli, Paul Amonson）§", "title": "使用 x86 AVX-512 指令加速 CRC32C 计算", "commits": ["3c6e8c123"], "section": "源代码", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "5c411d4b51c4b6be50ef868a21271a59e4a75118bd9ef67ecd94fe284fa402d6", "section_path": ["源代码"], "commit_groups": [["3c6e8c123"]], "identity_text": "Speed up CRC32C calculations using x86 AVX-512 instructions (Raghuveer Devulapalli, Paul Amonson)", "commit_aliases": ["3c6e8c123"], "source_commits": ["3c6e8c123"], "source_entry_id": "18.0/changes/157", "db_id": "ecafb4a5cc6e92dddebe2ea023f597fc", "patch_ids": ["019ee0d01e78e91881714ff3219df19d"], "statement_hash": "9ebfb29bd90710429d9371df23815bf2b5a56103e50f8fd93d29218148000bd5", "relations": [], "version": "18.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-800b2833fc9c07cb", "cves": [], "html": "添加用于 popcount（整数位计数）的ARM Neon 和SVE CPU内在函数（Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi）§ §
", "text": "添加用于 popcount（整数位计数）的ARM Neon 和SVE CPU内在函数（Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi）§ §", "title": "添加用于 popcount（整数位计数）的ARM Neon 和SVE CPU内在函数", "commits": ["519338ace", "6be53c276"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "09d6f13a948bcd90f3f3ac8e4018d0c533c115226c68a7db35a0bca2856dc813", "section_path": ["源代码"], "commit_groups": [["519338ace"], ["6be53c276"]], "identity_text": "Add ARM Neon and SVE CPU intrinsics for popcount (integer bit counting) (Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi)", "commit_aliases": ["519338ace", "6be53c276"], "source_commits": ["519338ace", "6be53c276"], "source_entry_id": "18.0/changes/158", "db_id": "e50b80ab8e5fdb402e0beb48a5db4bc9", "patch_ids": ["205916923c7dd75d0231c55476cd4c48", "fd2f2d7fbcf88e0449c66f9f417165fc"], "statement_hash": "ee09c22e85fe2068ac5f7492e13742c8aea22c6679a441f8015237ca7bdeeca7", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-0ce7fe540ff763c1", "cves": [], "html": "提高数值乘法和除法的速度（Joel Jacobson, Dean Rasheed）§ § § §
", "text": "提高数值乘法和除法的速度（Joel Jacobson, Dean Rasheed）§ § § §", "title": "提高数值乘法和除法的速度", "commits": ["8dc28d7eb", "9428c001f", "c4e44224c", "ca481d3c9"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "6edd099ca744adedc636a8415e8be30ad6220455ffa27ad1859cf8db0e9e45b0", "section_path": ["源代码"], "commit_groups": [["8dc28d7eb"], ["9428c001f"], ["c4e44224c"], ["ca481d3c9"]], "identity_text": "Improve the speed of numeric multiplication and division (Joel Jacobson, Dean Rasheed)", "commit_aliases": ["8dc28d7eb", "9428c001f", "c4e44224c", "ca481d3c9"], "source_commits": ["8dc28d7eb", "9428c001f", "c4e44224c", "ca481d3c9"], "source_entry_id": "18.0/changes/159", "db_id": "a7dfad9e7ea9413b1f4feb4de2d8c632", "patch_ids": ["2f55166563d7d9ec64de99e0bf6e591a", "674fb4fd8062e095c5e8fbfa7beab186", "8d573b00acf40046627605c19414157d", "eb6faba6db5698c6310910540adef0d3"], "statement_hash": "8921ae4e40b001cd77fce579693d0a2e93ba934d8c04d74b261b43866655c114", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-7ed66c101b89375c", "cves": [], "html": "添加配置选项--with-libnuma以启用NUMA感知功能（Jakub Wartak, Bertrand Drouvot）§ § §
函数pg_numa_available() 报告是否具备NUMA感知能力；系统视图 pg_shmem_allocations_numa 和pg_buffercache_numa 报告共享内存在NUMA节点之间的分布。
将TOAST表添加到pg_index，以允许创建超大型表达式索引（Nathan Bossart）§
移除列pg_attribute.attcacheoff（David Rowley）§
添加列pg_class.relallfrozen（Melanie Plageman）§
将amgettreeheight、amconsistentequality和amconsistentordering添加到索引访问方法API（Mark Dilger）§ §
添加GiST支持函数stratnum()（Paul A. Jungwirth）§
在pg_controldata中记录CPU对char类型的默认有符号性（Masahiko Sawada）§
在PL/Python中添加对 Python“Limited API”的支持（Peter Eisentraut）§§
\n这有助于防止由于Python 3.x 版本不匹配引起的问题。
", "text": "在PL/Python中添加对 Python“Limited API”的支持（Peter Eisentraut）§§ 这有助于防止由于Python 3.x 版本不匹配引起的问题。", "title": "在PL/Python中添加对 Python“Limited API”的支持", "commits": ["0793ab810", "72a3d0462"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "f49def5963789b61e9e11e6b78ad16b391ce6657675eb5e12857c3d90c25063f", "section_path": ["源代码"], "commit_groups": [["0793ab810"], ["72a3d0462"]], "identity_text": "Add support for Python \"Limited API\" in PL/Python (Peter Eisentraut) This helps prevent problems caused by Python 3.x version mismatches.", "commit_aliases": ["0793ab810", "72a3d0462"], "source_commits": ["0793ab810", "72a3d0462"], "source_entry_id": "18.0/changes/167", "db_id": "d9d289d7c17d30019901f5104438a9b5", "patch_ids": ["cbf73ec20c058f368547efbe37a75ed9", "d615c6575bcf9dabc148901891890deb"], "statement_hash": "bf3af05933e7d77673abcb674c13915120867f48aac15d60053f750a42d0d7d0", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-a91e1aed4a58b3e8", "cves": [], "html": "将最低支持的Python版本更改为3.6.8（Jacob Champion）§
", "text": "将最低支持的Python版本更改为3.6.8（Jacob Champion）§", "title": "将最低支持的Python版本更改为3.6.8", "commits": ["45363fca6"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "edfc0a822c1e6decb577eb651c059faf6285be5446a2ae201393b823c93a7b4a", "section_path": ["源代码"], "commit_groups": [["45363fca6"]], "identity_text": "Change the minimum supported Python version to 3.6.8 (Jacob Champion)", "commit_aliases": ["45363fca6"], "source_commits": ["45363fca6"], "source_entry_id": "18.0/changes/168", "db_id": "3803d2204af4aafb31861db9c07294df", "patch_ids": ["d238a5c385201266bab1298ddc3d6937"], "statement_hash": "8e0582a6e94665c56a736b1daf82f2826837a955bf1ad3c8fed3ee41c1854b9b", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-569734334a6b98e9", "cves": [], "html": "移除对早于1.1.1版本的OpenSSL的支持（Daniel Gustafsson）§ §
", "text": "移除对早于1.1.1版本的OpenSSL的支持（Daniel Gustafsson）§ §", "title": "移除对早于1.1.1版本的OpenSSL的支持", "commits": ["6c66b7443", "a70e01d43"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "fef36e34b98c4cf8afc0e87fda7cd8014955b79b409cd798e1776f2cbb3cc19d", "section_path": ["源代码"], "commit_groups": [["6c66b7443"], ["a70e01d43"]], "identity_text": "Remove support for OpenSSL versions older than 1.1.1 (Daniel Gustafsson)", "commit_aliases": ["6c66b7443", "a70e01d43"], "source_commits": ["6c66b7443", "a70e01d43"], "source_entry_id": "18.0/changes/169", "db_id": "48cbbe1a33f004fe33768f2881d5d92f", "patch_ids": ["abb2eed446c79007a20dabd90ec11e07", "e230f75c4521f002154fbc695ab93e0a"], "statement_hash": "c8e7dae9a85d85423b23da56e2d21b96b7f26438f93b7ac8c175a38b66b24100", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-bd09bbc2d989193e", "cves": [], "html": "如果启用LLVM，则要求版本14或更高（Thomas Munro）§
", "text": "如果启用LLVM，则要求版本14或更高（Thomas Munro）§", "title": "如果启用LLVM，则要求版本14或更高", "commits": ["972c2cd28"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "312a91a833836d352538d85b42e2e70e2f3593c02b219f7e95f80da5e10bfaf4", "section_path": ["源代码"], "commit_groups": [["972c2cd28"]], "identity_text": "If LLVM is enabled, require version 14 or later (Thomas Munro)", "commit_aliases": ["972c2cd28"], "source_commits": ["972c2cd28"], "source_entry_id": "18.0/changes/170", "db_id": "50c7a44be3192eea399751ed1200e8e8", "patch_ids": ["8a4ef85fef8148a0752a6381c6a739bb"], "statement_hash": "36fc6c5974c10ca846263ab84a10c91abb0ab4d1f95effb5f1513c71c37a4bbe", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-0f56f248bf4ec2a9", "cves": [], "html": "添加宏PG_MODULE_MAGIC_EXT以允许扩展报告其名称和版本（Andrei Lepikhov）§
此信息可以通过新函数pg_get_loaded_modules()访问。
文档指出SPI_connect()/SPI_connect_ext()总是返回成功（SPI_OK_CONNECT）（Stepan Neretin）§
错误总是通过ereport()报告。
添加关于API和ABI兼容性的文档章节（David Wheeler, Peter Eisentraut）§
", "text": "添加关于API和ABI兼容性的文档章节（David Wheeler, Peter Eisentraut）§", "title": "添加关于API和ABI兼容性的文档章节", "commits": ["e54a42ac9"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "90c971529d419760d77397cb587a82b521c16886289aebdd0a9950e6910000f9", "section_path": ["源代码"], "commit_groups": [["e54a42ac9"]], "identity_text": "Add documentation section about API and ABI compatibility (David Wheeler, Peter Eisentraut)", "commit_aliases": ["e54a42ac9"], "source_commits": ["e54a42ac9"], "source_entry_id": "18.0/changes/173", "db_id": "bce92895bdc4d2128762d0826b82afe5", "patch_ids": ["ed9bc344aa72386c8e767c718632ec82"], "statement_hash": "0295a4b203df0b9501cc58312ecd1041db9220faa5a8a3ae88d0fb981ee922f4", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-4788a1f5f1370946", "cves": [], "html": "移除Meson上Windows构建的实验性标记（Aleksander Alekseev）§
", "text": "移除Meson上Windows构建的实验性标记（Aleksander Alekseev）§", "title": "移除Meson上Windows构建的实验性标记", "commits": ["5afaba629"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "6fa8dda0e2cd9ac5555c784bf5c0ef8242c1206143e83bc3f734bc4ebaecdc2a", "section_path": ["源代码"], "commit_groups": [["5afaba629"]], "identity_text": "Remove the experimental designation of Meson builds on Windows (Aleksander Alekseev)", "commit_aliases": ["5afaba629"], "source_commits": ["5afaba629"], "source_entry_id": "18.0/changes/174", "db_id": "65f45b8de45e88579fb3a07c1fc5ca82", "patch_ids": ["7f3733853ec88ef6dcc506c3f311ca02"], "statement_hash": "4b791d0ce6d561df0dc9266dbc1c032420c8b1a17d776165cd28778ec4824762", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-6b5e40a77fbcbf1d", "cves": [], "html": "移除配置选项--disable-spinlocks和--disable-atomics（Thomas Munro）§ §
现在需要32位原子操作。
", "text": "移除配置选项--disable-spinlocks和--disable-atomics（Thomas Munro）§ § 现在需要32位原子操作。", "title": "移除配置选项--disable-spinlocks和--disable-atomics", "commits": ["813852613", "e25626677"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "dea8d45db1e65b97fa1c42d83d77ae1a21b44ff4bf947e134c0ae0c51fec84eb", "section_path": ["源代码"], "commit_groups": [["813852613"], ["e25626677"]], "identity_text": "Remove configure options --disable-spinlocks and --disable-atomics (Thomas Munro) Thirty-two-bit atomic operations are now required.", "commit_aliases": ["813852613", "e25626677"], "source_commits": ["813852613", "e25626677"], "source_entry_id": "18.0/changes/175", "db_id": "cb76202d341bfde3157c7f5662fdca08", "patch_ids": ["1adba83a13269f9fe1796e4c938f5668", "c5a68b790cc12df3a522cd1c85e50f75"], "statement_hash": "f075e693a989fc62b94be60cc6414f54094d772e3fc9f2cc5a1a1beefdca9437", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-e7a698f98f5c42cc", "cves": [], "html": "移除对HPPA/PA-RISC架构的支持（Tom Lane）§
", "text": "移除对HPPA/PA-RISC架构的支持（Tom Lane）§", "title": "移除对HPPA/PA-RISC架构的支持", "commits": ["edadeb071"], "section": "源代码", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "8f4d3cb0f0e25fcd326fb98621d0aefc3e51c019fd35d16cfdf8c01567fe96be", "section_path": ["源代码"], "commit_groups": [["edadeb071"]], "identity_text": "Remove support for the HPPA/PA-RISC architecture (Tom Lane)", "commit_aliases": ["edadeb071"], "source_commits": ["edadeb071"], "source_entry_id": "18.0/changes/176", "db_id": "a167452f08dbddf1b2de4b6f87175253", "patch_ids": ["4c7fcd694e4cfcfdf4d2b66e07bcc93b"], "statement_hash": "34e0e62ec64cf13e242497f80e1704894b16ff8d2f43db397bcdbb5fd4d87a42", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-7300ae371e3a1273", "cves": [], "html": "添加扩展pg_logicalinspect以检查逻辑快照（Bertrand Drouvot）§
", "text": "添加扩展pg_logicalinspect以检查逻辑快照（Bertrand Drouvot）§", "title": "添加扩展pg_logicalinspect以检查逻辑快照", "commits": ["7cdfeee32"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "2687560225facdefa50011e45e121f7d2ba43f8c8dbd44cf574154afa1445beb", "section_path": ["附加模块"], "commit_groups": [["7cdfeee32"]], "identity_text": "Add extension pglogicalinspect to inspect logical snapshots (Bertrand Drouvot)", "commit_aliases": ["7cdfeee32"], "source_commits": ["7cdfeee32"], "source_entry_id": "18.0/changes/177", "db_id": "67c4f0ce87d750c9d1fc47621ad4ca18", "patch_ids": ["a7b197beccb692abf2aeb8c35a0a48a1"], "statement_hash": "aacda762c76e2c1fbfdaa69e9c927a9740a1692b0b61c349e5016a3c3b699a0a", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-cd656e77492d840c", "cves": [], "html": "添加扩展pg_overexplain，它向EXPLAIN输出添加调试细节（Robert Haas）§
向postgres_fdw_get_connections()添加输出列（Hayato Kuroda, Sagar Dilip Shedge）§ § § §
新的输出列used_in_xact指示外部数据包装器是否正在被当前事务使用，closed指示它是否已关闭，user_name指示用户名，remote_backend_pid指示远程后端进程标识符。
允许将客户端的SCRAM认证传递给postgres_fdw服务器（Matheus Alcantara, Peter Eisentraut）§
\n这避免了在数据库中存储postgres_fdw认证信息，并通过postgres_fdw use_scram_passthrough连接选项启用。libpq使用新的连接参数scram_client_key和scram_server_key。
允许将客户端的SCRAM认证传递给dblink服务器（Matheus Alcantara）§
", "text": "允许将客户端的SCRAM认证传递给dblink服务器（Matheus Alcantara）§", "title": "允许将客户端的SCRAM认证传递给dblink服务器", "commits": ["3642df265"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "d5d459964678c5f8377c3bd875649fc44172ce4cb2a1b6401f0950b80fc6ba4a", "section_path": ["附加模块"], "commit_groups": [["3642df265"]], "identity_text": "Allow SCRAM authentication from the client to be passed to dblink servers (Matheus Alcantara)", "commit_aliases": ["3642df265"], "source_commits": ["3642df265"], "source_entry_id": "18.0/changes/181", "db_id": "db82382f896f8242594f26f0e98cd318", "patch_ids": ["071743b3a560980bed101b42da01a888"], "statement_hash": "606c662a7292efbe14169ab67273e036f3695f6e116ffb4735ab23da0a7f3415", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-b232c340f3e456c9", "cves": [], "html": "为file_fdw添加on_error和log_verbosity选项（Atsushi Torikoshi）§
这些控制file_fdw如何处理和报告无效文件行。
", "text": "为file_fdw添加on_error和log_verbosity选项（Atsushi Torikoshi）§ 这些控制file_fdw如何处理和报告无效文件行。", "title": "为file_fdw添加on_error和log_verbosity选项", "commits": ["a1c4c8a9e"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "115a0c8a418b7106acd2734d853b844db562b082c4bda8f83428f4e298314284", "section_path": ["附加模块"], "commit_groups": [["a1c4c8a9e"]], "identity_text": "Add on_error and log_verbosity options to file-fdw (Atsushi Torikoshi) These control how file_fdw handles and reports invalid file rows.", "commit_aliases": ["a1c4c8a9e"], "source_commits": ["a1c4c8a9e"], "source_entry_id": "18.0/changes/182", "db_id": "6982b0c41f58b8ad05599dd36f57aaa9", "patch_ids": ["21992e0340c7459eca57bac98530eee3"], "statement_hash": "c5180a0af1dd4fdd3162754e1b488f348273f6c2f9209b82ebf3d374fabffd98", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-270f462ffe8c1a9e", "cves": [], "html": "添加reject_limit以控制file_fdw可以忽略的无效行数（Atsushi Torikoshi）§
这在ON_ERROR = 'ignore'时激活。
向passwordcheck添加可配置变量min_password_length（Emanuele Musella, Maurizio Boriani）§
这控制最小密码长度。
", "text": "向passwordcheck添加可配置变量min_password_length（Emanuele Musella, Maurizio Boriani）§ 这控制最小密码长度。", "title": "向passwordcheck添加可配置变量min_password_length", "commits": ["f7e1b3828"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "1b94e879146707658c8624a2cc1d0d5d51823ca6cec56d81901b4e94cb11b78c", "section_path": ["附加模块"], "commit_groups": [["f7e1b3828"]], "identity_text": "Add configurable variable min_password_length to passwordcheck (Emanuele Musella, Maurizio Boriani) This controls the minimum password length.", "commit_aliases": ["f7e1b3828"], "source_commits": ["f7e1b3828"], "source_entry_id": "18.0/changes/184", "db_id": "c2f3e4981e48c781d80d8d683bfeafdc", "patch_ids": ["8adca4662ef9e316e20e61eac39f5953"], "statement_hash": "3c96a08392c835400e1601043498429b0df9c4a3c6205b65fa827329a880c71d", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-261498b314e3db45", "cves": [], "html": "让pgbench在每脚本报告中报告失败、重试或跳过的事务数（Yugo Nagata）§
", "text": "让pgbench在每脚本报告中报告失败、重试或跳过的事务数（Yugo Nagata）§", "title": "让pgbench在每脚本报告中报告失败、重试或跳过的事务数", "commits": ["cae0f3c40"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "b6ab8471bd55acbc24e7b6d8e4dbc4490126311ba216112a2325d59926d09340", "section_path": ["附加模块"], "commit_groups": [["cae0f3c40"]], "identity_text": "Have pgbench report the number of failed, retried, or skipped transactions in per-script reports (Yugo Nagata)", "commit_aliases": ["cae0f3c40"], "source_commits": ["cae0f3c40"], "source_entry_id": "18.0/changes/185", "db_id": "7d68f2a4e71d87ab7e6b4494d5b3c176", "patch_ids": ["7ae9139da216927d66da497ea952bf95"], "statement_hash": "18f1805b3f36c44aa22e9a7c871bfc854cae06d2d1ba7d54f1c9ef8c03dabac0", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-e465d00ad3f4615d", "cves": [], "html": "添加isn服务器变量weak以控制是否接受无效的校验位（Viktor Holmberg）§
这以前仅由函数isn_weak()控制。
允许对值进行排序以加快btree_gist索引的构建（Bernd Helmle, Andrey Borodin）§
", "text": "允许对值进行排序以加快btree_gist索引的构建（Bernd Helmle, Andrey Borodin）§", "title": "允许对值进行排序以加快btree_gist索引的构建", "commits": ["e4309f73f"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "212669f707e1fce095f4a15af5bba9c3db22d8a44760a389af1d2d2f668d8dde", "section_path": ["附加模块"], "commit_groups": [["e4309f73f"]], "identity_text": "Allow values to be sorted to speed btree-gist index builds (Bernd Helmle, Andrey Borodin)", "commit_aliases": ["e4309f73f"], "source_commits": ["e4309f73f"], "source_entry_id": "18.0/changes/187", "db_id": "7e911d1361965be0a82fa600d4ebef9d", "patch_ids": ["cffdd969af417cd314b82e92cb6a914f"], "statement_hash": "cebec6909a36bdf2166bf54e64bff4c820d6b198d1e688f1c4007e765cf72614", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-ee8b77296d44e546", "cves": [], "html": "添加amcheck检查函数gin_index_check()以验证GIN索引（Grigory Kryachko, Heikki Linnakangas, Andrey Borodin）§
添加函数pg_buffercache_evict_relation()和pg_buffercache_evict_all()以逐出未钉住的共享缓冲区（Nazir Bilal Yavuz）§
现有函数pg_buffercache_evict()现在返回缓冲区刷新状态。
允许扩展安装自定义的EXPLAIN选项（Robert Haas, Sami Imseih）§ § §
", "text": "允许扩展安装自定义的EXPLAIN选项（Robert Haas, Sami Imseih）§ § §", "title": "允许扩展安装自定义的EXPLAIN选项", "commits": ["4fd02bf7c", "50ba65e73", "c65bc2e1d"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "126c1e252fd401d5cbcf8667b52299d2f5510b10142a7ea6310dcbba82c8bd12", "section_path": ["附加模块"], "commit_groups": [["4fd02bf7c"], ["50ba65e73"], ["c65bc2e1d"]], "identity_text": "Allow extensions to install custom sql-explain options (Robert Haas, Sami Imseih)", "commit_aliases": ["4fd02bf7c", "50ba65e73", "c65bc2e1d"], "source_commits": ["4fd02bf7c", "50ba65e73", "c65bc2e1d"], "source_entry_id": "18.0/changes/190", "db_id": "17128679b68e62fcef0d48d266afb493", "patch_ids": ["4a90cb7809dd3268e814052cb9d568f6", "a7446b42cbf558abedd81726ef25be11", "b1d23fea200234c95397b7e93fd14848"], "statement_hash": "e8646573cbbb7286af9b4ad50cc583bc6310d49c513b0e947a6bca0270e16301", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-384d5964db6a292c", "cves": [], "html": "允许扩展使用服务器的累计统计信息API（Michael Paquier）§ §
", "text": "允许扩展使用服务器的累计统计信息API（Michael Paquier）§ §", "title": "允许扩展使用服务器的累计统计信息API", "commits": ["2eff9e678", "7949d9594"], "section": "附加模块", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "7611ce1609aa627ae59449ba16bf0a6a11d238cb4b3f48d277fa6399e2615ef5", "section_path": ["附加模块"], "commit_groups": [["2eff9e678"], ["7949d9594"]], "identity_text": "Allow extensions to use the server's cumulative statistics API (Michael Paquier)", "commit_aliases": ["2eff9e678", "7949d9594"], "source_commits": ["2eff9e678", "7949d9594"], "source_entry_id": "18.0/changes/191", "db_id": "51ed37dd51200e7f7a59592baf05f997", "patch_ids": ["3eb79f54769a802749d52f97f9f8c4cd", "4af802e5801cb1008a49bbd7ffb1b4c6"], "statement_hash": "a6e76441b49e4dfc8c5b6323c846f1efe63f20730e0cc0450e6f197b1eb9b2a0", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-097a6648e4c5022b", "cves": [], "html": "允许CREATE TABLE AS和DECLARE的查询被pg_stat_statements跟踪（Anthonin Bonnefoy）§
\n它们现在也被分配了查询ID。
", "text": "允许CREATE TABLE AS和DECLARE的查询被pg_stat_statements跟踪（Anthonin Bonnefoy）§ 它们现在也被分配了查询ID。", "title": "允许CREATE TABLE AS和DECLARE的查询被pg_stat_statements跟踪", "commits": ["6b652e6ce"], "section": "附加模块 / pg_stat_statements", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGSTATSTATEMENTS", "source_hash": "a71330cbf6ff1fcbcb3577f9497064f4234185cd87242388194c557aabf1ba1b", "section_path": ["附加模块", "pg_stat_statements"], "commit_groups": [["6b652e6ce"]], "identity_text": "Allow the queries of sql-createtableas and sql-declare to be tracked by pg_stat_statements (Anthonin Bonnefoy) They are also now assigned query ids.", "commit_aliases": ["6b652e6ce"], "source_commits": ["6b652e6ce"], "source_entry_id": "18.0/changes/192", "db_id": "222e3bfb3e07da2a4bb138e9b89a9ea9", "patch_ids": ["6f27bba477d5d34ec287e6d1f0cb4c01"], "statement_hash": "529743a734ea4d3d2e0ab03ec1c2bc3a516f21292fd3896db229b7e1ee80bdfd", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-1104b155543e7f0f", "cves": [], "html": "允许在pg_stat_statements中对SET的值进行参数化（Greg Sabino Mullane, Michael Paquier）§
\n这减少了由于具有不同常量的SET语句引起的数据膨胀。
添加pg_stat_statements列以报告并行活动（Guillaume Lelarge）§
新列是 parallel_workers_to_launch 和 parallel_workers_launched。
添加pg_stat_statements.wal_buffers_full以报告满WAL缓冲区（Bertrand Drouvot）§
添加pgcrypto算法sha256crypt和sha512crypt（Bernd Helmle）§
为pgcrypto的加密和解密添加CFB模式（Umar Hayat）§
", "text": "为pgcrypto的加密和解密添加CFB模式（Umar Hayat）§", "title": "为pgcrypto的加密和解密添加CFB模式", "commits": ["9ad1b3d01"], "section": "附加模块 / pgcrypto", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGCRYPTO", "source_hash": "7f5b08debbba5d1cc71560caa889a862bb5b8108f756e758ad8bc02d4921180a", "section_path": ["附加模块", "pgcrypto"], "commit_groups": [["9ad1b3d01"]], "identity_text": "Add CFB mode to pgcrypto encryption and decryption (Umar Hayat)", "commit_aliases": ["9ad1b3d01"], "source_commits": ["9ad1b3d01"], "source_entry_id": "18.0/changes/197", "db_id": "ec341ecdfcaabcd1827eb401ea40905d", "patch_ids": ["b040d33a3888055fc5edf9f0c6e56795"], "statement_hash": "7c89f9937951f96c3f497c06864857f8e8c21ba76f5ef791d1eed77d00a71e81", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "18.0-612c4479d75f9942", "cves": [], "html": "添加函数fips_mode()以报告服务器的FIPS模式（Daniel Gustafsson）§
添加pgcrypto服务器变量builtin_crypto_enabled以允许禁用内置非FIPS模式密码学函数（Daniel Gustafsson, Joe Conway）§
这对于保证FIPS模式行为很有用。
", "text": "添加pgcrypto服务器变量builtin_crypto_enabled以允许禁用内置非FIPS模式密码学函数（Daniel Gustafsson, Joe Conway）§ 这对于保证FIPS模式行为很有用。", "title": "添加pgcrypto服务器变量builtin_crypto_enabled以允许禁用内置非FIPS模式密码学函数", "commits": ["035f99cbe"], "section": "附加模块 / pgcrypto", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGCRYPTO", "source_hash": "7ec37d9ad093c24c937b540278b9a28ded5495aa79ee7e13b25b399ad32123f6", "section_path": ["附加模块", "pgcrypto"], "commit_groups": [["035f99cbe"]], "identity_text": "Add pgcrypto server variable builtin_crypto_enabled to allow disabling builtin non-FIPS mode cryptographic functions (Daniel Gustafsson, Joe Conway) This is useful for guaranteeing FIPS mode behavior.", "commit_aliases": ["035f99cbe"], "source_commits": ["035f99cbe"], "source_entry_id": "18.0/changes/199", "db_id": "85292659fb670a2d9202838e30370170", "patch_ids": ["c996d7a6dfbb6918d1e1c1bdc8763d5d"], "statement_hash": "9c517ea3b0ae09d9ac23588dcc459bf5530faea31bee9ef47a11255f44c8ee81", "relations": [], "version": "18.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}]}], "stats": [{"key": "all", "label": "全部变更", "count": 210}, {"key": "feature", "label": "新功能", "count": 188}, {"key": "bugfix", "label": "BUG 修复", "count": 1}, {"key": "security", "label": "安全相关", "count": 0}, {"key": "performance", "label": "性能改进", "count": 10}, {"key": "compatibility", "label": "兼容性变化", "count": 11}, {"key": "improvement", "label": "其他改进", "count": 0}], "total": 210, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 210, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}