对于希望从任何先前版本迁移数据的用户，需要使用pg_dumpall进行导出/恢复，或使用pg_upgrade或逻辑复制。有关迁移到新主版本的一般信息，请参见第 18.6 节。
\n版本 11 包含许多可能影响与先前版本兼容性的变更。请注意以下不兼容性：
\n对于希望从任何先前版本迁移数据的用户，需要使用pg_dumpall进行导出/恢复，或使用pg_upgrade或逻辑复制。有关迁移到新主版本的一般信息，请参见第 18.6 节。
\n版本 11 包含许多可能影响与先前版本兼容性的变更。请注意以下不兼容性：
\n使pg_dump转储数据库的属性，而不只是内容（Haribabu Kommi）
\n以前，数据库本身的属性，例如数据库级 GRANT/REVOKE 权限和 ALTER DATABASE SET 变量设置，只能由pg_dumpall转储。现在，pg_dump --create 和 pg_restore --create 除恢复数据库内的对象外，也会恢复这些数据库属性。pg_dumpall -g 现在仅转储角色和表空间相关属性。pg_dumpall 的完整输出（不带 -g）保持不变。
如果没有指定 --create，pg_dump 和 pg_restore 不再转储/恢复数据库级注释和安全标签；这些内容现在被视为数据库的属性。
pg_dumpall 的输出脚本现在始终使用数据库原有的区域设置和编码创建数据库，因此如果目标系统不认识该区域设置或编码名称，操作就会失败。以前，如果数据库的区域设置和编码与旧集群的默认值一致，输出的 CREATE DATABASE 就不会包含这些指定。
pg_dumpall --clean 现在会恢复 postgres 和 template1 数据库的原始区域设置和编码，以及用户创建数据库的相应设置。
在消除函数引用与列引用之间的歧义时，考虑语法形式（Tom Lane）
\n当 x 是表名或复合列时，PostgreSQL 传统上将语法形式 f(x)x.f
全面强制表约束名和域约束名的唯一性（Tom Lane）
\nPostgreSQL 要求同一表的约束名称各不相同，域的约束名称也是如此。但以前对此没有严格强制检查，存在可创建重复名称的边界情况。
", "text": "全面强制表约束名和域约束名的唯一性（Tom Lane） PostgreSQL 要求同一表的约束名称各不相同，域的约束名称也是如此。但以前对此没有严格强制检查，存在可创建重复名称的边界情况。", "title": "全面强制表约束名和域约束名的唯一性", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "4bdebe8985707e6d9f0b290305681832b94c60751c1e706067f6eab95315dff1", "section_path": ["兼容性"], "commit_groups": [["fb466d7b5"]], "identity_text": "Fully enforce uniqueness of table and domain constraint names (Tom Lane) PostgreSQL expects the names of a table's constraints to be distinct, and likewise for the names of a domain's constraints. However, there was not rigid enforcement of this, and previously there were corner cases where duplicate names could be created.", "commit_aliases": ["fb466d7b5"], "source_commits": ["fb466d7b5"], "source_entry_id": "11.0/migration/003", "db_id": "123aceccc369aadda88119d2695f9eb3", "patch_ids": ["06b45dc7ea0b7a5af683574355ab7287"], "statement_hash": "4bf3335d18dccf3f5928783a351ae52a804cbdaffe0158949c9fc541ee53f290", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-7a8f7b252c15249c", "cves": [], "html": "使 power(numeric, numeric) 和 power(float8, float8) 按照 POSIX 标准处理 NaN 输入（Tom Lane，Dang Minh Huong）
POSIX 规定 NaN ^ 0 = 1 且 1 ^ NaN = 1，但其他所有包含 NaN 输入的情况都应返回 NaN。power(numeric, numeric) 以前在所有此类情况下都返回 NaN，现在会遵循这两个例外。只要 C 库符合标准，power(float8, float8) 就会符合标准；但某些旧 Unix 平台的库不符合标准，某些 Windows 版本上也存在问题。
当模板分隔符不匹配时，防止 to_number() 消耗字符（Oliver Ford）
具体而言，SELECT to_number('1234', '9,999') 以前返回 134，现在会返回 1234。L 和 TH 现在只消耗数字、正负号、小数点和逗号以外的字符。
修复 to_date()、to_number() 和 to_timestamp()，使其对每个模板字符跳过一个字符（Tom Lane）
以前，它们对模板字符的每个字节跳过一个字节，如果任一字符串包含多字节字符，就会出现异常行为。
", "text": "修复 to_date()、to_number() 和 to_timestamp()，使其对每个模板字符跳过一个字符（Tom Lane） 以前，它们对模板字符的每个字节跳过一个字节，如果任一字符串包含多字节字符，就会出现异常行为。", "title": "修复 to_date()、to_number() 和 to_timestamp()，使其对每个模板字符跳过一个字符", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "b9bb1d95a02a2e58a51443c4d3556a46902084423cd01266e1fb3af2b232d31a", "section_path": ["兼容性"], "commit_groups": [["976a1a48f"]], "identity_text": "Fix to_date(), to_number(), and to_timestamp() to skip a character for each template character (Tom Lane) Previously, they skipped one byte for each byte of template character, resulting in strange behavior if either string contained multibyte characters.", "commit_aliases": ["976a1a48f"], "source_commits": ["976a1a48f"], "source_entry_id": "11.0/migration/006", "db_id": "6df82a80a5d3a6122d268b3bbdf21b2a", "patch_ids": ["269cd62584c55d7d310c398734f57870"], "statement_hash": "2836a86a738388e6f787cca08001f8204dd38eb0fdf5473b72d6f62fb16b569d", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-b61c6aef74df877f", "cves": [], "html": "调整 to_char()、to_number() 和 to_timestamp() 对模板字符串中双引号内反斜线的处理。
这种反斜线现在会转义其后的字符，尤其是双引号或另一个反斜线。
", "text": "调整 to_char()、to_number() 和 to_timestamp() 对模板字符串中双引号内反斜线的处理。 这种反斜线现在会转义其后的字符，尤其是双引号或另一个反斜线。", "title": "调整 to_char()、to_number() 和 to_timestamp() 对模板字符串中双引号内反斜线的处理。", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "77a41e11b951df5a820061b703f45127f9a7f403c1cd7ca8d47a09aa6fe4e4e8", "section_path": ["兼容性"], "commit_groups": [["63ca86318"]], "identity_text": "Adjust the handling of backslashes inside double-quotes in template strings for to_char(), to_number(), and to_timestamp(). Such a backslash now escapes the character after it, particularly a double-quote or another backslash.", "commit_aliases": ["63ca86318"], "source_commits": ["63ca86318"], "source_entry_id": "11.0/migration/007", "db_id": "8b765ef312915548a5d0e1b3dc25e93a", "patch_ids": ["541fc3a298457cbbdf17a516fb268b77"], "statement_hash": "a1ad21134ed44eba401dac111dbdfa9da67d26118cc360a58ab81a619eee4c5a", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-573ac15b77b3d279", "cves": [], "html": "正确处理 xmltable()、xpath() 及其他 XML 处理函数中的相对路径表达式（Markus Winand）
按照 SQL 标准，相对路径从 XML 输入文档的文档节点开始，而非像这些函数以前那样从根节点开始。
", "text": "正确处理 xmltable()、xpath() 及其他 XML 处理函数中的相对路径表达式（Markus Winand） 按照 SQL 标准，相对路径从 XML 输入文档的文档节点开始，而非像这些函数以前那样从根节点开始。", "title": "正确处理 xmltable()、xpath() 及其他 XML 处理函数中的相对路径表达式", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "b57dec541603d4df7eb296d86e9638bfc2b9f8aa1bc6bdd17dcd42c0bc1e4a98", "section_path": ["兼容性"], "commit_groups": [["e474c2b7e"]], "identity_text": "Correctly handle relative path expressions in xmltable(), xpath(), and other XML-handling functions (Markus Winand) Per the SQL standard, relative paths start from the document node of the XML input document, not the root node as these functions previously did.", "commit_aliases": ["e474c2b7e"], "source_commits": ["e474c2b7e"], "source_entry_id": "11.0/migration/008", "db_id": "5699f3abda8af69c0a85646bb3ff0293", "patch_ids": ["076da883585834bc70dee1fd22aadc3f"], "statement_hash": "6ada139b2aab9ed5d53b101a7faf9c590fe786f1bfa9c5afb96e2c98de1a7ea4", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-8e9e09a48c7e164e", "cves": [], "html": "在扩展查询协议中，使 statement_timeout 分别应用于每条 Execute 消息，而非应用于 Sync 之前的所有命令（Tatsuo Ishii，Andres Freund）
从系统目录 pg_class 中移除 relhaspkey 列（Peter Eisentraut）
需要检查主键的应用应查询 pg_index。
将系统目录 pg_proc 的 proisagg 和 proiswindow 列替换为 prokind（Peter Eisentraut）
这个新列更清楚地区分了函数、过程、聚合和窗口函数。
", "text": "将系统目录 pg_proc 的 proisagg 和 proiswindow 列替换为 prokind（Peter Eisentraut） 这个新列更清楚地区分了函数、过程、聚合和窗口函数。", "title": "将系统目录 pg_proc 的 proisagg 和 proiswindow 列替换为 prokind", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "bd0cff500a63df2a36b517e981ac6a039083dad6ee29fa17bc325925aba9d41a", "section_path": ["兼容性"], "commit_groups": [["fd1a421fe"]], "identity_text": "Replace system catalog pg_proc's proisagg and proiswindow columns with prokind (Peter Eisentraut) This new column more clearly distinguishes functions, procedures, aggregates, and window functions.", "commit_aliases": ["fd1a421fe"], "source_commits": ["fd1a421fe"], "source_entry_id": "11.0/migration/011", "db_id": "46b97d9b8fc22340398342e0e2d1af76", "patch_ids": ["8e17e29f1be6a33f04f90f3e744bd693"], "statement_hash": "8b0e803bb096d60aa7eb687a94d5616f94c85849b514712421c46aa1ee399657", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-0660dd9c08d66b2a", "cves": [], "html": "修正信息模式列 tables.table_type，使其返回 FOREIGN 而非 FOREIGN TABLE（Peter Eisentraut）
这种新输出符合 SQL 标准。
", "text": "修正信息模式列 tables.table_type，使其返回 FOREIGN 而非 FOREIGN TABLE（Peter Eisentraut） 这种新输出符合 SQL 标准。", "title": "修正信息模式列 tables.table_type，使其返回 FOREIGN 而非 FOREIGN TABLE", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "54c773d3100e6e4d43ff5a65d6a7d79e575f33c2989f8650d43da735819f98fc", "section_path": ["兼容性"], "commit_groups": [["9b5140fb5"]], "identity_text": "Correct information schema column tables.table_type to return FOREIGN instead of FOREIGN TABLE (Peter Eisentraut) This new output matches the SQL standard.", "commit_aliases": ["9b5140fb5"], "source_commits": ["9b5140fb5"], "source_entry_id": "11.0/migration/012", "db_id": "4d19dd34e3e88bc61a91087b1c7ec4ff", "patch_ids": ["cc9473f3c6726efa0e5ba7d6df4d4cf0"], "statement_hash": "f16352bb86564ed5ad249abaa57ab4134e8626c1817850d5fa9ab17c7d785329", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-5e2eda965c0eb82a", "cves": [], "html": "更改 ps 进程显示中的后台工作进程标签，使其与 pg_stat_activity.backend_type 标签一致（Peter Eisentraut）
在通过 lo_open() 打开大对象时检查大对象权限，而非在尝试读写时检查（Tom Lane，Michael Paquier）
如果请求写入权限但无法获得，现在即使最终从未写入该大对象，也会抛出错误。
", "text": "在通过 lo_open() 打开大对象时检查大对象权限，而非在尝试读写时检查（Tom Lane，Michael Paquier） 如果请求写入权限但无法获得，现在即使最终从未写入该大对象，也会抛出错误。", "title": "在通过 lo_open() 打开大对象时检查大对象权限，而非在尝试读写时检查", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "fbf598ce9dad5b80cc65f4e4eb9f86d3f1ab70ba114fe741648f08aa5274ff7c", "section_path": ["兼容性"], "commit_groups": [["6d776522d"], ["ae20b23a9"]], "identity_text": "Cause large object permission checks to happen during large object open, lo_open(), not when a read or write is attempted (Tom Lane, Michael Paquier) If write access is requested and not available, an error will now be thrown even if the large object is never written to.", "commit_aliases": ["6d776522d", "ae20b23a9"], "source_commits": ["6d776522d", "ae20b23a9"], "source_entry_id": "11.0/migration/014", "db_id": "0b279c27863f37b234d2c71e90a34f66", "patch_ids": ["2f492a4642cc93d8877db1a9839f8422", "e024d72ca9cefd67b4b949d559a264bf"], "statement_hash": "6471209976cf5d1276925197802d9c912a204d4416a08695e9f340c57266c9a6", "relations": [{"rule": 2, "type": "related", "target": "64317dec4095a31874ad8bfffd1b3783", "evidence": {"same_day": true, "patch_ids": ["2f492a4642cc93d8877db1a9839f8422"]}}], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": [{"db_id": "64317dec4095a31874ad8bfffd1b3783", "kind": "related", "version": "11.0", "label": "11.0", "title": "使用 GRANT/REVOKE 控制对 lo_import() 和 lo_export() 的访问", "evidence": {"same_day": true, "patch_ids": ["2f492a4642cc93d8877db1a9839f8422"]}, "url": "/docs/compare/?release=11.0#11.0-43b08ce9ee77cf87", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.9"}]}, {"id": "11.0-b0724f8405584b6f", "cves": [], "html": "防止非超级用户重建共享目录的索引（Michael Paquier，Robert Haas）
\n以前，数据库所有者也被允许这样做，但现在认为这超出了其权限范围。
", "text": "防止非超级用户重建共享目录的索引（Michael Paquier，Robert Haas） 以前，数据库所有者也被允许这样做，但现在认为这超出了其权限范围。", "title": "防止非超级用户重建共享目录的索引", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "8ee57ba2c765d48589177b630d60a310a9805abf65fe0b35d18186b18095ca00", "section_path": ["兼容性"], "commit_groups": [["87330e21c"]], "identity_text": "Prevent non-superusers from reindexing shared catalogs (Michael Paquier, Robert Haas) Previously, database owners were also allowed to do this, but now it is considered outside the bounds of their privileges.", "commit_aliases": ["87330e21c"], "source_commits": ["87330e21c"], "source_entry_id": "11.0/migration/015", "db_id": "7eb022cb658a9316dd3bdbcb7c457b1d", "patch_ids": ["20edf52c8362f05176bca0d955851dcd"], "statement_hash": "7e78d2559eccc3fd82555d10ac834c89f03850fc49bcb728a3cfbe396a10c518", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-595d2f64bc2955c0", "cves": [], "html": "移除已弃用的 adminpack 函数 pg_file_read()、pg_file_length() 和 pg_logfile_rotate()（Stephen Frost）
核心后端现在已提供等效功能。现有 adminpack 安装在通过 ALTER EXTENSION ... UPDATE 更新之前，仍可访问这些函数。
遵循双引号内命令选项的大小写（Daniel Gustafsson）
\n以前，某些 SQL 命令中的选项名即使以双引号输入，也会被强制转换为小写；因此，例如 \"FillFactor\" 会被接受为索引存储选项，尽管其正确名称应为小写。现在，此类情况将产生错误。
移除服务器参数 replacement_sort_tuples（Peter Geoghegan）
经判断，置换排序已不再有用。
", "text": "移除服务器参数 replacement_sort_tuples（Peter Geoghegan） 经判断，置换排序已不再有用。", "title": "移除服务器参数 replacement_sort_tuples", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "328feeb2742bcb24f952fbbe24eaddd4b5e18e433102baf7563d95bbcd58bd5f", "section_path": ["兼容性"], "commit_groups": [["8b304b8b7"]], "identity_text": "Remove server parameter replacement_sort_tuples (Peter Geoghegan) Replacement sorts were determined to be no longer useful.", "commit_aliases": ["8b304b8b7"], "source_commits": ["8b304b8b7"], "source_entry_id": "11.0/migration/018", "db_id": "7cf4f2ec73d04546c03927edbe4be9db", "patch_ids": ["d1cfa6a03d12878685c6b764ca4f9db4"], "statement_hash": "d57f08d89d73c4b87c76f348e43051202a8046ebd46f6e18465db1ccb95d31ed", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-55f2585ac1bc4d18", "cves": [], "html": "移除 CREATE FUNCTION 中的 WITH 子句（Michael Paquier）
PostgreSQL 很早以前就已支持更符合标准的语法来实现此功能。
", "text": "移除 CREATE FUNCTION 中的 WITH 子句（Michael Paquier） PostgreSQL 很早以前就已支持更符合标准的语法来实现此功能。", "title": "移除 CREATE FUNCTION 中的 WITH 子句", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "921bb3d803a01622c41f642f4f66cf8b29e3a539e253dd0a6b0d173761c3e179", "section_path": ["兼容性"], "commit_groups": [["4971d2a32"]], "identity_text": "Remove WITH clause in CREATE FUNCTION (Michael Paquier) PostgreSQL has long supported a more standard-compliant syntax for this capability.", "commit_aliases": ["4971d2a32"], "source_commits": ["4971d2a32"], "source_entry_id": "11.0/migration/019", "db_id": "3cccbdd25cbdc9c0bb3564745dec576b", "patch_ids": ["e0b5bcba963a61c883ea515233c7a2a0"], "statement_hash": "8375875dcb7c64b550b7fd2f590205498270caebe376f4dfdb8b2d975cecadd9", "relations": [], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-ff3eda9ae3792bf5", "cves": [], "html": "在 PL/pgSQL 触发器函数中，未赋值的 OLD 和 NEW 变量现在读取为 NULL（Tom Lane）
以前，对这些变量的引用可以解析，但无法执行。
", "text": "在 PL/pgSQL 触发器函数中，未赋值的 OLD 和 NEW 变量现在读取为 NULL（Tom Lane） 以前，对这些变量的引用可以解析，但无法执行。", "title": "在 PL/pgSQL 触发器函数中，未赋值的 OLD 和 NEW 变量现在读取为 NULL", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/11.0/#id-1.11.6.27.4", "source_hash": "893abeb3bea6ccf4e04e46bbe3bbff6d0ba0df6c8e8c1797978e15061a8669e3", "section_path": ["兼容性"], "commit_groups": [["4b93f5799"]], "identity_text": "In PL/pgSQL trigger functions, the OLD and NEW variables now read as NULL when not assigned (Tom Lane) Previously, references to these variables could be parsed but not executed.", "commit_aliases": ["4b93f5799"], "source_commits": ["4b93f5799"], "source_entry_id": "11.0/migration/020", "db_id": "3a10a968211dd2f57e469ce081a0fb6d", "patch_ids": ["f114eab24a7e02f5cca2a84c5e3329c7"], "statement_hash": "a5b061ff232949ced51b689168c06f142e18a6bb650ae9cc49f239b3f31d077f", "relations": [{"rule": 2, "type": "related", "target": "a3362f67b1e652e63b477f8810eafbf7", "evidence": {"same_day": true, "patch_ids": ["f114eab24a7e02f5cca2a84c5e3329c7"]}}], "version": "11.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": [{"db_id": "a3362f67b1e652e63b477f8810eafbf7", "kind": "related", "version": "11.0", "label": "11.0", "title": "允许 PL/pgSQL 处理同一会话中首次和后续函数执行之间发生的复合类型（如 record、row）变更", "evidence": {"same_day": true, "patch_ids": ["f114eab24a7e02f5cca2a84c5e3329c7"]}, "url": "/docs/compare/?release=11.0#11.0-9dbe6c91d3f62157", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.8"}]}, {"id": "11.0-59117420e19d66d1", "cves": [], "html": "允许根据键列的 hash 值创建分区（Amul Sul）
", "text": "允许根据键列的 hash 值创建分区（Amul Sul）", "title": "允许根据键列的 hash 值创建分区", "commits": [], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.2", "source_hash": "11e55c3fd2c68b90e12e4a8d18713e5ab35ef293cd478bfd59544f56cfa4ec5f", "section_path": ["服务器", "分区"], "commit_groups": [["1aba8e651"]], "identity_text": "Allow the creation of partitions based on hashing a key column (Amul Sul)", "commit_aliases": ["1aba8e651"], "source_commits": ["1aba8e651"], "source_entry_id": "11.0/changes/001", "db_id": "f7cb7d4d9f264e9a3e3d4868febbb04f", "patch_ids": ["194514b774748b3babd76e89c9041d5a"], "statement_hash": "d80ddc780f51bb6e799c5e814e146dbd9c8ed9981cac21cb5a64bc13ed039cc2", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-b45f0210071db040", "cves": [], "html": "支持分区表上的索引（Álvaro Herrera，Amit Langote）
\n分区表上的“索引”并非跨越整个分区表的物理索引，而是用于在表的每个分区上自动创建类似索引的模板。
\n如果索引列集合包含分区键，则可以将分区索引声明为 UNIQUE。它将表示覆盖整个分区表的有效唯一约束，尽管每个物理索引只在其自身分区内实施唯一性。
新命令 ALTER INDEX ATTACH PARTITION 将分区上的现有索引与其分区表的匹配索引模板关联起来。这为给现有分区表设置新的分区索引提供了灵活性。
允许在分区表上定义外键（Álvaro Herrera）
", "text": "允许在分区表上定义外键（Álvaro Herrera）", "title": "允许在分区表上定义外键", "commits": [], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.2", "source_hash": "dc67bc785f7e1778043b758f310adc04b5852b98cdb4a903aeba155d7d10ba9f", "section_path": ["服务器", "分区"], "commit_groups": [["3de241dba"]], "identity_text": "Allow foreign keys on partitioned tables (Álvaro Herrera)", "commit_aliases": ["3de241dba"], "source_commits": ["3de241dba"], "source_entry_id": "11.0/changes/003", "db_id": "0c7773820a30b56570d6f95aedfd1133", "patch_ids": ["94ca84cd999984e6a0b8c8ea9b634215"], "statement_hash": "5bd0ab22d8a44ac8754731968e3f4c5e559c0d9a06c5329944cdd698c6f9dbc4", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-ba0b680dd97692d1", "cves": [], "html": "允许在分区表上定义 FOR EACH ROW 触发器（Álvaro Herrera）
在分区表上创建触发器，会自动在所有现有和未来分区上创建触发器。这也使分区表能够使用延迟唯一约束。
", "text": "允许在分区表上定义 FOR EACH ROW 触发器（Álvaro Herrera） 在分区表上创建触发器，会自动在所有现有和未来分区上创建触发器。这也使分区表能够使用延迟唯一约束。", "title": "允许在分区表上定义 FOR EACH ROW 触发器", "commits": [], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.2", "source_hash": "cd41f776dce1c2c452de71398963679266387c8bf3d67f8d6f3df01c3ce559b3", "section_path": ["服务器", "分区"], "commit_groups": [["86f575948"]], "identity_text": "Allow FOR EACH ROW triggers on partitioned tables (Álvaro Herrera) Creation of a trigger on a partitioned table automatically creates triggers on all existing and future partitions. This also allows deferred unique constraints on partitioned tables.", "commit_aliases": ["86f575948"], "source_commits": ["86f575948"], "source_entry_id": "11.0/changes/004", "db_id": "7d6202919b4586a86ada3b9fe59af082", "patch_ids": ["2b43e0cd05fd6b6d7632c98a936ad926"], "statement_hash": "1b03ebef716f00a393887f86f649f7e30c34fe9ffdb5ed2b50e28a8ced284685", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-9ae3e4f50e43c281", "cves": [], "html": "允许分区表具有默认分区（Jeevan Ladhe，Beena Emerson，Ashutosh Bapat，Rahila Syed，Robert Haas）
\n默认分区存储不匹配其他任何已定义分区的行，并据此被搜索。
", "text": "允许分区表具有默认分区（Jeevan Ladhe，Beena Emerson，Ashutosh Bapat，Rahila Syed，Robert Haas） 默认分区存储不匹配其他任何已定义分区的行，并据此被搜索。", "title": "允许分区表具有默认分区", "commits": [], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.2", "source_hash": "9d9e2098b2319a321ba73f8de42ec125424bf45c54362e4e4d356446612f607e", "section_path": ["服务器", "分区"], "commit_groups": [["6f6b99d13"], ["72cf7f310"]], "identity_text": "Allow partitioned tables to have a default partition (Jeevan Ladhe, Beena Emerson, Ashutosh Bapat, Rahila Syed, Robert Haas) The default partition will store rows that don't match any of the other defined partitions, and is searched accordingly.", "commit_aliases": ["6f6b99d13", "72cf7f310"], "source_commits": ["6f6b99d13", "72cf7f310"], "source_entry_id": "11.0/changes/005", "db_id": "a090353dc7e17740c7bdec216dd25f67", "patch_ids": ["434bfc281b2b0fd143b31d7eaab8272e", "d6b1868800d61b8f4183e57bfe95403e"], "statement_hash": "aed453c47c8a416546140b6e6ebcdaf1acc5acff4d4fb887b0daf143ea385c09", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-5e1b7ed3d5b2217e", "cves": [], "html": "更改分区键列的 UPDATE 语句现在会将受影响的行移动到适当的分区（Amit Khandekar）
允许分区表上的 INSERT、UPDATE 和 COPY 将行正确路由到外部分区（Etsuro Fujita，Amit Langote）
postgres_fdw 外部表支持此功能。由于为此调用 ExecForeignInsert 回调函数的方式与以前不同，外部数据包装器必须相应修改以适应此更改。
加快查询处理期间的分区排除（Amit Langote，David Rowley，Dilip Kumar）
\n这加快了对具有大量分区的分区表的访问。
", "text": "加快查询处理期间的分区排除（Amit Langote，David Rowley，Dilip Kumar） 这加快了对具有大量分区的分区表的访问。", "title": "加快查询处理期间的分区排除", "commits": [], "section": "服务器 / 分区", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.2", "source_hash": "7f642df7b782ddb3cf168bee3ae7796785e4625279f9ae5840d2838ba121e7fb", "section_path": ["服务器", "分区"], "commit_groups": [["055fb8d33"], ["9aef17316"], ["9fdb675fc"], ["f724022d0"]], "identity_text": "Allow faster partition elimination during query processing (Amit Langote, David Rowley, Dilip Kumar) This speeds access to partitioned tables with many partitions.", "commit_aliases": ["055fb8d33", "9aef17316", "9fdb675fc", "f724022d0"], "source_commits": ["055fb8d33", "9aef17316", "9fdb675fc", "f724022d0"], "source_entry_id": "11.0/changes/008", "db_id": "04be6fa026234526485799d43b324c90", "patch_ids": ["43f08e14edc9aa39d146e6feed033b5e", "48df2b8793fbd9e9af3599d5123c8ab0", "606557f0940af2073b36c96583ac1c7c", "a21bda5efcbb10a8727735a7d332ff4a"], "statement_hash": "a31961ad07ce3b19c800101372954cd30abd16a9c1a777a5c57ba3625141edd6", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-df0a2b4745fc1ea4", "cves": [], "html": "允许在查询执行期间排除分区（David Rowley，Beena Emerson）
\n以前，分区排除仅在规划时进行，因此许多连接和预备查询无法使用分区排除。
", "text": "允许在查询执行期间排除分区（David Rowley，Beena Emerson） 以前，分区排除仅在规划时进行，因此许多连接和预备查询无法使用分区排除。", "title": "允许在查询执行期间排除分区", "commits": [], "section": "服务器 / 分区", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.2", "source_hash": "2aab3bab67d46f7fc4ed1bb73cafba823169c33dd0e17894b21e9b584acc2d2d", "section_path": ["服务器", "分区"], "commit_groups": [["499be013d"]], "identity_text": "Allow partition elimination during query execution (David Rowley, Beena Emerson) Previously, partition elimination only happened at planning time, meaning many joins and prepared queries could not use partition elimination.", "commit_aliases": ["499be013d"], "source_commits": ["499be013d"], "source_entry_id": "11.0/changes/009", "db_id": "7e8f633201ff318bd320ea749fae06c7", "patch_ids": ["70e0afea6729c77502adb2f42a1048b8"], "statement_hash": "78e23bccb69798ba20a75be445dcb4e4933bab6afdf00adec16a26e1809ef408", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-57d1b0b652630f44", "cves": [], "html": "在分区表之间的等值连接中，允许直接连接匹配的分区（Ashutosh Bapat）
\n此特性默认禁用，但可以通过更改 enable_partitionwise_join 启用。
允许对分区表上的聚合函数按分区分别求值，随后合并结果（Jeevan Chalke，Ashutosh Bapat，Robert Haas）
\n此特性默认禁用，但可以通过更改 enable_partitionwise_aggregate 启用。
允许 postgres_fdw 将聚合下推到作为分区的外部表（Jeevan Chalke）
允许并行构建 B-树索引（Peter Geoghegan，Rushabh Lathia，Heikki Linnakangas）
", "text": "允许并行构建 B-树索引（Peter Geoghegan，Rushabh Lathia，Heikki Linnakangas）", "title": "允许并行构建 B-树索引", "commits": [], "section": "服务器 / 并行查询", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.3", "source_hash": "db1cde0d14ee2d0513ea8231c9ee5e4b638a0205981f862f8cd4e941173aeab5", "section_path": ["服务器", "并行查询"], "commit_groups": [["9da0cc352"]], "identity_text": "Allow parallel building of a btree index (Peter Geoghegan, Rushabh Lathia, Heikki Linnakangas)", "commit_aliases": ["9da0cc352"], "source_commits": ["9da0cc352"], "source_entry_id": "11.0/changes/013", "db_id": "ebebcb159958434c7a70968c23e45efa", "patch_ids": ["2c9c56459f484ad9645918bc5f548db7"], "statement_hash": "38142ba29149c0a51365408497f76dd359050b4781d2dc8217f27272786ccf88", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-49f0f972c189bbb7", "cves": [], "html": "允许使用共享 hash 表并行执行哈希连接（Thomas Munro）
", "text": "允许使用共享 hash 表并行执行哈希连接（Thomas Munro）", "title": "允许使用共享 hash 表并行执行哈希连接", "commits": [], "section": "服务器 / 并行查询", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.3", "source_hash": "d11762aa88afbc10ebc63c7eed2512e24eb7b869384b2be50f80b74269bba3b8", "section_path": ["服务器", "并行查询"], "commit_groups": [["180428404"]], "identity_text": "Allow hash joins to be performed in parallel using a shared hash table (Thomas Munro)", "commit_aliases": ["180428404"], "source_commits": ["180428404"], "source_entry_id": "11.0/changes/014", "db_id": "31c36b3f68c262b2ed036aa00cf5080f", "patch_ids": ["3231d47f627676812da6968fb733723b"], "statement_hash": "433681317904435eb293602ed6bb0c77e69dff46d8a42deeb7efc78697cbd0f9", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-36677c155a4a46cc", "cves": [], "html": "如果各条 SELECT 无法分别并行化，则允许 UNION 并行运行各条 SELECT（Amit Khandekar，Robert Haas，Amul Sul）
允许分区扫描更高效地使用并行工作进程（Amit Khandekar，Robert Haas，Amul Sul）
", "text": "允许分区扫描更高效地使用并行工作进程（Amit Khandekar，Robert Haas，Amul Sul）", "title": "允许分区扫描更高效地使用并行工作进程", "commits": [], "section": "服务器 / 并行查询", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.3", "source_hash": "ceeddd9150462be93a5bc2af2afb7683b54e2ff2f93081dfe923d974fd8bd8de", "section_path": ["服务器", "并行查询"], "commit_groups": [["88ba0ae2a"], ["ab7271677"]], "identity_text": "Allow partition scans to more efficiently use parallel workers (Amit Khandekar, Robert Haas, Amul Sul)", "commit_aliases": ["88ba0ae2a", "ab7271677"], "source_commits": ["88ba0ae2a", "ab7271677"], "source_entry_id": "11.0/changes/016", "db_id": "5b4957aa1d555480e40c68785e28f2b2", "patch_ids": ["457c25b7a415826ca03aceac35deb1f2", "c400bcb186f456151e538f876d061e4c"], "statement_hash": "ec2ed8211c34a41619081f1957d1c4a9a7a8755aa8298b747a37851b1ec69cd8", "relations": [{"rule": 2, "type": "related", "target": "9ab18149bf30a44705b6fa2b2403debe", "evidence": {"same_day": true, "patch_ids": ["457c25b7a415826ca03aceac35deb1f2", "c400bcb186f456151e538f876d061e4c"], "ambiguous_patch_ids": ["457c25b7a415826ca03aceac35deb1f2", "c400bcb186f456151e538f876d061e4c"]}}], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "9ab18149bf30a44705b6fa2b2403debe", "kind": "related", "version": "11.0", "label": "11.0", "title": "如果各条 SELECT 无法分别并行化，则允许 UNION 并行运行各条 SELECT", "evidence": {"same_day": true, "patch_ids": ["457c25b7a415826ca03aceac35deb1f2", "c400bcb186f456151e538f876d061e4c"], "ambiguous_patch_ids": ["457c25b7a415826ca03aceac35deb1f2", "c400bcb186f456151e538f876d061e4c"]}, "url": "/docs/compare/?release=11.0#11.0-36677c155a4a46cc", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.3"}]}, {"id": "11.0-60ac920933ae9f5f", "cves": [], "html": "允许将 LIMIT 传递给并行工作进程（Robert Haas，Tom Lane）
这使工作进程能够减少返回结果，并使用有针对性的索引扫描。
", "text": "允许将 LIMIT 传递给并行工作进程（Robert Haas，Tom Lane） 这使工作进程能够减少返回结果，并使用有针对性的索引扫描。", "title": "允许将 LIMIT 传递给并行工作进程", "commits": [], "section": "服务器 / 并行查询", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.3", "source_hash": "d590d55b923012dc29e2732ed6a6f3942308bea790764414a940b800e5ab8ffd", "section_path": ["服务器", "并行查询"], "commit_groups": [["3452dc524"]], "identity_text": "Allow LIMIT to be passed to parallel workers (Robert Haas, Tom Lane) This allows workers to reduce returned results and use targeted index scans.", "commit_aliases": ["3452dc524"], "source_commits": ["3452dc524"], "source_entry_id": "11.0/changes/017", "db_id": "30df37453e20ca98232664b124039f4b", "patch_ids": ["1be8b1adc84325ccba41b724023c2e8b"], "statement_hash": "d0e795a7c3b810f98b7c28a67b1142d1cf0c7d0e112cdee0eaa80a9674afd95e", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-ad59df825403ddc5", "cves": [], "html": "允许单次求值查询（例如 WHERE 子句中的聚合查询）以及目标列表中的函数并行执行（Amit Kapila，Robert Haas）
添加服务器参数 parallel_leader_participation，以控制领导者是否也执行子计划（Thomas Munro）
默认启用，意味着领导者将执行子计划。
", "text": "添加服务器参数 parallel_leader_participation，以控制领导者是否也执行子计划（Thomas Munro） 默认启用，意味着领导者将执行子计划。", "title": "添加服务器参数 parallel_leader_participation，以控制领导者是否也执行子计划", "commits": [], "section": "服务器 / 并行查询", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.3", "source_hash": "794ce133d5cac0266f8545c6981f9faee1ab00872b7454600b97c200e2df1248", "section_path": ["服务器", "并行查询"], "commit_groups": [["e5253fdc4"]], "identity_text": "Add server parameter parallel_leader_participation to control whether the leader also executes subplans (Thomas Munro) The default is enabled, meaning the leader will execute subplans.", "commit_aliases": ["e5253fdc4"], "source_commits": ["e5253fdc4"], "source_entry_id": "11.0/changes/019", "db_id": "b134e0a76a7aee98a1afcac2792b8de4", "patch_ids": ["01e563d1799001dfd99ef9fe35b40c37"], "statement_hash": "b91357664ec5d7f37fb805c30cf11e2b16b3f20107382d65f389037fc723dfc3", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-c564e5cd479af39c", "cves": [], "html": "允许并行执行 CREATE TABLE ... AS、SELECT INTO 和 CREATE MATERIALIZED VIEW 命令（Haribabu Kommi）
提高使用大量并行工作进程时顺序扫描的性能（David Rowley）
", "text": "提高使用大量并行工作进程时顺序扫描的性能（David Rowley）", "title": "提高使用大量并行工作进程时顺序扫描的性能", "commits": [], "section": "服务器 / 并行查询", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.3", "source_hash": "c62c76641150bf17c2599909498c957e4fe0906808eae9cb6052570f6ab8e5c7", "section_path": ["服务器", "并行查询"], "commit_groups": [["3cda10f41"]], "identity_text": "Improve performance of sequential scans with many parallel workers (David Rowley)", "commit_aliases": ["3cda10f41"], "source_commits": ["3cda10f41"], "source_entry_id": "11.0/changes/021", "db_id": "98bbf7f7cdf8dd1962475e9ab5f9deee", "patch_ids": ["b14f13b397af28878149f0eb50c883c2"], "statement_hash": "bdada06eadb287e076c383460c1ca8494141bd9499a43a5975a407c22f0d8431", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-c433ebb3891227c9", "cves": [], "html": "在 EXPLAIN 中添加并行工作进程排序活动的报告（Robert Haas，Tom Lane）
允许 B-树索引包含不属于搜索键或唯一约束、但可供仅索引扫描读取的列（Anastasia Lubennikova，Alexander Korotkov，Teodor Sigaev）
\n这通过 CREATE INDEX 的新 INCLUDE 子句启用。它便于构建优化特定查询类型的“覆盖索引”。即使列的数据类型不支持 B-树，也可以将其包含在内。
提高单调递增的索引插入的性能（Pavan Deolasee，Peter Geoghegan）
", "text": "提高单调递增的索引插入的性能（Pavan Deolasee，Peter Geoghegan）", "title": "提高单调递增的索引插入的性能", "commits": [], "section": "服务器 / 索引", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.4", "source_hash": "8b797f071f1c8a7e58ddce756a6c4b742b4fb9bba551e89dc80e5ef4482f5181", "section_path": ["服务器", "索引"], "commit_groups": [["074251db6"], ["2b2727343"]], "identity_text": "Improve performance of monotonically increasing index additions (Pavan Deolasee, Peter Geoghegan)", "commit_aliases": ["074251db6", "2b2727343"], "source_commits": ["074251db6", "2b2727343"], "source_entry_id": "11.0/changes/024", "db_id": "0a2c17b4f262ca2cbf31e08a86f28b64", "patch_ids": ["8291df90338ca33ba8bd74f6ef15f9c4", "96d574c1377b5e0b2212470971aed433"], "statement_hash": "7020dab0076cc612ced27f2276826615f33675938ad21ef3bb11a0805a3f6a54", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-7d7519739255cf02", "cves": [], "html": "提高 hash 索引扫描的性能（Ashutosh Sharma）
", "text": "提高 hash 索引扫描的性能（Ashutosh Sharma）", "title": "提高 hash 索引扫描的性能", "commits": [], "section": "服务器 / 索引", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.4", "source_hash": "2e45c1dbbd6985d3e5202b267405f61340b7d7f47064b1a1844c630a9537a22b", "section_path": ["服务器", "索引"], "commit_groups": [["7c75ef571"]], "identity_text": "Improve performance of hash index scans (Ashutosh Sharma)", "commit_aliases": ["7c75ef571"], "source_commits": ["7c75ef571"], "source_entry_id": "11.0/changes/025", "db_id": "f9beb9582e618a52d28ddab461ed1fe7", "patch_ids": ["390439a03f9f19fbf9aebf5352b4557f"], "statement_hash": "4b62f17e465249d53d3e410f97852643353e94a638947f0a4c4f89f83a64a62b", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-3c66e72bb92280c1", "cves": [], "html": "为 hash、GiST 和 GIN 索引添加谓词锁定（Shubham Barai）
\n这降低了可串行化模式事务发生串行化冲突的可能性。
", "text": "为 hash、GiST 和 GIN 索引添加谓词锁定（Shubham Barai） 这降低了可串行化模式事务发生串行化冲突的可能性。", "title": "为 hash、GiST 和 GIN 索引添加谓词锁定", "commits": [], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.4", "source_hash": "347646bfcfbb4666f75d6b10e9e221d38d8b9c2475a1524b42fd72085228c68a", "section_path": ["服务器", "索引"], "commit_groups": [["3ad55863e"], ["43d1ed60f"], ["b508a56f2"]], "identity_text": "Add predicate locking for hash, GiST and GIN indexes (Shubham Barai) This reduces the likelihood of serialization conflicts in serializable-mode transactions.", "commit_aliases": ["3ad55863e", "43d1ed60f", "b508a56f2"], "source_commits": ["3ad55863e", "43d1ed60f", "b508a56f2"], "source_entry_id": "11.0/changes/026", "db_id": "56d4ff9224e92787bc5b133c0439a804", "patch_ids": ["51712d8aa268bfd72afe25c8101eeb2c", "cabe231e7f9494b1182875f43b9c5fa1", "f336752de7832a5a32d0e9566bbc1f55"], "statement_hash": "a2a55f03f5bc9d8b2bad0415f9b49e75774ccae0af5cc8270d62a5675ee420f1", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-c69f62d316d9bcda", "cves": [], "html": "添加前缀匹配操作符 text ^@ text，并由 SP-GiST 支持（Ildus Kurbangaliev）
这类似于配合 B-树索引使用 var LIKE 'word%'，但效率更高。
允许使用 SP-GiST 对多边形建立索引（Nikita Glukhov，Alexander Korotkov）
", "text": "允许使用 SP-GiST 对多边形建立索引（Nikita Glukhov，Alexander Korotkov）", "title": "允许使用 SP-GiST 对多边形建立索引", "commits": [], "section": "服务器 / 索引 / SP-Gist", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.4.3", "source_hash": "4b97263a7e19682c270e260a8efe02c5ba14faa94bddd354aaddca0f2aff51ba", "section_path": ["服务器", "索引", "SP-Gist"], "commit_groups": [["ff963b393"]], "identity_text": "Allow polygons to be indexed with SP-GiST (Nikita Glukhov, Alexander Korotkov)", "commit_aliases": ["ff963b393"], "source_commits": ["ff963b393"], "source_entry_id": "11.0/changes/028", "db_id": "6be9a520a242153b75eebfbba4588589", "patch_ids": ["d495145a3de97e76dd0322c0133acc45"], "statement_hash": "2a543c7819b7fdd499e0f23e17345cd5bcc80f6f4b2afe955c689f400b98ce32", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-a8c70553230a9d53", "cves": [], "html": "允许 SP-GiST 对叶子键使用有损表示（Teodor Sigaev，Heikki Linnakangas，Alexander Korotkov，Nikita Glukhov）
", "text": "允许 SP-GiST 对叶子键使用有损表示（Teodor Sigaev，Heikki Linnakangas，Alexander Korotkov，Nikita Glukhov）", "title": "允许 SP-GiST 对叶子键使用有损表示", "commits": [], "section": "服务器 / 索引 / SP-Gist", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.4.3", "source_hash": "934e662cc299f46f3d66e15d86fedb656e31911d39f1e9c52b5d1804b30864b2", "section_path": ["服务器", "索引", "SP-Gist"], "commit_groups": [["854823fa3"]], "identity_text": "Allow SP-GiST to use lossy representation of leaf keys (Teodor Sigaev, Heikki Linnakangas, Alexander Korotkov, Nikita Glukhov)", "commit_aliases": ["854823fa3"], "source_commits": ["854823fa3"], "source_entry_id": "11.0/changes/029", "db_id": "92b6279f35dba8bb5f148642d5b113e2", "patch_ids": ["8f2ec9b90cb397c84384c01087623f9d"], "statement_hash": "6231f1fbbafb16e4353b03b7bc06d2b364386735502856f50ffe93768b491030", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-29e596088fb86c71", "cves": [], "html": "改进统计信息中高频值的选择（Jeff Janes，Dean Rasheed）
\n以前，根据某个值相对于所有列值的频率来识别高频值（MCV）。现在，根据其相对于非 MCV 值的频率选择 MCV。这提高了算法在均匀分布和非均匀分布下的稳健性。
", "text": "改进统计信息中高频值的选择（Jeff Janes，Dean Rasheed） 以前，根据某个值相对于所有列值的频率来识别高频值（MCV）。现在，根据其相对于非 MCV 值的频率选择 MCV。这提高了算法在均匀分布和非均匀分布下的稳健性。", "title": "改进统计信息中高频值的选择", "commits": [], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.5", "source_hash": "10ab43b7e90578617411a30b09731f72b935cdc22732f17e6a9bdbd9a6a18e6f", "section_path": ["服务器", "优化器"], "commit_groups": [["b5db1d93d"]], "identity_text": "Improve selection of the most common values for statistics (Jeff Janes, Dean Rasheed) Previously, the most common values (MCVs) were identified based on their frequency compared to all column values. Now, MCVs are chosen based on their frequency compared to the non-MCV values. This improves the robustness of the algorithm for both uniform and non-uniform distributions.", "commit_aliases": ["b5db1d93d"], "source_commits": ["b5db1d93d"], "source_entry_id": "11.0/changes/030", "db_id": "c77333ec171bc43be04e4dafa9d0c35b", "patch_ids": ["e46d4e93a2e3aacd9a08bb2b6bcb47a3"], "statement_hash": "89dbd93d9935ba3283605c3b4868d0bc6a7739e43d0b237979fa31ba89cf0d12", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-ff3b616e2d0ff22c", "cves": [], "html": "改进 >= 和 <= 的选择率估算（Tom Lane）
以前，除非比较常量为 MCV，这些情况分别采用与 > 和 < 相同的选择率估算。此更改对涉及小范围 BETWEEN 的查询尤其有帮助。
在等价的情况下，将 var = var 简化为 var IS NOT NULL（Tom Lane）
这会改善选择率估算。
", "text": "在等价的情况下，将 var = var 简化为 var IS NOT NULL（Tom Lane） 这会改善选择率估算。", "title": "在等价的情况下，将 var = var 简化为 var IS NOT NULL", "commits": [], "section": "服务器 / 优化器", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.5", "source_hash": "0f3f8bf24f025674077e3649a68c2525a73e800523d4da1e2167f9dbff07aafd", "section_path": ["服务器", "优化器"], "commit_groups": [["8ec5429e2"]], "identity_text": "Reduce var = var to var IS NOT NULL where equivalent (Tom Lane) This leads to better selectivity estimates.", "commit_aliases": ["8ec5429e2"], "source_commits": ["8ec5429e2"], "source_entry_id": "11.0/changes/032", "db_id": "f502793100de87c3464c2c49ea723ea0", "patch_ids": ["dacc2d199e6c2e60c0492e312eabfdba"], "statement_hash": "3bb7d6a4177ae8a51bac6fe0c13f693d48b8d778812f8e9244428563253f5625", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-963100a3e2e88fdd", "cves": [], "html": "改进优化器对 EXISTS 和 NOT EXISTS 查询的行数估算（Tom Lane）
使优化器考虑 HAVING 子句的求值代价和选择率（Tom Lane）
为查询计划的某些部分添加即时（JIT）编译，以提高执行速度（Andres Freund）
\n此特性要求 LLVM 可用。目前，即使构建支持它，默认也不启用。
", "text": "为查询计划的某些部分添加即时（JIT）编译，以提高执行速度（Andres Freund） 此特性要求 LLVM 可用。目前，即使构建支持它，默认也不启用。", "title": "为查询计划的某些部分添加即时（JIT）编译，以提高执行速度", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.6", "source_hash": "7113bf4da653975a08301a40ad892f415ed572c16d58a9889dbec4db6e947376", "section_path": ["服务器", "一般性能"], "commit_groups": [["0fdadfb01"], ["32af96b2b"], ["432bb9e04"], ["9370462e9"], ["b96d550eb"], ["cc415a56d"], ["f4f5845b3"]], "identity_text": "Add Just-in-Time (JIT) compilation of some parts of query plans to improve execution speed (Andres Freund) This feature requires LLVM to be available. It is not currently enabled by default, even in builds that support it.", "commit_aliases": ["0fdadfb01", "32af96b2b", "432bb9e04", "9370462e9", "b96d550eb", "cc415a56d", "f4f5845b3"], "source_commits": ["0fdadfb01", "32af96b2b", "432bb9e04", "9370462e9", "b96d550eb", "cc415a56d", "f4f5845b3"], "source_entry_id": "11.0/changes/035", "db_id": "f5aa0e68c7bb86ea988d9629a59e39b7", "patch_ids": ["04a274b866c80eebad3a30af5cbb12e4", "43c5b65c52a6d29a9ca45b1db25bc1bf", "4da261a19858bd649076a90e04ee448d", "4f1617e0f9afec0375f9e30035939be7", "661d5108f639ab722bb541e9841e5edf", "dc124cfb0ef67126a9c06e536b2b9986", "f6fd992546ccbc05f174abb1796e6aa1"], "statement_hash": "cd4ada7658f0e7adb0764a4b0ef5cecd34aa92798c5cf4c93a0dfa5d0c3ad733", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-9551bea74772b6d6", "cves": [], "html": "允许位图扫描在可能时执行仅索引扫描（Alexander Kuzmenkov）
", "text": "允许位图扫描在可能时执行仅索引扫描（Alexander Kuzmenkov）", "title": "允许位图扫描在可能时执行仅索引扫描", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.6", "source_hash": "eb40b6dd6abde2a00dd8680972cb51da09b06f99a0a284faa3e78f50ba4568d8", "section_path": ["服务器", "一般性能"], "commit_groups": [["7c70996eb"]], "identity_text": "Allow bitmap scans to perform index-only scans when possible (Alexander Kuzmenkov)", "commit_aliases": ["7c70996eb"], "source_commits": ["7c70996eb"], "source_entry_id": "11.0/changes/036", "db_id": "cdc84ae14a90b8f8f74e98d7e9f60cbf", "patch_ids": ["14ddb409be3f6465527dcb705962e11d"], "statement_hash": "f0583b530831e72163b7f48bdfdf8b23deefacc92ea563dff9ffae66833c7f7b", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-e8bd201a3430e4da", "cves": [], "html": "在 VACUUM 期间更新空闲空间映射（Claudio Freire）
这使空闲空间能够更快地被复用。
", "text": "在 VACUUM 期间更新空闲空间映射（Claudio Freire） 这使空闲空间能够更快地被复用。", "title": "在 VACUUM 期间更新空闲空间映射", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.6", "source_hash": "5cf5dbc6f367bd7329ffee73b644d9d3f51ec5f11c9fcb816a4c7ca1f4e2852e", "section_path": ["服务器", "一般性能"], "commit_groups": [["851a26e26"], ["c79f6df75"]], "identity_text": "Update the free space map during VACUUM (Claudio Freire) This allows free space to be reused more quickly.", "commit_aliases": ["851a26e26", "c79f6df75"], "source_commits": ["851a26e26", "c79f6df75"], "source_entry_id": "11.0/changes/037", "db_id": "79c5cb83f4ceb7751e4b14cecd300b36", "patch_ids": ["263848c0a37e919e865258f46a2ee719", "63ead92f5d0dcc96b6dfa6c5cb86b146"], "statement_hash": "094f6d9fe3db0306f0d79d92de59ca3fd75d1e6470dbc72648e9712ce296d869", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-4566989b2713b728", "cves": [], "html": "允许 VACUUM 避免不必要的索引扫描（Masahiko Sawada，Alexander Korotkov）
提高提交多个并发事务的性能（Amit Kapila）
", "text": "提高提交多个并发事务的性能（Amit Kapila）", "title": "提高提交多个并发事务的性能", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.6", "source_hash": "02afbdcc08010f053e25e805fef6da95c49915ccdc235ebe7c21cfd4e14b8c44", "section_path": ["服务器", "一般性能"], "commit_groups": [["baaf272ac"]], "identity_text": "Improve performance of committing multiple concurrent transactions (Amit Kapila)", "commit_aliases": ["baaf272ac"], "source_commits": ["baaf272ac"], "source_entry_id": "11.0/changes/039", "db_id": "36dce2fac3398c608c1fe1a9905e22f1", "patch_ids": ["fb852ad8c1824c2d025dbff3c5b8a500"], "statement_hash": "da412e08e1358a01844d255132284cd3484d5fa33bc99b62ea6e2b860ae621f5", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-57f0dd08e01ec664", "cves": [], "html": "减少目标列表中使用返回集合函数的查询的内存用量（Andres Freund）
", "text": "减少目标列表中使用返回集合函数的查询的内存用量（Andres Freund）", "title": "减少目标列表中使用返回集合函数的查询的内存用量", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.6", "source_hash": "a7aa3d1942a52d0821ec6e5298fec9a9acd7cf0a37297ebcebe9d794bb982e29", "section_path": ["服务器", "一般性能"], "commit_groups": [["84ad4b036"]], "identity_text": "Reduce memory usage for queries using set-returning functions in their target lists (Andres Freund)", "commit_aliases": ["84ad4b036"], "source_commits": ["84ad4b036"], "source_entry_id": "11.0/changes/040", "db_id": "3aa21c8b21b62e64afb38c65fb73486f", "patch_ids": ["a6cbdecc9c0c45a47c95dbaa5fc4fcc2"], "statement_hash": "bae35c7905967036eed535a2c3125e2d327250937a3832e02d6aefe9a0ae47f6", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-0ea9090b12cb0dc1", "cves": [], "html": "提高聚合计算的速度（Andres Freund）
", "text": "提高聚合计算的速度（Andres Freund）", "title": "提高聚合计算的速度", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.6", "source_hash": "58dab48812275fbe84b759a84cf96a0ff33877f0f5a22a4640bc4be40235958e", "section_path": ["服务器", "一般性能"], "commit_groups": [["69c3936a1"]], "identity_text": "Improve the speed of aggregate computations (Andres Freund)", "commit_aliases": ["69c3936a1"], "source_commits": ["69c3936a1"], "source_entry_id": "11.0/changes/041", "db_id": "991c579f8f8714afaac4570c5441a21a", "patch_ids": ["84624809612700b979c023402b09d3f1"], "statement_hash": "5848429f9dbd27d63af51305d76199d4f0ed81090d48f7f55f64dd8c6c795d77", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-9abd1a0f09dd7155", "cves": [], "html": "允许 postgres_fdw 将使用连接的 UPDATE 和 DELETE 下推到外部服务器（Etsuro Fujita）
以前，只会下推不含连接的 UPDATE 和 DELETE。
添加对 Windows 上大页的支持（Takayuki Tsunakawa，Thomas Munro）
\n这由 huge_pages 配置参数控制。
", "text": "添加对 Windows 上大页的支持（Takayuki Tsunakawa，Thomas Munro） 这由 huge_pages 配置参数控制。", "title": "添加对 Windows 上大页的支持", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.6", "source_hash": "b6cfca66a8916570598eb6191a174c0037103df1d7e93ba6b1a62a534161aa3b", "section_path": ["服务器", "一般性能"], "commit_groups": [["1cc4f536e"]], "identity_text": "Add support for large pages on Windows (Takayuki Tsunakawa, Thomas Munro) This is controlled by the huge_pages configuration parameter.", "commit_aliases": ["1cc4f536e"], "source_commits": ["1cc4f536e"], "source_entry_id": "11.0/changes/043", "db_id": "f01fb3ea5f5e5114b391d3f3253b246d", "patch_ids": ["11e4d73b483ef111f384ec9213b96db8"], "statement_hash": "97e99e91a4fee7f004238a46669b2ce164ad40eaaee3b5d47f7cbcb51d336dac", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-8903e8211b3b1313", "cves": [], "html": "在 log_statement_stats、log_parser_stats、log_planner_stats 和 log_executor_stats 的输出中显示内存用量（Justin Pryzby，Peter Eisentraut）
添加 pg_stat_activity.backend_type 列，以显示后台工作进程的类型（Peter Eisentraut）
该类型在 ps 输出中也可见。
", "text": "添加 pg_stat_activity.backend_type 列，以显示后台工作进程的类型（Peter Eisentraut） 该类型在 ps 输出中也可见。", "title": "添加 pg_stat_activity.backend_type 列，以显示后台工作进程的类型", "commits": [], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.7", "source_hash": "14fccba940dda1c121267fc4000b512603cd920429994468f870242cef74b317", "section_path": ["服务器", "监控"], "commit_groups": [["5373bc2a0"]], "identity_text": "Add column pg_stat_activity.backend_type to show the type of a background worker (Peter Eisentraut) The type is also visible in ps output.", "commit_aliases": ["5373bc2a0"], "source_commits": ["5373bc2a0"], "source_entry_id": "11.0/changes/045", "db_id": "50ce9aa0b2a355c578fef384489ef45e", "patch_ids": ["2dae9ba379e6b0016d69c23449d9d026"], "statement_hash": "85fbb6a715d941890095670548c2ed66c4964c6cb04d54a44c0ea0b5fa2574cf", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-fbb92a78e33433d7", "cves": [], "html": "使 log_autovacuum_min_duration 记录因正被并发删除而跳过的表（Nathan Bossart）
添加与表约束和触发器相关的 information_schema 列（Peter Eisentraut）
具体而言，triggers.action_order、triggers.action_reference_old_table 和 triggers.action_reference_new_table 现在会填入值，而以前始终为空。此外，table_constraints.enforced 列现在已存在，但尚未填入有用的值。
允许服务器在 search+bind 模式下使用更复杂的 LDAP 配置（Thomas Munro）
\n具体而言，ldapsearchfilter 允许组合 LDAP 属性进行模式匹配。
允许 LDAP 认证使用加密的 LDAP（Thomas Munro）
\n以前已可通过 ldaptls=1 支持基于 TLS 的 LDAP。这种用于加密 LDAP 的新 TLS LDAP 方式，通过 ldapscheme=ldaps 或 ldapurl=ldaps:// 启用。
改进 LDAP 错误的日志记录（Thomas Munro）
", "text": "改进 LDAP 错误的日志记录（Thomas Munro）", "title": "改进 LDAP 错误的日志记录", "commits": [], "section": "服务器 / Authentication", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.8", "source_hash": "ba42ec08339ab64fe9d31d3c817bdaf20c7d8ccfc855404be63bc3a947473a52", "section_path": ["服务器", "Authentication"], "commit_groups": [["cf1238cd9"]], "identity_text": "Improve logging of LDAP errors (Thomas Munro)", "commit_aliases": ["cf1238cd9"], "source_commits": ["cf1238cd9"], "source_entry_id": "11.0/changes/050", "db_id": "d835fe9c0c6d7625838a8d833f2e30c5", "patch_ids": ["dcdc5233ecc8a2496357e0a0dd8f06c6"], "statement_hash": "ae64df16cae8d6bf31768ae216689854e043231ae9b13136c821d6ecddfaf46b", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-cb345e26b4519c8d", "cves": [], "html": "添加允许文件系统访问的默认角色（Stephen Frost）
\n具体来说，新增角色是 pg_read_server_files、pg_write_server_files 和 pg_execute_server_program。这些角色现在还控制谁可以使用服务器端的 COPY 和 file_fdw 扩展。以前，只有超级用户可以使用这些功能，现在默认行为仍然如此。
允许通过 GRANT/REVOKE 权限控制对文件系统函数的访问，取代超级用户检查（Stephen Frost）
具体而言，修改了以下函数：pg_ls_dir()、pg_read_file()、pg_read_binary_file()、pg_stat_file()。
使用 GRANT/REVOKE 控制对 lo_import() 和 lo_export() 的访问（Michael Paquier，Tom Lane）
以前，只有超级用户获准访问这些函数。
\n编译时选项 ALLOW_DANGEROUS_LO_FUNCTIONS 已被移除。
在阻止以非密码方式访问 postgres_fdw 表时，使用视图所有者而非会话所有者（Robert Haas）
PostgreSQL 只允许超级用户在不使用密码的情况下访问 postgres_fdw 表，例如通过 peer 认证。以前，要允许此类访问，会话所有者必须是超级用户；现在改为检查视图所有者。
修复对视图执行 SELECT FOR UPDATE 时无效的锁定权限检查（Tom Lane）
添加服务器设置 ssl_passphrase_command，以允许为 SSL 密钥文件提供口令（Peter Eisentraut）
同时添加 ssl_passphrase_command_supports_reload，用于指定服务器配置重新加载期间，是否应重新加载 SSL 配置并调用 ssl_passphrase_command。
添加存储参数 toast_tuple_target，以控制开始考虑 TOAST 存储的最小元组长度（Simon Riggs）
默认的 TOAST 阈值没有改变。
", "text": "添加存储参数 toast_tuple_target，以控制开始考虑 TOAST 存储的最小元组长度（Simon Riggs） 默认的 TOAST 阈值没有改变。", "title": "添加存储参数 toast_tuple_target，以控制开始考虑 TOAST 存储的最小元组长度", "commits": [], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.10", "source_hash": "35a464e2aeb91ffb892bb99c2fdb1484274b1e86d619ce65830cfde29bed4f39", "section_path": ["服务器", "服务器配置"], "commit_groups": [["c2513365a"]], "identity_text": "Add storage parameter toast_tuple_target to control the minimum tuple length before TOAST storage will be considered (Simon Riggs) The default TOAST threshold has not been changed.", "commit_aliases": ["c2513365a"], "source_commits": ["c2513365a"], "source_entry_id": "11.0/changes/057", "db_id": "ace5f27f4a22e60e5e315e523db0d475", "patch_ids": ["f38bc3b70a551b1688d8e728acf7441e"], "statement_hash": "d5dc594bc3fc7340bd7891227b000cc0bcc1b869027a591115a7fb0e8e23c398", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-1ae6bab0db83cc2f", "cves": [], "html": "允许以字节为单位指定与内存和文件大小相关的服务器选项（Beena Emerson）
\n新增单位后缀为 “B”，与现有的 “kB”、“MB”、“GB” 和 “TB” 并用。
", "text": "允许以字节为单位指定与内存和文件大小相关的服务器选项（Beena Emerson） 新增单位后缀为 “B”，与现有的 “kB”、“MB”、“GB” 和 “TB” 并用。", "title": "允许以字节为单位指定与内存和文件大小相关的服务器选项", "commits": [], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.10", "source_hash": "cb52ef7d99025408e5a80f9fd9b3b0e35f32c64a857e0f7869435bbd25a71b29", "section_path": ["服务器", "服务器配置"], "commit_groups": [["6e7baa322"], ["b06d8e58b"]], "identity_text": "Allow server options related to memory and file sizes to be specified in units of bytes (Beena Emerson) The new unit suffix is B. This is in addition to the existing units kB, MB, GB and TB.", "commit_aliases": ["6e7baa322", "b06d8e58b"], "source_commits": ["6e7baa322", "b06d8e58b"], "source_entry_id": "11.0/changes/058", "db_id": "04aa60ab2b89066ec89bd6c60605739f", "patch_ids": ["9d6582b2063b65dcd591508db87d200b", "deb10772777150c2727b2fb1111e397a"], "statement_hash": "bf40f7571fa9ca8a72e64645abededd51cb9dbc57408ce8c91da5b4d30a04fe0", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-1b8986eeb92ea478", "cves": [], "html": "允许在 initdb 期间设置 WAL 文件大小（Beena Emerson）
\n以前，16MB 的默认值只能在编译时更改。
", "text": "允许在 initdb 期间设置 WAL 文件大小（Beena Emerson） 以前，16MB 的默认值只能在编译时更改。", "title": "允许在 initdb 期间设置 WAL 文件大小", "commits": [], "section": "服务器 / 预写式日志（WAL）", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.11", "source_hash": "a4b35c4d9ef913a225d8b16649c7a028a8745439b219f63babe5cc56ef7a410d", "section_path": ["服务器", "预写式日志（WAL）"], "commit_groups": [["fc49e24fa"]], "identity_text": "Allow the WAL file size to be set during initdb (Beena Emerson) Previously, the 16MB default could only be changed at compile time.", "commit_aliases": ["fc49e24fa"], "source_commits": ["fc49e24fa"], "source_entry_id": "11.0/changes/059", "db_id": "47fbfb37e540c4f7c25c4d48495164a6", "patch_ids": ["ee4d6e1f35c15ef4c16cbe190565844b"], "statement_hash": "1a93805137ff3cfed2d7c3a0ebc49e8ec2f0d1870b2808eea2695c68735c8814", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-18da4a5f1610d3be", "cves": [], "html": "仅保留一个检查点周期的 WAL 数据（Simon Riggs）
\n以前，会保留两个检查点周期的 WAL。
", "text": "仅保留一个检查点周期的 WAL 数据（Simon Riggs） 以前，会保留两个检查点周期的 WAL。", "title": "仅保留一个检查点周期的 WAL 数据", "commits": [], "section": "服务器 / 预写式日志（WAL）", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.11", "source_hash": "50c9f9b4293446b1347e8322d6f1625f4e563ab6935111083d59bc30509e84de", "section_path": ["服务器", "预写式日志（WAL）"], "commit_groups": [["4b0d28de0"]], "identity_text": "Retain WAL data for only a single checkpoint (Simon Riggs) Previously, WAL was retained for two checkpoints.", "commit_aliases": ["4b0d28de0"], "source_commits": ["4b0d28de0"], "source_entry_id": "11.0/changes/060", "db_id": "3c4e095cf338efc7d6cff054f32a1b69", "patch_ids": ["3f2f66997e3f108a9c73bf448bc219f7"], "statement_hash": "af4dbd2ba0c5566e7873419a170a149c449d50f89532ebbd550f38329bb1e8ca", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-e5b305e2f5efef96", "cves": [], "html": "将被强制切换的 WAL 段文件的未使用部分填零，以提高可压缩性（Chapman Flack）
", "text": "将被强制切换的 WAL 段文件的未使用部分填零，以提高可压缩性（Chapman Flack）", "title": "将被强制切换的 WAL 段文件的未使用部分填零，以提高可压缩性", "commits": [], "section": "服务器 / 预写式日志（WAL）", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.3.11", "source_hash": "1fe7484f03ff0030c53014fc689c2b7c839496546b2b6d1f100be6ef5b1d62ab", "section_path": ["服务器", "预写式日志（WAL）"], "commit_groups": [["4a33bb59d"]], "identity_text": "Fill the unused portion of force-switched WAL segment files with zeros for improved compressibility (Chapman Flack)", "commit_aliases": ["4a33bb59d"], "source_commits": ["4a33bb59d"], "source_entry_id": "11.0/changes/061", "db_id": "4e3acc0d84234a1ec3efd039df3393e4", "patch_ids": ["8fd6fa5958971b4f1660135683d1d71c"], "statement_hash": "7af1a11e9a791a7fd72fdb1ca63c549cee73f7e0277ca37f6ea45c4ecbbf0533", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-e0cda63716b24a68", "cves": [], "html": "使用逻辑复制时复制 TRUNCATE 操作（Simon Riggs，Marco Nenciarini，Peter Eisentraut）
将预备事务信息传递给逻辑复制订阅者（Nikhil Sontakke，Stas Kelvich）
", "text": "将预备事务信息传递给逻辑复制订阅者（Nikhil Sontakke，Stas Kelvich）", "title": "将预备事务信息传递给逻辑复制订阅者", "commits": [], "section": "基础备份与流复制", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.4", "source_hash": "dc49bbb987a75a0d038856abcbce2adb6ec1c67e109f31ee83310ec95767eab0", "section_path": ["基础备份与流复制"], "commit_groups": [["1eb6d6527"]], "identity_text": "Pass prepared transaction information to logical replication subscribers (Nikhil Sontakke, Stas Kelvich)", "commit_aliases": ["1eb6d6527"], "source_commits": ["1eb6d6527"], "source_entry_id": "11.0/changes/063", "db_id": "000e84c6a14d505070db1fde381d32d1", "patch_ids": ["2ba325ad80ccae1670c875ef0fd4af0f"], "statement_hash": "673a98baf03e197ddf064444b068b41028b57f3b1508951514933c8e8e019c7e", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-670a6a1014286406", "cves": [], "html": "从流式基础备份中排除不记录 WAL 的表、临时表和 pg_internal.init 文件（David Steele）
没有必要复制此类文件。
", "text": "从流式基础备份中排除不记录 WAL 的表、临时表和 pg_internal.init 文件（David Steele） 没有必要复制此类文件。", "title": "从流式基础备份中排除不记录 WAL 的表、临时表和 pg_internal.init 文件", "commits": [], "section": "基础备份与流复制", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.4", "source_hash": "9178b93090507d43bcfd51ac6be8adb84020ca93413294e0baff628f8ebef3a2", "section_path": ["基础备份与流复制"], "commit_groups": [["8694cc96b"], ["920a5e500"], ["98267ee83"]], "identity_text": "Exclude unlogged tables, temporary tables, and pg_internal.init files from streaming base backups (David Steele) There is no need to copy such files.", "commit_aliases": ["8694cc96b", "920a5e500", "98267ee83"], "source_commits": ["8694cc96b", "920a5e500", "98267ee83"], "source_entry_id": "11.0/changes/064", "db_id": "3ff82d6fb2b9b7d7c949768a55cc2c64", "patch_ids": ["af9ef3186ec110b08c56cf73eac67d2f", "cf882b1a701bad25e36043c11c518f4e", "f88ea6b39b72b92570f52b22c9b3b017"], "statement_hash": "617b9d4b6fd00f590e792ecd9b54bf4d5fd58ecd9ef5f7e98cd71e97750e1d01", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-a4ce6d62b997e183", "cves": [], "html": "允许在流式基础备份期间验证堆页面的校验和（Michael Banck）
", "text": "允许在流式基础备份期间验证堆页面的校验和（Michael Banck）", "title": "允许在流式基础备份期间验证堆页面的校验和", "commits": [], "section": "基础备份与流复制", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.4", "source_hash": "43354a3a0759f59c26e71c6c038d2dff6642e6e6c8ad8ce7c5af025d8f2104f3", "section_path": ["基础备份与流复制"], "commit_groups": [["4eb77d50c"]], "identity_text": "Allow checksums of heap pages to be verified during streaming base backup (Michael Banck)", "commit_aliases": ["4eb77d50c"], "source_commits": ["4eb77d50c"], "source_entry_id": "11.0/changes/065", "db_id": "01df6d05d7b158bfd2b91e2bf4237f07", "patch_ids": ["f8b763beb9b5b162f708472e1eb70b24"], "statement_hash": "a5d71ce1a1f7fa28f7cddd7dec2454b3de7d49fa803c8a655225317978c4fa4c", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-1d01578cd91f097a", "cves": [], "html": "允许以编程方式推进复制槽，而无需由订阅者消费（Petr Jelinek）
\n这使复制槽在内容无需被消费时能够高效推进。相应操作通过 pg_replication_slot_advance() 执行。
向 backup_label 文件添加时间线信息（Michael Paquier）
同时添加检查，确保 WAL 时间线与 backup_label 文件的时间线匹配。
向 pg_stat_wal_receiver 系统视图添加主机和端口连接信息（Haribabu Kommi）
允许 ALTER TABLE 添加具有非空默认值的列，而无需重写表（Andrew Dunstan，Serge Rielau）
默认值为常量时会启用此优化。
", "text": "允许 ALTER TABLE 添加具有非空默认值的列，而无需重写表（Andrew Dunstan，Serge Rielau） 默认值为常量时会启用此优化。", "title": "允许 ALTER TABLE 添加具有非空默认值的列，而无需重写表", "commits": [], "section": "工具命令", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.5", "source_hash": "ab9acc3a94dc6e6f2b802a749ca8b7ebe5ed9da9e517844138fb502da921ef62", "section_path": ["工具命令"], "commit_groups": [["16828d5c0"]], "identity_text": "Allow ALTER TABLE to add a column with a non-null default without doing a table rewrite (Andrew Dunstan, Serge Rielau) This is enabled when the default value is a constant.", "commit_aliases": ["16828d5c0"], "source_commits": ["16828d5c0"], "source_entry_id": "11.0/changes/069", "db_id": "ace512d78734cf5085a3fe9cbd1d25b6", "patch_ids": ["cea7a1fe3222777a2fed9157ac898a65"], "statement_hash": "3fa7b43f1eb4f52baf2d7a121c418f0f9d9a9ffa8edc7f7daf132b5f92096d76", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-427b09fb12f0ce8b", "cves": [], "html": "允许通过锁定底层表来锁定视图（Yugo Nagata）
", "text": "允许通过锁定底层表来锁定视图（Yugo Nagata）", "title": "允许通过锁定底层表来锁定视图", "commits": [], "section": "工具命令", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.5", "source_hash": "a718af0a0a99ba22d9f3cb076d327b173193f11d6db34ad4509996619007fa99", "section_path": ["工具命令"], "commit_groups": [["1b26bd408"], ["34c20de4d"]], "identity_text": "Allow views to be locked by locking the underlying tables (Yugo Nagata)", "commit_aliases": ["1b26bd408", "34c20de4d"], "source_commits": ["1b26bd408", "34c20de4d"], "source_entry_id": "11.0/changes/070", "db_id": "378f06d3060eb35779f10e6b19f7eb45", "patch_ids": ["0ac14f284c72a9a43a4f307047dd95d9", "ff4e3e43f9330e79c2d8d139accc0b29"], "statement_hash": "2b58056cab3df82d676457915083bd3da77e51662b112be4266df5e394b51812", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-2ef62ec9212372d9", "cves": [], "html": "允许 ALTER INDEX 设置表达式索引的统计收集目标（Alexander Korotkov，Adrien Nayrat）
在 psql 中，\\d+ 现在会显示索引的统计目标。
允许在一条 VACUUM 或 ANALYZE 命令中指定多个表（Nathan Bossart）
此外，如果 VACUUM 中提到的任何表使用了列列表，就必须提供 ANALYZE 关键字；以前，此类情况会隐含执行 ANALYZE。
为 ANALYZE 添加括号包围的选项语法（Nathan Bossart）
这与 VACUUM 支持的语法类似。
添加 CREATE AGGREGATE 选项，以指定聚合最终函数的行为（Tom Lane）
这有助于优化用户定义的聚合函数，并使其能够用作窗口函数。
", "text": "添加 CREATE AGGREGATE 选项，以指定聚合最终函数的行为（Tom Lane） 这有助于优化用户定义的聚合函数，并使其能够用作窗口函数。", "title": "添加 CREATE AGGREGATE 选项，以指定聚合最终函数的行为", "commits": [], "section": "工具命令", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.5", "source_hash": "4f78a0f85dee9a484d4bb3c107bfd03080ecebd91239d9f766191b64f149dfa9", "section_path": ["工具命令"], "commit_groups": [["4de2d4fba"], ["be0ebb65f"]], "identity_text": "Add CREATE AGGREGATE option to specify the behavior of the aggregate's finalization function (Tom Lane) This is helpful for allowing user-defined aggregate functions to be optimized and to work as window functions.", "commit_aliases": ["4de2d4fba", "be0ebb65f"], "source_commits": ["4de2d4fba", "be0ebb65f"], "source_entry_id": "11.0/changes/074", "db_id": "28b3f7fda0292e912add1c943a7a36bc", "patch_ids": ["1e8ad797a9d1556bd7f2f6b05ca3ec2b", "b71a80b232b7e351f4c1036ef6d403c5"], "statement_hash": "63cadbb561a467935ff1ad72a07f6a0a4cf117c8495caa648fc9df104a28f5a1", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-2dd97447dd7e278c", "cves": [], "html": "允许创建域的数组（Tom Lane）
\n这也允许对域使用 array_agg()。
支持基于复合类型的域（Tom Lane）
\n同时允许 PL/Perl、PL/Python 和 PL/Tcl 处理复合类型域的函数参数和结果，并改进 PL/Python 的域处理。
", "text": "支持基于复合类型的域（Tom Lane） 同时允许 PL/Perl、PL/Python 和 PL/Tcl 处理复合类型域的函数参数和结果，并改进 PL/Python 的域处理。", "title": "支持基于复合类型的域", "commits": [], "section": "数据类型", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.6", "source_hash": "a0906d2fe9ca776ec3d672a430c9575e2adb19e499bf46714cafe5148c31155a", "section_path": ["数据类型"], "commit_groups": [["37a795a60"], ["60651e4cd"], ["687f096ea"], ["820c0305f"]], "identity_text": "Support domains over composite types (Tom Lane) Also allow PL/Perl, PL/Python, and PL/Tcl to handle composite-domain function arguments and results. Also improve PL/Python domain handling.", "commit_aliases": ["37a795a60", "60651e4cd", "687f096ea", "820c0305f"], "source_commits": ["37a795a60", "60651e4cd", "687f096ea", "820c0305f"], "source_entry_id": "11.0/changes/076", "db_id": "a929b9dce201e5448b7104fdb8f9ca52", "patch_ids": ["0199429a370a79ecc83782c7a1802524", "067667940e422ee6ab3fc971f7da687e", "243494c5c925b1ac225a902e971cbcbc", "32f98202db83f109091677492b37b96a"], "statement_hash": "bd778de7e9ae77d4bb0fdafcc086815da2c753347a2afc96999f843667f91741", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-83135c589052bd38", "cves": [], "html": "添加从 JSONB 标量到数值和布尔数据类型的类型转换（Anastasia Lubennikova）
添加 SQL:2011 规定的所有窗口函数帧选项（Oliver Ford，Tom Lane）
\n具体而言，允许 RANGE 模式使用 PRECEDING 和 FOLLOWING，选取分组值位于加减指定偏移量范围内的行。添加 GROUPS 模式，以包含前后指定数量的同等行组。同时添加了帧排除语法。
添加 SHA-2 系列 hash 函数（Peter Eisentraut）
\n具体添加了 sha224()、sha256()、sha384() 和 sha512()。
添加对 64 位非密码学 hash 函数的支持（Robert Haas，Amul Sul）
", "text": "添加对 64 位非密码学 hash 函数的支持（Robert Haas，Amul Sul）", "title": "添加对 64 位非密码学 hash 函数的支持", "commits": [], "section": "函数", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.7", "source_hash": "94fbc570e9870b1cf1a594a84337e5bd4e171490b8492107204670236d7a1847", "section_path": ["函数"], "commit_groups": [["81c5e46c4"]], "identity_text": "Add support for 64-bit non-cryptographic hash functions (Robert Haas, Amul Sul)", "commit_aliases": ["81c5e46c4"], "source_commits": ["81c5e46c4"], "source_entry_id": "11.0/changes/080", "db_id": "ff64ebfcf14bf447f2efd05d00561849", "patch_ids": ["17130222dbd63f36c1476c5e317600f0"], "statement_hash": "f4a02ff76aa1c37c206f293d495a68200e5e504efec5553e76d0fe8517b56598", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-2389b115d28e1b12", "cves": [], "html": "允许 to_char() 和 to_timestamp() 以小时和分钟指定时区相对于 UTC 的偏移量（Nikita Glukhov，Andrew Dunstan）
这通过格式指定符 TZH 和 TZM 完成。
添加文本检索函数 websearch_to_tsquery()，支持类似网页搜索引擎所用的查询语法（Victor Drobny，Dmitry Ivanov）
添加函数 json(b)_to_tsvector()，以创建用于匹配 JSON/JSONB 值的文本检索查询（Dmitry Dolgov）
添加 SQL 级过程，使其能够开始并提交自己的事务（Peter Eisentraut）
\n它们使用新的 CREATE PROCEDURE 命令创建，并通过 CALL 调用。
新的 ALTER/DROP ROUTINE 命令允许更改/删除所有例程类对象，包括过程、函数和聚合。
另外，在 CREATE OPERATOR 和 CREATE TRIGGER 中，现在推荐使用 FUNCTION 而非 PROCEDURE，因为所引用的对象必须是函数，而不能是过程。不过，为保持兼容，仍然接受旧语法。
为 PL/pgSQL、PL/Perl、PL/Python、PL/Tcl 和 SPI 服务器端语言添加事务控制（Peter Eisentraut）
\n事务控制仅可用于事务顶层的过程，以及嵌套的 DO 和 CALL 块；嵌套层次中只能包含其他 DO 和 CALL 块。
添加将 PL/pgSQL 复合类型变量定义为非空、常量或带初始值的能力（Tom Lane）
", "text": "添加将 PL/pgSQL 复合类型变量定义为非空、常量或带初始值的能力（Tom Lane）", "title": "添加将 PL/pgSQL 复合类型变量定义为非空、常量或带初始值的能力", "commits": [], "section": "服务器端语言", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.8", "source_hash": "7d6e07950b825c413df025174cf8ad1ef5fe17de427c46d3b360c861dae2cd46", "section_path": ["服务器端语言"], "commit_groups": [["f9263006d"]], "identity_text": "Add the ability to define PL/pgSQL composite-type variables as not null, constant, or with initial values (Tom Lane)", "commit_aliases": ["f9263006d"], "source_commits": ["f9263006d"], "source_entry_id": "11.0/changes/086", "db_id": "c743e55abd548e5d1814e204dce1bc90", "patch_ids": ["31928413ec8367c76704d16ecb2a7838"], "statement_hash": "f569e276f072fd72bfd4c385f16b2b3b0c879bdb169c0178b712440ac058f95b", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-9dbe6c91d3f62157", "cves": [], "html": "允许 PL/pgSQL 处理同一会话中首次和后续函数执行之间发生的复合类型（如 record、row）变更（Tom Lane）
\n以前，这类情况会产生错误。
", "text": "允许 PL/pgSQL 处理同一会话中首次和后续函数执行之间发生的复合类型（如 record、row）变更（Tom Lane） 以前，这类情况会产生错误。", "title": "允许 PL/pgSQL 处理同一会话中首次和后续函数执行之间发生的复合类型（如 record、row）变更", "commits": [], "section": "服务器端语言", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.8", "source_hash": "d68a6fec0c4f6c3eb768986d19d0f50095977c3bca932c38aa38bb0786da69ab", "section_path": ["服务器端语言"], "commit_groups": [["4b93f5799"]], "identity_text": "Allow PL/pgSQL to handle changes to composite types (e.g., record, row) that happen between the first and later function executions in the same session (Tom Lane) Previously, such circumstances generated errors.", "commit_aliases": ["4b93f5799"], "source_commits": ["4b93f5799"], "source_entry_id": "11.0/changes/087", "db_id": "a3362f67b1e652e63b477f8810eafbf7", "patch_ids": ["f114eab24a7e02f5cca2a84c5e3329c7"], "statement_hash": "d1994def39aae02afe1cce17c5c008d2559df4c0a092189349a94ebbed7ea19d", "relations": [{"rule": 2, "type": "related", "target": "3a10a968211dd2f57e469ce081a0fb6d", "evidence": {"same_day": true, "patch_ids": ["f114eab24a7e02f5cca2a84c5e3329c7"]}}], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "3a10a968211dd2f57e469ce081a0fb6d", "kind": "related", "version": "11.0", "label": "11.0", "title": "在 PL/pgSQL 触发器函数中，未赋值的 OLD 和 NEW 变量现在读取为 NULL", "evidence": {"same_day": true, "patch_ids": ["f114eab24a7e02f5cca2a84c5e3329c7"]}, "url": "/docs/compare/?release=11.0#11.0-ff3eda9ae3792bf5", "source_url": "/docs/release/11.0/#id-1.11.6.27.4"}]}, {"id": "11.0-5942580edbb4a235", "cves": [], "html": "添加扩展 jsonb_plpython，以在 JSONB 和 PL/Python 类型之间进行转换（Anthony Bykov）
添加扩展 jsonb_plperl，以在 JSONB 和 PL/Perl 类型之间进行转换（Anthony Bykov）
更改 libpq，使其默认禁用压缩（Peter Eisentraut）
\n现代 OpenSSL 版本已禁用压缩，因此 libpq 的这一设置对这些库并无影响。
", "text": "更改 libpq，使其默认禁用压缩（Peter Eisentraut） 现代 OpenSSL 版本已禁用压缩，因此 libpq 的这一设置对这些库并无影响。", "title": "更改 libpq，使其默认禁用压缩", "commits": [], "section": "客户端接口", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.9", "source_hash": "8b7c8ea31266553c661c13e94dfdecc01941f01e1058cf911aa06ffc09d27b64", "section_path": ["客户端接口"], "commit_groups": [["e3bdb2d92"]], "identity_text": "Change libpq to disable compression by default (Peter Eisentraut) Compression is already disabled in modern OpenSSL versions, so that the libpq setting had no effect with such libraries.", "commit_aliases": ["e3bdb2d92"], "source_commits": ["e3bdb2d92"], "source_entry_id": "11.0/changes/090", "db_id": "ab14123142f2413561276971f9d15d31", "patch_ids": ["2e176b4eccc0a54ea0d5a691b357de75"], "statement_hash": "46b18ff8d5a860ece3b7f81b89c2a17c7dbb59fd5531759c5e1454095ce4483c", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-95efd4a0da7cd5d0", "cves": [], "html": "为 ecpg 的 WHENEVER 语句添加 DO CONTINUE 选项（Vinayak Pokale）
这会生成 C continue 语句，在指定条件发生时返回所在循环的顶部。
添加 ecpg 模式，以启用 Oracle Pro*C 风格的字符数组处理。
\n此模式通过 -C 启用。
添加 psql 命令 \\gdesc，以显示查询结果中各列的名称和类型（Pavel Stehule）
添加 psql 变量，以报告查询活动和错误（Fabien Coelho）
\n具体新增变量为 ERROR、SQLSTATE、ROW_COUNT、LAST_ERROR_MESSAGE 和 LAST_ERROR_SQLSTATE。
允许 psql 测试变量是否存在（Fabien Coelho）
\n具体而言，语法 :{?variable_name} 允许在 \\if 语句中测试变量是否存在。
允许环境变量 PSQL_PAGER 控制 psql 的分页器（Pavel Stehule）
这允许用独立的环境变量指定 psql 的默认分页器，将其与其他应用的分页器设置分开。如果未设置 PSQL_PAGER，仍会遵循 PAGER。
使 psql 的 \\d+ 命令始终显示表的分区信息（Amit Langote，Ashutosh Bapat）
以前，如果分区表没有分区，就不会显示其分区信息。现在还会指出哪些分区本身也是分区表。
", "text": "使 psql 的 \\d+ 命令始终显示表的分区信息（Amit Langote，Ashutosh Bapat） 以前，如果分区表没有分区，就不会显示其分区信息。现在还会指出哪些分区本身也是分区表。", "title": "使 psql 的 \\d+ 命令始终显示表的分区信息", "commits": [], "section": "客户端应用程序 / psql", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.10.2", "source_hash": "ec6eced2b9ee5c76f4be7245d0cfe270d47bdca45bf074a6e4da386f47b97493", "section_path": ["客户端应用程序", "psql"], "commit_groups": [["05b6ec39d"]], "identity_text": "Make psql's \\d+ command always show the table's partitioning information (Amit Langote, Ashutosh Bapat) Previously, partition information would not be displayed for a partitioned table if it had no partitions. Also indicate which partitions are themselves partitioned.", "commit_aliases": ["05b6ec39d"], "source_commits": ["05b6ec39d"], "source_entry_id": "11.0/changes/097", "db_id": "ddd8a240f034d09cb69e0c7072aabf9d", "patch_ids": ["d7e1c099800b2ba39c455082c9700779"], "statement_hash": "beec64e9ac1cbe7cc263e9e6c9f7b8ff3d9cb011f8099794589c2264749321c3", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-19e85f37615ab10b", "cves": [], "html": "确保 psql 在提示输入密码时显示正确的用户名（Tom Lane）
\n以前，同时使用 -U 和嵌入 URI 的用户名会导致显示错误的用户名。另外，在指定 --password 时，不再在密码提示前显示用户名。
在此前没有输入的情况下，允许 quit 和 exit 退出 psql（Bruce Momjian）
当输入缓冲区非空，而 quit 和 exit 单独出现在一行时，也会输出如何退出的提示。为 help 添加类似提示。
当 \\q 单独输入在一行上却被忽略时，让 psql 提示使用 control-D（Bruce Momjian）
例如，在字符串内输入 \\q 不会退出。
改进 ALTER INDEX RESET/SET 的 Tab 补全（Masahiko Sawada）
添加基础支持，使 psql 能够根据服务器版本调整 Tab 补全查询（Tom Lane）
\n以前，对旧版服务器执行 Tab 补全查询可能失败。
", "text": "添加基础支持，使 psql 能够根据服务器版本调整 Tab 补全查询（Tom Lane） 以前，对旧版服务器执行 Tab 补全查询可能失败。", "title": "添加基础支持，使 psql 能够根据服务器版本调整 Tab 补全查询", "commits": [], "section": "客户端应用程序 / psql", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.10.2", "source_hash": "a5798e3ff9afccea76b5c3acb305a938d58bdd611887aba4a371db458e38d6c4", "section_path": ["客户端应用程序", "psql"], "commit_groups": [["722408bcd"]], "identity_text": "Add infrastructure to allow psql to adapt its tab completion queries based on the server version (Tom Lane) Previously, tab completion queries could fail against older servers.", "commit_aliases": ["722408bcd"], "source_commits": ["722408bcd"], "source_entry_id": "11.0/changes/102", "db_id": "d73cc3fa3a9277b3b73a041107e70106", "patch_ids": ["0c3d876ea5142ca54846b4b4a10f23ff"], "statement_hash": "042ce4291bd63660fa7896b9744350dc4341129d4181716ab348e8766d3bca18", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-e34e6672b68952cc", "cves": [], "html": "为 pgbench 表达式添加对 NULL、布尔值以及某些函数和操作符的支持（Fabien Coelho）
", "text": "为 pgbench 表达式添加对 NULL、布尔值以及某些函数和操作符的支持（Fabien Coelho）", "title": "为 pgbench 表达式添加对 NULL、布尔值以及某些函数和操作符的支持", "commits": [], "section": "客户端应用程序 / pgbench", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.10.3", "source_hash": "41ba284f3f76d243280aaff9f0084c2972b4e53266ec1d405d93f6b1017a41ce", "section_path": ["客户端应用程序", "pgbench"], "commit_groups": [["bc7fa0c15"]], "identity_text": "Add pgbench expression support for NULLs, booleans, and some functions and operators (Fabien Coelho)", "commit_aliases": ["bc7fa0c15"], "source_commits": ["bc7fa0c15"], "source_entry_id": "11.0/changes/103", "db_id": "cfa65d518b36a213a88cc8f92b88f355", "patch_ids": ["f678764112d3f53e34e26137a4d40018"], "statement_hash": "e9a92c818aaf876c88bf006316c026821bccac67a2faf9b13b9b078d73c0678d", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-f162b7f7f9215d6f", "cves": [], "html": "为 pgbench 添加 \\if 条件支持（Fabien Coelho）
允许在 pgbench 变量名中使用非 ASCII 字符（Fabien Coelho）
", "text": "允许在 pgbench 变量名中使用非 ASCII 字符（Fabien Coelho）", "title": "允许在 pgbench 变量名中使用非 ASCII 字符", "commits": [], "section": "客户端应用程序 / pgbench", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.10.3", "source_hash": "69a59e5fa35a7d954e181bc8e55aea4f46bbc8c43e0864c97c70de554a2aa59e", "section_path": ["客户端应用程序", "pgbench"], "commit_groups": [["9d36a3866"]], "identity_text": "Allow the use of non-ASCII characters in pgbench variable names (Fabien Coelho)", "commit_aliases": ["9d36a3866"], "source_commits": ["9d36a3866"], "source_entry_id": "11.0/changes/105", "db_id": "bb0f6df209355898befb0a1ecd000bd6", "patch_ids": ["0881ff570e19830837c6e7e8bf5df1b4"], "statement_hash": "50562993e22d16dd1d6f31b4cfb5b47023b6097d02d249e21e0ea1ba07ee9cb2", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-429fe142f3879a71", "cves": [], "html": "添加 pgbench 选项 --init-steps，以控制执行哪些初始化步骤（Masahiko Sawada）
为 pgbench 添加近似服从 Zipf 分布的随机数生成器（Alik Khilazhev）
", "text": "为 pgbench 添加近似服从 Zipf 分布的随机数生成器（Alik Khilazhev）", "title": "为 pgbench 添加近似服从 Zipf 分布的随机数生成器", "commits": [], "section": "客户端应用程序 / pgbench", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.10.3", "source_hash": "87e8768e86e3ceb136565edb6b1c07b808e27e1100eb8e29d99f2c0dd232c666", "section_path": ["客户端应用程序", "pgbench"], "commit_groups": [["1fcd0adeb"]], "identity_text": "Add an approximately Zipfian-distributed random generator to pgbench (Alik Khilazhev)", "commit_aliases": ["1fcd0adeb"], "source_commits": ["1fcd0adeb"], "source_entry_id": "11.0/changes/107", "db_id": "c576e674c678e17e35cbec7c1dc0f5f8", "patch_ids": ["50df856d2fb3e7fd21aef2f17d02e136"], "statement_hash": "d5f7f2deddb1d83f5349378c3fd2a0618546941cad634081203daecf24d3e445", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-c23b9d3f534d0a63", "cves": [], "html": "允许在 pgbench 中设置随机种子（Fabien Coelho）
", "text": "允许在 pgbench 中设置随机种子（Fabien Coelho）", "title": "允许在 pgbench 中设置随机种子", "commits": [], "section": "客户端应用程序 / pgbench", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.10.3", "source_hash": "57035472ff139c6e6578c2bc3e854b63185504a958c9407218e5d85498b45257", "section_path": ["客户端应用程序", "pgbench"], "commit_groups": [["64f85894a"]], "identity_text": "Allow the random seed to be set in pgbench (Fabien Coelho)", "commit_aliases": ["64f85894a"], "source_commits": ["64f85894a"], "source_entry_id": "11.0/changes/108", "db_id": "45271260a2db818e3a5fbd5e4fc61371", "patch_ids": ["03d4f513f7fe8d96e42426d3c6e9fc36"], "statement_hash": "043567b7ed20da4e08f7a4c36a62cf0875c0a88984611d1a23616a35a0428e86", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-760f2ff680330972", "cves": [], "html": "允许 pgbench 使用 pow() 和 power() 执行幂运算（Raúl Marín Rodríguez）
为 pgbench 添加 hash 函数（Ildar Musin）
", "text": "为 pgbench 添加 hash 函数（Ildar Musin）", "title": "为 pgbench 添加 hash 函数", "commits": [], "section": "客户端应用程序 / pgbench", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.10.3", "source_hash": "3785f7ae7a1b86ce8eb9c5c8c842d1b16f304e26a3cbac05d80b8faf0722ce75", "section_path": ["客户端应用程序", "pgbench"], "commit_groups": [["e51a04840"]], "identity_text": "Add hashing functions to pgbench (Ildar Musin)", "commit_aliases": ["e51a04840"], "source_commits": ["e51a04840"], "source_entry_id": "11.0/changes/110", "db_id": "c620d215e9b3e2dc3c7876f99e5e8b97", "patch_ids": ["a431cd372e5bebd56707bc7d847928ea"], "statement_hash": "dcfad91620e5e826d5d4d3613a1e958a6a189ec1230900af619eb97b3daac6af", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-4cfd5aadf6132f23", "cves": [], "html": "提高使用 --latency-limit 和 --rate 时 pgbench 统计信息的准确性（Fabien Coelho）
为pg_basebackup添加创建命名复制槽的选项（Michael Banck）
\n使用 WAL 流式方法（--wal-method=stream）时，--create-slot 选项会创建指定名称的复制槽（--slot）。
允许initdb为数据目录设置组读取权限（David Steele）
\n这通过新的 initdb 选项 --allow-group-access 完成。管理员也可以在运行 initdb 之前，为空数据目录设置组权限。服务器变量 data_directory_mode 允许读取数据目录的组权限。
添加pg_verify_checksums工具，以在离线状态下验证数据库校验和（Magnus Hagander）
", "text": "添加pg_verify_checksums工具，以在离线状态下验证数据库校验和（Magnus Hagander）", "title": "添加pg_verify_checksums工具，以在离线状态下验证数据库校验和", "commits": [], "section": "服务器应用程序", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.11", "source_hash": "95dd64ab542cfee27d56fbc8ff75696901a456bcd3ce7bf956e297aaa2f9a226", "section_path": ["服务器应用程序"], "commit_groups": [["1fde38bea"], ["a228cc13a"]], "identity_text": "Add pg_verify_checksums tool to verify database checksums while offline (Magnus Hagander)", "commit_aliases": ["1fde38bea", "a228cc13a"], "source_commits": ["1fde38bea", "a228cc13a"], "source_entry_id": "11.0/changes/114", "db_id": "7bc800b6ddf2404a8af49dadcb85f760", "patch_ids": ["493c868c123954ae362bb49b0c6af372", "6a2ad58e29e69d02b6a5334d5b22bce5"], "statement_hash": "cd09e84a3fe2abc536d67cdb5b0c937939f7d74bde53bd33adaf58b1e5d93ad9", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-107327c053dabe6f", "cves": [], "html": "允许pg_resetwal通过 --wal-segsize 更改 WAL 段大小（Nathan Bossart）
为 pg_resetwal 和 pg_controldata 添加长选项（Nathan Bossart，Peter Eisentraut）
", "text": "为 pg_resetwal 和 pg_controldata 添加长选项（Nathan Bossart，Peter Eisentraut）", "title": "为 pg_resetwal 和 pg_controldata 添加长选项", "commits": [], "section": "服务器应用程序", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.11", "source_hash": "47cda5e08b88dd2bc9511855ef02d7bcde1b58c9f1f09946fdaf93ad7864530c", "section_path": ["服务器应用程序"], "commit_groups": [["e22b27f0c"]], "identity_text": "Add long options to pg_resetwal and pg_controldata (Nathan Bossart, Peter Eisentraut)", "commit_aliases": ["e22b27f0c"], "source_commits": ["e22b27f0c"], "source_entry_id": "11.0/changes/116", "db_id": "032dbbc37940357248f8193567e674ab", "patch_ids": ["3ba65b9a6f132e2aa46a0e0982aad992"], "statement_hash": "de6b68ffb2cb31c118a0badc8472afd999544a39c92bb589d14cdf5778c95fd4", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-347d98e4c8d6a2e7", "cves": [], "html": "为pg_receivewal添加 --no-sync 选项，用于测试时禁止同步 WAL 写入（Michael Paquier）
添加 pg_receivewal 选项 --endpos，以指定何时停止接收 WAL（Michael Paquier）
允许pg_ctl向进程发送 SIGKILL 信号（Andres Freund）
以前因担心可能被误用而不支持此功能。
", "text": "允许pg_ctl向进程发送 SIGKILL 信号（Andres Freund） 以前因担心可能被误用而不支持此功能。", "title": "允许pg_ctl向进程发送 SIGKILL 信号", "commits": [], "section": "服务器应用程序", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.11", "source_hash": "14a7befffcafd97427bf9194ae669ea045e11739b6ebc814a39daec13e44509a", "section_path": ["服务器应用程序"], "commit_groups": [["2e83db3ad"]], "identity_text": "Allow pg_ctl to send the SIGKILL signal to processes (Andres Freund) This was previously unsupported due to concerns over possible misuse.", "commit_aliases": ["2e83db3ad"], "source_commits": ["2e83db3ad"], "source_entry_id": "11.0/changes/119", "db_id": "879b7bfac469d8b0819e2423c3427698", "patch_ids": ["7b5cc9dcbb869008d2f5042b03e1a1c4"], "statement_hash": "d613ec4710d919dd19c1d1ec90c05467cf23acaead0071c04777f9f72b306284", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-9223e70b2770d60b", "cves": [], "html": "减少pg_rewind复制的文件数量（Michael Paquier）
", "text": "减少pg_rewind复制的文件数量（Michael Paquier）", "title": "减少pg_rewind复制的文件数量", "commits": [], "section": "服务器应用程序", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.11", "source_hash": "c68a4a15563a4d0424f0c3cdd10549b95c9ae64a68afa2d18c26c67516727d16", "section_path": ["服务器应用程序"], "commit_groups": [["266b6acb3"]], "identity_text": "Reduce the number of files copied by pg_rewind (Michael Paquier)", "commit_aliases": ["266b6acb3"], "source_commits": ["266b6acb3"], "source_entry_id": "11.0/changes/120", "db_id": "494a3012f8ad23efa3c627cf39818950", "patch_ids": ["f41bfcea710b81a51151e05ecea904d1"], "statement_hash": "a552fbbfdc9cbed77f552bf61232ee99de360c4223c7f99ce0913243d4ae0399", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-d50375570e81e04d", "cves": [], "html": "禁止以 root 身份运行 pg_rewind（Michael Paquier）
添加 pg_dumpall 选项 --encoding，以控制输出编码（Michael Paquier）
pg_dump 已有此选项。
", "text": "添加 pg_dumpall 选项 --encoding，以控制输出编码（Michael Paquier） pg_dump 已有此选项。", "title": "添加 pg_dumpall 选项 --encoding，以控制输出编码", "commits": [], "section": "服务器应用程序 / pg_dump, pg_dumpall, pg_restore", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.11.3", "source_hash": "7607d71661db12b412d17a4b449175f5dc834359c21292fb11712e46e96e6ac5", "section_path": ["服务器应用程序", "pg_dump, pg_dumpall, pg_restore"], "commit_groups": [["84be67181"]], "identity_text": "Add pg_dumpall option --encoding to control output encoding (Michael Paquier) pg_dump already had this option.", "commit_aliases": ["84be67181"], "source_commits": ["84be67181"], "source_entry_id": "11.0/changes/122", "db_id": "8a3be6dda64a9c63bbd5d83e04c4fb42", "patch_ids": ["ec4ecedd6ae3ad1a5657e30c466497ca"], "statement_hash": "a1b1a073366d289d12eac1c0b2e44e48415911558a9ee262668621c17f58aad8", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-1159e95875b2f787", "cves": [], "html": "添加 pg_dump 选项 --load-via-partition-root，强制将数据加载到分区的根表，而非原分区（Rushabh Lathia）
当加载目标系统具有不同的排序规则定义或字节序，可能需要将行存储到与以前不同的分区时，此选项很有用。
", "text": "添加 pg_dump 选项 --load-via-partition-root，强制将数据加载到分区的根表，而非原分区（Rushabh Lathia） 当加载目标系统具有不同的排序规则定义或字节序，可能需要将行存储到与以前不同的分区时，此选项很有用。", "title": "添加 pg_dump 选项 --load-via-partition-root，强制将数据加载到分区的根表，而非原分区", "commits": [], "section": "服务器应用程序 / pg_dump, pg_dumpall, pg_restore", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.11.3", "source_hash": "1362f6a9caf76fbf03f21925047fabe3723535e7f8fb06d5e2a6992b0ed2a41b", "section_path": ["服务器应用程序", "pg_dump, pg_dumpall, pg_restore"], "commit_groups": [["23d7680d0"]], "identity_text": "Add pg_dump option --load-via-partition-root to force loading of data into the partition's root table, rather than the original partition (Rushabh Lathia) This is useful if the system to be loaded to has different collation definitions or endianness, possibly requiring rows to be stored in different partitions than previously.", "commit_aliases": ["23d7680d0"], "source_commits": ["23d7680d0"], "source_entry_id": "11.0/changes/123", "db_id": "d8ce247aa432f1b8c31b6582bd5d701f", "patch_ids": ["361ec601363ea8647143e2bc114d4d6b"], "statement_hash": "56de5be176992f656fdaa53f7c753cc20cc5d621a1be24dafc607cbfe19fc0aa", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-8d176c84a545004d", "cves": [], "html": "添加禁止转储和恢复数据库对象注释的选项（Robins Tharakan）
\npg_dump、pg_dumpall 和 pg_restore 的新选项为 --no-comments。
为 PGXS 添加安装包含文件的支持（Andrew Gierth）
\n这支持创建依赖其他模块的扩展模块。以前，依赖模块没有简单的方法找到被引用模块的包含文件。若干定义了数据类型的现有 contrib 模块已作调整，以安装相关文件。此外，PL/Perl 和 PL/Python 现在也会安装其包含文件，以支持创建这些语言的转换模块。
安装 errcodes.txt，使扩展可以访问 PostgreSQL 已知的错误码列表（Thomas Munro）
将文档转换为 DocBook XML（Peter Eisentraut，Alexander Lakhin，Jürgen Purtz）
\n为与旧分支保持兼容，文件名仍使用 sgml 扩展名。
在适用的平台（即大多数平台）上，使用 stdbool.h 定义 bool 类型（Peter Eisentraut）
这消除了需要包含 stdbool.h 的扩展模块的一项编码隐患。
全面调整初始系统目录内容的定义方式（John Naylor）
\n初始数据现在用 Perl 数据结构表示，更便于机械化处理。
", "text": "全面调整初始系统目录内容的定义方式（John Naylor） 初始数据现在用 Perl 数据结构表示，更便于机械化处理。", "title": "全面调整初始系统目录内容的定义方式", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "89f375702b2376b0f696d72accb1485a6f529ac8f1a8b341daacbec7f2a1b867", "section_path": ["源代码"], "commit_groups": [["372728b0d"], ["5372c2c84"], ["55d26ff63"], ["9ffcccdb9"], ["a0854f107"], ["a351679c8"], ["d160882a1"], ["e90d4ddc6"]], "identity_text": "Overhaul the way that initial system catalog contents are defined (John Naylor) The initial data is now represented in Perl data structures, making it much easier to manipulate mechanically.", "commit_aliases": ["372728b0d", "5372c2c84", "55d26ff63", "9ffcccdb9", "a0854f107", "a351679c8", "d160882a1", "e90d4ddc6"], "source_commits": ["372728b0d", "5372c2c84", "55d26ff63", "9ffcccdb9", "a0854f107", "a351679c8", "d160882a1", "e90d4ddc6"], "source_entry_id": "11.0/changes/129", "db_id": "9773a2e3c16865a72cb89ce092d8f44b", "patch_ids": ["0a91fd7eea2bd9374829ba515dab3df0", "146bbe432469b2f8ab4b7b02eedcbe34", "2c15844dbb1f273678cdab191d7db6e8", "3f82aa50c53f911b5d1416fde037ec66", "643e802bb5429fae3bb9303b40c40b93", "720f9c40048efc8c8792b46269335825", "76eaa97376cc029d87cb57484e76f241", "bb35965bdb73e5dba9d3b451e5d4c8c4"], "statement_hash": "9baebafd01c5089c96fbb52e76f777150531e692f67e1bb1661d1d12b65166fe", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-1e4a2520a235d5ed", "cves": [], "html": "禁止扩展创建接受带引号值列表的自定义服务器参数（Tom Lane）
\n目前无法支持这种功能，因为在加载扩展之前就必须知道该参数的这一属性。
", "text": "禁止扩展创建接受带引号值列表的自定义服务器参数（Tom Lane） 目前无法支持这种功能，因为在加载扩展之前就必须知道该参数的这一属性。", "title": "禁止扩展创建接受带引号值列表的自定义服务器参数", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "3102df18fa840331516ae64a75e8dc100b0068e8fcb1aa385c497b9fe23b7e3d", "section_path": ["源代码"], "commit_groups": [["846b5a525"]], "identity_text": "Prevent extensions from creating custom server parameters that take a quoted list of values (Tom Lane) This cannot be supported at present because knowledge of the parameter's property would be required even before the extension is loaded.", "commit_aliases": ["846b5a525"], "source_commits": ["846b5a525"], "source_entry_id": "11.0/changes/130", "db_id": "fa1933de3caaacef029869867e384235", "patch_ids": ["b2dfa83744fece20365ea5ce10500696"], "statement_hash": "de435aafd451f97414aa74df6755ec1a997a9c3b17bf6b70c7c4ca0a76a98e89", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-cce6409f88b40e7a", "cves": [], "html": "增加在使用SCRAM认证时使用通道绑定的能力（Michael Paquier）
\n通道绑定旨在防止中间人攻击，但除非能够强制启用通道绑定，否则 SCRAM 无法防止此类攻击。遗憾的是，libpq 中没有办法做到这一点。预计未来版本的 libpq，以及不基于 libpq 构建的接口（例如 JDBC）将支持此功能。
", "text": "增加在使用SCRAM认证时使用通道绑定的能力（Michael Paquier） 通道绑定旨在防止中间人攻击，但除非能够强制启用通道绑定，否则 SCRAM 无法防止此类攻击。遗憾的是，libpq 中没有办法做到这一点。预计未来版本的 libpq，以及不基于 libpq 构建的接口（例如 JDBC）将支持此功能。", "title": "增加在使用SCRAM认证时使用通道绑定的能力", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "e9900e57e2ba7a3c7a5cf2db99ecd37d06b9c93d70d24ccb2c564c8ff678fb24", "section_path": ["源代码"], "commit_groups": [["4bbf110d2"], ["9288d62bb"], ["d3fb72ea6"]], "identity_text": "Add ability to use channel binding when using SCRAM authentication (Michael Paquier) Channel binding is intended to prevent man-in-the-middle attacks, but SCRAM cannot prevent them unless it can be forced to be active. Unfortunately, there is no way to do that in libpq. Support for it is expected in future versions of libpq and in interfaces not built using libpq, e.g., JDBC.", "commit_aliases": ["4bbf110d2", "9288d62bb", "d3fb72ea6"], "source_commits": ["4bbf110d2", "9288d62bb", "d3fb72ea6"], "source_entry_id": "11.0/changes/131", "db_id": "bff2bbba65a3a78f20ded5b40ad97bcd", "patch_ids": ["58bcf4280be6f33e7af5b0fce5beae4c", "a5a66f394978747f567c44c5f56aee33", "f3f9ce78e54a2f22b140ce58321e5a30"], "statement_hash": "4ac7731ba95956c7ff0cba8389b5a9a073dde6f1c14af05a0d5c47b3b54538f1", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-f90ee171e8da7552", "cves": [], "html": "允许后台工作进程连接到通常不允许连接的数据库（Magnus Hagander）
", "text": "允许后台工作进程连接到通常不允许连接的数据库（Magnus Hagander）", "title": "允许后台工作进程连接到通常不允许连接的数据库", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "9c45d8fcc278a3c7b0a0f4ef4b33b3adeb678a0016f2368bc1e5e001c8d53d6a", "section_path": ["源代码"], "commit_groups": [["eed1ce72e"]], "identity_text": "Allow background workers to attach to databases that normally disallow connections (Magnus Hagander)", "commit_aliases": ["eed1ce72e"], "source_commits": ["eed1ce72e"], "source_entry_id": "11.0/changes/132", "db_id": "bf4de24dee6e29eead99c6ef51fb51d4", "patch_ids": ["af425665c70b422de85126d33ad9ca7c"], "statement_hash": "b42172728d8c7ea936188af9479aaa827a39f49d295dd0d7c8bfa5e3cd08ab62", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-36580fc2da065a0b", "cves": [], "html": "添加对 ARMv8 上硬件 CRC 计算的支持（Yuqi Gu，Heikki Linnakangas，Thomas Munro）
", "text": "添加对 ARMv8 上硬件 CRC 计算的支持（Yuqi Gu，Heikki Linnakangas，Thomas Munro）", "title": "添加对 ARMv8 上硬件 CRC 计算的支持", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "9bb529820c80e4bad118d25ca812ada7ed0a23196ab2ebd89da8db11da75dc3a", "section_path": ["源代码"], "commit_groups": [["f044d71e3"]], "identity_text": "Add support for hardware CRC calculations on ARMv8 (Yuqi Gu, Heikki Linnakangas, Thomas Munro)", "commit_aliases": ["f044d71e3"], "source_commits": ["f044d71e3"], "source_entry_id": "11.0/changes/133", "db_id": "cb36577d1888cc82e055d4a9a2b50b79", "patch_ids": ["647b77da2e2ae79ae08a85d5bd1918fb"], "statement_hash": "230ddd1801f8486e3fd8f84599fff320addedacf003bc6d2a71c5487e6ca4dc2", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-09c3f074623ac070", "cves": [], "html": "加快按 OID 查找内置函数的速度（Andres Freund）
\n以前的二分查找已被查找数组取代。
", "text": "加快按 OID 查找内置函数的速度（Andres Freund） 以前的二分查找已被查找数组取代。", "title": "加快按 OID 查找内置函数的速度", "commits": [], "section": "源代码", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "1ddf635d514b9be1402b8b86e931de9f5a1834ea84fa21c3bdd5f405d2b7a8d2", "section_path": ["源代码"], "commit_groups": [["212e6f34d"]], "identity_text": "Speed up lookups of built-in functions by OID (Andres Freund) The previous binary search has been replaced by a lookup array.", "commit_aliases": ["212e6f34d"], "source_commits": ["212e6f34d"], "source_entry_id": "11.0/changes/134", "db_id": "94ec7e396f8dc999a09f697106c28df6", "patch_ids": ["e6e8c82618c377c8f870b965f7a9e7a5"], "statement_hash": "1b7371d563061a55030a2bdb6f00f1faa018c57f58fbb791e35a278258165c61", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-27ff29dcb88bd240", "cves": [], "html": "加快查询结果的构建速度（Andres Freund）
", "text": "加快查询结果的构建速度（Andres Freund）", "title": "加快查询结果的构建速度", "commits": [], "section": "源代码", "category": "performance", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "009117c5661b9c55dcb3714916c9cb0bf52478dd7c7c3da93f8f069a5ee96b51", "section_path": ["源代码"], "commit_groups": [["1de09ad8e"]], "identity_text": "Speed up construction of query results (Andres Freund)", "commit_aliases": ["1de09ad8e"], "source_commits": ["1de09ad8e"], "source_entry_id": "11.0/changes/135", "db_id": "34053cc0896d4a9669457a67246f6e7e", "patch_ids": ["85f4e76a59e9c383cf86e2c7ccbafb4c"], "statement_hash": "1baaa4a1dd11964bc069e855ebcfd74456e27d8f3ca4dbddd461277708fae3e8", "relations": [], "version": "11.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-2d2984315b63ebeb", "cves": [], "html": "提高系统缓存访问速度（Andres Freund）
", "text": "提高系统缓存访问速度（Andres Freund）", "title": "提高系统缓存访问速度", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "289e094cea74c24c298cf2c4e9a027dbf564b60c7ef76597ec4c18e422b11b65", "section_path": ["源代码"], "commit_groups": [["141fd1b66"]], "identity_text": "Improve speed of access to system caches (Andres Freund)", "commit_aliases": ["141fd1b66"], "source_commits": ["141fd1b66"], "source_entry_id": "11.0/changes/136", "db_id": "530d1c150e18d66aee7af6b58cb4df9e", "patch_ids": ["29d10df3d54f86172861e68229213df5"], "statement_hash": "8b5ecdae4df4f12173450f136078ad967e4e1748ec9ea630c615bf56d915cb80", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-b88a510b264075ad", "cves": [], "html": "添加针对顺序分配/释放优化的分代内存分配器（Tomas Vondra）
\n这减少了逻辑解码的内存用量。
", "text": "添加针对顺序分配/释放优化的分代内存分配器（Tomas Vondra） 这减少了逻辑解码的内存用量。", "title": "添加针对顺序分配/释放优化的分代内存分配器", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.12", "source_hash": "c14a53537d0af6cde8a251efb074496e1ebb45d22585e58639f74e6b465f3c04", "section_path": ["源代码"], "commit_groups": [["a4ccc1cef"]], "identity_text": "Add a generational memory allocator which is optimized for serial allocation/deallocation (Tomas Vondra) This reduces memory usage for logical decoding.", "commit_aliases": ["a4ccc1cef"], "source_commits": ["a4ccc1cef"], "source_entry_id": "11.0/changes/137", "db_id": "9847caa26fee78f3b0a69dfc70e9bf63", "patch_ids": ["434d2d499e2bf454df5e0609073c2a1a"], "statement_hash": "789d55f1fe16c0d086a0320adbbe348ebf397aafbeb1cc1b2b5c2020d38060b9", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-f9a5db0f36872eac", "cves": [], "html": "使 VACUUM 对 pg_class.reltuples 的计算与 ANALYZE 一致（Tomas Vondra）
更新为使用 perltidy 20170521 版（Tom Lane，Peter Eisentraut）
允许扩展 pg_prewarm 在启动时恢复先前的共享缓冲区内容（Mithun Cy，Robert Haas）
实现方式是让 pg_prewarm 在服务器运行期间不时地、并在关闭时，将共享缓冲区的关系和块号数据存储到磁盘。
添加 pg_trgm 函数 strict_word_similarity()，以计算完整单词的相似度（Alexander Korotkov）
已有的 word_similarity() 函数也用于此目的，但它的设计是寻找单词中相似的部分，而 strict_word_similarity() 计算的是与完整单词的相似度。
允许 btree_gin 对 bool、bpchar、name 和 uuid 数据类型建立索引（Matheus Oliveira）
允许 cube 和 seg 扩展使用 GiST 索引执行仅索引扫描（Andrey Borodin）
允许使用 ~> 操作符获取 cube 坐标的负值（Alexander Korotkov）
这对按降序查找坐标的 KNN-GiST 搜索很有用。
", "text": "允许使用 ~> 操作符获取 cube 坐标的负值（Alexander Korotkov） 这对按降序查找坐标的 KNN-GiST 搜索很有用。", "title": "允许使用 ~> 操作符获取 cube 坐标的负值", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.13", "source_hash": "3842508fe0dd5e6a829f4322a069c633f89a1b53f6dea2ab8b1cb00928da2118", "section_path": ["附加模块"], "commit_groups": [["f50c80dbb"]], "identity_text": "Allow retrieval of negative cube coordinates using the ~> operator (Alexander Korotkov) This is useful for KNN-GiST searches when looking for coordinates in descending order.", "commit_aliases": ["f50c80dbb"], "source_commits": ["f50c80dbb"], "source_entry_id": "11.0/changes/144", "db_id": "d0aa28ed8bdd90ef52a67c9ba53903da", "patch_ids": ["9d1210542967d5503d0d492e58a8c8b2"], "statement_hash": "121932e5d04988888fc75d9f792800af88fcf96b2654665d497a2a053f21253d", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-1a53674dba5aba2b", "cves": [], "html": "为 unaccent 扩展添加越南语字母处理（Dang Minh Huong，Michael Paquier）
增强 amcheck，以检查每个堆元组都有对应的索引条目（Peter Geoghegan）
让 adminpack 使用新的默认文件系统访问角色（Stephen Frost）
以前，只有超级用户可以调用 adminpack 函数；现在改为检查角色权限。
将 pg_stat_statement 的查询 ID 扩为 64 位（Robert Haas）
这大幅降低了查询 ID hash 冲突的概率。查询 ID 现在可能显示为负值。
", "text": "将 pg_stat_statement 的查询 ID 扩为 64 位（Robert Haas） 这大幅降低了查询 ID hash 冲突的概率。查询 ID 现在可能显示为负值。", "title": "将 pg_stat_statement 的查询 ID 扩为 64 位", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.13", "source_hash": "9aee8b8a48ba3f9d4de3038864f86551f8c515fe2bfed89017de748d246ed8bc", "section_path": ["附加模块"], "commit_groups": [["cff440d36"]], "identity_text": "Widen pg_stat_statement's query ID to 64 bits (Robert Haas) This greatly reduces the chance of query ID hash collisions. The query ID can now potentially display as a negative value.", "commit_aliases": ["cff440d36"], "source_commits": ["cff440d36"], "source_entry_id": "11.0/changes/148", "db_id": "cfa11fa74eb230e29de71cc99e87ff06", "patch_ids": ["a3899478d8ed23a4dffcb46a113776b9"], "statement_hash": "aae9f267db0da793abb612ab114d96045f9f93bed9b72055f8fb49e00f704363", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.0-804effeee98dd043", "cves": [], "html": "移除已不再推荐使用的 contrib/start-scripts/osx 脚本（改用 contrib/start-scripts/macos）（Tom Lane）
移除 chkpass 扩展（Peter Eisentraut）
此扩展不再被视为可用的安全工具或编写扩展的示例。
", "text": "移除 chkpass 扩展（Peter Eisentraut） 此扩展不再被视为可用的安全工具或编写扩展的示例。", "title": "移除 chkpass 扩展", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/11.0/#id-1.11.6.27.5.13", "source_hash": "95299c9f9c2230254234ec626356d19fb8b136d7039caef28751950196c5d868", "section_path": ["附加模块"], "commit_groups": [["5d3cad564"]], "identity_text": "Remove the chkpass extension (Peter Eisentraut) This extension is no longer considered to be a usable security tool or example of how to write an extension.", "commit_aliases": ["5d3cad564"], "source_commits": ["5d3cad564"], "source_entry_id": "11.0/changes/150", "db_id": "012f7d9145630497084cdbbc91bd1273", "patch_ids": ["553aea83ba19f896ed71e578247646c9"], "statement_hash": "98de147845068f753a2ddc8d6d3457fb327083492cbdc9c4d065e7691423bacf", "relations": [], "version": "11.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}]}], "stats": [{"key": "all", "label": "全部变更", "count": 170}, {"key": "feature", "label": "新功能", "count": 134}, {"key": "bugfix", "label": "BUG 修复", "count": 1}, {"key": "security", "label": "安全相关", "count": 0}, {"key": "performance", "label": "性能改进", "count": 15}, {"key": "compatibility", "label": "兼容性变化", "count": 20}, {"key": "improvement", "label": "其他改进", "count": 0}], "total": 170, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 170, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}