希望从任何之前的版本迁移数据的用户，需要使用pg_dumpall进行转储/恢复，或使用pg_upgrade。
\n版本 9.5 包含许多可能影响与以前版本兼容性的变更。请注意以下不兼容之处：
\n希望从任何之前的版本迁移数据的用户，需要使用pg_dumpall进行转储/恢复，或使用pg_upgrade。
\n版本 9.5 包含许多可能影响与以前版本兼容性的变更。请注意以下不兼容之处：
\n调整操作符优先级以符合 SQL 标准（Tom Lane）
\n<=、>= 和 <> 的优先级已降低到与 <、> 和 = 相同。IS 测试（例如 x IS NULL）的优先级已降低到恰好位于这六个比较操作符之下。此外，以 NOT 开头的多关键字操作符现在具有其基础操作符的优先级（例如 NOT BETWEEN 现在与 BETWEEN 优先级相同），而以前它们的优先级并不一致：对左操作数表现得像 NOT，对右操作数表现得像其基础操作符。新的配置参数operator_precedence_warning可以启用，以就在这些优先级变更导致不同解析选择的查询发出警告。
把pg_ctl的默认关闭模式从 smart 改为 fast（Bruce Momjian）
这意味着默认行为将是强制取消现有的数据库会话，而不是简单地等待它们退出。
", "text": "把pg_ctl的默认关闭模式从 smart 改为 fast（Bruce Momjian） 这意味着默认行为将是强制取消现有的数据库会话，而不是简单地等待它们退出。", "title": "把pg_ctl的默认关闭模式从 smart 改为 fast", "commits": [], "section": "兼容性", "category": "compatibility", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.4", "source_hash": "1e63dd781478d9fbf641859b38c05969d31beed300211a7dd0c9fc716a93d8c2", "section_path": ["兼容性"], "commit_groups": [["0badb06"]], "identity_text": "Change app-pg-ctl 's default shutdown mode from smart to fast (Bruce Momjian) This means the default behavior will be to forcibly cancel existing database sessions, not simply wait for them to exit.", "commit_aliases": ["0badb06"], "source_commits": ["0badb06"], "source_entry_id": "9.5.0/migration/002", "db_id": "f76a6aa690d0c54ecde945f7684765a5", "patch_ids": ["d4c48015af1ecb5f3e967053a45afbb6"], "statement_hash": "046ab2f5e8c63575089f137a3385f83e28d012ad3d490112ce0dee7b221b87cf", "relations": [], "version": "9.5.0", "category_label": "兼容性变化", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-84db91e7afc45d2b", "cves": [], "html": "在 PL/pgSQL 赋值中使用赋值转换行为进行数据类型转换，而不是经由文本往返转换（Tom Lane）
\n此变更使布尔值到字符串的转换产生 true 或 false，而不是 t 或 f。其他类型转换可能在比以前更多的情况下成功；例如，把数值 3.9 赋给整数变量现在会赋值 4，而不是失败。如果没有为特定的源类型和目标类型定义赋值级转换，PL/pgSQL 将回退到旧的 I/O 转换行为。
允许服务器命令行选项中的字符用反斜杠转义（Andres Freund）
\n以前，选项字符串中的空格总是分隔选项，因此无法在选项值中包含空格。现在要在选项值中包含反斜杠，需要写成 \\\\。
把 GSSAPI 的 include_realm 参数默认值改为 1，因此默认情况下不会从 GSS 或 SSPI 主体名中移除领域（realm）（Stephen Frost）
用min_wal_size和max_wal_size替换配置参数 checkpoint_segments（Heikki Linnakangas）
如果你以前调整过 checkpoint_segments，以下公式可给出近似等效的设置：
max_wal_size = (3 * checkpoint_segments) * 16MB\n\n
注意，max_wal_size 的默认设置比过去 checkpoint_segments 的默认值高得多，因此可能不再需要调整它。
通过新的环境变量 PG_OOM_ADJUST_FILE 和 PG_OOM_ADJUST_VALUE 控制 Linux 的 OOM killer，而不是编译时选项 LINUX_OOM_SCORE_ADJ 和 LINUX_OOM_ADJ（Gurjeet Singh）
停用服务器配置参数 ssl_renegotiation_limit，它在以前的版本中已被弃用（Andres Freund）
虽然 SSL 重协商在理论上是个好主意，但它引发的 bug 之多，使它在实践中被认为弊大于利，而且相关标准的未来版本将移除它。因此我们已从 PostgreSQL 中移除了对它的支持。ssl_renegotiation_limit 参数仍然存在，但只能设置为零（禁用）。它也不再被写入文档。
移除服务器配置参数 autocommit，它此前已被弃用且不起作用（Tom Lane）
移除 pg_authid 系统目录的 rolcatupdate 字段，因为它毫无用处（Adam Brightwell）
当没有有效值时，pg_stat_replication 系统视图的 sent 字段现在为 NULL 而不是零（Magnus Hagander）
允许 json 和 jsonb 数组提取操作符接受负数下标，它们从 JSON 数组末尾开始计数（Peter Geoghegan、Andrew Dunstan）
以前，这些操作符对负数下标返回 NULL。
添加块范围索引（BRIN）（Álvaro Herrera）
\nBRIN 索引只为堆块范围存储摘要数据（如最小值和最大值）。因此它们非常紧凑且更新成本低；但如果数据是自然聚簇的，它们仍能显著加速搜索。
", "text": "添加块范围索引（BRIN）（Álvaro Herrera） BRIN 索引只为堆块范围存储摘要数据（如最小值和最大值）。因此它们非常紧凑且更新成本低；但如果数据是自然聚簇的，它们仍能显著加速搜索。", "title": "添加块范围索引（BRIN）", "commits": [], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.2", "source_hash": "79f99eb475123bead35dfd18d69e0b399ec99d49e2b6133340bf045328d41f56", "section_path": ["服务器", "索引"], "commit_groups": [["3b6db1f"], ["7516f52"], ["b0b7be6"]], "identity_text": "Add Block Range Indexes (BRIN) (Álvaro Herrera) BRIN indexes store only summary data (such as minimum and maximum values) for ranges of heap blocks. They are therefore very compact and cheap to update; but if the data is naturally clustered, they can still provide substantial speedup of searches.", "commit_aliases": ["3b6db1f", "7516f52", "b0b7be6"], "source_commits": ["3b6db1f", "7516f52", "b0b7be6"], "source_entry_id": "9.5.0/changes/001", "db_id": "61b932eb0ca243618ca88858b0c22415", "patch_ids": ["409348e161bf2bf75161a96690e81f1c", "59df5103ed7970fe3a71204244b2660a", "6686a53149bd06d67cf986ee4e0d766f"], "statement_hash": "b242d053ef1d3d3d21874881f4e1b4e486df41e3628351eda758a6562b797114", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-6c1b223aa632b406", "cves": [], "html": "允许查询使用 GiST 索引对边界框索引的对象（多边形、圆）执行精确的距离过滤（Alexander Korotkov、Heikki Linnakangas）
\n以前，要利用此类索引，必须使用子查询选取大量按边界框距离排序的行，然后再用更精确的距离计算对结果进一步过滤。
", "text": "允许查询使用 GiST 索引对边界框索引的对象（多边形、圆）执行精确的距离过滤（Alexander Korotkov、Heikki Linnakangas） 以前，要利用此类索引，必须使用子查询选取大量按边界框距离排序的行，然后再用更精确的距离计算对结果进一步过滤。", "title": "允许查询使用 GiST 索引对边界框索引的对象（多边形、圆）执行精确的距离过滤", "commits": [], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.2", "source_hash": "6dc98cb99e472b3d75e35aa73e8338aafee7c40c87320aa37a17c26e1679d939", "section_path": ["服务器", "索引"], "commit_groups": [["35fcb1b"]], "identity_text": "Allow queries to perform accurate distance filtering of bounding-box-indexed objects (polygons, circles) using GiST indexes (Alexander Korotkov, Heikki Linnakangas) Previously, to exploit such an index a subquery had to be used to select a large number of rows ordered by bounding-box distance, and the result then had to be filtered further with a more accurate distance calculation.", "commit_aliases": ["35fcb1b"], "source_commits": ["35fcb1b"], "source_entry_id": "9.5.0/changes/002", "db_id": "e00f276bee28b9d1f2eb1aa907d98be9", "patch_ids": ["c23da46c6c4f74313cd462c9fca109d4"], "statement_hash": "0eb743004e6c7781b20e3b79173c5d42341047df53645f0317f4ea69b7712907", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-0c44a10ed44b325b", "cves": [], "html": "允许 GiST 索引执行仅索引扫描（Anastasia Lubennikova、Heikki Linnakangas、Andreas Karlsson）
", "text": "允许 GiST 索引执行仅索引扫描（Anastasia Lubennikova、Heikki Linnakangas、Andreas Karlsson）", "title": "允许 GiST 索引执行仅索引扫描", "commits": [], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.2", "source_hash": "93d2bcf53419242f403fdd065d86dc5bc9018de0360c2a7a43b6b5adb1d3cf7a", "section_path": ["服务器", "索引"], "commit_groups": [["0633a60"], ["3a20b0e"], ["d04c8ed"], ["e09b483"]], "identity_text": "Allow GiST indexes to perform index-only scans (Anastasia Lubennikova, Heikki Linnakangas, Andreas Karlsson)", "commit_aliases": ["0633a60", "3a20b0e", "d04c8ed", "e09b483"], "source_commits": ["0633a60", "3a20b0e", "d04c8ed", "e09b483"], "source_entry_id": "9.5.0/changes/003", "db_id": "5436479695de4902eccbccb4027e72ad", "patch_ids": ["061da7f214b64ba4c49b68cda3ac7a06", "129259c361fc08965355e98bd6fc286a", "8f0f0ddcf5583bc189a3b621fb96cef0", "d7c7fe930de958b70f487336af71e193"], "statement_hash": "593d5106b58664dbc8ad22608789fe85997d6388e039062cc7c42155c90140e4", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-0d1dce56c0d008bb", "cves": [], "html": "添加配置参数gin_pending_list_limit来控制 GIN 待处理列表的大小（Fujii Masao）
\n该值也可以按索引设置为索引存储参数。以前，待处理列表的大小由work_mem控制，这很不方便，因为 work_mem 的合适值对此用途往往太大了。
在创建哈希索引期间发出警告，因为它们不是崩溃安全的（Bruce Momjian）
", "text": "在创建哈希索引期间发出警告，因为它们不是崩溃安全的（Bruce Momjian）", "title": "在创建哈希索引期间发出警告，因为它们不是崩溃安全的", "commits": [], "section": "服务器 / 索引", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.2", "source_hash": "25727798f27ccf3afb17278589c387a8aca3b859623148865a23d9236f66e1c1", "section_path": ["服务器", "索引"], "commit_groups": [["84aa8ba"]], "identity_text": "Issue a warning during the creation of hash indexes because they are not crash-safe (Bruce Momjian)", "commit_aliases": ["84aa8ba"], "source_commits": ["84aa8ba"], "source_entry_id": "9.5.0/changes/005", "db_id": "1b58f556c0159f26b6ae2af8bd14abe2", "patch_ids": ["7f1ead641f6df51f7feb3946d313f7e6"], "statement_hash": "8f47daead5289fa681c6c257021b027922685be91e2909acc97b7525059b489e", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-bc8ffc1908e9cb57", "cves": [], "html": "通过“缩写”键提高 varchar、text 和 numeric 字段的排序速度（Peter Geoghegan、Andrew Gierth、Robert Haas）
扩展允许由内联的、非 SQL 可调用的比较函数执行排序的基础设施，使其覆盖 CREATE INDEX、REINDEX 和 CLUSTER（Peter Geoghegan）
改进哈希连接的性能（Tomas Vondra、Robert Haas）
", "text": "改进哈希连接的性能（Tomas Vondra、Robert Haas）", "title": "改进哈希连接的性能", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "c58e154d814856647e6f03597b8b881c8e47ff6d4173844dd687b0ef2d750c13", "section_path": ["服务器", "一般性能"], "commit_groups": [["30d7ae3"], ["45f6240"], ["8cce08f"]], "identity_text": "Improve performance of hash joins (Tomas Vondra, Robert Haas)", "commit_aliases": ["30d7ae3", "45f6240", "8cce08f"], "source_commits": ["30d7ae3", "45f6240", "8cce08f"], "source_entry_id": "9.5.0/changes/008", "db_id": "1845465bea21a58ff76581628c372d6e", "patch_ids": ["2d1e336595ee510dd7bb935e41152468", "7ffa30a5895e9161e0f5d4798632f769", "e10bd03fcab600fb4c143c1c4f40b201"], "statement_hash": "25afd8a51c4f242c20ac8b76b790953121225fdcd038570aac9d798e08df35b8", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-a1c6eeea0f1a3f5f", "cves": [], "html": "改进共享缓冲区替换的并发性（Robert Haas、Amit Kapila、Andres Freund）
", "text": "改进共享缓冲区替换的并发性（Robert Haas、Amit Kapila、Andres Freund）", "title": "改进共享缓冲区替换的并发性", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "cd897cc55017dbb49516b08cfd000c6a7a6685d3e09e1c32b6f97351fcb0e592", "section_path": ["服务器", "一般性能"], "commit_groups": [["5d7962c"], ["d72731a"]], "identity_text": "Improve concurrency of shared buffer replacement (Robert Haas, Amit Kapila, Andres Freund)", "commit_aliases": ["5d7962c", "d72731a"], "source_commits": ["5d7962c", "d72731a"], "source_entry_id": "9.5.0/changes/009", "db_id": "0ea3ad655a4d38d58dbbf9be72d7df82", "patch_ids": ["9204ad2e4dcc557b1e4a4864b7c144d3", "94803eb385b5d84965f6edd062462a7f"], "statement_hash": "c3118df535e21d2b4e26500a573a820c438c2a6c2ff4829f0a2b8a605713a80b", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-2eeadfb65fa576df", "cves": [], "html": "减少索引扫描期间的页锁和引脚数量（Kevin Grittner）
\n其主要好处是让索引清理较少被阻塞。
", "text": "减少索引扫描期间的页锁和引脚数量（Kevin Grittner） 其主要好处是让索引清理较少被阻塞。", "title": "减少索引扫描期间的页锁和引脚数量", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "4d86a8dcd03456ffeaa18354e5ed3bbdbbd6d296033ea2c044ea2c7b5aa6d231", "section_path": ["服务器", "一般性能"], "commit_groups": [["2ed5b87f"]], "identity_text": "Reduce the number of page locks and pins during index scans (Kevin Grittner) The primary benefit of this is to allow index vacuums to be blocked less often.", "commit_aliases": ["2ed5b87f"], "source_commits": ["2ed5b87f"], "source_entry_id": "9.5.0/changes/010", "db_id": "f883ea2df27a49eb0eb07cf49ed0d7f1", "patch_ids": ["c6b7f57e09c2f00fa4f93b3faa2033bb"], "statement_hash": "ac765ba1fac8d2e00ffb32fd45217bb141e793f5118bf0435a8d8afcdbda7312", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-a32d4bed6a7ab735", "cves": [], "html": "使按后端的缓冲区引脚跟踪更省内存（Andres Freund）
", "text": "使按后端的缓冲区引脚跟踪更省内存（Andres Freund）", "title": "使按后端的缓冲区引脚跟踪更省内存", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "c0cf28da9f28a67f6b7769942252ebb5892a72510b8bc7e7d0945871acabb406", "section_path": ["服务器", "一般性能"], "commit_groups": [["2d115e4"], ["4b4b680"]], "identity_text": "Make per-backend tracking of buffer pins more memory-efficient (Andres Freund)", "commit_aliases": ["2d115e4", "4b4b680"], "source_commits": ["2d115e4", "4b4b680"], "source_entry_id": "9.5.0/changes/011", "db_id": "5845a1f4aae80e32a8d575381d129821", "patch_ids": ["30552bcdd2c7477ebe730c6931f20beb", "6f989c10384d10dfaabe4c874bc965e1"], "statement_hash": "c7e5fe0bd7976b9c4253d7fb0db918706d596a24fcf6c9bbd942a6e927fc460e", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-f4d07e21c0a0b0ac", "cves": [], "html": "改进锁的可伸缩性（Andres Freund）
\n这尤其解决了在多 CPU 插槽系统上运行时的可伸缩性问题。
", "text": "改进锁的可伸缩性（Andres Freund） 这尤其解决了在多 CPU 插槽系统上运行时的可伸缩性问题。", "title": "改进锁的可伸缩性", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "a2caae329b323bac5c99b3e5ae530510b76db24d55409fb5abd029a01d36b919", "section_path": ["服务器", "一般性能"], "commit_groups": [["ab5194e"]], "identity_text": "Improve lock scalability (Andres Freund) This particularly addresses scalability problems when running on systems with multiple CPU sockets.", "commit_aliases": ["ab5194e"], "source_commits": ["ab5194e"], "source_entry_id": "9.5.0/changes/012", "db_id": "75a32ad623e144a4bbba22b547e9057a", "patch_ids": ["34af986d7bb34421beb3f6449f97e2be"], "statement_hash": "8cce4bfa85501055656427f774cab39a0358306398f8b42f23ea7d0204350b77", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-207c30cf08814e89", "cves": [], "html": "允许优化器移除对左连接子查询的不必要引用（David Rowley）
", "text": "允许优化器移除对左连接子查询的不必要引用（David Rowley）", "title": "允许优化器移除对左连接子查询的不必要引用", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "2fea479a45b7be7d769c9aa67520cb313f5275fabdc2a666d776a14a5617cac7", "section_path": ["服务器", "一般性能"], "commit_groups": [["f15821e"]], "identity_text": "Allow the optimizer to remove unnecessary references to left-joined subqueries (David Rowley)", "commit_aliases": ["f15821e"], "source_commits": ["f15821e"], "source_entry_id": "9.5.0/changes/013", "db_id": "4aeed9af62ca2b64dcfc52a844cbdbc0", "patch_ids": ["a32c39e5ea8e28de27cc62d4feaa2343"], "statement_hash": "a83cc6e5acec6dddb8c7418be8ace6d4be56ba86069365b06f28e4d8cabc8637", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-16c29fac83bc8709", "cves": [], "html": "在合适的情况下，允许把查询限制下推到带窗口函数的子查询中（David Rowley）
", "text": "在合适的情况下，允许把查询限制下推到带窗口函数的子查询中（David Rowley）", "title": "在合适的情况下，允许把查询限制下推到带窗口函数的子查询中", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "ea8b110918da00050e43b5e425bbe11209cedd32ead4e65260d2a9eddf95517d", "section_path": ["服务器", "一般性能"], "commit_groups": [["d222585"]], "identity_text": "Allow pushdown of query restrictions into subqueries with window functions, where appropriate (David Rowley)", "commit_aliases": ["d222585"], "source_commits": ["d222585"], "source_entry_id": "9.5.0/changes/014", "db_id": "31571c04051fc5e9b86bb4419f9e9296", "patch_ids": ["b48721830dc7e8f7363999c7c6512644"], "statement_hash": "15a7c7f16ce79de8aaecda9af616f78951490bf56bfc36a5f3a4d8ae5812c571", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-18ba2591d01d83e8", "cves": [], "html": "如果非防泄漏函数不接收任何视图输出列，则允许把它下推到安全屏障视图中（Dean Rasheed）
", "text": "如果非防泄漏函数不接收任何视图输出列，则允许把它下推到安全屏障视图中（Dean Rasheed）", "title": "如果非防泄漏函数不接收任何视图输出列，则允许把它下推到安全屏障视图中", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "67a10a9f920848af1ece61a65c7752dbca8f96e7f2747488bcf5437140ad3503", "section_path": ["服务器", "一般性能"], "commit_groups": [["dcbf594"]], "identity_text": "Allow a non-leakproof function to be pushed down into a security barrier view if the function does not receive any view output columns (Dean Rasheed)", "commit_aliases": ["dcbf594"], "source_commits": ["dcbf594"], "source_entry_id": "9.5.0/changes/015", "db_id": "233959bb4266d2c22da453f23f84eb2c", "patch_ids": ["aa5b40f52f4a2230285062d4db47dc31"], "statement_hash": "e3b3d74e05a4d3a22fe00c8ab0e66baaafc8138ecaaba3ebda5436b1f5bd6587", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-f26b6997875cadb0", "cves": [], "html": "当 WHERE 中出现匹配的函数调用时，让规划器使用从布尔返回函数表达式索引获得的统计信息（Tom Lane）
即使列的数据类型缺少相等函数，也让 ANALYZE 计算基本统计信息（空值比例和平均列宽）（Oleksandr Shulgin）
加速 CRC（循环冗余校验）计算并切换到 CRC-32C（Abhijit Menon-Sen、Heikki Linnakangas）
", "text": "加速 CRC（循环冗余校验）计算并切换到 CRC-32C（Abhijit Menon-Sen、Heikki Linnakangas）", "title": "加速 CRC（循环冗余校验）计算并切换到 CRC-32C", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "88cfbfe3a6a7d83fe29013b29a6f2704c0941c38147f85c230168e7218261d88", "section_path": ["服务器", "一般性能"], "commit_groups": [["025c024"], ["3dc2d62"], ["5028f22"]], "identity_text": "Speed up CRC (cyclic redundancy check) computations and switch to CRC-32C (Abhijit Menon-Sen, Heikki Linnakangas)", "commit_aliases": ["025c024", "3dc2d62", "5028f22"], "source_commits": ["025c024", "3dc2d62", "5028f22"], "source_entry_id": "9.5.0/changes/018", "db_id": "a36decdc418e0679b6675dda80aad1c3", "patch_ids": ["0bc647ce19e0126123eae70cc3506767", "0dd548ed7e5f879f75c4c5b9bcc354cc", "7d2485cebcd6131e199d50d6cebc42e2"], "statement_hash": "72dff919231807053de727ede4a5c20f2fc674a20078f67de95609dd8c825e88", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-54c7856c2222b61b", "cves": [], "html": "改进位图索引扫描的性能（Teodor Sigaev、Tom Lane）
", "text": "改进位图索引扫描的性能（Teodor Sigaev、Tom Lane）", "title": "改进位图索引扫描的性能", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "a97eaf7d2060b7c8c1ce3ed0a75f4052a838b191dc1e556bdfc400452821b53e", "section_path": ["服务器", "一般性能"], "commit_groups": [["779fdcd"], ["f5ae3ba"]], "identity_text": "Improve bitmap index scan performance (Teodor Sigaev, Tom Lane)", "commit_aliases": ["779fdcd", "f5ae3ba"], "source_commits": ["779fdcd", "f5ae3ba"], "source_entry_id": "9.5.0/changes/019", "db_id": "ef392a440ccccb964b87dd9f84a08025", "patch_ids": ["047da880087c1bb16965dd54c33ad6ce", "7d8039c0ba1bfd52d70ebbc07ce9ff50"], "statement_hash": "f04bb3b2e6e1cf66f10467e1e5860aaa8f9e506ec5a3cd044ddc3af21fc3a4d6", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-d6dcc06d20a78efa", "cves": [], "html": "通过避免不必要的内存复制加速 CREATE INDEX（Robert Haas）
增加缓冲区映射的分区数（Amit Kapila、Andres Freund、Robert Haas）
\n这提高了高并发负载下的性能。
", "text": "增加缓冲区映射的分区数（Amit Kapila、Andres Freund、Robert Haas） 这提高了高并发负载下的性能。", "title": "增加缓冲区映射的分区数", "commits": [], "section": "服务器 / 一般性能", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.3", "source_hash": "085671386dabf52d6e0d50470f3eb7fcd2fb16bfa3055b8e7b6eed6a90869f1f", "section_path": ["服务器", "一般性能"], "commit_groups": [["3acc10c9"]], "identity_text": "Increase the number of buffer mapping partitions (Amit Kapila, Andres Freund, Robert Haas) This improves performance for highly concurrent workloads.", "commit_aliases": ["3acc10c9"], "source_commits": ["3acc10c9"], "source_entry_id": "9.5.0/changes/021", "db_id": "ad4bfd3db0ae1a6fc8af5969417d23c9", "patch_ids": ["d74305ba3826b04f48fd77728822059e"], "statement_hash": "ff7973859a8f4b2bb6ab1687d0c3b38ea039d389a31ec2fc508fc1571d0c6a79", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-54b7494c08857e80", "cves": [], "html": "通过新的 log_autovacuum_min_duration 存储参数添加按表的自动清理日志控制（Michael Paquier）
添加新的配置参数cluster_name（Thomas Munro）
\n这个字符串通常在 postgresql.conf 中设置，让客户端能够识别集群。该名称还会出现在所有服务器进程的进程标题中，便于识别属于同一集群的进程。
防止非超级用户在连接启动时更改log_disconnections（Fujii Masao）
", "text": "防止非超级用户在连接启动时更改log_disconnections（Fujii Masao）", "title": "防止非超级用户在连接启动时更改log_disconnections", "commits": [], "section": "服务器 / 监控", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.4", "source_hash": "6a39c0e0448c3b65cb9bab68d016940aadd8af448c0d6276bdce082332b3d6be", "section_path": ["服务器", "监控"], "commit_groups": [["fe550b2"]], "identity_text": "Prevent non-superusers from changing guc-log-disconnections on connection startup (Fujii Masao)", "commit_aliases": ["fe550b2"], "source_commits": ["fe550b2"], "source_entry_id": "9.5.0/changes/024", "db_id": "ee24b60403635caf0465b11ef0693e59", "patch_ids": ["e63528d8f3123e1fb4df9e2ea954d765"], "statement_hash": "27c5b5e0bf38d5347fc5457c0c13291a51e755ae5f00e63d02360a5fae610866", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-6986236008533c7c", "cves": [], "html": "检查 SSL 服务器证书中的“使用者可选名称（Subject Alternative Names）”（如果存在）（Alexey Klyukin）
\n当它们存在时，这将取代对证书“通用名称（Common Name）”的检查。
", "text": "检查 SSL 服务器证书中的“使用者可选名称（Subject Alternative Names）”（如果存在）（Alexey Klyukin） 当它们存在时，这将取代对证书“通用名称（Common Name）”的检查。", "title": "检查 SSL 服务器证书中的“使用者可选名称（Subject Alternative Names）”（如果存在）", "commits": [], "section": "服务器 / SSL", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.5", "source_hash": "6709b6bb9280df0af5591c5fe907bc3af2398f6263052b35e3d3335017f0baf5", "section_path": ["服务器", "SSL"], "commit_groups": [["acd08d7"]], "identity_text": "Check Subject Alternative Names in SSL server certificates, if present (Alexey Klyukin) When they are present, this replaces checks against the certificate's Common Name.", "commit_aliases": ["acd08d7"], "source_commits": ["acd08d7"], "source_entry_id": "9.5.0/changes/025", "db_id": "abf53921ead1d7aa50dab167fc5a3ea0", "patch_ids": ["c634d9e56ccad24dbe8040e3b8c4aebc"], "statement_hash": "74649e000f29bfecc271cf300810b139bf66b170294025dd84dff2c9771264ec", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-ac49bfcfb39a8606", "cves": [], "html": "添加系统视图 pg_stat_ssl，用于报告 SSL 连接信息（Magnus Hagander）
添加以与实现无关的方式返回 SSL 信息的 libpq 函数（Heikki Linnakangas）
\n虽然 PQgetssl() 仍可用于调用 OpenSSL 函数，但它现在被视为已弃用，因为未来版本的 libpq 可能支持其他 SSL 实现。在可能的情况下，请使用新函数 PQsslAttribute()、PQsslAttributeNames() 和 PQsslInUse()，以与 SSL 实现无关的方式获取 SSL 信息。
使 libpq 遵循任何 OpenSSL 线程回调（Jan Urbanski）
\n以前它们会被覆盖。
", "text": "使 libpq 遵循任何 OpenSSL 线程回调（Jan Urbanski） 以前它们会被覆盖。", "title": "使 libpq 遵循任何 OpenSSL 线程回调", "commits": [], "section": "服务器 / SSL", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.5", "source_hash": "fc98b8bc5d6cff74d9f822aaeb289535e0358d0adc3905d27900eeedaa72add8", "section_path": ["服务器", "SSL"], "commit_groups": [["8a0d34e4"]], "identity_text": "Make libpq honor any OpenSSL thread callbacks (Jan Urbanski) Previously they were overwritten.", "commit_aliases": ["8a0d34e4"], "source_commits": ["8a0d34e4"], "source_entry_id": "9.5.0/changes/028", "db_id": "8ec1d792b344e024ae22c1ec2b4eeb08", "patch_ids": ["89779d2b8bb8182cb01dbccf43fbe2ce"], "statement_hash": "7bfe9c16c91eafda3ce10b4d1cccb06069b12dd4cdb8bf4742a0a86623331093", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-42a4f1960250cc53", "cves": [], "html": "用min_wal_size和max_wal_size替换配置参数 checkpoint_segments（Heikki Linnakangas）
此变更允许分配大量 WAL 文件，而在不再需要之后不必保留它们。因此 max_wal_size 的默认值被设置为 1GB，比过去 checkpoint_segments 的默认值大得多。另请注意，备库会执行重做点以尝试把 WAL 空间消耗限制在 max_wal_size 以内；以前它们完全不理会 checkpoint_segments。
通过新的环境变量 PG_OOM_ADJUST_FILE 和 PG_OOM_ADJUST_VALUE 控制 Linux 的 OOM killer（Gurjeet Singh）
以前的 OOM 控制基础设施涉及编译时选项 LINUX_OOM_SCORE_ADJ 和 LINUX_OOM_ADJ，它们不再受支持。新的行为在所有构建中都可用。
当配置参数track_commit_timestamp启用时，允许记录事务提交时间戳（Álvaro Herrera、Petr Jelínek）
\n时间戳信息可以通过函数 pg_xact_commit_timestamp() 和 pg_last_committed_xact() 访问。
允许通过 ALTER ROLE SET 设置local_preload_libraries（Peter Eisentraut、Kyotaro Horiguchi）
允许自动清理工作进程在运行期间响应配置参数更改（Michael Paquier）
", "text": "允许自动清理工作进程在运行期间响应配置参数更改（Michael Paquier）", "title": "允许自动清理工作进程在运行期间响应配置参数更改", "commits": [], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.6", "source_hash": "df290d291ea3c708ae89e9c4d6646289d39bdb7fc0cd4d320c0d6fb52c81af23", "section_path": ["服务器", "服务器配置"], "commit_groups": [["a75fb9b"]], "identity_text": "Allow autovacuum workers to respond to configuration parameter changes during a run (Michael Paquier)", "commit_aliases": ["a75fb9b"], "source_commits": ["a75fb9b"], "source_entry_id": "9.5.0/changes/033", "db_id": "7f2f3fb46c783644078a3be74c894014", "patch_ids": ["2d19d0a1429c5c6d0412545b6c2c07e2"], "statement_hash": "8b039809a9eafa442fc23a93d82d0bc1a96c1a9a2745571e51fca517471b006f", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-46730184452ade72", "cves": [], "html": "把配置参数debug_assertions设为只读（Andres Freund）
\n这意味着，如果在编译时启用了断言，就无法再关闭它们，从而允许更高效的代码优化。此变更还移除了 postgres 的 -A 选项。
允许在不生效的系统上设置effective_io_concurrency（Peter Eisentraut）
", "text": "允许在不生效的系统上设置effective_io_concurrency（Peter Eisentraut）", "title": "允许在不生效的系统上设置effective_io_concurrency", "commits": [], "section": "服务器 / 服务器配置", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.3.6", "source_hash": "63b578c8986a5a4c789589229a8f66c01127b17ea6db77013ebbc9aabdc916ee", "section_path": ["服务器", "服务器配置"], "commit_groups": [["7feaccc"]], "identity_text": "Allow setting guc-effective-io-concurrency on systems where it has no effect (Peter Eisentraut)", "commit_aliases": ["7feaccc"], "source_commits": ["7feaccc"], "source_entry_id": "9.5.0/changes/035", "db_id": "3977e7a29e9bfd6bf2029df637507dbb", "patch_ids": ["9f23e4040c2772eedadfbae4ec24b8b4"], "statement_hash": "4ff62176a37c36e84bc911683c99d8461f129751ccfc814695aa459c3ada674b", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-796bd68866d9702d", "cves": [], "html": "添加系统视图 pg_file_settings，用于显示服务器配置文件的内容（Sawada Masahiko）
向系统视图 pg_settings 添加 pending_restart，用于指示已做出更改但在数据库重启之前不会生效（Peter Eisentraut）
允许用 ALTER SYSTEM RESET 重置 ALTER SYSTEM 的值（Vik Fearing）
此命令会从 postgresql.auto.conf 中移除指定的设置。
创建跟踪复制进度的机制，包括在逻辑复制期间识别单条变更来源的方法（Andres Freund）
\n这在实现复制解决方案时很有帮助。
", "text": "创建跟踪复制进度的机制，包括在逻辑复制期间识别单条变更来源的方法（Andres Freund） 这在实现复制解决方案时很有帮助。", "title": "创建跟踪复制进度的机制，包括在逻辑复制期间识别单条变更来源的方法", "commits": [], "section": "复制与恢复", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.4", "source_hash": "6329b606caca3448ab8d1ed23de96e1514c3c1b4885edb1feb2acdc1322cd79b", "section_path": ["复制与恢复"], "commit_groups": [["5aa2350"]], "identity_text": "Create mechanisms for tracking the progress of replication, including methods for identifying the origin of individual changes during logical replication (Andres Freund) This is helpful when implementing replication solutions.", "commit_aliases": ["5aa2350"], "source_commits": ["5aa2350"], "source_entry_id": "9.5.0/changes/039", "db_id": "6d17d6257f9cc73c52321b82e3534493", "patch_ids": ["6fb670c2ba27e389c57f3b5c18e02481"], "statement_hash": "39e9d0df0336857b498775f3321cb41a9d8ef483c0b3a244715eaa3b11f99e07", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-3c7abb698f17882a", "cves": [], "html": "重做多事务提交日志的截断逻辑，使其正确记录 WAL（Andres Freund）
\n这使事情变得明显更简单、更健壮。
", "text": "重做多事务提交日志的截断逻辑，使其正确记录 WAL（Andres Freund） 这使事情变得明显更简单、更健壮。", "title": "重做多事务提交日志的截断逻辑，使其正确记录 WAL", "commits": [], "section": "复制与恢复", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.4", "source_hash": "9eee24a74c1cb73a1ec3a17e71df9799314bd74de2153d5ab22b20675e8d2420", "section_path": ["复制与恢复"], "commit_groups": [["6e8af37"], ["bd7c348"]], "identity_text": "Rework truncation of the multixact commit log to be properly WAL-logged (Andres Freund) This makes things substantially simpler and more robust.", "commit_aliases": ["6e8af37", "bd7c348"], "source_commits": ["6e8af37", "bd7c348"], "source_entry_id": "9.5.0/changes/040", "db_id": "864d515e21696e566eec2efd2b014fd1", "patch_ids": ["270448c43c72d8a97a99d20914b9c7cb", "7fc0ca6a1aedf2861da914bd5cb125d2"], "statement_hash": "1514a04f968aac8df001041d426e42cf7cea4fc71baafa58e2305d7bbb6da660", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-97c9728a159adf37", "cves": [], "html": "添加 recovery.conf 参数 recovery_target_action 来控制恢复之后的动作（Petr Jelínek）
它取代了旧的参数 pause_at_recovery_target。
为archive_mode添加新值 always，允许备库始终归档收到的 WAL 文件（Fujii Masao）
添加配置参数wal_retrieve_retry_interval，控制在失败后重试读取 WAL 的间隔（Alexey Vasiliev、Michael Paquier）
\n这对温备库特别有用。
", "text": "添加配置参数wal_retrieve_retry_interval，控制在失败后重试读取 WAL 的间隔（Alexey Vasiliev、Michael Paquier） 这对温备库特别有用。", "title": "添加配置参数wal_retrieve_retry_interval，控制在失败后重试读取 WAL 的间隔", "commits": [], "section": "复制与恢复", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.4", "source_hash": "8cbc05b0a62bfbe145a584eedeb2a1acc921ed35a2b5d535fe6b13e18f4fdf61", "section_path": ["复制与恢复"], "commit_groups": [["5d2b45e"]], "identity_text": "Add configuration parameter guc-wal-retrieve-retry-interval to control WAL read retry after failure (Alexey Vasiliev, Michael Paquier) This is particularly helpful for warm standbys.", "commit_aliases": ["5d2b45e"], "source_commits": ["5d2b45e"], "source_entry_id": "9.5.0/changes/043", "db_id": "7734e2d7f1e813d689fe49d19192e0b3", "patch_ids": ["fc590e5733daaeb18a93d2555c7d6c24"], "statement_hash": "60bd3d5a8090d4957995b08470464926a665258881940e14c9e0e3a994b2bb0e", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-4a52f1d364e8b193", "cves": [], "html": "允许压缩存储在 WAL 中的全页映像（Rahila Syed、Michael Paquier）
\n此特性可减少 WAL 量，代价是 WAL 记录和 WAL 重放消耗更多 CPU 时间。它由新的配置参数wal_compression控制，目前默认关闭。
", "text": "允许压缩存储在 WAL 中的全页映像（Rahila Syed、Michael Paquier） 此特性可减少 WAL 量，代价是 WAL 记录和 WAL 重放消耗更多 CPU 时间。它由新的配置参数wal_compression控制，目前默认关闭。", "title": "允许压缩存储在 WAL 中的全页映像", "commits": [], "section": "复制与恢复", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.4", "source_hash": "dbb1a913f047c596daadcf9eaaff3ae34a9b55ac63b6dbbd59a09c6ee9a27434", "section_path": ["复制与恢复"], "commit_groups": [["57aa5b2"]], "identity_text": "Allow compression of full-page images stored in WAL (Rahila Syed, Michael Paquier) This feature reduces WAL volume, at the cost of more CPU time spent on WAL logging and WAL replay. It is controlled by a new configuration parameter guc-wal-compression , which currently is off by default.", "commit_aliases": ["57aa5b2"], "source_commits": ["57aa5b2"], "source_entry_id": "9.5.0/changes/044", "db_id": "c26bf44d832909614463ea4aef25b34f", "patch_ids": ["c1c20ba3f7797e312e6fadaf4ba98c94"], "statement_hash": "abbc8efac6ff86491366039eda94481699cf2bc44a916d22cf46a6b0fb590e02", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-986807ac621d092b", "cves": [], "html": "在备库提升期间为 WAL 文件加上 .partial 后缀后归档（Heikki Linnakangas）
添加配置参数log_replication_commands来记录复制命令（Fujii Masao）
\n默认情况下，复制命令（例如 IDENTIFY_SYSTEM）不会被记录，即使log_statement被设置为 all。
在 pg_replication_slots 中报告持有复制槽的进程（Craig Ringer）
新增的输出列为 active_pid。
允许 recovery.conf 的 primary_conninfo 设置使用连接 URI（例如 postgres://）（Alexander Shulgin）
允许把会产生约束冲突的 INSERT 转换为 UPDATE 或忽略（Peter Geoghegan、Heikki Linnakangas、Andres Freund）
语法为 INSERT ... ON CONFLICT DO NOTHING/UPDATE。这是流行的 UPSERT 命令的 Postgres 实现。
添加 GROUP BY 分析特性 GROUPING SETS、CUBE 和 ROLLUP（Andrew Gierth、Atri Sharma）
允许在 UPDATE 中用单个子 SELECT 的结果设置多个目标列（Tom Lane）
这通过语法 UPDATE tab SET (col1, col2, ...) = (SELECT ...) 完成。
为 SELECT 添加选项 SKIP LOCKED，用于跳过已锁定的行（Thomas Munro）
与 NOWAIT 不同，它不会对已锁定的行抛出错误。
为 SELECT 添加选项 TABLESAMPLE，用于返回表的子集（Petr Jelínek）
此特性支持 SQL 标准的表采样方法。此外，还为用户自定义表采样方法提供了机制。
", "text": "为 SELECT 添加选项 TABLESAMPLE，用于返回表的子集（Petr Jelínek） 此特性支持 SQL 标准的表采样方法。此外，还为用户自定义表采样方法提供了机制。", "title": "为 SELECT 添加选项 TABLESAMPLE，用于返回表的子集", "commits": [], "section": "查询", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.5", "source_hash": "ffd3e2d7c579bebe950c5172af1874207fd7cbba0ac7e86b2a5588cecb19098a", "section_path": ["查询"], "commit_groups": [["f6d208d"]], "identity_text": "Add SELECT option TABLESAMPLE to return a subset of a table (Petr Jelínek) This feature supports the SQL-standard table sampling methods. In addition, there are provisions for user-defined table sampling methods.", "commit_aliases": ["f6d208d"], "source_commits": ["f6d208d"], "source_entry_id": "9.5.0/changes/053", "db_id": "fdd9b53b97775de21b11e98ee953f73e", "patch_ids": ["6468461e45621f5340359e12bff20d0b"], "statement_hash": "f041e7a54a90193f4f2c0900b77ca98cfb2f62edd33e421ba311c06779ecbcaa", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-039427c9efbde9cd", "cves": [], "html": "为拼错的列名建议可能的匹配（Peter Geoghegan、Robert Haas）
", "text": "为拼错的列名建议可能的匹配（Peter Geoghegan、Robert Haas）", "title": "为拼错的列名建议可能的匹配", "commits": [], "section": "查询", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.5", "source_hash": "2b7c028f2eb23c374949c311e93172c1fb87b92f4a7a811fa5f7f240efec4650", "section_path": ["查询"], "commit_groups": [["e529cd4"]], "identity_text": "Suggest possible matches for mistyped column names (Peter Geoghegan, Robert Haas)", "commit_aliases": ["e529cd4"], "source_commits": ["e529cd4"], "source_entry_id": "9.5.0/changes/054", "db_id": "1385c3e30aec8e5a8b17d2faccf9101a", "patch_ids": ["6638d4e01c601df03e885f3b6a90b99b"], "statement_hash": "cb192e2c7524aff5fe5070e97ea658a6fb8e58b892ce3f3040fe11f9f461a6e2", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-2841859e8cfef1dc", "cves": [], "html": "在 EXPLAIN 输出中添加有关排序的更多细节（Marius Timmer、Lukas Kreft、Arne Scheffer）
细节包括 COLLATE、DESC、USING 以及 NULLS FIRST/LAST。
使 VACUUM 记录因引脚（pin）而跳过的页数（Jim Nasby）
使 TRUNCATE 正确更新 pg_stat* 元组计数器（Alexander Shulgin）
允许 REINDEX 使用 SCHEMA 选项对整个模式重新索引（Sawada Masahiko）
为 REINDEX 添加 VERBOSE 选项（Sawada Masahiko）
防止 REINDEX DATABASE 和 SCHEMA 输出对象名称，除非使用 VERBOSE（Simon Riggs）
从 REINDEX 中移除过时的 FORCE 选项（Fujii Masao）
添加行级安全性控制（Craig Ringer、KaiGai Kohei、Adam Brightwell、Dean Rasheed、Stephen Frost）
\n此特性允许逐行控制哪些用户可以添加、修改甚至看到表中的行。它由新命令 CREATE/ALTER/DROP POLICY 以及 ALTER TABLE ... ENABLE/DISABLE ROW SECURITY 控制。
允许在创建表之后用 ALTER TABLE ... SET LOGGED / UNLOGGED 更改其 WAL 记录状态（Fabrízio de Royes Mello）
为 CREATE TABLE AS、CREATE INDEX、CREATE SEQUENCE 和 CREATE MATERIALIZED VIEW 添加 IF NOT EXISTS 子句（Fabrízio de Royes Mello）
为 ALTER TABLE ... RENAME CONSTRAINT 添加对 IF EXISTS 的支持（Bruce Momjian）
允许一些 DDL 命令接受 CURRENT_USER 或 SESSION_USER（即当前用户或会话用户）来代替特定的用户名（Kyotaro Horiguchi、Álvaro Herrera）
ALTER USER、ALTER GROUP、ALTER ROLE、GRANT以及 ALTER 命令现在支持此特性。object OWNER TO
支持对域约束的注释（Álvaro Herrera）
", "text": "支持对域约束的注释（Álvaro Herrera）", "title": "支持对域约束的注释", "commits": [], "section": "对象操作", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.7", "source_hash": "398d5bc398474fe21f02246eb538c2c97c94b27f515131f13b7b1060ba51287d", "section_path": ["对象操作"], "commit_groups": [["7eca575"]], "identity_text": "Support comments on domain constraints (Álvaro Herrera)", "commit_aliases": ["7eca575"], "source_commits": ["7eca575"], "source_entry_id": "9.5.0/changes/067", "db_id": "65a4cb2d096e0a22ad14f4a6e8a33df7", "patch_ids": ["7ba4ad2d0439465b836f91fc1a8d370b"], "statement_hash": "431800fba40815588a0679f7a3d4b39e9d7cf4ad016c6fb78f2e5a89e91116e1", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-b26b2992ece17d47", "cves": [], "html": "降低一些创建/更改触发器和外键命令的锁定级别（Simon Riggs、Andreas Karlsson）
", "text": "降低一些创建/更改触发器和外键命令的锁定级别（Simon Riggs、Andreas Karlsson）", "title": "降低一些创建/更改触发器和外键命令的锁定级别", "commits": [], "section": "对象操作", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.7", "source_hash": "8023b14001977383649d63df51d15b5314d406a33bede9639a965646b229e439", "section_path": ["对象操作"], "commit_groups": [["0ef0396"]], "identity_text": "Reduce lock levels of some create and alter trigger and foreign key commands (Simon Riggs, Andreas Karlsson)", "commit_aliases": ["0ef0396"], "source_commits": ["0ef0396"], "source_entry_id": "9.5.0/changes/068", "db_id": "63c0a0e57c41166375300264ea06242c", "patch_ids": ["f5def199c09879e19eb473f99aba8b80"], "statement_hash": "99e1e2484e8b86e69c60d86fa24c80450c4540cccbb5bf2c5efd8d01297ad1d3", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-aa2a590f636d06cc", "cves": [], "html": "允许对目标表具有 INSERT 权限的用户执行 LOCK TABLE ... ROW EXCLUSIVE MODE（Stephen Frost）
以前此命令要求 UPDATE、DELETE 或 TRUNCATE 权限。
按名称顺序应用表和域的 CHECK 约束（Tom Lane）
以前的顺序是不确定的。
", "text": "按名称顺序应用表和域的 CHECK 约束（Tom Lane） 以前的顺序是不确定的。", "title": "按名称顺序应用表和域的 CHECK 约束", "commits": [], "section": "对象操作", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.7", "source_hash": "d363e9aec0b53c042ce33f68d8cd30e4e74b338d77a1f905946abf84abbcf7e7", "section_path": ["对象操作"], "commit_groups": [["e5f455f"]], "identity_text": "Apply table and domain CHECK constraints in order by name (Tom Lane) The previous ordering was indeterminate.", "commit_aliases": ["e5f455f"], "source_commits": ["e5f455f"], "source_entry_id": "9.5.0/changes/070", "db_id": "9213120fcb94758ca55f8af0ac9746df", "patch_ids": ["28970e157c93332f648f3fe413bbc5d2"], "statement_hash": "de1121f32e1c318d910ee7d12d34d402e31ef6e1c62d2e4c6395210871de14d7", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-e877865aa511fb12", "cves": [], "html": "允许 CREATE/ALTER DATABASE 操纵 datistemplate 和 datallowconn（Vik Fearing）
这样无需手动修改 pg_database 系统目录即可更改这些按数据库的设置。
添加对IMPORT FOREIGN SCHEMA的支持（Ronan Dunklau、Michael Paquier、Tom Lane）
\n此命令允许自动创建与远程服务器上现有表结构匹配的本地外部表。
", "text": "添加对IMPORT FOREIGN SCHEMA的支持（Ronan Dunklau、Michael Paquier、Tom Lane） 此命令允许自动创建与远程服务器上现有表结构匹配的本地外部表。", "title": "添加对IMPORT FOREIGN SCHEMA的支持", "commits": [], "section": "对象操作 / 外部表", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.7.3", "source_hash": "05639b3b91fa565da47ba390a571bbcb7a89ecd36834047937431841937b376c", "section_path": ["对象操作", "外部表"], "commit_groups": [["59efda3"]], "identity_text": "Add support for SQL-IMPORTFOREIGNSCHEMA (Ronan Dunklau, Michael Paquier, Tom Lane) This command allows automatic creation of local foreign tables that match the structure of existing tables on a remote server.", "commit_aliases": ["59efda3"], "source_commits": ["59efda3"], "source_entry_id": "9.5.0/changes/072", "db_id": "9f8e2af3460d1109110303b6560ffa03", "patch_ids": ["6d46883fdd99480a6bc4998ba38b617c"], "statement_hash": "2c40830551976902708a4c9c72c26e4bf22bb85a328d96adfc7e7c8cee930227", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-ca73bf6fc07e2962", "cves": [], "html": "允许在外部表上放置 CHECK 约束（Shigeru Hanada、Etsuro Fujita）
此类约束被假定在远程服务器上执行，本地并不执行。但在查询优化（例如约束排除）中假定它们成立。
", "text": "允许在外部表上放置 CHECK 约束（Shigeru Hanada、Etsuro Fujita） 此类约束被假定在远程服务器上执行，本地并不执行。但在查询优化（例如约束排除）中假定它们成立。", "title": "允许在外部表上放置 CHECK 约束", "commits": [], "section": "对象操作 / 外部表", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.7.3", "source_hash": "973c63e9a79a4732526d49a32b70d90403daec7a7dc8ffaebe8b81f437c837e4", "section_path": ["对象操作", "外部表"], "commit_groups": [["fc2ac1f"]], "identity_text": "Allow CHECK constraints to be placed on foreign tables (Shigeru Hanada, Etsuro Fujita) Such constraints are assumed to be enforced on the remote server, and are not enforced locally. However, they are assumed to hold for purposes of query optimization, such as constraint exclusion.", "commit_aliases": ["fc2ac1f"], "source_commits": ["fc2ac1f"], "source_entry_id": "9.5.0/changes/073", "db_id": "c3b25292cf6bf2eb7e19d5276c7fa148", "patch_ids": ["84d651b9d82b8fb561e2e517163c4cdb"], "statement_hash": "6b1841b1b9b2bdfe2df4662a9bdcacc28390a62de25ddf72c0d563412e734894", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-e686ba471689800f", "cves": [], "html": "允许外部表参与继承（Shigeru Hanada、Etsuro Fujita）
\n为使其自然工作，现在允许外部表带有标记为 NOT VALID 的检查约束，并允许设置存储和 OID 特性，尽管这些操作对外部表实际上是空操作。
允许外部数据包装器和自定义扫描实现连接下推（KaiGai Kohei）
", "text": "允许外部数据包装器和自定义扫描实现连接下推（KaiGai Kohei）", "title": "允许外部数据包装器和自定义扫描实现连接下推", "commits": [], "section": "对象操作 / 外部表", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.7.3", "source_hash": "ab08d71a7f508cf4c4172952495a733b318ea5f6a31fc81345cf216bf44111c6", "section_path": ["对象操作", "外部表"], "commit_groups": [["1a8a4e5"], ["e7cb7ee"]], "identity_text": "Allow foreign data wrappers and custom scans to implement join pushdown (KaiGai Kohei)", "commit_aliases": ["1a8a4e5", "e7cb7ee"], "source_commits": ["1a8a4e5", "e7cb7ee"], "source_entry_id": "9.5.0/changes/075", "db_id": "ae1c885a81ba7eb50335823a36e355bd", "patch_ids": ["64617be1d88ce0f9f661e4113e14081a", "9b5c7fd937c23980dde98b7340486e1a"], "statement_hash": "ea1c795e802bc1f390596fbcf6a4f9b203df582158d813ec81dcfcca71485eb0", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-588de96c4d1f809d", "cves": [], "html": "只要安装了 ddl_command_end 事件触发器，就会捕获 DDL 活动的细节供其检查（Álvaro Herrera）
这些信息可以通过集合返回函数 pg_event_trigger_ddl_commands() 获取；如果该函数提供的细节不够，也可以通过检查 C 数据结构获取。
允许对由 ALTER TABLE 引起的表重写设置事件触发器（Dimitri Fontaine）
为数据库级的 COMMENT、SECURITY LABEL 和 GRANT/REVOKE 添加事件触发器支持（Álvaro Herrera）
向 pg_event_trigger_dropped_objects 的输出添加列（Álvaro Herrera）
这使删除操作的处理更简单。
", "text": "向 pg_event_trigger_dropped_objects 的输出添加列（Álvaro Herrera） 这使删除操作的处理更简单。", "title": "向 pg_event_trigger_dropped_objects 的输出添加列", "commits": [], "section": "对象操作 / 事件触发器", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.7.4", "source_hash": "8f15cc0feed41960175fbbb8b536c335b61b1ffc6b6675cc78a1e992c2e9e81d", "section_path": ["对象操作", "事件触发器"], "commit_groups": [["72dd233"], ["e9a077c"]], "identity_text": "Add columns to the output of pg_event_trigger_dropped_objects (Álvaro Herrera) This allows simpler processing of delete operations.", "commit_aliases": ["72dd233", "e9a077c"], "source_commits": ["72dd233", "e9a077c"], "source_entry_id": "9.5.0/changes/079", "db_id": "b9dae0889e642cc159b6761a44360ae0", "patch_ids": ["56341f602d371aedb8f428b974ec2df4", "826fb6d16def63f43f8f3d983a88fb13"], "statement_hash": "f4e5371f203731d38d2a95b944fa11d11f565c84ea266c72c37773fbaf11fb0d", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-a959299311129a89", "cves": [], "html": "允许 xml 数据类型接受空或全空白的内容值（Peter Eisentraut）
这是 SQL/XML 规范的要求。
", "text": "允许 xml 数据类型接受空或全空白的内容值（Peter Eisentraut） 这是 SQL/XML 规范的要求。", "title": "允许 xml 数据类型接受空或全空白的内容值", "commits": [], "section": "数据类型", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.8", "source_hash": "0a2e3f8422757a22f27785cf9dfe6e1a6cf8131d7a0c5a6c081ea38e1c43e900", "section_path": ["数据类型"], "commit_groups": [["57b1085"]], "identity_text": "Allow the xml data type to accept empty or all-whitespace content values (Peter Eisentraut) This is required by the SQL/XML specification.", "commit_aliases": ["57b1085"], "source_commits": ["57b1085"], "source_entry_id": "9.5.0/changes/080", "db_id": "27b9ce45d6d08472d8eff11808a54043", "patch_ids": ["0916d00ef19b13a99506da0d82e34a79"], "statement_hash": "6aaddfeac327ee4202da7ca5634d12f12efc99151fec26decd8e70d2be510255", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-0a908b3481161ac5", "cves": [], "html": "允许 macaddr 使用 xxxx-xxxx-xxxx 格式输入（Herwin Weststrate）
禁止对 interval 同时指定精度和字段说明的非 SQL 标准语法（Bruce Momjian）
按照标准，此类类型说明应写成例如 INTERVAL MINUTE TO SECOND(2)。PostgreSQL 以前允许写成 INTERVAL(2) MINUTE TO SECOND，但现在必须按标准方式书写。
为 inet/cidr 操作符添加选择率估计器，并改进文本检索函数的估计器（Emre Hasegeli、Tom Lane）
添加数据类型 regrole 和 regnamespace，以简化角色或命名空间 OID 的输入与美化打印（Kyotaro Horiguchi）
添加 jsonb 函数 jsonb_set() 和 jsonb_pretty()（Dmitry Dolgov、Andrew Dunstan、Petr Jelínek）
添加 jsonb 生成函数 to_jsonb()、jsonb_object()、jsonb_build_object()、jsonb_build_array()、jsonb_agg() 和 jsonb_object_agg()（Andrew Dunstan）
json 类型此前已有等效函数。
降低 json 与 jsonb 之间相互转换的转换要求（Tom Lane）
允许从 jsonb 文档中减去text、text 数组和 integer 值（Dmitry Dolgov、Andrew Dunstan）
添加 jsonb 的 || 操作符（Dmitry Dolgov、Andrew Dunstan）
添加 json_strip_nulls() 和 jsonb_strip_nulls() 函数，用于从文档中移除 JSON 空值（Andrew Dunstan）
为 numeric 值添加 generate_series()（Plato Malugin）
允许 array_agg() 和 ARRAY() 接受数组作为输入（Ali Akbar、Tom Lane）
添加函数 array_position() 和 array_positions()，用于返回数组值的下标（Pavel Stehule）
添加 point 到 polygon 的距离操作符 <->（Alexander Korotkov）
允许在 SIMILAR TO 和 SUBSTRING 中使用多字节字符作为转义符（Jeff Davis）
以前只允许单字节字符作为转义符。
", "text": "允许在 SIMILAR TO 和 SUBSTRING 中使用多字节字符作为转义符（Jeff Davis） 以前只允许单字节字符作为转义符。", "title": "允许在 SIMILAR TO 和 SUBSTRING 中使用多字节字符作为转义符", "commits": [], "section": "函数", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.9", "source_hash": "7c833d9ec107d169e7d78cbd9e13c1667025d6bfbcc8bcff4499cadeeb028e1e", "section_path": ["函数"], "commit_groups": [["8167a38"]], "identity_text": "Allow multibyte characters as escapes in SIMILAR TO and SUBSTRING (Jeff Davis) Previously, only a single-byte character was allowed as an escape.", "commit_aliases": ["8167a38"], "source_commits": ["8167a38"], "source_entry_id": "9.5.0/changes/095", "db_id": "3c473219df64e1b136d99e8a2de50320", "patch_ids": ["593bfd74b90631efb99be0dbd1e1380a"], "statement_hash": "0b5b91c1485f8986c34525658885daaa13d31ab150e647deb55192c30f9c8f1f", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-b9e7f371f3b7ca1a", "cves": [], "html": "添加 width_bucket() 的一个变体，支持任何可排序的数据类型和非均匀的桶宽（Petr Jelínek）
为 pg_read_file() 及相关函数添加可选的 missing_ok 参数（Michael Paquier、Heikki Linnakangas）
允许在函数调用中用 => 指定命名参数（Pavel Stehule）
以前只能使用 :=。这要求移除 => 作为用户定义操作符的可能。自 PostgreSQL 9.0 起，创建用户定义的 => 操作符就一直发出警告。
为使用 PostgreSQL 提供的舍入函数的平台添加符合 POSIX 的舍入（Pedro Gimeno Fortea）
", "text": "为使用 PostgreSQL 提供的舍入函数的平台添加符合 POSIX 的舍入（Pedro Gimeno Fortea）", "title": "为使用 PostgreSQL 提供的舍入函数的平台添加符合 POSIX 的舍入", "commits": [], "section": "函数", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.9", "source_hash": "25e8205535c8e0723fffc4dd75e3e4aa713f8dd3249939bc5bd705f37bd74f82", "section_path": ["函数"], "commit_groups": [["06bf0dd"]], "identity_text": "Add POSIX-compliant rounding for platforms that use PostgreSQL-supplied rounding functions (Pedro Gimeno Fortea)", "commit_aliases": ["06bf0dd"], "source_commits": ["06bf0dd"], "source_entry_id": "9.5.0/changes/099", "db_id": "21c4bf0e9a87dfc7ed4156693a05f7b0", "patch_ids": ["48857ab2c928904fd3cbddbf12c01c9c"], "statement_hash": "97cc0925a939051926bcb9f362665d1368e90fb656d8aa2f940fc58736ac9a0c", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-f4e6126cccb0efc5", "cves": [], "html": "添加函数 pg_get_object_address()（返回唯一标识对象的 OID）和函数 pg_identify_object_as_address()（基于 OID 返回对象信息）（Álvaro Herrera）
放宽在 pg_stat_activity 中查看查询、执行 pg_cancel_backend() 和执行 pg_terminate_backend() 的安全检查（Stephen Frost）
以前，只有拥有目标会话的那个特定角色才能执行这些操作；现在，是该角色的成员即可。
", "text": "放宽在 pg_stat_activity 中查看查询、执行 pg_cancel_backend() 和执行 pg_terminate_backend() 的安全检查（Stephen Frost） 以前，只有拥有目标会话的那个特定角色才能执行这些操作；现在，是该角色的成员即可。", "title": "放宽在 pg_stat_activity 中查看查询、执行 pg_cancel_backend() 和执行 pg_terminate_backend() 的安全检查", "commits": [], "section": "函数 / 系统信息函数和视图", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.9.3", "source_hash": "8a2cbce6b19ad96f10f130ea8bcb739f0332847bd540e17a8cddc6da389061cf", "section_path": ["函数", "系统信息函数和视图"], "commit_groups": [["bf03889"]], "identity_text": "Loosen security checks for viewing queries in pg_stat_activity, executing pg_cancel_backend(), and executing pg_terminate_backend() (Stephen Frost) Previously, only the specific role owning the target session could perform these operations; now membership in that role is sufficient.", "commit_aliases": ["bf03889"], "source_commits": ["bf03889"], "source_entry_id": "9.5.0/changes/101", "db_id": "1b5052c646a7d704d759d5593c04fbbc", "patch_ids": ["91138b084a4cf530cafa922c1ea4a737"], "statement_hash": "eec5017ef948b9344aeb897058ba990e7368dea781cff2975d68a1666f5dd723", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-1d06cf81dddcedd8", "cves": [], "html": "添加 pg_stat_get_snapshot_timestamp()，用于输出统计快照的时间戳（Matt Kelly）
它表示快照文件最后一次写入文件系统的时间。
", "text": "添加 pg_stat_get_snapshot_timestamp()，用于输出统计快照的时间戳（Matt Kelly） 它表示快照文件最后一次写入文件系统的时间。", "title": "添加 pg_stat_get_snapshot_timestamp()，用于输出统计快照的时间戳", "commits": [], "section": "函数 / 系统信息函数和视图", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.9.3", "source_hash": "e7826f0ed41afa0ffa097d410ce20d9185e46bb73717933f132b60d1c9482fbd", "section_path": ["函数", "系统信息函数和视图"], "commit_groups": [["2fb7a75"]], "identity_text": "Add pg_stat_get_snapshot_timestamp() to output the time stamp of the statistics snapshot (Matt Kelly) This represents the last time the snapshot file was written to the file system.", "commit_aliases": ["2fb7a75"], "source_commits": ["2fb7a75"], "source_entry_id": "9.5.0/changes/102", "db_id": "2237fe392a0ee774a96bf86d74c35a46", "patch_ids": ["df4ae36deec70d8d69731e4b6db18b3f"], "statement_hash": "2ecc4af871a74582262402797262922ec5246b6dc300f03a883c7fc39b622e25", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-d2b456f7305d04b3", "cves": [], "html": "添加 mxid_age()，用于计算多事务 ID 的年龄（Bruce Momjian）
为 inet/cidr 数据类型添加 min()/max() 聚合（Haribabu Kommi）
在支持的平台上，使用 128 位整数作为某些聚合函数的累加器（Andreas Karlsson）
", "text": "在支持的平台上，使用 128 位整数作为某些聚合函数的累加器（Andreas Karlsson）", "title": "在支持的平台上，使用 128 位整数作为某些聚合函数的累加器", "commits": [], "section": "函数 / 聚合", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.9.4", "source_hash": "707b096778f4675716abb4fd3577b9618e958e78ebf3cccbe99c06f9f11a30ce", "section_path": ["函数", "聚合"], "commit_groups": [["8122e14"], ["959277a"]], "identity_text": "Use 128-bit integers, where supported, as accumulators for some aggregate functions (Andreas Karlsson)", "commit_aliases": ["8122e14", "959277a"], "source_commits": ["8122e14", "959277a"], "source_entry_id": "9.5.0/changes/105", "db_id": "824ff2982e52fed918bc92b4d92c12e7", "patch_ids": ["3b1e99ddd67e01f7f54f9617a805a823", "729f36f3d2856a4284579c267491d18a"], "statement_hash": "cdac3d502ce0678e472c5bcf743a95dd54ea5478beadd18351dbc6534b85d629", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-afe1901a74931826", "cves": [], "html": "改进PL/Python对组合类型的支持（Ed Behn、Ronan Dunklau）
\n这允许 PL/Python 函数返回组合类型的数组。
", "text": "改进PL/Python对组合类型的支持（Ed Behn、Ronan Dunklau） 这允许 PL/Python 函数返回组合类型的数组。", "title": "改进PL/Python对组合类型的支持", "commits": [], "section": "服务器端语言", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.10", "source_hash": "15661ca372b4cc4a0bbefe876302ce083b4336323fbcbd4d1468d8e6776300d8", "section_path": ["服务器端语言"], "commit_groups": [["8b6010b"]], "identity_text": "Improve support for composite types in PL/Python (Ed Behn, Ronan Dunklau) This allows PL/Python functions to return arrays of composite types.", "commit_aliases": ["8b6010b"], "source_commits": ["8b6010b"], "source_entry_id": "9.5.0/changes/106", "db_id": "a72381c9135349e2330463dcf08f6b4d", "patch_ids": ["df4badd790f2191bbcdf33c8fcfb4d80"], "statement_hash": "e9da78ce50172af36d52751669e3031e09ebe01f63232012893622f126556592", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-174d069281e9e9b8", "cves": [], "html": "降低PL/Python浮点值转换的精度损失（Marko Kreen）
", "text": "降低PL/Python浮点值转换的精度损失（Marko Kreen）", "title": "降低PL/Python浮点值转换的精度损失", "commits": [], "section": "服务器端语言", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.10", "source_hash": "4e9b72f88bf0834fabbf649f44ed857c8a69e2eccc9d7f37a60b5f58f0ea1c5a", "section_path": ["服务器端语言"], "commit_groups": [["1ce7a57"]], "identity_text": "Reduce lossiness of PL/Python floating-point value conversions (Marko Kreen)", "commit_aliases": ["1ce7a57"], "source_commits": ["1ce7a57"], "source_entry_id": "9.5.0/changes/107", "db_id": "724c3d755ab5d83229da82d27302f1b3", "patch_ids": ["27d291d0326a750839f26b7a1ab46048"], "statement_hash": "374739fbd69db0102df646e1bd391c898ca9d74a016600d387c4475774d27dba", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-971baa2998f05a5d", "cves": [], "html": "允许指定 SQL 数据类型与过程语言数据类型之间的转换例程（Peter Eisentraut）
\n此变更添加了新命令 CREATE/DROP TRANSFORM。它还添加了hstore和ltree类型与PL/Perl和PL/Python之间的可选转换。
改进PL/pgSQL的数组性能（Tom Lane）
", "text": "改进PL/pgSQL的数组性能（Tom Lane）", "title": "改进PL/pgSQL的数组性能", "commits": [], "section": "服务器端语言 / PL/pgSQL Server-Side Language", "category": "performance", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.10.3", "source_hash": "4bde8306770c7fb9f91d178fc1ac9af57426cbced18191d26b822cb00cfb8328", "section_path": ["服务器端语言", "PL/pgSQL Server-Side Language"], "commit_groups": [["1dc5ebc"], ["56a79a8"], ["9e3ad1a"], ["e983c4d"]], "identity_text": "Improve PL/pgSQL array performance (Tom Lane)", "commit_aliases": ["1dc5ebc", "56a79a8", "9e3ad1a", "e983c4d"], "source_commits": ["1dc5ebc", "56a79a8", "9e3ad1a", "e983c4d"], "source_entry_id": "9.5.0/changes/109", "db_id": "2a4086025d35c201416bddbc41e33184", "patch_ids": ["0c899841948d22ea55115921f615a0f4", "78c5321bc194dc05453b7879b2987d3f", "b57b1cbcee3b626709146b4857e397fa", "fe4c37d33343439b831c5aec5b6167f0"], "statement_hash": "e603b5d51d2866a41f0de039ec01cd9a3d13f9c100423e0ff4fb95dc32c02d52", "relations": [], "version": "9.5.0", "category_label": "性能改进", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-a7714db92dacec8a", "cves": [], "html": "在 PL/pgSQL 中添加 ASSERT 语句（Pavel Stehule）
允许更多PL/pgSQL关键字用作标识符（Tom Lane）
", "text": "允许更多PL/pgSQL关键字用作标识符（Tom Lane）", "title": "允许更多PL/pgSQL关键字用作标识符", "commits": [], "section": "服务器端语言 / PL/pgSQL Server-Side Language", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.10.3", "source_hash": "da651777bde9c4dd31e230cdf5f188b02fc9502deacd1ceed90985e0556ad694", "section_path": ["服务器端语言", "PL/pgSQL Server-Side Language"], "commit_groups": [["bb1b8f6"]], "identity_text": "Allow more PL/pgSQL keywords to be used as identifiers (Tom Lane)", "commit_aliases": ["bb1b8f6"], "source_commits": ["bb1b8f6"], "source_entry_id": "9.5.0/changes/111", "db_id": "94dc1a7510afb84630780526cc268c33", "patch_ids": ["d70f6f09d3884f26f2f5d4f45ec6f044"], "statement_hash": "f111b7a90304244ca536c50f2ea96e2bb610927b2eb7c91ef723e42b0f5d3650", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-b9757ea22686d981", "cves": [], "html": "把pg_archivecleanup、pg_test_fsync、pg_test_timing和pg_xlogdump从 contrib 移到 src/bin（Peter Eisentraut）
这应使这些程序在大多数安装中默认被安装。
", "text": "把pg_archivecleanup、pg_test_fsync、pg_test_timing和pg_xlogdump从 contrib 移到 src/bin（Peter Eisentraut） 这应使这些程序在大多数安装中默认被安装。", "title": "把pg_archivecleanup、pg_test_fsync、pg_test_timing和pg_xlogdump从 contrib 移到 src/bin", "commits": [], "section": "客户端应用程序", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11", "source_hash": "dac84b8f7539476942c83264910e4170f37f233d34a7847e0bbd50c557318b07", "section_path": ["客户端应用程序"], "commit_groups": [["00882d9"], ["528c2e4"], ["83aca89"], ["b0a738f"]], "identity_text": "Move pg_archivecleanup, pg_test_fsync, pg_test_timing, and pg_xlogdump from contrib to src/bin (Peter Eisentraut) This should result in these programs being installed by default in most installations.", "commit_aliases": ["00882d9", "528c2e4", "83aca89", "b0a738f"], "source_commits": ["00882d9", "528c2e4", "83aca89", "b0a738f"], "source_entry_id": "9.5.0/changes/112", "db_id": "a72f1f1c0d935c6f18d34effd77f4d1d", "patch_ids": ["314d4cd13dd985c09a55afe3a6c7ef97", "4bf9cdd7787053a0760c8b9741bcdd0d", "c9af4c351a3775fb289bc48ad4bf9a70", "d764169e3d85a71fea41a78dfb1507b3"], "statement_hash": "1d4c6246a53779e55be75ff0abe8afe25267b11dda9f0d570c1f037adb6af290", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-272b7d921010af8f", "cves": [], "html": "添加pg_rewind，它允许在故障回切后重新同步主服务器（Heikki Linnakangas）
", "text": "添加pg_rewind，它允许在故障回切后重新同步主服务器（Heikki Linnakangas）", "title": "添加pg_rewind，它允许在故障回切后重新同步主服务器", "commits": [], "section": "客户端应用程序", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11", "source_hash": "fecd4acdc5544a5fe35df8be3eaa8cc93e29fb342883b360f2ccd1d017a20e37", "section_path": ["客户端应用程序"], "commit_groups": [["61081e7"]], "identity_text": "Add pg_rewind, which allows re-synchronizing a master server after failback (Heikki Linnakangas)", "commit_aliases": ["61081e7"], "source_commits": ["61081e7"], "source_entry_id": "9.5.0/changes/113", "db_id": "dae12f156a5faf674445ca24d959613c", "patch_ids": ["fed60089254b5e4a2f030865f6e6a47d"], "statement_hash": "b9803a8eab55b2706f3125a1f5894051c043dfcc5222cce38172890ec9922b7b", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-b76a1bda89547ed0", "cves": [], "html": "允许pg_receivexlog管理物理复制槽（Michael Paquier）
\n这通过新的 --create-slot 和 --drop-slot 选项控制。
允许pg_receivexlog使用新的 --synchronous 选项同步刷写 WAL 到存储（Furuya Osamu、Fujii Masao）
若不使用该选项，WAL 文件只在关闭时被 fsync。
", "text": "允许pg_receivexlog使用新的 --synchronous 选项同步刷写 WAL 到存储（Furuya Osamu、Fujii Masao） 若不使用该选项，WAL 文件只在关闭时被 fsync。", "title": "允许pg_receivexlog使用新的 --synchronous 选项同步刷写 WAL 到存储", "commits": [], "section": "客户端应用程序", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11", "source_hash": "e8404ffa2d7bd701d04aea2faccaa80ce30b5e3c8a63bb794299977185ae5257", "section_path": ["客户端应用程序"], "commit_groups": [["c4f99d2"]], "identity_text": "Allow pg_receivexlog to synchronously flush WAL to storage using new --synchronous option (Furuya Osamu, Fujii Masao) Without this, WAL files are fsync'ed only on close.", "commit_aliases": ["c4f99d2"], "source_commits": ["c4f99d2"], "source_entry_id": "9.5.0/changes/115", "db_id": "c89acc451869584da78182a73b048fa3", "patch_ids": ["4c9330b6b6d8dae5fd480be95f89c9da"], "statement_hash": "4b523ea3c3c1cc8b8b18aa3964bc6074dc95eb5a9aee8b80a92715c9d25a51ed", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-a8563d9f240e287e", "cves": [], "html": "允许vacuumdb使用新的 --jobs 选项并行清理（Dilip Kumar）
在vacuumdb中，当需要多个连接时不再重复提示输入同一密码（Haribabu Kommi、Michael Paquier）
", "text": "在vacuumdb中，当需要多个连接时不再重复提示输入同一密码（Haribabu Kommi、Michael Paquier）", "title": "在vacuumdb中，当需要多个连接时不再重复提示输入同一密码", "commits": [], "section": "客户端应用程序", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11", "source_hash": "c7c27119524849a7b5e646d3581d7a2afe9f1591dcf9ab9b7f7f568ad6d4b60e", "section_path": ["客户端应用程序"], "commit_groups": [["5094da9"]], "identity_text": "In vacuumdb, do not prompt for the same password repeatedly when multiple connections are necessary (Haribabu Kommi, Michael Paquier)", "commit_aliases": ["5094da9"], "source_commits": ["5094da9"], "source_entry_id": "9.5.0/changes/117", "db_id": "67c6ad463bb370b5dfbac354dd7d1925", "patch_ids": ["b39c6b83d7ba2480eea8cc78c71fb910"], "statement_hash": "435033ce2b8e4d1ba53f9c35cda4320de02c553a4650f35c4d06a0d9f4a5ae06", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-776734b4b144288e", "cves": [], "html": "为reindexdb添加 --verbose 选项（Sawada Masahiko）
使pg_basebackup在使用 tar 格式时使用表空间映射文件，以支持 MS Windows 上的符号链接和 100 字符以上的文件路径（Amit Kapila）
", "text": "使pg_basebackup在使用 tar 格式时使用表空间映射文件，以支持 MS Windows 上的符号链接和 100 字符以上的文件路径（Amit Kapila）", "title": "使pg_basebackup在使用 tar 格式时使用表空间映射文件，以支持 MS Windows 上的符号链接和 100 字符以上的文件路径", "commits": [], "section": "客户端应用程序", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11", "source_hash": "113a1ca25a6fa33228e11ff1edc06bb2583153e8195ace7608aaf02002142446", "section_path": ["客户端应用程序"], "commit_groups": [["72d422a"]], "identity_text": "Make pg_basebackup use a tablespace mapping file when using tar format, to support symbolic links and file paths of 100+ characters in length on MS Windows (Amit Kapila)", "commit_aliases": ["72d422a"], "source_commits": ["72d422a"], "source_entry_id": "9.5.0/changes/119", "db_id": "fad5aa9be8cf1729dd27fd3cba372381", "patch_ids": ["690d079a8e91566658d3a83c238ae77e"], "statement_hash": "df9ff914c270d61d98515f66fc679053b8289772ef743ffb3a0d61230a832d49", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-f5c00b2b4b08ee8c", "cves": [], "html": "为pg_xlogdump添加 --stats 选项，用于显示摘要统计（Abhijit Menon-Sen）
允许 psql 生成 AsciiDoc 输出（Szymon Guz）
", "text": "允许 psql 生成 AsciiDoc 输出（Szymon Guz）", "title": "允许 psql 生成 AsciiDoc 输出", "commits": [], "section": "客户端应用程序 / psql", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.3", "source_hash": "40c4a27b76a26b3a06e7d611790de3b6200b283cc48bfbf20d84556dd1d929e0", "section_path": ["客户端应用程序", "psql"], "commit_groups": [["9d9991c"]], "identity_text": "Allow psql to produce AsciiDoc output (Szymon Guz)", "commit_aliases": ["9d9991c"], "source_commits": ["9d9991c"], "source_entry_id": "9.5.0/changes/121", "db_id": "61c7420bb41d28bde8743505a3fd4669", "patch_ids": ["8cb7e1828c10f2c798c1b65de140d394"], "statement_hash": "5b1d7bc38a93884f3f1c9ed5b6befd855aa68898e8eb5ce9a6017298ba02fc11", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-18211a7815dd87fb", "cves": [], "html": "为 psql 的 ECHO 变量添加 errors 模式，只显示失败的命令（Pavel Stehule）
该行为也可以通过 psql 的 -b 选项选择。
在 psql 的 unicode 线型中提供对列、表头和边框线型的分别控制（Pavel Stehule）
\n支持单线或双线；默认为 single。
在 psql 的 PROMPT 变量中添加新选项 %l，用于显示当前多行语句的行号（Sawada Masahiko）
添加 \\pset 选项 pager_min_lines，用于控制分页器的调用（Andrew Dunstan）
改进 psql 在决定是否调用分页器时使用的行数统计（Andrew Dunstan）
", "text": "改进 psql 在决定是否调用分页器时使用的行数统计（Andrew Dunstan）", "title": "改进 psql 在决定是否调用分页器时使用的行数统计", "commits": [], "section": "客户端应用程序 / psql", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.3", "source_hash": "c41a926c6db7df6419debd2ceec1fbf338fdc029ac682d1aa1121632bfb7347f", "section_path": ["客户端应用程序", "psql"], "commit_groups": [["4077fb4"]], "identity_text": "Improve psql line counting used when deciding to invoke the pager (Andrew Dunstan)", "commit_aliases": ["4077fb4"], "source_commits": ["4077fb4"], "source_entry_id": "9.5.0/changes/126", "db_id": "997bb844703fca9e5e16f07ce7624ed7", "patch_ids": ["2bf5fd8ba5ba46f26845c464f338cb69"], "statement_hash": "956f6a9add2a31852c2609d763104aa4a19048cd2c3d1e63e69184283bf350d1", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-f81e91b4d8af9ef8", "cves": [], "html": "如果 --output 或 --log-file 开关指定的文件无法写入，psql 现在会失败（Tom Lane、Daniel Vérité）
以前在这种情况下它实际上会忽略该开关。
", "text": "如果 --output 或 --log-file 开关指定的文件无法写入，psql 现在会失败（Tom Lane、Daniel Vérité） 以前在这种情况下它实际上会忽略该开关。", "title": "如果 --output 或 --log-file 开关指定的文件无法写入，psql 现在会失败", "commits": [], "section": "客户端应用程序 / psql", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.3", "source_hash": "a777fb5334b53f98a4c673f7b05e0a71f00f3eef131c91b026c5ce6658b86b9a", "section_path": ["客户端应用程序", "psql"], "commit_groups": [["07338cb"], ["e90371d"]], "identity_text": "psql now fails if the file specified by an --output or --log-file switch cannot be written (Tom Lane, Daniel Vérité) Previously, it effectively ignored the switch in such cases.", "commit_aliases": ["07338cb", "e90371d"], "source_commits": ["07338cb", "e90371d"], "source_entry_id": "9.5.0/changes/127", "db_id": "430cf100b551b4ee887e2f5dda782fe3", "patch_ids": ["303ed2589f8ce53a3f9d0d7146bba921", "71bf8a43afc6e658fef7ad09919f08d5"], "statement_hash": "a60f18ca50e5d63238cdec091a6da8e9cec86100d8da35594ce8a9a83c116e74", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-ba53c80f50356a2b", "cves": [], "html": "为设置search_path变量添加 psql Tab 补全（Jeff Janes）
\n目前只有第一个模式可以被 Tab 补全。
", "text": "为设置search_path变量添加 psql Tab 补全（Jeff Janes） 目前只有第一个模式可以被 Tab 补全。", "title": "为设置search_path变量添加 psql Tab 补全", "commits": [], "section": "客户端应用程序 / psql", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.3", "source_hash": "665d407edc536ee0e857731de8e3f9c4d7f40645770993c400757a8b6a57a1fb", "section_path": ["客户端应用程序", "psql"], "commit_groups": [["bd40951"]], "identity_text": "Add psql tab completion when setting the guc-search-path variable (Jeff Janes) Currently only the first schema can be tab-completed.", "commit_aliases": ["bd40951"], "source_commits": ["bd40951"], "source_entry_id": "9.5.0/changes/128", "db_id": "d9fda2f7f82049d8288a768bd91a8273", "patch_ids": ["6de5d8b80f493a920e196674b5db33f5"], "statement_hash": "5441a847099eafe8dbc7245b554c14c9bc783b8a9bc36e025d4cb35450fde295", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-33ce04bb4315a033", "cves": [], "html": "改进 psql 对触发器和规则的 Tab 补全（Andreas Karlsson）
", "text": "改进 psql 对触发器和规则的 Tab 补全（Andreas Karlsson）", "title": "改进 psql 对触发器和规则的 Tab 补全", "commits": [], "section": "客户端应用程序 / psql", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.3", "source_hash": "e84cbcc816bd316ba0af573e78635ab715cf437185b474f26d2ceae042cb738e", "section_path": ["客户端应用程序", "psql"], "commit_groups": [["631e7f6"]], "identity_text": "Improve psql's tab completion for triggers and rules (Andreas Karlsson)", "commit_aliases": ["631e7f6"], "source_commits": ["631e7f6"], "source_entry_id": "9.5.0/changes/129", "db_id": "ec97ba66ad4f4791a0af4dd40a42bf27", "patch_ids": ["f3046753d54f5e6efe19159da34d98d9"], "statement_hash": "7875e696983183353ed58ee6ac46cc63f7e702afd8bb06e8c72ff59a9c7ff375", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-340ad54b3eb03993", "cves": [], "html": "为 psql 的 \\? 帮助添加 variables 和 options 小节（Pavel Stehule）
\\? variables 显示 psql 的特殊变量，\\? options 显示命令行选项。\\? commands 显示元命令，这是传统输出，仍为默认。这些帮助显示也可以通过命令行选项 --help= 获取。section
在 psql 的 \\db+ 中显示表空间大小（Fabrízio de Royes Mello）
在 psql 的 \\dT+ 中显示数据类型的拥有者（Magnus Hagander）
允许 psql 的 \\watch 输出 \\timing 信息（Fujii Masao）
同时防止 --echo-hidden 回显 \\watch 查询，因为这通常是不需要的。
使 psql 的 \\sf 和 \\ef 命令遵循 ECHO_HIDDEN（Andrew Dunstan）
改进 psql 对 \\set、\\unset 和 :variable 名称的 Tab 补全（Pavel Stehule）
允许在 psql 的 \\c 命令中 Tab 补全角色名（Ian Barwick）
允许 pg_dump 使用 --snapshot 共享另一个会话取得的快照（Simon Riggs、Michael Paquier）
远程快照必须是由 pg_export_snapshot() 或逻辑复制槽创建所导出的。这可用于在多个 pg_dump 进程之间共享一致的快照。
支持 tar 归档格式中超过 8GB 的表（Tom Lane）
\nPOSIX 的 tar 格式标准不允许 tar 归档的元素超过 8GB，但大多数现代 tar 实现支持一个允许超过该限制的扩展。必要时使用扩展格式，而不是失败。
", "text": "支持 tar 归档格式中超过 8GB 的表（Tom Lane） POSIX 的 tar 格式标准不允许 tar 归档的元素超过 8GB，但大多数现代 tar 实现支持一个允许超过该限制的扩展。必要时使用扩展格式，而不是失败。", "title": "支持 tar 归档格式中超过 8GB 的表", "commits": [], "section": "客户端应用程序 / pg_dump", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.4", "source_hash": "fedf067b57cc4c1642f5c9a1a5ae80fcfe4e4b6039d8d9696a604e19c0270030", "section_path": ["客户端应用程序", "pg_dump"], "commit_groups": [["5f5e68b"]], "identity_text": "Support table sizes exceeding 8GB in tar archive format (Tom Lane) The POSIX standard for tar format does not allow elements of a tar archive to exceed 8GB, but most modern implementations of tar support an extension that does allow it. Use the extension format when necessary, rather than failing.", "commit_aliases": ["5f5e68b"], "source_commits": ["5f5e68b"], "source_entry_id": "9.5.0/changes/138", "db_id": "f383c7e9ad9ec10560ab185e01c34b8d", "patch_ids": ["649b94ec9206b7a616abf2708b3aad3f"], "statement_hash": "7bcc5e9850992053c6813a8419d6a8ee75bfae20b01297daf286556903a2b59b", "relations": [{"rule": 2, "type": "related", "target": "4e3f89c03416acc7e4b32ecb6ddaa0a7", "evidence": {"same_day": false, "patch_ids": ["649b94ec9206b7a616abf2708b3aad3f"]}}], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "4e3f89c03416acc7e4b32ecb6ddaa0a7", "kind": "related", "version": "9.4.6", "label": "9.4.6", "title": "在 pg_dump 和 pg_basebackup 中，采用 GNU 约定来处理超过 8GB 的 tar 归档成员", "evidence": {"same_day": false, "patch_ids": ["649b94ec9206b7a616abf2708b3aad3f"]}, "url": "/docs/compare/?release=9.4.6#9.4.6-1c89c97d21ad6317", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}]}, {"id": "9.5.0-afc7f9b1fda0c880", "cves": [], "html": "使 pg_dump 始终打印服务器和 pg_dump 的版本（Jing Wang）
\n以前，版本信息只在 --verbose 模式下打印。
从 pg_dump、pg_dumpall 和 pg_restore 中移除早已被忽略的 -i/--ignore-version 选项（Fujii Masao）
支持多个 pg_ctl 的 -o 选项，将其值串联（Bruce Momjian）
允许在 MS Windows 上控制 pg_ctl 的事件源日志（MauMau）
\n这只控制 pg_ctl，不控制服务器；服务器在 postgresql.conf 中有单独的设置。
如果服务器的监听地址设置为通配值（IPv4 的 0.0.0.0 或 IPv6 的 ::），则通过回环地址连接，而不是尝试按字面使用通配地址（Kondo Yuta）
此修复主要影响 Windows，因为在其他平台上 pg_ctl 会优先使用 Unix 域套接字。
", "text": "如果服务器的监听地址设置为通配值（IPv4 的 0.0.0.0 或 IPv6 的 ::），则通过回环地址连接，而不是尝试按字面使用通配地址（Kondo Yuta） 此修复主要影响 Windows，因为在其他平台上 pg_ctl 会优先使用 Unix 域套接字。", "title": "如果服务器的监听地址设置为通配值（IPv4 的 0.0.0.0 或 IPv6 的 ::），则通过回环地址连接，而不是尝试按字面使用通配地址", "commits": [], "section": "客户端应用程序 / pg_ctl", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.5", "source_hash": "1ab4415900bdbf7890cf039278dfdba05035450208c910358e0eb7a4f31d6a7d", "section_path": ["客户端应用程序", "pg_ctl"], "commit_groups": [["bdb42ba"]], "identity_text": "If the server's listen address is set to a wildcard value (0.0.0.0 in IPv4 or :: in IPv6), connect via the loopback address rather than trying to use the wildcard address literally (Kondo Yuta) This fix primarily affects Windows, since on other platforms pg_ctl will prefer to use a Unix-domain socket.", "commit_aliases": ["bdb42ba"], "source_commits": ["bdb42ba"], "source_entry_id": "9.5.0/changes/143", "db_id": "eecc5aaa6765bfe268eb07d9fa8f853b", "patch_ids": ["d4f9858b4d92fd34521494ae8ded6e57"], "statement_hash": "2f1b257fd5d636a1c3a2eef1e1a2df9fe1fdd0cd912c667f42d6646ae5de99dc", "relations": [{"rule": 2, "type": "related", "target": "31b49007fe1571a1ebbd1c79f0557c22", "evidence": {"same_day": false, "patch_ids": ["d4f9858b4d92fd34521494ae8ded6e57"]}}], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": [{"db_id": "31b49007fe1571a1ebbd1c79f0557c22", "kind": "related", "version": "9.4.6", "label": "9.4.6", "title": "在 pg_ctl start -w 中，不再尝试使用通配监听地址连接 postmaster", "evidence": {"same_day": false, "patch_ids": ["d4f9858b4d92fd34521494ae8ded6e57"]}, "url": "/docs/compare/?release=9.4.6#9.4.6-fedb61d027839e17", "source_url": "/docs/release/9.4.6/#id-1.11.6.25.5"}]}, {"id": "9.5.0-9834957e39a9e9dc", "cves": [], "html": "把 pg_upgrade 从 contrib 移到 src/bin（Peter Eisentraut）
与此变更相关，先前由 pg_upgrade_support 模块提供的功能已被移入核心服务器。
", "text": "把 pg_upgrade 从 contrib 移到 src/bin（Peter Eisentraut） 与此变更相关，先前由 pg_upgrade_support 模块提供的功能已被移入核心服务器。", "title": "把 pg_upgrade 从 contrib 移到 src/bin", "commits": [], "section": "客户端应用程序 / pg_upgrade", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.6", "source_hash": "cf2adbde9e81dbbf0b34f4c80b585fa1c7c78b0d38687f96ddc6c6f4f8349842", "section_path": ["客户端应用程序", "pg_upgrade"], "commit_groups": [["9fa8b0e"]], "identity_text": "Move pg_upgrade from contrib to src/bin (Peter Eisentraut) In connection with this change, the functionality previously provided by the pg_upgrade_support module has been moved into the core server.", "commit_aliases": ["9fa8b0e"], "source_commits": ["9fa8b0e"], "source_entry_id": "9.5.0/changes/144", "db_id": "50fb83702e984de6a0284979be191f49", "patch_ids": ["3b3645bc1ff4dffa739eda7b03145fc6"], "statement_hash": "6d909d584d55365fd19988a3b40cf442d0937d77a54a9e19ea60596b8279ed70", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-469e0ee539e43150", "cves": [], "html": "支持多个 pg_upgrade 的 -o/-O 选项，将其值串联（Bruce Momjian）
改进 pg_upgrade 中的数据库排序规则比较（Heikki Linnakangas）
", "text": "改进 pg_upgrade 中的数据库排序规则比较（Heikki Linnakangas）", "title": "改进 pg_upgrade 中的数据库排序规则比较", "commits": [], "section": "客户端应用程序 / pg_upgrade", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.6", "source_hash": "d22265138092ad89a24fe71fb5509870a1b8269e9efe8c370fe3642dd28393c6", "section_path": ["客户端应用程序", "pg_upgrade"], "commit_groups": [["33755e8"]], "identity_text": "Improve database collation comparisons in pg_upgrade (Heikki Linnakangas)", "commit_aliases": ["33755e8"], "source_commits": ["33755e8"], "source_entry_id": "9.5.0/changes/146", "db_id": "ecef73e1291c6ff36b7a7558e558e6a5", "patch_ids": ["ebb967a8bf89a93635538476fcb902bf"], "statement_hash": "d8c344c7cc1316d46e22f32def9697ed977f6b5ea360ea1437e0beb10610f2bd", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-4536a56e8d60b5fd", "cves": [], "html": "移除从 8.3 集群升级的支持（Bruce Momjian）
", "text": "移除从 8.3 集群升级的支持（Bruce Momjian）", "title": "移除从 8.3 集群升级的支持", "commits": [], "section": "客户端应用程序 / pg_upgrade", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.6", "source_hash": "fe1cd22d451851321ce4b10707b27a6938ddd48e84417b1d5b6e03ceedc94489", "section_path": ["客户端应用程序", "pg_upgrade"], "commit_groups": [["2209b39"]], "identity_text": "Remove support for upgrading from 8.3 clusters (Bruce Momjian)", "commit_aliases": ["2209b39"], "source_commits": ["2209b39"], "source_entry_id": "9.5.0/changes/147", "db_id": "b143b90f314fd5e281177bdf527941be", "patch_ids": ["241ab73404aeeba44ecd153a85dccfd4"], "statement_hash": "4abfcf2f6a20a2696e2e1451692bc1823623d41c2f4cdfb78fe8f6121353dce3", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-a2a677906aa6a859", "cves": [], "html": "把 pgbench 从 contrib 移到 src/bin（Peter Eisentraut）
修复“excluding connections establishing”（排除连接建立）的 TPS 数值的计算（Tatsuo Ishii、Fabien Coelho）
\n每当 pgbench 线程数少于客户端连接数时，连接建立的开销就会被算错。虽然这显然是个 bug，但我们不会把它回移植到 9.5 之前的分支，因为这会使 TPS 数值无法与以前的结果比较。
", "text": "修复“excluding connections establishing”（排除连接建立）的 TPS 数值的计算（Tatsuo Ishii、Fabien Coelho） 每当 pgbench 线程数少于客户端连接数时，连接建立的开销就会被算错。虽然这显然是个 bug，但我们不会把它回移植到 9.5 之前的分支，因为这会使 TPS 数值无法与以前的结果比较。", "title": "修复“excluding connections establishing”（排除连接建立）的 TPS 数值的计算", "commits": [], "section": "客户端应用程序 / pgbench", "category": "bugfix", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.11.7", "source_hash": "53c1d3b99cb32245802a59c448d4194a3fa76420912b2ec6a1785447b2021b90", "section_path": ["客户端应用程序", "pgbench"], "commit_groups": [["3c4c5ac"]], "identity_text": "Fix calculation of TPS number excluding connections establishing (Tatsuo Ishii, Fabien Coelho) The overhead for connection establishment was miscalculated whenever the number of pgbench threads was less than the number of client connections. Although this is clearly a bug, we won't back-patch it into pre-9.5 branches since it makes TPS numbers not comparable to previous results.", "commit_aliases": ["3c4c5ac"], "source_commits": ["3c4c5ac"], "source_entry_id": "9.5.0/changes/149", "db_id": "735b59374271e56481933ef1894e65a9", "patch_ids": ["a0670cb627ae711ac07cb6d52ec17073"], "statement_hash": "8994714d6ba7894d2982b66d085f1f07117200e87a2f5fa71a9a028140706a17", "relations": [], "version": "9.5.0", "category_label": "BUG 修复", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-5e06fefc7c5addf7", "cves": [], "html": "允许统计超过指定时间的 pgbench 事务（Fabien Coelho）
\n这由新的 --latency-limit 选项控制。
允许 pgbench 使用 \\setrandom 生成高斯/指数分布（Kondo Mitsumasa、Fabien Coelho）
允许 pgbench 的 \\set 命令处理包含多个操作符的算术表达式，并向其支持的操作符集合添加 %（取模）（Robert Haas、Fabien Coelho）
简化 WAL 记录格式（Heikki Linnakangas）
\n这使外部工具更容易跟踪哪些块被修改。
", "text": "简化 WAL 记录格式（Heikki Linnakangas） 这使外部工具更容易跟踪哪些块被修改。", "title": "简化 WAL 记录格式", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "08c9f117b32f390548b431a7c7fafedb25589f063cc69d4ebafe5c9eceb3b182", "section_path": ["源代码"], "commit_groups": [["2c03216"]], "identity_text": "Simplify WAL record format (Heikki Linnakangas) This allows external tools to more easily track what blocks are modified.", "commit_aliases": ["2c03216"], "source_commits": ["2c03216"], "source_entry_id": "9.5.0/changes/153", "db_id": "20aee3deae5ffbeb0a7b89e9c15790fe", "patch_ids": ["b807de3ad2ede9ecad666244a1ea6df6"], "statement_hash": "e86e8ca5f2e15fcd448abd71b76d9ebf430884f44d9bd130918155adadc27982", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-9e9455bf7d870291", "cves": [], "html": "改进事务提交和中止 WAL 记录的表示（Andres Freund）
", "text": "改进事务提交和中止 WAL 记录的表示（Andres Freund）", "title": "改进事务提交和中止 WAL 记录的表示", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "991c6ac214660cafd8236b60edc3493b62b931e4f19130469bb3ef6707c78023", "section_path": ["源代码"], "commit_groups": [["4f1b890"]], "identity_text": "Improve the representation of transaction commit and abort WAL records (Andres Freund)", "commit_aliases": ["4f1b890"], "source_commits": ["4f1b890"], "source_entry_id": "9.5.0/changes/154", "db_id": "d54f1416a7f49bce3ba242a28820d51c", "patch_ids": ["59987e1c530f4f479c95e457feb98627"], "statement_hash": "58cc05b37d9e05ed7499e302f1ff4aa1b3c94bdda6fbedb1db2dc410027f201f", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-c103934fc2a15613", "cves": [], "html": "添加原子内存操作 API（Andres Freund）
", "text": "添加原子内存操作 API（Andres Freund）", "title": "添加原子内存操作 API", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "487e47abfb09a520df4017d9c7e50a1db6555bccdabcd34a953cced29edd7c5f", "section_path": ["源代码"], "commit_groups": [["b64d92f"]], "identity_text": "Add atomic memory operations API (Andres Freund)", "commit_aliases": ["b64d92f"], "source_commits": ["b64d92f"], "source_entry_id": "9.5.0/changes/155", "db_id": "98a985d6f0321fc27223053950f9b5f5", "patch_ids": ["a348b29745d46b12466681c6331f1654"], "statement_hash": "fb7c1229d52a13a0862f6b7b75a3f0e98c27f097938aba410720adf1ee3fd83f", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-636a7af9e737bb3a", "cves": [], "html": "允许自定义路径和扫描方法（KaiGai Kohei、Tom Lane）
\n这允许扩展对优化器和执行器进行更大的控制。
", "text": "允许自定义路径和扫描方法（KaiGai Kohei、Tom Lane） 这允许扩展对优化器和执行器进行更大的控制。", "title": "允许自定义路径和扫描方法", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "4946a74501b506de935d5484d6cb066afdf1e9e1ad0eb6a33dd1cd5de7e3c3dd", "section_path": ["源代码"], "commit_groups": [["0b03e59"], ["4477704"], ["a34fa8e"], ["c2ea228"]], "identity_text": "Allow custom path and scan methods (KaiGai Kohei, Tom Lane) This allows extensions greater control over the optimizer and executor.", "commit_aliases": ["0b03e59", "4477704", "a34fa8e", "c2ea228"], "source_commits": ["0b03e59", "4477704", "a34fa8e", "c2ea228"], "source_entry_id": "9.5.0/changes/156", "db_id": "d348901b6726c7ea62cbac3e421bd228", "patch_ids": ["2de3bb56fe387c57e4d5cc2307acae1b", "55d1a71f09ddcd57dfb2519a59a3dfa8", "a0231ff31a5ad87db539e33cddde9a43", "d91d36d2723a96dde2a2d1bbef84574d"], "statement_hash": "a8e7ead7c967f524e6bc399d1cd96b84614b40706b952b0a3e5cdfc73fe6b56b", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-6f8168aba914f305", "cves": [], "html": "允许外部数据包装器执行过滤后锁定（Etsuro Fujita）
", "text": "允许外部数据包装器执行过滤后锁定（Etsuro Fujita）", "title": "允许外部数据包装器执行过滤后锁定", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "17537f880a3ee317cdcb96b382f987fa71ccb4eaf3b23b475ce416776ea2f98e", "section_path": ["源代码"], "commit_groups": [["afb9249"]], "identity_text": "Allow foreign data wrappers to do post-filter locking (Etsuro Fujita)", "commit_aliases": ["afb9249"], "source_commits": ["afb9249"], "source_entry_id": "9.5.0/changes/157", "db_id": "5fcd6867ef90186b21fd2fdbf2d112eb", "patch_ids": ["ef7a8e171d24bc7e37d99dc054a869a6"], "statement_hash": "564a7e15b17f9d544772c53d491c7214a74bce0d4366a10f88e37b1ea8d996dc", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-41594b963e578f2b", "cves": [], "html": "外部表现在可以参与 INSERT ... ON CONFLICT DO NOTHING 查询（Peter Geoghegan、Heikki Linnakangas、Andres Freund）
必须修改外部数据包装器才能处理这一点。外部表不支持 INSERT ... ON CONFLICT DO UPDATE。
改进 hash_create() 选择简单二进制键哈希函数的 API（Teodor Sigaev、Tom Lane）
改进并行执行基础设施（Robert Haas、Amit Kapila、Noah Misch、Rushabh Lathia、Jeevan Chalke）
", "text": "改进并行执行基础设施（Robert Haas、Amit Kapila、Noah Misch、Rushabh Lathia、Jeevan Chalke）", "title": "改进并行执行基础设施", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "916dda8f6c85b27ab08fd5556f6852e92969cb52a8f971815ca310ef014a2770", "section_path": ["源代码"], "commit_groups": [["2bd9e41"], ["924bcf4"]], "identity_text": "Improve parallel execution infrastructure (Robert Haas, Amit Kapila, Noah Misch, Rushabh Lathia, Jeevan Chalke)", "commit_aliases": ["2bd9e41", "924bcf4"], "source_commits": ["2bd9e41", "924bcf4"], "source_entry_id": "9.5.0/changes/160", "db_id": "d3a12b825586bf6ea96e7c816d4e605b", "patch_ids": ["6c351a7f0e42a37f5bf15caed7972de9", "6e2c892769171c723663b209080011db"], "statement_hash": "a6bc767ee18408e04231f2c9dc98382c634e38253b6483a401e63d6e3e2e6262", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-3ba794938a7b70a3", "cves": [], "html": "移除 Alpha（CPU）和 Tru64（操作系统）移植（Andres Freund）
", "text": "移除 Alpha（CPU）和 Tru64（操作系统）移植（Andres Freund）", "title": "移除 Alpha（CPU）和 Tru64（操作系统）移植", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "7a367a481192ca8c3810d633d1c4154d308e836ed787da1e214a38d9fd1f7493", "section_path": ["源代码"], "commit_groups": [["a6d488c"]], "identity_text": "Remove Alpha (CPU) and Tru64 (OS) ports (Andres Freund)", "commit_aliases": ["a6d488c"], "source_commits": ["a6d488c"], "source_entry_id": "9.5.0/changes/161", "db_id": "10293991f75a2f102ecfbed06c115698", "patch_ids": ["7efeffea8ca11c724ce52c1296814f40"], "statement_hash": "87a87aedcf326bc88cc006b463ba7a9d1a5f8fcb04598ff1e7f3fe4a53b75e58", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-f222f972a2c28d5f", "cves": [], "html": "移除 ARMv5 及更早 CPU 的基于字节交换的自旋锁实现（Robert Haas）
\nARMv5 的弱内存排序使这种锁定实现不安全。在支持原子操作的较新 gcc 实现上，自旋锁支持仍然可能。
", "text": "移除 ARMv5 及更早 CPU 的基于字节交换的自旋锁实现（Robert Haas） ARMv5 的弱内存排序使这种锁定实现不安全。在支持原子操作的较新 gcc 实现上，自旋锁支持仍然可能。", "title": "移除 ARMv5 及更早 CPU 的基于字节交换的自旋锁实现", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "0b504e052b905042117b1150a22275cfe0f268a08a2aea782fc598aba1dce39c", "section_path": ["源代码"], "commit_groups": [["4893ccd"]], "identity_text": "Remove swap-byte-based spinlock implementation for ARMv5 and earlier CPUs (Robert Haas) ARMv5's weak memory ordering made this locking implementation unsafe. Spinlock support is still possible on newer gcc implementations with atomics support.", "commit_aliases": ["4893ccd"], "source_commits": ["4893ccd"], "source_entry_id": "9.5.0/changes/162", "db_id": "a04e4c57c358719580af6f8ea4d461c4", "patch_ids": ["934ca0da6da7d95debd7665a01551a9a"], "statement_hash": "532a08929b6cd54fd952ac665cc6c1ce6fa01694245a2942a7d1e978c9a38d65", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-49d7622baa3a29fd", "cves": [], "html": "当过长的（100 字符以上）文件路径被写入 tar 文件时产生错误（Peter Eisentraut）
\ntar 不支持这种过长的路径。
", "text": "当过长的（100 字符以上）文件路径被写入 tar 文件时产生错误（Peter Eisentraut） tar 不支持这种过长的路径。", "title": "当过长的（100 字符以上）文件路径被写入 tar 文件时产生错误", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "51baf04ae034e8f5b67cd576885e71b29809c9d15642833e5271b5fd295df897", "section_path": ["源代码"], "commit_groups": [["23a7835"]], "identity_text": "Generate an error when excessively long (100+ character) file paths are written to tar files (Peter Eisentraut) Tar does not support such overly-long paths.", "commit_aliases": ["23a7835"], "source_commits": ["23a7835"], "source_entry_id": "9.5.0/changes/163", "db_id": "446961028a6677148040e9c97d785ad4", "patch_ids": ["fbf9f6cadc7ca0c5ea44c821a9e44486"], "statement_hash": "888a8f0aae1fa02a82e8af1d14a4fd2716b9c411f07509509b9b12e9d0c9411e", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-7018e0617caab619", "cves": [], "html": "把列 pg_seclabel.provider 和 pg_shseclabel.provider 的索引操作符类改为 text_pattern_ops（Tom Lane）
这避免了当集群中不同数据库具有不同默认排序规则时这些索引可能出现的问题。
", "text": "把列 pg_seclabel.provider 和 pg_shseclabel.provider 的索引操作符类改为 text_pattern_ops（Tom Lane） 这避免了当集群中不同数据库具有不同默认排序规则时这些索引可能出现的问题。", "title": "把列 pg_seclabel.provider 和 pg_shseclabel.provider 的索引操作符类改为 text_pattern_ops", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "0ffcd056a2c651b725996378c01eaa1fb2d4671b13c8c95bc13d948964ef1dd6", "section_path": ["源代码"], "commit_groups": [["0b28ea7"]], "identity_text": "Change index operator class for columns pg_seclabel.provider and pg_shseclabel.provider to be text_pattern_ops (Tom Lane) This avoids possible problems with these indexes when different databases of a cluster have different default collations.", "commit_aliases": ["0b28ea7"], "source_commits": ["0b28ea7"], "source_entry_id": "9.5.0/changes/164", "db_id": "9f36fea2b6001f53645cf74a6c88194a", "patch_ids": ["e8bada510b4695e67f830e69045ddb0f"], "statement_hash": "4f8e415ebc8ae6c4be83fb67d4c4bc73bb42f1200d452515fc4124cca7d966d5", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-5e44ae13e7b7809f", "cves": [], "html": "把自旋锁原语改为兼作编译器屏障（Robert Haas）
", "text": "把自旋锁原语改为兼作编译器屏障（Robert Haas）", "title": "把自旋锁原语改为兼作编译器屏障", "commits": [], "section": "源代码", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12", "source_hash": "e11cbc6548d85e17656d8fa1cfcda87ec40f39a98349e054af22ef67d72a2481", "section_path": ["源代码"], "commit_groups": [["0709b7e"]], "identity_text": "Change the spinlock primitives to function as compiler barriers (Robert Haas)", "commit_aliases": ["0709b7e"], "source_commits": ["0709b7e"], "source_entry_id": "9.5.0/changes/165", "db_id": "20b92c98c23ac0219b3a9076001cc9b8", "patch_ids": ["0f93d2fd768ac49ebcfbae083793ea57"], "statement_hash": "e2edb96c4abad46fc222a148d3cb74ad2652ab702c674bd7ac6cbef651613af6", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-4cb856d751d585b3", "cves": [], "html": "在 Windows 8、Windows Server 2012 及更高版本的 Windows 系统上允许更高精度的时间戳分辨率（Craig Ringer）
", "text": "在 Windows 8、Windows Server 2012 及更高版本的 Windows 系统上允许更高精度的时间戳分辨率（Craig Ringer）", "title": "在 Windows 8、Windows Server 2012 及更高版本的 Windows 系统上允许更高精度的时间戳分辨率", "commits": [], "section": "源代码 / MS Windows", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12.3", "source_hash": "b12966ff7333edcb93fa13febf1081abea23b96d92014449f1908fe08eed07f6", "section_path": ["源代码", "MS Windows"], "commit_groups": [["519b075"], ["8001fe6"]], "identity_text": "Allow higher-precision time stamp resolution on Windows 8, Windows Server 2012, and later Windows systems (Craig Ringer)", "commit_aliases": ["519b075", "8001fe6"], "source_commits": ["519b075", "8001fe6"], "source_entry_id": "9.5.0/changes/166", "db_id": "abc62621ab4cd0a71765b9b11331c21c", "patch_ids": ["75b36b9da3300a6502f3cb168d58cd6e", "ea1b596bdc21d8db1e645ab1aa8eb568"], "statement_hash": "1a44f973c7bd391fd3a814a0ff27f12bcc38bd8561aff44a5278655e4821202b", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-72b99301f6d8571a", "cves": [], "html": "在 MS Windows 上把共享库安装到 bin（Peter Eisentraut、Michael Paquier）
在 MSVC 构建中把 src/test/modules 与 contrib 一起安装（Michael Paquier）
允许 MSVC 构建遵循 configure 的 --with-extra-version 选项（Michael Paquier）
把 PGFILEDESC 传入 MSVC contrib 构建（Michael Paquier）
为所有 MSVC 构建的二进制文件添加图标，并为所有 MS Windows 二进制文件添加版本信息（Noah Misch）
\nMinGW 此前已有此类图标。
", "text": "为所有 MSVC 构建的二进制文件添加图标，并为所有 MS Windows 二进制文件添加版本信息（Noah Misch） MinGW 此前已有此类图标。", "title": "为所有 MSVC 构建的二进制文件添加图标，并为所有 MS Windows 二进制文件添加版本信息", "commits": [], "section": "源代码 / MS Windows", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12.3", "source_hash": "b2fa71ebdc76b2e3e4797938cc16b75191d4ebfb6eb2215ff720e760355e48c6", "section_path": ["源代码", "MS Windows"], "commit_groups": [["c4a448e"]], "identity_text": "Add icons to all MSVC-built binaries and version information to all MS Windows binaries (Noah Misch) MinGW already had such icons.", "commit_aliases": ["c4a448e"], "source_commits": ["c4a448e"], "source_entry_id": "9.5.0/changes/171", "db_id": "5997aa668f6caffc9eb3405886f61d7b", "patch_ids": ["a7914ecee62ea56098f8a66f7195e53b"], "statement_hash": "936b0710039148aa585f4c4979c6b6d5ae2551ef5c57bf3f9282c4375d159fcf", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-df47e95e545f670f", "cves": [], "html": "为内部的 getopt_long() 实现添加可选参数支持（Michael Paquier、Andres Freund）
这被 MSVC 构建使用。
", "text": "为内部的 getopt_long() 实现添加可选参数支持（Michael Paquier、Andres Freund） 这被 MSVC 构建使用。", "title": "为内部的 getopt_long() 实现添加可选参数支持", "commits": [], "section": "源代码 / MS Windows", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.12.3", "source_hash": "941a89b0a195e4658251576c53681763a49eb1c951b8580d84786df8757a2ff1", "section_path": ["源代码", "MS Windows"], "commit_groups": [["311da16"]], "identity_text": "Add optional-argument support to the internal getopt_long() implementation (Michael Paquier, Andres Freund) This is used by the MSVC build.", "commit_aliases": ["311da16"], "source_commits": ["311da16"], "source_entry_id": "9.5.0/changes/172", "db_id": "91a2843dabeed128b973d863fef1e7f1", "patch_ids": ["b9d4735a164099fce07d25ec4a5bb0d1"], "statement_hash": "b63e5c6e61e113fb6ef8ef12d45ef878712691b7c0987f0729a06354eed33e23", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-eb45f06c745d76b5", "cves": [], "html": "为pg_stat_statements添加最小、最大、平均和标准差时间统计（Mitsumasa Kondo、Andrew Dunstan）
", "text": "为pg_stat_statements添加最小、最大、平均和标准差时间统计（Mitsumasa Kondo、Andrew Dunstan）", "title": "为pg_stat_statements添加最小、最大、平均和标准差时间统计", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.13", "source_hash": "c03ac8d98e702b5d25af2f34b4961627b4764d8cfdf45e2d4718cf765fa28958", "section_path": ["附加模块"], "commit_groups": [["717f709"]], "identity_text": "Add statistics for minimum, maximum, mean, and standard deviation times to pg_stat_statements (Mitsumasa Kondo, Andrew Dunstan)", "commit_aliases": ["717f709"], "source_commits": ["717f709"], "source_entry_id": "9.5.0/changes/173", "db_id": "c4b17b1fbafbcf1057800f85123c1816", "patch_ids": ["d2ad792a1f10626a3bb52c17e95b8509"], "statement_hash": "06600e7886b09eabb4539021392b5e805e4c1a22a0a4c25d217e3dcabde40006", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-c56666e9ff7aa955", "cves": [], "html": "添加pgcrypto函数 pgp_armor_headers()，用于提取 PGP armor 头（Marko Tiikkaja、Heikki Linnakangas）
允许unaccent中使用空的替换字符串（Mohammad Alhashash）
\n这在变音符号表示为独立字符的语言中很有用。
", "text": "允许unaccent中使用空的替换字符串（Mohammad Alhashash） 这在变音符号表示为独立字符的语言中很有用。", "title": "允许unaccent中使用空的替换字符串", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.13", "source_hash": "4e368141f093c8f6874ecb598fcf327901088e5f2a372402526e9f824f1b7ca9", "section_path": ["附加模块"], "commit_groups": [["97c40ce"]], "identity_text": "Allow empty replacement strings in unaccent (Mohammad Alhashash) This is useful in languages where diacritic signs are represented as separate characters.", "commit_aliases": ["97c40ce"], "source_commits": ["97c40ce"], "source_entry_id": "9.5.0/changes/175", "db_id": "34150ee6becfc7540e4dac52093a60e5", "patch_ids": ["66c82df308bd80a4569ea4ac1a06aafd"], "statement_hash": "103d093c230c6f506d4fe69e94fc3906fb88cd264618c08ee3d676c1d0b2e9df", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-42e0498024289a81", "cves": [], "html": "允许unaccent中使用多字符源字符串（Tom Lane）
\n这在变音符号表示为独立字符的语言中可能有用。它还允许更复杂的 unaccent 词典。
", "text": "允许unaccent中使用多字符源字符串（Tom Lane） 这在变音符号表示为独立字符的语言中可能有用。它还允许更复杂的 unaccent 词典。", "title": "允许unaccent中使用多字符源字符串", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.13", "source_hash": "43dcf4c58d14074c5b447c70f5b35475d1655ecd309bec5bc860a179b525fdb2", "section_path": ["附加模块"], "commit_groups": [["1b24887"]], "identity_text": "Allow multicharacter source strings in unaccent (Tom Lane) This could be useful in languages where diacritic signs are represented as separate characters. It also allows more complex unaccent dictionaries.", "commit_aliases": ["1b24887"], "source_commits": ["1b24887"], "source_entry_id": "9.5.0/changes/176", "db_id": "f6b8f9620ce1f12553ff3e6374081556", "patch_ids": ["e5682450fff156c06b4a6f7acc1149e6"], "statement_hash": "ca79e99fbc1055f0ac1349b4ac1b727a499c1e294894d13cca20753bd3322f43", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-6835388dc683403f", "cves": [], "html": "添加 contrib 模块tsm_system_rows和tsm_system_time，以提供更多的表采样方法（Petr Jelínek）
为pageinspect添加 GIN 索引检查函数（Heikki Linnakangas、Peter Geoghegan、Michael Paquier）
", "text": "为pageinspect添加 GIN 索引检查函数（Heikki Linnakangas、Peter Geoghegan、Michael Paquier）", "title": "为pageinspect添加 GIN 索引检查函数", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.13", "source_hash": "ccb4beba52ed6d551e27baf8404cd9f4601412db8e3b77c9405d323eeb286885", "section_path": ["附加模块"], "commit_groups": [["3a82bc6"]], "identity_text": "Add GIN index inspection functions to pageinspect (Heikki Linnakangas, Peter Geoghegan, Michael Paquier)", "commit_aliases": ["3a82bc6"], "source_commits": ["3a82bc6"], "source_entry_id": "9.5.0/changes/178", "db_id": "903f6c673f326458b4a7dc7f7f2d8a00", "patch_ids": ["6476228757e1f15fc0cf87cd6d2e7274"], "statement_hash": "892bd9da4738f98aedab006cdc09d62436728f20c79d4c2b66a2f73aad628958", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-6cf92a06522e3ee1", "cves": [], "html": "在pg_buffercache显示中添加有关缓冲区引脚的信息（Andres Freund）
", "text": "在pg_buffercache显示中添加有关缓冲区引脚的信息（Andres Freund）", "title": "在pg_buffercache显示中添加有关缓冲区引脚的信息", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.13", "source_hash": "fcd0543ce70d22fafb3d21a6e5fa642cfbcf94e4bc4059a5c2a34a1b2a4d5b92", "section_path": ["附加模块"], "commit_groups": [["f577919"]], "identity_text": "Add information about buffer pins to pg_buffercache display (Andres Freund)", "commit_aliases": ["f577919"], "source_commits": ["f577919"], "source_entry_id": "9.5.0/changes/179", "db_id": "85b2c623f3e345dd61370421c228950f", "patch_ids": ["26ec244f11ed5dad821884ed529ec0c0"], "statement_hash": "60691d4228ef5ea8c019df40e936e2985339a504c75f748bec254d4c73cc0f7c", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.0-5cbb150721240e76", "cves": [], "html": "允许pgstattuple使用 pgstattuple_approx() 以更低的开销报告近似结果（Abhijit Menon-Sen）
把 dummy_seclabel、test_shm_mq、test_parser 和 worker_spi 从 contrib 移到 src/test/modules（Álvaro Herrera）
这些模块仅用于服务器测试，因此在打包 PostgreSQL 时无需构建或安装它们。
", "text": "把 dummy_seclabel、test_shm_mq、test_parser 和 worker_spi 从 contrib 移到 src/test/modules（Álvaro Herrera） 这些模块仅用于服务器测试，因此在打包 PostgreSQL 时无需构建或安装它们。", "title": "把 dummy_seclabel、test_shm_mq、test_parser 和 worker_spi 从 contrib 移到 src/test/modules", "commits": [], "section": "附加模块", "category": "feature", "source_url": "/docs/release/9.5.0/#id-1.11.6.30.5.13", "source_hash": "e886b8319adeec8e09d5b3f92904197d02d65f1a3ab5d90caebf47cf425181a6", "section_path": ["附加模块"], "commit_groups": [["22dfd11"], ["df761e3"]], "identity_text": "Move dummy_seclabel, test_shm_mq, test_parser, and worker_spi from contrib to src/test/modules (Álvaro Herrera) These modules are only meant for server testing, so they do not need to be built or installed when packaging PostgreSQL.", "commit_aliases": ["22dfd11", "df761e3"], "source_commits": ["22dfd11", "df761e3"], "source_entry_id": "9.5.0/changes/181", "db_id": "c3a0078420271734de569015fbd66c11", "patch_ids": ["457c4dc7a9e5f2cb7ad02ed44066e8da", "ca08baf9bf9bb25202fecffeb4b7b890"], "statement_hash": "116b58fba1e9bd132401ab261247402e116c9cd697be1fd0a8ec94cae9a05552", "relations": [], "version": "9.5.0", "category_label": "新功能", "also_in": [], "variants": [], "related_changes": []}]}], "stats": [{"key": "all", "label": "全部变更", "count": 193}, {"key": "feature", "label": "新功能", "count": 163}, {"key": "bugfix", "label": "BUG 修复", "count": 1}, {"key": "security", "label": "安全相关", "count": 0}, {"key": "performance", "label": "性能改进", "count": 17}, {"key": "compatibility", "label": "兼容性变化", "count": 12}, {"key": "improvement", "label": "其他改进", "count": 0}], "total": 193, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 193, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}