\u5c06initdb\u9ed8\u8ba4\u66f4\u6539\u4e3a\u542f\u7528\u6570\u636e\u6821\u9a8c\u548c\uff08Greg Sabino Mullane\uff09\u00a7
\n\u53ef\u4ee5\u4f7f\u7528\u65b0\u7684 initdb \u9009\u9879 --no-data-checksums \u7981\u7528\u6821\u9a8c\u548c\u3002pg_upgrade\u8981\u6c42\u5339\u914d\u96c6\u7c07\u6821\u9a8c\u548c\u8bbe\u7f6e\uff0c\u56e0\u6b64\u8fd9\u4e2a\u65b0\u9009\u9879\u5bf9\u4e8e\u5347\u7ea7\u4e0d\u5e26\u6821\u9a8c\u548c\u7684\u65e7\u96c6\u7c07\u5f88\u6709\u7528\u3002
\u66f4\u6539\u65f6\u533a\u7f29\u5199\u5904\u7406\uff08Tom Lane\uff09\u00a7
\n\u7cfb\u7edf\u73b0\u5728\u5c06\u4f18\u5148\u8003\u8651\u5f53\u524d\u4f1a\u8bdd\u7684\u65f6\u533a\u7f29\u5199\uff0c\u7136\u540e\u68c0\u67e5\u670d\u52a1\u5668\u53d8\u91cftimezone_abbreviations\u3002\u4ee5\u524d\u662f\u5148\u68c0\u67e5 timezone_abbreviations\u3002
\u5f03\u7528 MD5 \u5bc6\u7801\u8ba4\u8bc1\uff08Nathan Bossart\uff09\u00a7
\n\u5bf9 MD5 \u5bc6\u7801\u7684\u652f\u6301\u5c06\u5728\u672a\u6765\u7684\u4e3b\u8981\u7248\u672c\u4e2d\u79fb\u9664\u3002CREATE ROLE\u548cALTER ROLE\u73b0\u5728\u5728\u8bbe\u7f6e MD5 \u5bc6\u7801\u65f6\u4f1a\u53d1\u51fa\u5f03\u7528\u8b66\u544a\u3002\u53ef\u4ee5\u901a\u8fc7\u5c06md5_password_warnings\u53c2\u6570\u8bbe\u7f6e\u4e3a off \u6765\u7981\u7528\u8fd9\u4e9b\u8b66\u544a\u3002
\u66f4\u6539VACUUM\u548cANALYZE\u4ee5\u5904\u7406\u7236\u8868\u7684\u7ee7\u627f\u5b50\u8868\uff08Michael Harris\uff09\u00a7
\n\u53ef\u4ee5\u4f7f\u7528\u65b0\u7684 ONLY \u9009\u9879\u6267\u884c\u4ee5\u524d\u7684\u884c\u4e3a\u3002
\u9632\u6b62 COPY FROM \u5728\u8bfb\u53d6 CSV \u6587\u4ef6\u65f6\u5c06 \\. \u89c6\u4e3a\u6587\u4ef6\u7ed3\u675f\u6807\u8bb0\uff08Daniel V\u00e9rit\u00e9, Tom Lane\uff09\u00a7 \u00a7
psql\u5728\u4ece STDIN \u8bfb\u53d6 CSV \u6587\u4ef6\u65f6\u4ecd\u4f1a\u5c06 \\. \u89c6\u4e3a\u6587\u4ef6\u7ed3\u675f\u6807\u8bb0\u3002\u8f83\u65e7\u7684 psql \u5ba2\u6237\u7aef\u8fde\u63a5\u5230 PostgreSQL 18 \u670d\u52a1\u5668\u65f6\uff0c\u53ef\u80fd\u4f1a\u5728 \\copy \u4e0a\u9047\u5230\u95ee\u9898\u3002\u6b64\u7248\u672c\u8fd8\u5f3a\u5236\u8981\u6c42 \\. \u5fc5\u987b\u5355\u72ec\u51fa\u73b0\u5728\u4e00\u884c\u4e2d\u3002
\u7981\u6b62\u4e0d\u8bb0\u5f55 WAL \u7684\u5206\u533a\u8868\uff08Michael Paquier\uff09\u00a7
\n\u4ee5\u524d ALTER TABLE SET [UN]LOGGED \u4e0d\u6267\u884c\u4efb\u4f55\u64cd\u4f5c\uff0c\u5e76\u4e14\u521b\u5efa\u4e0d\u8bb0\u5f55 WAL \u7684\u5206\u533a\u8868\u4e5f\u4e0d\u4f1a\u5bfc\u81f4\u5176\u5b50\u8868\u4e0d\u8bb0\u5f55 WAL\u3002
\u8ba9 AFTER \u89e6\u53d1\u5668\u4ee5\u89e6\u53d1\u5668\u4e8b\u4ef6\u6392\u961f\u65f6\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u7684\u89d2\u8272\u8eab\u4efd\u6267\u884c\uff08Laurenz Albe\uff09\u00a7
\u4ee5\u524d\uff0c\u6b64\u7c7b\u89e6\u53d1\u5668\u4ee5\u6267\u884c\u65f6\uff08\u4f8b\u5982\uff0c\u5728COMMIT\u65f6\uff09\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u7684\u89d2\u8272\u8eab\u4efd\u8fd0\u884c\u3002\u8fd9\u5bf9\u4e8e\u5728\u6392\u961f\u65f6\u95f4\u548c\u4e8b\u52a1\u63d0\u4ea4\u4e4b\u95f4\u89d2\u8272\u53d1\u751f\u53d8\u5316\u7684\u60c5\u51b5\u5f88\u91cd\u8981\u3002
", "text": "\u8ba9 AFTER \u89e6\u53d1\u5668\u4ee5\u89e6\u53d1\u5668\u4e8b\u4ef6\u6392\u961f\u65f6\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u7684\u89d2\u8272\u8eab\u4efd\u6267\u884c\uff08Laurenz Albe\uff09\u00a7 \u4ee5\u524d\uff0c\u6b64\u7c7b\u89e6\u53d1\u5668\u4ee5\u6267\u884c\u65f6\uff08\u4f8b\u5982\uff0c\u5728COMMIT\u65f6\uff09\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u7684\u89d2\u8272\u8eab\u4efd\u8fd0\u884c\u3002\u8fd9\u5bf9\u4e8e\u5728\u6392\u961f\u65f6\u95f4\u548c\u4e8b\u52a1\u63d0\u4ea4\u4e4b\u95f4\u89d2\u8272\u53d1\u751f\u53d8\u5316\u7684\u60c5\u51b5\u5f88\u91cd\u8981\u3002", "title": "\u8ba9 AFTER \u89e6\u53d1\u5668\u4ee5\u89e6\u53d1\u5668\u4e8b\u4ef6\u6392\u961f\u65f6\u5904\u4e8e\u6d3b\u52a8\u72b6\u6001\u7684\u89d2\u8272\u8eab\u4efd\u6267\u884c", "commits": ["01463e1cc"], "section": "\u517c\u5bb9\u6027", "category": "compatibility", "source_url": "/docs/release/18.0/#RELEASE-18-MIGRATION", "source_hash": "f10785acbe9b26f28a8c98e9a00c1d2a4e8afa8c0b7f7291f990211dfc079f53", "section_path": ["\u517c\u5bb9\u6027"], "commit_groups": [["01463e1cc"]], "identity_text": "Execute AFTER triggers as the role that was active when trigger events were queued (Laurenz Albe) Previously such triggers were run as the role that was active at trigger execution time (e.g., at sql-commit ). This is significant for cases where the role is changed between queue time and transaction commit.", "commit_aliases": ["01463e1cc"], "source_commits": ["01463e1cc"], "source_entry_id": "18.0/migration/007", "db_id": "ae8521434650fe5524c9fcaa38acac84", "patch_ids": ["917ba717810e74a1c7c638690cf0f5eb"], "statement_hash": "f0612c07183e11ac71073f5d359d3b0a521ebcc0822d94befe83c23059d03016", "relations": [], "category_label": "\u517c\u5bb9\u6027\u53d8\u5316", "url": "/docs/compare/?release=18.0#18.0-0d2c2c2259abf618", "migration": true}, {"id": "18.0-607cc591e9d82ae8", "cves": [], "html": "\u79fb\u9664GRANT/REVOKE\u4e2d\u4e0d\u8d77\u4f5c\u7528\u7684\u89c4\u5219\u6743\u9650\u652f\u6301\uff08Fujii Masao\uff09\u00a7
\n\u8fd9\u4e9b\u6743\u9650\u81ea PostgreSQL 8.2 \u8d77\u5c31\u5df2\u4e0d\u8d77\u4f5c\u7528\u3002
", "text": "\u79fb\u9664GRANT/REVOKE\u4e2d\u4e0d\u8d77\u4f5c\u7528\u7684\u89c4\u5219\u6743\u9650\u652f\u6301\uff08Fujii Masao\uff09\u00a7 \u8fd9\u4e9b\u6743\u9650\u81ea PostgreSQL 8.2 \u8d77\u5c31\u5df2\u4e0d\u8d77\u4f5c\u7528\u3002", "title": "\u79fb\u9664GRANT/REVOKE\u4e2d\u4e0d\u8d77\u4f5c\u7528\u7684\u89c4\u5219\u6743\u9650\u652f\u6301", "commits": ["fefa76f70"], "section": "\u517c\u5bb9\u6027", "category": "compatibility", "source_url": "/docs/release/18.0/#RELEASE-18-MIGRATION", "source_hash": "db08cd3d3ddd023cec8d6165fd052ba6e7d655cc958d6c238b6f02af024dc1a1", "section_path": ["\u517c\u5bb9\u6027"], "commit_groups": [["fefa76f70"]], "identity_text": "Remove non-functional support for rule privileges in sql-grant / sql-revoke (Fujii Masao) These have been non-functional since PostgreSQL 8.2.", "commit_aliases": ["fefa76f70"], "source_commits": ["fefa76f70"], "source_entry_id": "18.0/migration/008", "db_id": "421b9236b8ba45e9981de4acb0936336", "patch_ids": ["1a39a92752613c9674e39e99f119c2de"], "statement_hash": "9a9f6ec57f00ae867aca818ec5c55d43899650a49ee6ab2ce0bed4d154bb41b9", "relations": [], "category_label": "\u517c\u5bb9\u6027\u53d8\u5316", "url": "/docs/compare/?release=18.0#18.0-607cc591e9d82ae8", "migration": true}, {"id": "18.0-558a645d00b3f47b", "cves": [], "html": "\u79fb\u9664\u5217 pg_backend_memory_contexts.parent\uff08Melih Mutlu\uff09\u00a7
\u7531\u4e8e\u6dfb\u52a0\u4e86 pg_backend_memory_contexts.path\uff0c\u4e0d\u518d\u9700\u8981\u6b64\u5217\u3002
\u5c06 pg_backend_memory_contexts.level \u548c pg_log_backend_memory_contexts() \u66f4\u6539\u4e3a\u4ece1\u5f00\u59cb\uff08Melih Mutlu, Atsushi Torikoshi, David Rowley, Fujii Masao\uff09\u00a7 \u00a7 \u00a7
\u8fd9\u4e9b\u4ee5\u524d\u662f\u4ece\u96f6\u5f00\u59cb\u7684\u3002
", "text": "\u5c06 pg_backend_memory_contexts.level \u548c pg_log_backend_memory_contexts() \u66f4\u6539\u4e3a\u4ece1\u5f00\u59cb\uff08Melih Mutlu, Atsushi Torikoshi, David Rowley, Fujii Masao\uff09\u00a7 \u00a7 \u00a7 \u8fd9\u4e9b\u4ee5\u524d\u662f\u4ece\u96f6\u5f00\u59cb\u7684\u3002", "title": "\u5c06 pg_backend_memory_contexts.level \u548c pg_log_backend_memory_contexts() \u66f4\u6539\u4e3a\u4ece1\u5f00\u59cb", "commits": ["32d3ed816", "706cbed35", "d9e03864b"], "section": "\u517c\u5bb9\u6027", "category": "compatibility", "source_url": "/docs/release/18.0/#RELEASE-18-MIGRATION", "source_hash": "50bbd1729e746a694a3df7d491e7ab79d0b57696ebbb5127fdc124520b03ee7c", "section_path": ["\u517c\u5bb9\u6027"], "commit_groups": [["32d3ed816"], ["706cbed35"], ["d9e03864b"]], "identity_text": "Change pg_backend_memory_contexts.level and pg_log_backend_memory_contexts() to be one-based (Melih Mutlu, Atsushi Torikoshi, David Rowley, Fujii Masao) These were previously zero-based.", "commit_aliases": ["32d3ed816", "706cbed35", "d9e03864b"], "source_commits": ["32d3ed816", "706cbed35", "d9e03864b"], "source_entry_id": "18.0/migration/010", "db_id": "b8c57d935d8b183f9ee20e7477f90abd", "patch_ids": ["3d61500ab7649ba207c5b4742ce83946", "845864cc388c5f840e08c3fdf9f3032a", "eaa8db2e49e44f9880c123bf159cab42"], "statement_hash": "c56bfdda9e9b110545ab282f1be71da486fd1e7af030b2a5c125fe4d37560c98", "relations": [{"rule": 2, "type": "related", "target": "7ed5d279df474d7ce518a2cd605d091d", "evidence": {"same_day": true, "patch_ids": ["eaa8db2e49e44f9880c123bf159cab42"]}}], "category_label": "\u517c\u5bb9\u6027\u53d8\u5316", "url": "/docs/compare/?release=18.0#18.0-3bddcb1c02f74659", "migration": true}, {"id": "18.0-63b962f0125472b6", "cves": [], "html": "\u66f4\u6539\u5168\u6587\u68c0\u7d22\uff0c\u4f7f\u5176\u4f7f\u7528\u6570\u636e\u5e93\u96c6\u7c07\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\u6765\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6\u548c\u8bcd\u5178\uff0c\u800c\u4e0d\u518d\u59cb\u7ec8\u4f7f\u7528 libc\uff08Peter Eisentraut\uff09\u00a7
\n\u5982\u679c\u6570\u636e\u5e93\u96c6\u7c07\u9ed8\u8ba4\u4f7f\u7528\u7684\u975e libc \u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\uff08\u4f8b\u5982 ICU\u3001builtin\uff09\u5bf9 LC_CTYPE \u6240\u5904\u7406\u5b57\u7b26\u7684\u5904\u7406\u65b9\u5f0f\u4e0e libc \u4e0d\u540c\uff0c\u90a3\u4e48\u67d0\u4e9b\u5168\u6587\u68c0\u7d22\u51fd\u6570\u4ee5\u53capg_trgm\u6269\u5c55\u7684\u884c\u4e3a\u53ef\u80fd\u4f1a\u53d1\u751f\u53d8\u5316\u3002\u4f7f\u7528pg_upgrade\u5347\u7ea7\u6b64\u7c7b\u6570\u636e\u5e93\u96c6\u7c07\u65f6\uff0c\u5efa\u8bae\u5728\u5347\u7ea7\u540e\u91cd\u65b0\u7d22\u5f15\u6240\u6709\u4e0e\u5168\u6587\u68c0\u7d22\u548cpg_trgm\u76f8\u5173\u7684\u7d22\u5f15\u3002
", "text": "\u66f4\u6539\u5168\u6587\u68c0\u7d22\uff0c\u4f7f\u5176\u4f7f\u7528\u6570\u636e\u5e93\u96c6\u7c07\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\u6765\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6\u548c\u8bcd\u5178\uff0c\u800c\u4e0d\u518d\u59cb\u7ec8\u4f7f\u7528 libc\uff08Peter Eisentraut\uff09\u00a7 \u5982\u679c\u6570\u636e\u5e93\u96c6\u7c07\u9ed8\u8ba4\u4f7f\u7528\u7684\u975e libc \u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\uff08\u4f8b\u5982 ICU\u3001builtin\uff09\u5bf9 LC_CTYPE \u6240\u5904\u7406\u5b57\u7b26\u7684\u5904\u7406\u65b9\u5f0f\u4e0e libc \u4e0d\u540c\uff0c\u90a3\u4e48\u67d0\u4e9b\u5168\u6587\u68c0\u7d22\u51fd\u6570\u4ee5\u53capg_trgm\u6269\u5c55\u7684\u884c\u4e3a\u53ef\u80fd\u4f1a\u53d1\u751f\u53d8\u5316\u3002\u4f7f\u7528pg_upgrade\u5347\u7ea7\u6b64\u7c7b\u6570\u636e\u5e93\u96c6\u7c07\u65f6\uff0c\u5efa\u8bae\u5728\u5347\u7ea7\u540e\u91cd\u65b0\u7d22\u5f15\u6240\u6709\u4e0e\u5168\u6587\u68c0\u7d22\u548cpg_trgm\u76f8\u5173\u7684\u7d22\u5f15\u3002", "title": "\u66f4\u6539\u5168\u6587\u68c0\u7d22\uff0c\u4f7f\u5176\u4f7f\u7528\u6570\u636e\u5e93\u96c6\u7c07\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\u6765\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6\u548c\u8bcd\u5178\uff0c\u800c\u4e0d\u518d\u59cb\u7ec8\u4f7f\u7528 libc", "commits": ["fb1a18810f0"], "section": "\u517c\u5bb9\u6027", "category": "compatibility", "source_url": "/docs/release/18.0/#RELEASE-18-MIGRATION", "source_hash": "e3ce56b4fc2a72cd171306a24ddd0b8daecb530f1409e98a57781871e32f9519", "section_path": ["\u517c\u5bb9\u6027"], "commit_groups": [["fb1a18810f0"]], "identity_text": "Change full text search to use the default collation provider of the cluster to read configuration files and dictionaries, rather than always using libc (Peter Eisentraut) Clusters that default to non-libc collation providers (e.g., ICU, builtin) that behave differently than libc for characters processed by LC_CTYPE could observe changes in behavior of some full-text search functions, as well as the pgtrgm extension. When upgrading such clusters using pgupgrade , it is recommended to reindex all indexes related to full-text search and pg_trgm after the upgrade.", "commit_aliases": ["fb1a18810f0"], "source_commits": ["fb1a18810f0"], "source_entry_id": "18.0/migration/011", "db_id": "14f7ec96f489178a5ba54f0173a2002a", "patch_ids": ["d34589a0ca33552be8913ecb392dc365"], "statement_hash": "0d016706c1da5d040bed5653360eaa27ed050c9172ff53f737e1221153008011", "relations": [], "category_label": "\u517c\u5bb9\u6027\u53d8\u5316", "url": "/docs/compare/?release=18.0#18.0-63b962f0125472b6", "migration": true}, {"id": "18.0-cd59818e7d0a3dc5", "cves": [], "html": "\u81ea\u52a8\u5220\u9664\u4e00\u4e9b\u4e0d\u5fc5\u8981\u7684\u8868\u81ea\u8fde\u63a5\uff08Andrey Lepikhov, Alexander Kuzmenkov, Alexander Korotkov, Alena Rybakina\uff09\u00a7
\n\u53ef\u4ee5\u4f7f\u7528\u670d\u52a1\u5668\u53d8\u91cfenable_self_join_elimination\u7981\u7528\u6b64\u4f18\u5316\u3002
", "text": "\u81ea\u52a8\u5220\u9664\u4e00\u4e9b\u4e0d\u5fc5\u8981\u7684\u8868\u81ea\u8fde\u63a5\uff08Andrey Lepikhov, Alexander Kuzmenkov, Alexander Korotkov, Alena Rybakina\uff09\u00a7 \u53ef\u4ee5\u4f7f\u7528\u670d\u52a1\u5668\u53d8\u91cfenable_self_join_elimination\u7981\u7528\u6b64\u4f18\u5316\u3002", "title": "\u81ea\u52a8\u5220\u9664\u4e00\u4e9b\u4e0d\u5fc5\u8981\u7684\u8868\u81ea\u8fde\u63a5", "commits": ["fc069a3a6"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "40c3196e66530b1ad6c86357db78c6683c075a289ecc4fdc11ccdd15d42dafad", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["fc069a3a6"]], "identity_text": "Automatically remove some unnecessary table self-joins (Andrey Lepikhov, Alexander Kuzmenkov, Alexander Korotkov, Alena Rybakina) This optimization can be disabled using server variable guc-enable-self-join-elimination .", "commit_aliases": ["fc069a3a6"], "source_commits": ["fc069a3a6"], "source_entry_id": "18.0/changes/001", "db_id": "e93aac468afc7b983da5961bc89a6570", "patch_ids": ["f4668f24b918872b344ea179b57163cf"], "statement_hash": "235c5aa78ae11057e82ffcaba18192f08d816b80c7a4abeb2ccab576de5173f7", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-cd59818e7d0a3dc5", "migration": false}, {"id": "18.0-d69dbbb16cde79f1", "cves": [], "html": "\u5c06\u4e00\u4e9b IN (VALUES ...) \u8f6c\u6362\u4e3a x = ANY ... \u4ee5\u83b7\u5f97\u66f4\u597d\u7684\u4f18\u5316\u5668\u7edf\u8ba1\u4fe1\u606f\uff08Alena Rybakina, Andrei Lepikhov\uff09\u00a7
\u5141\u8bb8\u5c06 OR \u5b50\u53e5\u8f6c\u6362\u4e3a\u6570\u7ec4\u4ee5\u52a0\u5feb\u7d22\u5f15\u5904\u7406\uff08Alexander Korotkov, Andrey Lepikhov\uff09\u00a7
\u52a0\u5feb INTERSECT\u3001EXCEPT\u3001\u7a97\u53e3\u805a\u5408\u548c\u89c6\u56fe\u5217\u522b\u540d\u7684\u5904\u7406\u901f\u5ea6\uff08Tom Lane, David Rowley\uff09\u00a7 \u00a7 \u00a7 \u00a7
\u5141\u8bb8 SELECT DISTINCT \u7684\u952e\u5728\u5185\u90e8\u91cd\u65b0\u6392\u5e8f\u4ee5\u907f\u514d\u6392\u5e8f\uff08Richard Guo\uff09\u00a7
\u53ef\u4ee5\u4f7f\u7528enable_distinct_reordering\u7981\u7528\u6b64\u4f18\u5316\u3002
", "text": "\u5141\u8bb8 SELECT DISTINCT \u7684\u952e\u5728\u5185\u90e8\u91cd\u65b0\u6392\u5e8f\u4ee5\u907f\u514d\u6392\u5e8f\uff08Richard Guo\uff09\u00a7 \u53ef\u4ee5\u4f7f\u7528enable_distinct_reordering\u7981\u7528\u6b64\u4f18\u5316\u3002", "title": "\u5141\u8bb8 SELECT DISTINCT \u7684\u952e\u5728\u5185\u90e8\u91cd\u65b0\u6392\u5e8f\u4ee5\u907f\u514d\u6392\u5e8f", "commits": ["a8ccf4e93"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "0b3d9b69f68103fec0e196e120de31d7d5ccbd1c26beea05060ff6a886ab9130", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["a8ccf4e93"]], "identity_text": "Allow the keys of SELECT DISTINCT to be internally reordered to avoid sorting (Richard Guo) This optimization can be disabled using guc-enable-distinct-reordering .", "commit_aliases": ["a8ccf4e93"], "source_commits": ["a8ccf4e93"], "source_entry_id": "18.0/changes/005", "db_id": "e1633e7353cb2e283e589f245c02709b", "patch_ids": ["2a4dc17b68562e6259b7bb1052fff9ad"], "statement_hash": "8e10ed699456a43e5c53f99fc9ddb0ec2951686ee8551c8e706fbd1d1b10766c", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-3c9e3ca750eccbf6", "migration": false}, {"id": "18.0-41f66034d93a7cf1", "cves": [], "html": "\u5ffd\u7565\u529f\u80fd\u4e0a\u4f9d\u8d56\u4e8e\u5176\u4ed6\u5217\u7684 GROUP BY \u5217\uff08Zhang Mingli, Jian He, David Rowley\uff09\u00a7
\u5982\u679c GROUP BY \u5b50\u53e5\u5305\u542b\u552f\u4e00\u7d22\u5f15\u7684\u6240\u6709\u5217\u4ee5\u53ca\u540c\u4e00\u8868\u7684\u5176\u4ed6\u5217\uff0c\u5219\u8fd9\u4e9b\u5176\u4ed6\u5217\u662f\u5197\u4f59\u7684\uff0c\u53ef\u4ee5\u4ece\u5206\u7ec4\u4e2d\u5220\u9664\u3002\u5bf9\u4e8e\u975e\u5ef6\u8fdf\u4e3b\u952e\uff0c\u8fd9\u5df2\u7ecf\u6210\u7acb\u3002
\u5141\u8bb8\u5c06\u4f5c\u7528\u4e8e GROUPING SETS \u7684\u67d0\u4e9b HAVING \u5b50\u53e5\u4e0b\u63a8\u5230 WHERE \u5b50\u53e5\uff08Richard Guo\uff09\u00a7 \u00a7 \u00a7 \u00a7
\u8fd9\u5141\u8bb8\u66f4\u65e9\u5730\u8fdb\u884c\u884c\u8fc7\u6ee4\u3002\u6b64\u7248\u672c\u8fd8\u4fee\u590d\u4e86\u4e00\u4e9b\u4ee5\u524d\u8fd4\u56de\u4e0d\u6b63\u786e\u7ed3\u679c\u7684 GROUPING SETS \u67e5\u8be2\u3002
\u6539\u8fdb generate_series() \u4f7f\u7528 numeric \u548c timestamp \u503c\u65f6\u7684\u884c\u6570\u4f30\u8ba1\uff08David Rowley, Song Jinzhou\uff09\u00a7 \u00a7
\u5141\u8bb8\u4f18\u5316\u5668\u4f7f\u7528 Right Semi Join \u8ba1\u5212\uff08Richard Guo\uff09\u00a7
\u534a\u8fde\u63a5\u7528\u4e8e\u67e5\u627e\u662f\u5426\u5b58\u5728\u81f3\u5c11\u4e00\u4e2a\u5339\u914d\u9879\u3002
", "text": "\u5141\u8bb8\u4f18\u5316\u5668\u4f7f\u7528 Right Semi Join \u8ba1\u5212\uff08Richard Guo\uff09\u00a7 \u534a\u8fde\u63a5\u7528\u4e8e\u67e5\u627e\u662f\u5426\u5b58\u5728\u81f3\u5c11\u4e00\u4e2a\u5339\u914d\u9879\u3002", "title": "\u5141\u8bb8\u4f18\u5316\u5668\u4f7f\u7528 Right Semi Join \u8ba1\u5212", "commits": ["aa86129e1"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "619b5f1bfc705891d795ac9ab763f6362d300120b9a2d649250a5fb0fe617a45", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["aa86129e1"]], "identity_text": "Allow the optimizer to use Right Semi Join plans (Richard Guo) Semi-joins are used when needing to find if there is at least one match.", "commit_aliases": ["aa86129e1"], "source_commits": ["aa86129e1"], "source_entry_id": "18.0/changes/009", "db_id": "f76a8468845b91ddcffeaa33fa3400a0", "patch_ids": ["79e6e1842e88c7f535ade4eaba7be513"], "statement_hash": "117c31abccc7e061fab7475bec0bdf75e420f53925d5e95de87e71dad3cea951", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-3335fdf888440d5b", "migration": false}, {"id": "18.0-b111a6a6d4309764", "cves": [], "html": "\u5141\u8bb8\u5408\u5e76\u8fde\u63a5\u4f7f\u7528\u589e\u91cf\u6392\u5e8f\uff08Richard Guo\uff09\u00a7
", "text": "\u5141\u8bb8\u5408\u5e76\u8fde\u63a5\u4f7f\u7528\u589e\u91cf\u6392\u5e8f\uff08Richard Guo\uff09\u00a7", "title": "\u5141\u8bb8\u5408\u5e76\u8fde\u63a5\u4f7f\u7528\u589e\u91cf\u6392\u5e8f", "commits": ["828e94c9d"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "232faeb186a197cb2d471ce89d7969bca2593ea44e545f90f86f5ec9974800b1", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["828e94c9d"]], "identity_text": "Allow merge joins to use incremental sorts (Richard Guo)", "commit_aliases": ["828e94c9d"], "source_commits": ["828e94c9d"], "source_entry_id": "18.0/changes/010", "db_id": "7e8d7bcff75eca9f6d3794b3ed0388fb", "patch_ids": ["22cb8f9f6594048e5c90b7c0a948ea39"], "statement_hash": "c730545e91cae06688ba34e2ac9097a5800e1f311eaa283af2f272f7a1ac2767", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-b111a6a6d4309764", "migration": false}, {"id": "18.0-d6e730c654f94a8c", "cves": [], "html": "\u63d0\u9ad8\u8bbf\u95ee\u591a\u4e2a\u5206\u533a\u7684\u67e5\u8be2\u89c4\u5212\u6548\u7387\uff08Ashutosh Bapat, Yuya Watari, David Rowley\uff09\u00a7 \u00a7
", "text": "\u63d0\u9ad8\u8bbf\u95ee\u591a\u4e2a\u5206\u533a\u7684\u67e5\u8be2\u89c4\u5212\u6548\u7387\uff08Ashutosh Bapat, Yuya Watari, David Rowley\uff09\u00a7 \u00a7", "title": "\u63d0\u9ad8\u8bbf\u95ee\u591a\u4e2a\u5206\u533a\u7684\u67e5\u8be2\u89c4\u5212\u6548\u7387", "commits": ["88f55bc97", "d69d45a5a"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "7cec6b7a3c4b0b96689bd0d68404844c350a00677ea88e38b124b1582f228d77", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["88f55bc97"], ["d69d45a5a"]], "identity_text": "Improve the efficiency of planning queries accessing many partitions (Ashutosh Bapat, Yuya Watari, David Rowley)", "commit_aliases": ["88f55bc97", "d69d45a5a"], "source_commits": ["88f55bc97", "d69d45a5a"], "source_entry_id": "18.0/changes/011", "db_id": "6365c622e7f4156b307f731e72d9a3de", "patch_ids": ["15b3816633681459d9dd93e64a48ce0d", "ba8aa7045b27e8a9467ad9df65f2a614"], "statement_hash": "abf3aa0c2277a1dc8d9ddb61b3ffe1d2c987f7e7d4295a9d96f9ad75fa3f8e2a", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-d6e730c654f94a8c", "migration": false}, {"id": "18.0-efaad36fa63a27ed", "cves": [], "html": "\u5728\u66f4\u591a\u60c5\u51b5\u4e0b\u5141\u8bb8\u5206\u533a\u8fde\u63a5\uff0c\u5e76\u51cf\u5c11\u5176\u5185\u5b58\u4f7f\u7528\uff08Richard Guo, Tom Lane, Ashutosh Bapat\uff09\u00a7 \u00a7
", "text": "\u5728\u66f4\u591a\u60c5\u51b5\u4e0b\u5141\u8bb8\u5206\u533a\u8fde\u63a5\uff0c\u5e76\u51cf\u5c11\u5176\u5185\u5b58\u4f7f\u7528\uff08Richard Guo, Tom Lane, Ashutosh Bapat\uff09\u00a7 \u00a7", "title": "\u5728\u66f4\u591a\u60c5\u51b5\u4e0b\u5141\u8bb8\u5206\u533a\u8fde\u63a5\uff0c\u5e76\u51cf\u5c11\u5176\u5185\u5b58\u4f7f\u7528", "commits": ["513f4472a", "9b282a935"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "cccb81e8d167297ee2b086955ed9914693ecfdb1803b07df4ff007a993b1d1bd", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["513f4472a"], ["9b282a935"]], "identity_text": "Allow partitionwise joins in more cases, and reduce its memory usage (Richard Guo, Tom Lane, Ashutosh Bapat)", "commit_aliases": ["513f4472a", "9b282a935"], "source_commits": ["513f4472a", "9b282a935"], "source_entry_id": "18.0/changes/012", "db_id": "e1323b3c594bfa821577fa9462f03cdb", "patch_ids": ["2ff70c110f54ba540a2cece6e3a512cd", "dd416b1d8a4d68e28e16f90c7055e0bb"], "statement_hash": "40327e199cf2577490955fbcc74c05fe2901108bec3acfe4621734a986af7685", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-efaad36fa63a27ed", "migration": false}, {"id": "18.0-77174da6fc6ed32b", "cves": [], "html": "\u6539\u8fdb\u5206\u533a\u67e5\u8be2\u7684\u4ee3\u4ef7\u4f30\u7b97\uff08Nikita Malakhov, Andrei Lepikhov\uff09\u00a7
", "text": "\u6539\u8fdb\u5206\u533a\u67e5\u8be2\u7684\u4ee3\u4ef7\u4f30\u7b97\uff08Nikita Malakhov, Andrei Lepikhov\uff09\u00a7", "title": "\u6539\u8fdb\u5206\u533a\u67e5\u8be2\u7684\u4ee3\u4ef7\u4f30\u7b97", "commits": ["fae535da0"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "ad72fe467357e9b21f201ea22bac15faa0c66b16f28d43cb9b3f490b554ae9db", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["fae535da0"]], "identity_text": "Improve cost estimates of partition queries (Nikita Malakhov, Andrei Lepikhov)", "commit_aliases": ["fae535da0"], "source_commits": ["fae535da0"], "source_entry_id": "18.0/changes/013", "db_id": "c65e9805a7d1ddaa6d1373559e4cc29f", "patch_ids": ["61b7fea36f21c950e67f8bac538e8fce"], "statement_hash": "a36db3cf18d61186e69ff7181df62ed65dd845c1892191555ce2f6c4eecb52bd", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-77174da6fc6ed32b", "migration": false}, {"id": "18.0-3ca09b45eac4204e", "cves": [], "html": "\u6539\u8fdb SQL \u8bed\u8a00\u51fd\u6570\u7684\u8ba1\u5212\u7f13\u5b58\uff08Alexander Pyhalov, Tom Lane\uff09\u00a7 \u00a7
", "text": "\u6539\u8fdb SQL \u8bed\u8a00\u51fd\u6570\u7684\u8ba1\u5212\u7f13\u5b58\uff08Alexander Pyhalov, Tom Lane\uff09\u00a7 \u00a7", "title": "\u6539\u8fdb SQL \u8bed\u8a00\u51fd\u6570\u7684\u8ba1\u5212\u7f13\u5b58", "commits": ["09b07c295", "0dca5d68d"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "624d5ebd4fbd3484e763f4ffd477ed7308b2ba7c3b507bfe163d59e440d1c9f2", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["09b07c295"], ["0dca5d68d"]], "identity_text": "Improve SQL-language function plan caching (Alexander Pyhalov, Tom Lane)", "commit_aliases": ["09b07c295", "0dca5d68d"], "source_commits": ["09b07c295", "0dca5d68d"], "source_entry_id": "18.0/changes/014", "db_id": "de187fd5833da9236d39e17a824451c0", "patch_ids": ["254214644dc444095fdc1eed63435eea", "aca8b43ca22cd7e20074fc7a0a7722ba"], "statement_hash": "146626d1f5aff4758ae17dc01f8d5f905420813c8aeb98087d9ca08c5471eb23", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-3ca09b45eac4204e", "migration": false}, {"id": "18.0-96d708124ad44b45", "cves": [], "html": "\u6539\u8fdb\u7981\u7528\u4f18\u5316\u5668\u529f\u80fd\u7684\u5904\u7406\uff08Robert Haas\uff09\u00a7
", "text": "\u6539\u8fdb\u7981\u7528\u4f18\u5316\u5668\u529f\u80fd\u7684\u5904\u7406\uff08Robert Haas\uff09\u00a7", "title": "\u6539\u8fdb\u7981\u7528\u4f18\u5316\u5668\u529f\u80fd\u7684\u5904\u7406", "commits": ["e22253467"], "section": "\u670d\u52a1\u5668 / \u4f18\u5316\u5668", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-OPTIMIZER", "source_hash": "3ac7c9a012dfeb824499ec299452a4443f811573d8cdc48a32a87591feb62e84", "section_path": ["\u670d\u52a1\u5668", "\u4f18\u5316\u5668"], "commit_groups": [["e22253467"]], "identity_text": "Improve handling of disabled optimizer features (Robert Haas)", "commit_aliases": ["e22253467"], "source_commits": ["e22253467"], "source_entry_id": "18.0/changes/015", "db_id": "6af674fe85c6718d1c2ae803cc5fa2d4", "patch_ids": ["78269645a1e3bdd21fcde369b7fb1c82"], "statement_hash": "0dcbf8861cd7ba230ddcdaf5746f5f46a4f85aa3e242a34f907c8eadbc61f43c", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-96d708124ad44b45", "migration": false}, {"id": "18.0-f3a4d0c34bdfba51", "cves": [], "html": "\u5141\u8bb8 B-\u6811\u7d22\u5f15\u7684\u8df3\u8fc7\u626b\u63cf\uff08Peter Geoghegan\uff09\u00a7 \u00a7
\n\u8fd9\u5141\u8bb8\u5728\u66f4\u591a\u60c5\u51b5\u4e0b\u4f7f\u7528\u591a\u5217 B-\u6811\u7d22\u5f15\uff0c\u4f8b\u5982\uff0c\u5f53\u7b2c\u4e00\u4e2a\u6216\u8f83\u65e9\u7684\u7d22\u5f15\u5217\u4e0a\u6ca1\u6709\u9650\u5236\uff08\u6216\u53ea\u6709\u975e\u7b49\u503c\u9650\u5236\uff09\uff0c\u800c\u540e\u7eed\u7d22\u5f15\u5217\u4e0a\u5b58\u5728\u6709\u6548\u9650\u5236\u65f6\u3002
", "text": "\u5141\u8bb8 B-\u6811\u7d22\u5f15\u7684\u8df3\u8fc7\u626b\u63cf\uff08Peter Geoghegan\uff09\u00a7 \u00a7 \u8fd9\u5141\u8bb8\u5728\u66f4\u591a\u60c5\u51b5\u4e0b\u4f7f\u7528\u591a\u5217 B-\u6811\u7d22\u5f15\uff0c\u4f8b\u5982\uff0c\u5f53\u7b2c\u4e00\u4e2a\u6216\u8f83\u65e9\u7684\u7d22\u5f15\u5217\u4e0a\u6ca1\u6709\u9650\u5236\uff08\u6216\u53ea\u6709\u975e\u7b49\u503c\u9650\u5236\uff09\uff0c\u800c\u540e\u7eed\u7d22\u5f15\u5217\u4e0a\u5b58\u5728\u6709\u6548\u9650\u5236\u65f6\u3002", "title": "\u5141\u8bb8 B-\u6811\u7d22\u5f15\u7684\u8df3\u8fc7\u626b\u63cf", "commits": ["8a510275d", "92fe23d93"], "section": "\u670d\u52a1\u5668 / \u7d22\u5f15", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-INDEXES", "source_hash": "6fc7b9601b88e3906c876c63e64c4ed31901ffef59984e3a9f3c5467cf0e520e", "section_path": ["\u670d\u52a1\u5668", "\u7d22\u5f15"], "commit_groups": [["8a510275d"], ["92fe23d93"]], "identity_text": "Allow skip scans of btree indexes (Peter Geoghegan) This allows multi-column btree indexes to be used in more cases such as when there are no restrictions on the first or early indexed columns (or there are non-equality ones), and there are useful restrictions on later indexed columns.", "commit_aliases": ["8a510275d", "92fe23d93"], "source_commits": ["8a510275d", "92fe23d93"], "source_entry_id": "18.0/changes/016", "db_id": "d6862625b987b44876b5f8813415e301", "patch_ids": ["635b38c19244d008c0a276c87c34aabf", "e61ae831ab07aa91f44cf34554c51986"], "statement_hash": "5f70bac2450552918acb0585c69d065150051c94ca3fd7c0e78accb784965d18", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-f3a4d0c34bdfba51", "migration": false}, {"id": "18.0-533df00c1b04db03", "cves": [], "html": "\u5141\u8bb8\u975e B-\u6811\u552f\u4e00\u7d22\u5f15\u7528\u4f5c\u5206\u533a\u952e\uff0c\u5e76\u7528\u4e8e\u7269\u5316\u89c6\u56fe\uff08Mark Dilger\uff09\u00a7 \u00a7
\n\u7d22\u5f15\u7c7b\u578b\u4ecd\u5fc5\u987b\u652f\u6301\u76f8\u7b49\u6027\u3002
", "text": "\u5141\u8bb8\u975e B-\u6811\u552f\u4e00\u7d22\u5f15\u7528\u4f5c\u5206\u533a\u952e\uff0c\u5e76\u7528\u4e8e\u7269\u5316\u89c6\u56fe\uff08Mark Dilger\uff09\u00a7 \u00a7 \u7d22\u5f15\u7c7b\u578b\u4ecd\u5fc5\u987b\u652f\u6301\u76f8\u7b49\u6027\u3002", "title": "\u5141\u8bb8\u975e B-\u6811\u552f\u4e00\u7d22\u5f15\u7528\u4f5c\u5206\u533a\u952e\uff0c\u5e76\u7528\u4e8e\u7269\u5316\u89c6\u56fe", "commits": ["9d6db8bec", "f278e1fe3"], "section": "\u670d\u52a1\u5668 / \u7d22\u5f15", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-INDEXES", "source_hash": "48d1dc2e21671ed03ec096681269e55993854a87f636152113525b845910da6b", "section_path": ["\u670d\u52a1\u5668", "\u7d22\u5f15"], "commit_groups": [["9d6db8bec"], ["f278e1fe3"]], "identity_text": "Allow non-btree unique indexes to be used as partition keys and in materialized views (Mark Dilger) The index type must still support equality.", "commit_aliases": ["9d6db8bec", "f278e1fe3"], "source_commits": ["9d6db8bec", "f278e1fe3"], "source_entry_id": "18.0/changes/017", "db_id": "494315b065e8cf257c51cc573e8cd5ba", "patch_ids": ["5bf1633970b359c47772a29d428891b9", "afc683b089394ea6ac807e8fc8c1d9ac"], "statement_hash": "8627db4022a3b996448b3199a1438d065510142c1a86887f48fb1af1aa338936", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-533df00c1b04db03", "migration": false}, {"id": "18.0-1527473201723273", "cves": [], "html": "\u5141\u8bb8\u5e76\u884c\u521b\u5efa GIN \u7d22\u5f15\uff08Tomas Vondra, Matthias van de Meent\uff09\u00a7
\u5141\u8bb8\u5bf9\u503c\u8fdb\u884c\u6392\u5e8f\u4ee5\u52a0\u5feb\u8303\u56f4\u7c7b\u578b GiST \u548c B-\u6811\u7d22\u5f15\u6784\u5efa\uff08Bernd Helmle\uff09\u00a7
", "text": "\u5141\u8bb8\u5bf9\u503c\u8fdb\u884c\u6392\u5e8f\u4ee5\u52a0\u5feb\u8303\u56f4\u7c7b\u578b GiST \u548c B-\u6811\u7d22\u5f15\u6784\u5efa\uff08Bernd Helmle\uff09\u00a7", "title": "\u5141\u8bb8\u5bf9\u503c\u8fdb\u884c\u6392\u5e8f\u4ee5\u52a0\u5feb\u8303\u56f4\u7c7b\u578b GiST \u548c B-\u6811\u7d22\u5f15\u6784\u5efa", "commits": ["e9e7b6604"], "section": "\u670d\u52a1\u5668 / \u7d22\u5f15", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-INDEXES", "source_hash": "ac18bed164464842781add926baf8a19f9b384695cfa6ffc14d622e837b24226", "section_path": ["\u670d\u52a1\u5668", "\u7d22\u5f15"], "commit_groups": [["e9e7b6604"]], "identity_text": "Allow values to be sorted to speed range-type GiST and btree index builds (Bernd Helmle)", "commit_aliases": ["e9e7b6604"], "source_commits": ["e9e7b6604"], "source_entry_id": "18.0/changes/019", "db_id": "bb89183dc8713a98a5f1732f23ebf357", "patch_ids": ["21b0be863bb11025af07f036adc715cd"], "statement_hash": "1110884a4b4193d0fb56b65604f1f84d06c9b027816ac2b2f97f7eb335548e6f", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-3275a8a9fc76604f", "migration": false}, {"id": "18.0-ff0cc0de715bde2e", "cves": [], "html": "\u6dfb\u52a0\u5f02\u6b65 I/O \u5b50\u7cfb\u7edf\uff08Andres Freund, Thomas Munro, Nazir Bilal Yavuz, Melanie Plageman\uff09\u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7
\n\u6b64\u529f\u80fd\u5141\u8bb8\u540e\u7aef\u6392\u961f\u591a\u4e2a\u8bfb\u53d6\u8bf7\u6c42\uff0c\u4ece\u800c\u5b9e\u73b0\u66f4\u9ad8\u6548\u7684\u987a\u5e8f\u626b\u63cf\u3001\u4f4d\u56fe\u5806\u626b\u63cf\u3001\u6e05\u7406\u7b49\u3002\u8fd9\u7531\u670d\u52a1\u5668\u53d8\u91cfio_method\u542f\u7528\uff0c\u5e76\u6dfb\u52a0\u4e86\u670d\u52a1\u5668\u53d8\u91cfio_combine_limit\u548cio_max_combine_limit\u6765\u63a7\u5236\u5b83\u3002\u8fd9\u8fd8\u4f7f\u5f97\u4e0d\u652f\u6301 fadvise() \u7684\u7cfb\u7edf\u4e5f\u53ef\u4ee5\u5c06effective_io_concurrency\u548cmaintenance_io_concurrency\u8bbe\u4e3a\u5927\u4e8e\u96f6\u7684\u503c\u3002\u65b0\u7684\u7cfb\u7edf\u89c6\u56fe pg_aios \u663e\u793a\u7528\u4e8e\u5f02\u6b65 I/O \u7684\u6587\u4ef6\u53e5\u67c4\u3002
\u6539\u8fdb\u8bbf\u95ee\u8bb8\u591a\u5173\u7cfb\u7684\u67e5\u8be2\u7684\u9501\u5b9a\u6027\u80fd\uff08Tomas Vondra\uff09\u00a7
", "text": "\u6539\u8fdb\u8bbf\u95ee\u8bb8\u591a\u5173\u7cfb\u7684\u67e5\u8be2\u7684\u9501\u5b9a\u6027\u80fd\uff08Tomas Vondra\uff09\u00a7", "title": "\u6539\u8fdb\u8bbf\u95ee\u8bb8\u591a\u5173\u7cfb\u7684\u67e5\u8be2\u7684\u9501\u5b9a\u6027\u80fd", "commits": ["c4d5cb71d"], "section": "\u670d\u52a1\u5668 / \u4e00\u822c\u6027\u80fd", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-PERFORMANCE", "source_hash": "166ed61e81ac65ed621694d2130b525d95cd6eabf81198d9051b9df5a5471b51", "section_path": ["\u670d\u52a1\u5668", "\u4e00\u822c\u6027\u80fd"], "commit_groups": [["c4d5cb71d"]], "identity_text": "Improve the locking performance of queries that access many relations (Tomas Vondra)", "commit_aliases": ["c4d5cb71d"], "source_commits": ["c4d5cb71d"], "source_entry_id": "18.0/changes/021", "db_id": "aff48c3c83b235bf18a030e9ccc9c3b8", "patch_ids": ["fc2837c0cff32783885ae70d5fbb55db"], "statement_hash": "bbf31aaa998b69605f19fb5f3337b504b4ae92cf39abf056f16dadd0b84efe2d", "relations": [], "category_label": "\u6027\u80fd\u6539\u8fdb", "url": "/docs/compare/?release=18.0#18.0-ce512d334bac3308", "migration": false}, {"id": "18.0-685db88c876114b9", "cves": [], "html": "\u63d0\u9ad8\u54c8\u5e0c\u8fde\u63a5\u548c GROUP BY \u7684\u6027\u80fd\u5e76\u51cf\u5c11\u5185\u5b58\u4f7f\u7528\uff08David Rowley, Jeff Davis\uff09\u00a7 \u00a7 \u00a7 \u00a7 \u00a7
\u8fd9\u4e5f\u6539\u8fdb\u4e86 EXCEPT \u4f7f\u7528\u7684 hash \u96c6\u64cd\u4f5c\u548c\u5b50\u8ba1\u5212\u503c\u7684 hash \u67e5\u627e\u3002
\u5141\u8bb8\u666e\u901a\u6e05\u7406\u51bb\u7ed3\u67d0\u4e9b\u9875\u9762\uff0c\u5373\u4f7f\u5b83\u4eec\u90fd\u662f\u53ef\u89c1\u7684\uff08Melanie Plageman\uff09\u00a7 \u00a7
\n\u8fd9\u51cf\u5c11\u4e86\u540e\u671f\u5168\u5173\u7cfb\u51bb\u7ed3\u7684\u5f00\u9500\u3002\u5176\u6fc0\u8fdb\u6027\u53ef\u4ee5\u901a\u8fc7\u670d\u52a1\u5668\u53d8\u91cf\u548c\u6bcf\u8868\u8bbe\u7f6evacuum_max_eager_freeze_failure_rate\u63a7\u5236\u3002\u4ee5\u524d\uff0c\u5728\u9700\u8981\u51bb\u7ed3\u4e4b\u524d\uff0c\u6e05\u7406\u4ece\u4e0d\u5904\u7406\u6240\u6709\u53ef\u89c1\u9875\u9762\u3002
", "text": "\u5141\u8bb8\u666e\u901a\u6e05\u7406\u51bb\u7ed3\u67d0\u4e9b\u9875\u9762\uff0c\u5373\u4f7f\u5b83\u4eec\u90fd\u662f\u53ef\u89c1\u7684\uff08Melanie Plageman\uff09\u00a7 \u00a7 \u8fd9\u51cf\u5c11\u4e86\u540e\u671f\u5168\u5173\u7cfb\u51bb\u7ed3\u7684\u5f00\u9500\u3002\u5176\u6fc0\u8fdb\u6027\u53ef\u4ee5\u901a\u8fc7\u670d\u52a1\u5668\u53d8\u91cf\u548c\u6bcf\u8868\u8bbe\u7f6evacuum_max_eager_freeze_failure_rate\u63a7\u5236\u3002\u4ee5\u524d\uff0c\u5728\u9700\u8981\u51bb\u7ed3\u4e4b\u524d\uff0c\u6e05\u7406\u4ece\u4e0d\u5904\u7406\u6240\u6709\u53ef\u89c1\u9875\u9762\u3002", "title": "\u5141\u8bb8\u666e\u901a\u6e05\u7406\u51bb\u7ed3\u67d0\u4e9b\u9875\u9762\uff0c\u5373\u4f7f\u5b83\u4eec\u90fd\u662f\u53ef\u89c1\u7684", "commits": ["052026c9b", "06eae9e62"], "section": "\u670d\u52a1\u5668 / \u4e00\u822c\u6027\u80fd", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-PERFORMANCE", "source_hash": "067908e36f6001abfd9b89898d6468091c7c408aba70fd6644ef0e6e78945b17", "section_path": ["\u670d\u52a1\u5668", "\u4e00\u822c\u6027\u80fd"], "commit_groups": [["052026c9b"], ["06eae9e62"]], "identity_text": "Allow normal vacuums to freeze some pages, even though they are all-visible (Melanie Plageman) This reduces the overhead of later full-relation freezing. The aggressiveness of this can be controlled by server variable and per-table setting guc-vacuum-max-eager-freeze-failure-rate . Previously vacuum never processed all-visible pages until freezing was required.", "commit_aliases": ["052026c9b", "06eae9e62"], "source_commits": ["052026c9b", "06eae9e62"], "source_entry_id": "18.0/changes/023", "db_id": "b143946a18139ecebf85f4773c7419b5", "patch_ids": ["67ea98ee74614c1e13cce028969b4f44", "d3f807b22dffb17b1216f302711474dd"], "statement_hash": "1d01a6afb8bdd666bc7b3013928540e3f748fdac185055067dcbcfcb19976f2d", "relations": [], "category_label": "\u6027\u80fd\u6539\u8fdb", "url": "/docs/compare/?release=18.0#18.0-79ad0339f5219dcf", "migration": false}, {"id": "18.0-929700b56f096829", "cves": [], "html": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfvacuum_truncate\u4ee5\u63a7\u5236VACUUM\u671f\u95f4\u7684\u6587\u4ef6\u622a\u65ad\uff08Nathan Bossart, Gurjeet Singh\uff09\u00a7
\n\u5df2\u7ecf\u5b58\u5728\u4e00\u4e2a\u5177\u6709\u76f8\u540c\u540d\u79f0\u548c\u884c\u4e3a\u7684\u5b58\u50a8\u7ea7\u522b\u53c2\u6570\u3002
", "text": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfvacuum_truncate\u4ee5\u63a7\u5236VACUUM\u671f\u95f4\u7684\u6587\u4ef6\u622a\u65ad\uff08Nathan Bossart, Gurjeet Singh\uff09\u00a7 \u5df2\u7ecf\u5b58\u5728\u4e00\u4e2a\u5177\u6709\u76f8\u540c\u540d\u79f0\u548c\u884c\u4e3a\u7684\u5b58\u50a8\u7ea7\u522b\u53c2\u6570\u3002", "title": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfvacuum_truncate\u4ee5\u63a7\u5236VACUUM\u671f\u95f4\u7684\u6587\u4ef6\u622a\u65ad", "commits": ["0164a0f9e"], "section": "\u670d\u52a1\u5668 / \u4e00\u822c\u6027\u80fd", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-PERFORMANCE", "source_hash": "3bdf7d1f300811ca038842a0cc4e774e2520f4329d021c60a179b690525ba77f", "section_path": ["\u670d\u52a1\u5668", "\u4e00\u822c\u6027\u80fd"], "commit_groups": [["0164a0f9e"]], "identity_text": "Add server variable guc-vacuum-truncate to control file truncation during sql-vacuum (Nathan Bossart, Gurjeet Singh) A storage-level parameter with the same name and behavior already existed.", "commit_aliases": ["0164a0f9e"], "source_commits": ["0164a0f9e"], "source_entry_id": "18.0/changes/024", "db_id": "d1bf74ed1cb4e3fbacc9001855d15f16", "patch_ids": ["be7bc9e56cdce4915b9e4a702d43e637"], "statement_hash": "944b8ce94c10828d6d6910957cf641b88dc95d22b1b8115647738cec01db9fbe", "relations": [], "category_label": "\u6027\u80fd\u6539\u8fdb", "url": "/docs/compare/?release=18.0#18.0-929700b56f096829", "migration": false}, {"id": "18.0-e2695fe0532b1c4e", "cves": [], "html": "\u5c06\u670d\u52a1\u5668\u53d8\u91cfeffective_io_concurrency\u548cmaintenance_io_concurrency\u7684\u9ed8\u8ba4\u503c\u589e\u52a0\u5230 16\uff08Melanie Plageman\uff09\u00a7 \u00a7
\n\u8fd9\u66f4\u51c6\u786e\u5730\u53cd\u6620\u4e86\u73b0\u4ee3\u786c\u4ef6\u3002
", "text": "\u5c06\u670d\u52a1\u5668\u53d8\u91cfeffective_io_concurrency\u548cmaintenance_io_concurrency\u7684\u9ed8\u8ba4\u503c\u589e\u52a0\u5230 16\uff08Melanie Plageman\uff09\u00a7 \u00a7 \u8fd9\u66f4\u51c6\u786e\u5730\u53cd\u6620\u4e86\u73b0\u4ee3\u786c\u4ef6\u3002", "title": "\u5c06\u670d\u52a1\u5668\u53d8\u91cfeffective_io_concurrency\u548cmaintenance_io_concurrency\u7684\u9ed8\u8ba4\u503c\u589e\u52a0\u5230 16", "commits": ["cc6be07eb", "ff79b5b2a"], "section": "\u670d\u52a1\u5668 / \u4e00\u822c\u6027\u80fd", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-PERFORMANCE", "source_hash": "5ed1ab656f1d067bc897340478dcbb402d18bafb76ff5da9b9bec5940ff0e6da", "section_path": ["\u670d\u52a1\u5668", "\u4e00\u822c\u6027\u80fd"], "commit_groups": [["cc6be07eb"], ["ff79b5b2a"]], "identity_text": "Increase server variables guc-effective-io-concurrency 's and guc-maintenance-io-concurrency 's default values to 16 (Melanie Plageman) This more accurately reflects modern hardware.", "commit_aliases": ["cc6be07eb", "ff79b5b2a"], "source_commits": ["cc6be07eb", "ff79b5b2a"], "source_entry_id": "18.0/changes/025", "db_id": "426d3063330d1605a0f8dada895702c7", "patch_ids": ["5048dc209f8f981f9a097d9636573570", "711b2163ed88e992fa8f7ebd50bcabfe"], "statement_hash": "2388b7de66243eaf67d83494c797d6d1e1d27a9f5ff72da1c364e2e04896d1a4", "relations": [], "category_label": "\u6027\u80fd\u6539\u8fdb", "url": "/docs/compare/?release=18.0#18.0-e2695fe0532b1c4e", "migration": false}, {"id": "18.0-1853092f38c97a1c", "cves": [], "html": "\u589e\u52a0\u670d\u52a1\u5668\u53d8\u91cflog_connections\u7684\u65e5\u5fd7\u8bb0\u5f55\u7c92\u5ea6\uff08Melanie Plageman\uff09\u00a7
\n\u6b64\u670d\u52a1\u5668\u53d8\u91cf\u4ee5\u524d\u4ec5\u63a5\u53d7\u5e03\u5c14\u503c\uff1b\u5e03\u5c14\u503c\u7528\u6cd5\u4ecd\u53d7\u652f\u6301\u3002
", "text": "\u589e\u52a0\u670d\u52a1\u5668\u53d8\u91cflog_connections\u7684\u65e5\u5fd7\u8bb0\u5f55\u7c92\u5ea6\uff08Melanie Plageman\uff09\u00a7 \u6b64\u670d\u52a1\u5668\u53d8\u91cf\u4ee5\u524d\u4ec5\u63a5\u53d7\u5e03\u5c14\u503c\uff1b\u5e03\u5c14\u503c\u7528\u6cd5\u4ecd\u53d7\u652f\u6301\u3002", "title": "\u589e\u52a0\u670d\u52a1\u5668\u53d8\u91cflog_connections\u7684\u65e5\u5fd7\u8bb0\u5f55\u7c92\u5ea6", "commits": ["9219093ca"], "section": "\u670d\u52a1\u5668 / \u76d1\u63a7", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "42fa035457ddebe4280da1ffdf030abca58669ddee1f4de16c1998a7b9a4dfb2", "section_path": ["\u670d\u52a1\u5668", "\u76d1\u63a7"], "commit_groups": [["9219093ca"]], "identity_text": "Increase the logging granularity of server variable guc-log-connections (Melanie Plageman) This server variable was previously only boolean, which is still supported.", "commit_aliases": ["9219093ca"], "source_commits": ["9219093ca"], "source_entry_id": "18.0/changes/026", "db_id": "ff5e5f18a1f9dca408cdf9912c05dbc0", "patch_ids": ["a7e481af208e8edfa0f5fb1487d6f5da"], "statement_hash": "bdb1f75b5ad766542e4be765b90646c65665a1de272e063859e8ddf2ad109820", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-1853092f38c97a1c", "migration": false}, {"id": "18.0-618b0a37a5adca9c", "cves": [], "html": "\u6dfb\u52a0 log_connections \u9009\u9879\u4ee5\u62a5\u544a\u8fde\u63a5\u9636\u6bb5\u7684\u6301\u7eed\u65f6\u95f4\uff08Melanie Plageman\uff09\u00a7
\u6dfb\u52a0log_line_prefix\u8f6c\u4e49 %L \u4ee5\u8f93\u51fa\u5ba2\u6237\u7aefIP\u5730\u5740\uff08Greg Sabino Mullane\uff09\u00a7
\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cflog_lock_failures\u4ee5\u8bb0\u5f55\u9501\u83b7\u53d6\u5931\u8d25\uff08Yuki Seino, Fujii Masao\uff09\u00a7 \u00a7
\n\u5177\u4f53\u6765\u8bf4\uff0c\u5b83\u62a5\u544a SELECT ... NOWAIT \u9501\u5931\u8d25\u3002
\u4fee\u6539 pg_stat_all_tables \u53ca\u5176\u53d8\u4f53\u4ee5\u62a5\u544a\u5728VACUUM\u3001ANALYZE\u53ca\u5176\u81ea\u52a8\u6267\u884c\u7684\u53d8\u4f53\u4e2d\u82b1\u8d39\u7684\u65f6\u95f4\uff08Sami Imseih\uff09\u00a7
\u65b0\u5217\u662f total_vacuum_time\u3001total_autovacuum_time\u3001total_analyze_time \u548c total_autoanalyze_time\u3002
\u5411VACUUM\u548cANALYZE\u6dfb\u52a0\u5ef6\u8fdf\u65f6\u95f4\u62a5\u544a\uff08Bertrand Drouvot, Nathan Bossart\uff09\u00a7 \u00a7
\n\u6b64\u4fe1\u606f\u51fa\u73b0\u5728\u670d\u52a1\u5668\u65e5\u5fd7\u3001\u7cfb\u7edf\u89c6\u56fe pg_stat_progress_vacuum \u548c pg_stat_progress_analyze \u4ee5\u53caVACUUM\u548cANALYZE\u5728 VERBOSE \u6a21\u5f0f\u4e0b\u7684\u8f93\u51fa\u4e2d\uff1b\u5fc5\u987b\u4f7f\u7528\u670d\u52a1\u5668\u53d8\u91cftrack_cost_delay_timing\u542f\u7528\u8ddf\u8e2a\u3002
\u6dfb\u52a0WAL\u3001CPU\u4ee5\u53ca\u5e73\u5747\u8bfb\u53d6\u7edf\u8ba1\u4fe1\u606f\u8f93\u51fa\u5230 ANALYZE VERBOSE\uff08Anthonin Bonnefoy\uff09\u00a7 \u00a7
\u6dfb\u52a0\u5b8c\u6574WAL\u7f13\u51b2\u533a\u8ba1\u6570\u5230 VACUUM/ANALYZE (VERBOSE) \u548c autovacuum \u65e5\u5fd7\u8f93\u51fa\uff08Bertrand Drouvot\uff09\u00a7
\u6dfb\u52a0\u6bcf\u540e\u7aef I/O \u7edf\u8ba1\u4fe1\u606f\u62a5\u544a\uff08Bertrand Drouvot\uff09\u00a7 \u00a7
\n\u7edf\u8ba1\u4fe1\u606f\u901a\u8fc7 pg_stat_get_backend_io() \u8bbf\u95ee\u3002\u6bcf\u540e\u7aef I/O \u7edf\u8ba1\u4fe1\u606f\u53ef\u4ee5\u901a\u8fc7 pg_stat_reset_backend_stats() \u6e05\u9664\u3002
\u6dfb\u52a0 pg_stat_io \u5217\u4ee5\u5b57\u8282\u62a5\u544a I/O \u6d3b\u52a8\uff08Nazir Bilal Yavuz\uff09\u00a7
\u65b0\u5217\u662f read_bytes\u3001write_bytes \u548c extend_bytes\u3002op_bytes \u5217\uff08\u59cb\u7ec8\u7b49\u4e8e BLCKSZ\uff09\u5df2\u79fb\u9664\u3002
\u5411pg_stat_io\u6dfb\u52a0WAL I/O \u6d3b\u52a8\u884c\uff08Nazir Bilal Yavuz, Bertrand Drouvot, Michael Paquier\uff09\u00a7 \u00a7 \u00a7
\u8fd9\u5305\u62ecWAL\u63a5\u6536\u5668\u6d3b\u52a8\u4ee5\u53ca\u6b64\u7c7b\u5199\u5165\u7684\u7b49\u5f85\u4e8b\u4ef6\u3002
", "text": "\u5411pg_stat_io\u6dfb\u52a0WAL I/O \u6d3b\u52a8\u884c\uff08Nazir Bilal Yavuz, Bertrand Drouvot, Michael Paquier\uff09\u00a7 \u00a7 \u00a7 \u8fd9\u5305\u62ecWAL\u63a5\u6536\u5668\u6d3b\u52a8\u4ee5\u53ca\u6b64\u7c7b\u5199\u5165\u7684\u7b49\u5f85\u4e8b\u4ef6\u3002", "title": "\u5411pg_stat_io\u6dfb\u52a0WAL I/O \u6d3b\u52a8\u884c", "commits": ["4538bd3f1", "7f7f324eb", "a051e71e2"], "section": "\u670d\u52a1\u5668 / \u76d1\u63a7", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "1073fae0e1addc89e2446fa37b2acba1f913d9723e1c4429053ee3268c3f10de", "section_path": ["\u670d\u52a1\u5668", "\u76d1\u63a7"], "commit_groups": [["4538bd3f1"], ["7f7f324eb"], ["a051e71e2"]], "identity_text": "Add WAL I/O activity rows to pg_stat_io (Nazir Bilal Yavuz, Bertrand Drouvot, Michael Paquier) This includes WAL receiver activity and a wait event for such writes.", "commit_aliases": ["4538bd3f1", "7f7f324eb", "a051e71e2"], "source_commits": ["4538bd3f1", "7f7f324eb", "a051e71e2"], "source_entry_id": "18.0/changes/036", "db_id": "4e8a04b21c8fb51fcf294e0a57d8462f", "patch_ids": ["0abab9a405c724624eabd4509d63171e", "3d509df32980788958c9572c50adb4fd", "bef53f830f1ba9f3cda0cc8ff4ed91e6"], "statement_hash": "c5453439738584b897b3afc314105f41051f5aa95d24752734738916b65af097", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-4957f414fc70c628", "migration": false}, {"id": "18.0-878674061147da87", "cves": [], "html": "\u66f4\u6539\u670d\u52a1\u5668\u53d8\u91cftrack_wal_io_timing\u4ee5\u63a7\u5236\u5728pg_stat_io\u800c\u4e0d\u662f pg_stat_wal\u4e2d\u8ddf\u8e2aWAL\u8ba1\u65f6\uff08Bertrand Drouvot\uff09\u00a7
\u4ece pg_stat_wal \u4e2d\u79fb\u9664\u8bfb/\u540c\u6b65\u5217\uff08Bertrand Drouvot\uff09\u00a7 \u00a7
\u8fd9\u4f1a\u79fb\u9664\u5217 wal_write\u3001wal_sync\u3001wal_write_time \u548c wal_sync_time\u3002
\u6dfb\u52a0\u51fd\u6570 pg_stat_get_backend_wal() \u4ee5\u8fd4\u56de\u6bcf\u540e\u7aefWAL\u7edf\u8ba1\u4fe1\u606f\uff08Bertrand Drouvot\uff09\u00a7
\u6bcf\u540e\u7aefWAL\u7edf\u8ba1\u4fe1\u606f\u53ef\u4ee5\u901a\u8fc7 pg_stat_reset_backend_stats() \u6e05\u9664\u3002
\u6dfb\u52a0\u51fd\u6570 pg_ls_summariesdir() \u4ee5\u4e13\u95e8\u5217\u51fa PGDATA/pg_wal/summaries \u7684\u5185\u5bb9\uff08Yushi Ogiwara\uff09\u00a7
\u6dfb\u52a0\u5217 pg_stat_checkpointer.num_done \u4ee5\u62a5\u544a\u5df2\u5b8c\u6210\u7684\u68c0\u67e5\u70b9\u6570\u91cf\uff08Anton A. Melnikov\uff09\u00a7
\u5217 num_timed \u548c num_requested \u540c\u65f6\u7edf\u8ba1\u5df2\u5b8c\u6210\u548c\u5df2\u8df3\u8fc7\u7684\u68c0\u67e5\u70b9\u3002
\u6dfb\u52a0\u5217 pg_stat_checkpointer.slru_written \u4ee5\u62a5\u544aSLRU\u5199\u5165\u7684\u7f13\u51b2\u533a\uff08Nitin Jadhav\uff09\u00a7
\u6b64\u5916\uff0c\u4fee\u6539\u68c0\u67e5\u70b9\u670d\u52a1\u5668\u65e5\u5fd7\u6d88\u606f\u4ee5\u62a5\u544a\u5355\u72ec\u7684\u5171\u4eab\u7f13\u51b2\u533a\u548cSLRU\u7f13\u51b2\u533a\u503c\u3002
", "text": "\u6dfb\u52a0\u5217 pg_stat_checkpointer.slru_written \u4ee5\u62a5\u544aSLRU\u5199\u5165\u7684\u7f13\u51b2\u533a\uff08Nitin Jadhav\uff09\u00a7 \u6b64\u5916\uff0c\u4fee\u6539\u68c0\u67e5\u70b9\u670d\u52a1\u5668\u65e5\u5fd7\u6d88\u606f\u4ee5\u62a5\u544a\u5355\u72ec\u7684\u5171\u4eab\u7f13\u51b2\u533a\u548cSLRU\u7f13\u51b2\u533a\u503c\u3002", "title": "\u6dfb\u52a0\u5217 pg_stat_checkpointer.slru_written \u4ee5\u62a5\u544aSLRU\u5199\u5165\u7684\u7f13\u51b2\u533a", "commits": ["17cc5f666"], "section": "\u670d\u52a1\u5668 / \u76d1\u63a7", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "e3cd14d094f854569dcf0a7ec616f689d1baac8a113db529f691cfd28c517c08", "section_path": ["\u670d\u52a1\u5668", "\u76d1\u63a7"], "commit_groups": [["17cc5f666"]], "identity_text": "Add column pg_stat_checkpointer.slru_written to report SLRU buffers written (Nitin Jadhav) Also, modify the checkpoint server log message to report separate shared buffer and SLRU buffer values.", "commit_aliases": ["17cc5f666"], "source_commits": ["17cc5f666"], "source_entry_id": "18.0/changes/042", "db_id": "c727bac201403ee5787ce91519d78b8f", "patch_ids": ["d6837b0ccfa7bed8d3ef332bff20c386"], "statement_hash": "d75f1cff8692d2b125311380a9eb939eed72a5eec22bed4041dad77e8aed16e7", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-e09a699e25c96cec", "migration": false}, {"id": "18.0-830bba3026f852b8", "cves": [], "html": "\u6dfb\u52a0\u5217\u5230 pg_stat_database \u4ee5\u62a5\u544a\u5e76\u884c\u5de5\u4f5c\u8005\u6d3b\u52a8\uff08Benoit Lobr\u00e9au\uff09\u00a7
\u65b0\u5217\u662f parallel_workers_to_launch \u548c parallel_workers_launched\u3002
\u8ba9\u5e38\u91cf\u5217\u8868\u7684\u67e5\u8be2 ID \u8ba1\u7b97\u53ea\u8003\u8651\u7b2c\u4e00\u4e2a\u548c\u6700\u540e\u4e00\u4e2a\u5e38\u91cf\uff08Dmitry Dolgov, Sami Imseih\uff09\u00a7 \u00a7 \u00a7
\n\u67e5\u8be2\u89c4\u8303\u5316\u7531pg_stat_statements\u4f7f\u7528\u3002
", "text": "\u8ba9\u5e38\u91cf\u5217\u8868\u7684\u67e5\u8be2 ID \u8ba1\u7b97\u53ea\u8003\u8651\u7b2c\u4e00\u4e2a\u548c\u6700\u540e\u4e00\u4e2a\u5e38\u91cf\uff08Dmitry Dolgov, Sami Imseih\uff09\u00a7 \u00a7 \u00a7 \u67e5\u8be2\u89c4\u8303\u5316\u7531pg_stat_statements\u4f7f\u7528\u3002", "title": "\u8ba9\u5e38\u91cf\u5217\u8868\u7684\u67e5\u8be2 ID \u8ba1\u7b97\u53ea\u8003\u8651\u7b2c\u4e00\u4e2a\u548c\u6700\u540e\u4e00\u4e2a\u5e38\u91cf", "commits": ["62d712ecf", "9fbd53dea", "c2da1a5d6"], "section": "\u670d\u52a1\u5668 / \u76d1\u63a7", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "2cf9373f5b7eddab9fd5ff38dada6cd3257b8f28a837aed595560e11f200a37d", "section_path": ["\u670d\u52a1\u5668", "\u76d1\u63a7"], "commit_groups": [["62d712ecf"], ["9fbd53dea"], ["c2da1a5d6"]], "identity_text": "Have query id computation of constant lists consider only the first and last constants (Dmitry Dolgov, Sami Imseih) Jumbling is used by pgstatstatements .", "commit_aliases": ["62d712ecf", "9fbd53dea", "c2da1a5d6"], "source_commits": ["62d712ecf", "9fbd53dea", "c2da1a5d6"], "source_entry_id": "18.0/changes/044", "db_id": "602391884e0f9956bc8189e3df9fa46c", "patch_ids": ["5788e402f9a32d0839d25eda04d2e777", "892e3023e3eb75d6d37898823ef6e17d", "b602290e314da4eb2c893c183d542ea2"], "statement_hash": "15594176dafd96eadc8774ee3c07b03bfac584e26aab1114deaf08975c0d6fa7", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-73696288ba5ce9c6", "migration": false}, {"id": "18.0-628577c78133fcaf", "cves": [], "html": "\u8c03\u6574\u67e5\u8be2 ID \u8ba1\u7b97\u4ee5\u5c06\u4f7f\u7528\u76f8\u540c\u5173\u7cfb\u540d\u79f0\u7684\u67e5\u8be2\u7ec4\u5408\u5728\u4e00\u8d77\uff08Michael Paquier, Sami Imseih\uff09\u00a7
\n\u5373\u4f7f\u4e0d\u540c\u6a21\u5f0f\u4e2d\u7684\u8868\u5177\u6709\u4e0d\u540c\u7684\u5217\u540d\uff0c\u8fd9\u4e5f\u662f\u6210\u7acb\u7684\u3002
", "text": "\u8c03\u6574\u67e5\u8be2 ID \u8ba1\u7b97\u4ee5\u5c06\u4f7f\u7528\u76f8\u540c\u5173\u7cfb\u540d\u79f0\u7684\u67e5\u8be2\u7ec4\u5408\u5728\u4e00\u8d77\uff08Michael Paquier, Sami Imseih\uff09\u00a7 \u5373\u4f7f\u4e0d\u540c\u6a21\u5f0f\u4e2d\u7684\u8868\u5177\u6709\u4e0d\u540c\u7684\u5217\u540d\uff0c\u8fd9\u4e5f\u662f\u6210\u7acb\u7684\u3002", "title": "\u8c03\u6574\u67e5\u8be2 ID \u8ba1\u7b97\u4ee5\u5c06\u4f7f\u7528\u76f8\u540c\u5173\u7cfb\u540d\u79f0\u7684\u67e5\u8be2\u7ec4\u5408\u5728\u4e00\u8d77", "commits": ["787514b30"], "section": "\u670d\u52a1\u5668 / \u76d1\u63a7", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MONITORING", "source_hash": "09abeab4f5099639b5d52aa31679edc914c3b3c20594c0d395bf45bf491d5e09", "section_path": ["\u670d\u52a1\u5668", "\u76d1\u63a7"], "commit_groups": [["787514b30"]], "identity_text": "Adjust query id computations to group together queries using the same relation name (Michael Paquier, Sami Imseih) This is true even if the tables in different schemas have different column names.", "commit_aliases": ["787514b30"], "source_commits": ["787514b30"], "source_entry_id": "18.0/changes/045", "db_id": "b3b7d2a11d4d31f38f5974d4bc93b3e3", "patch_ids": ["79273c32213aef68723d02e288664812"], "statement_hash": "4cd23dc47a6dcb75efe88b4674803607d5b63bfc8d8855e3822b801ecc934093", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-628577c78133fcaf", "migration": false}, {"id": "18.0-1c87b8097e5f44a6", "cves": [], "html": "\u6dfb\u52a0\u5217 pg_backend_memory_contexts.type \u4ee5\u62a5\u544a\u5185\u5b58\u4e0a\u4e0b\u6587\u7684\u7c7b\u578b\uff08David Rowley\uff09\u00a7
\u6dfb\u52a0\u5217 pg_backend_memory_contexts.path \u4ee5\u663e\u793a\u5185\u5b58\u4e0a\u4e0b\u6587\u7236\u7ea7\uff08Melih Mutlu\uff09\u00a7
\u6dfb\u52a0\u51fd\u6570 pg_get_acl() \u4ee5\u68c0\u7d22\u6570\u636e\u5e93\u8bbf\u95ee\u63a7\u5236\u8be6\u7ec6\u4fe1\u606f\uff08Joel Jacobson\uff09\u00a7 \u00a7
\u6dfb\u52a0\u51fd\u6570 has_largeobject_privilege() \u4ee5\u68c0\u67e5\u5927\u578b\u5bf9\u8c61\u6743\u9650\uff08Yugo Nagata\uff09\u00a7
\u5141\u8bb8ALTER DEFAULT PRIVILEGES\u5b9a\u4e49\u5927\u578b\u5bf9\u8c61\u9ed8\u8ba4\u6743\u9650\uff08Takatsuka Haruka, Yugo Nagata, Laurenz Albe\uff09\u00a7
", "text": "\u5141\u8bb8ALTER DEFAULT PRIVILEGES\u5b9a\u4e49\u5927\u578b\u5bf9\u8c61\u9ed8\u8ba4\u6743\u9650\uff08Takatsuka Haruka, Yugo Nagata, Laurenz Albe\uff09\u00a7", "title": "\u5141\u8bb8ALTER DEFAULT PRIVILEGES\u5b9a\u4e49\u5927\u578b\u5bf9\u8c61\u9ed8\u8ba4\u6743\u9650", "commits": ["0d6c47766"], "section": "\u670d\u52a1\u5668 / \u6743\u9650", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PRIVILEGES", "source_hash": "4c91df429994b748ca8f11482114f697801f5b8c6c8b714ebf14f04619bf4653", "section_path": ["\u670d\u52a1\u5668", "\u6743\u9650"], "commit_groups": [["0d6c47766"]], "identity_text": "Allow sql-alterdefaultprivileges to define large object default privileges (Takatsuka Haruka, Yugo Nagata, Laurenz Albe)", "commit_aliases": ["0d6c47766"], "source_commits": ["0d6c47766"], "source_entry_id": "18.0/changes/050", "db_id": "2115b59fe3ecb850d34420db9087d6ee", "patch_ids": ["8bd885a988ec8e858d73081f630fd33d"], "statement_hash": "91512a6ced76577a52c71c7f1692309e60bb18dc1ce44331c056f04fd50fb429", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-5604ffb99ab25c2e", "migration": false}, {"id": "18.0-85bb8a1c74259843", "cves": [], "html": "\u6dfb\u52a0\u9884\u5b9a\u4e49\u89d2\u8272 pg_signal_autovacuum_worker\uff08Kirill Reshke\uff09\u00a7
\u8fd9\u5141\u8bb8\u5411\u81ea\u52a8\u6e05\u7406\u5de5\u4f5c\u8005\u53d1\u9001\u4fe1\u53f7\u3002
", "text": "\u6dfb\u52a0\u9884\u5b9a\u4e49\u89d2\u8272 pg_signal_autovacuum_worker\uff08Kirill Reshke\uff09\u00a7 \u8fd9\u5141\u8bb8\u5411\u81ea\u52a8\u6e05\u7406\u5de5\u4f5c\u8005\u53d1\u9001\u4fe1\u53f7\u3002", "title": "\u6dfb\u52a0\u9884\u5b9a\u4e49\u89d2\u8272 pg_signal_autovacuum_worker", "commits": ["ccd38024b"], "section": "\u670d\u52a1\u5668 / \u6743\u9650", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PRIVILEGES", "source_hash": "bfdef5e379e1781509025a5997d7b24eee477202a1c63fdf10ed414f0ba7b3e4", "section_path": ["\u670d\u52a1\u5668", "\u6743\u9650"], "commit_groups": [["ccd38024b"]], "identity_text": "Add predefined role pg_signal_autovacuum_worker (Kirill Reshke) This allows sending signals to autovacuum workers.", "commit_aliases": ["ccd38024b"], "source_commits": ["ccd38024b"], "source_entry_id": "18.0/changes/051", "db_id": "20b3f6628c87707ad4d0eb8fd8768e0a", "patch_ids": ["a254744dab5b2721c5babac8740a351d"], "statement_hash": "c15408fea664f43b416b4b112fe35a5f8e4c76546718ab374fef03190e47327d", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-85bb8a1c74259843", "migration": false}, {"id": "18.0-5ff741495e245c7b", "cves": [], "html": "\u6dfb\u52a0\u5bf9 OAuth \u8ba4\u8bc1\u65b9\u6cd5\u7684\u652f\u6301\uff08Jacob Champion, Daniel Gustafsson, Thomas Munro\uff09\u00a7
\n\u8fd9\u4e3a pg_hba.conf \u6dfb\u52a0\u4e86 oauth \u8ba4\u8bc1\u65b9\u6cd5\u3001libpq OAuth \u9009\u9879\u3001\u4e00\u4e2a\u7528\u4e8e\u52a0\u8f7d\u4ee4\u724c\u9a8c\u8bc1\u5e93\u7684\u670d\u52a1\u5668\u53d8\u91cfoauth_validator_libraries\uff0c\u4ee5\u53ca\u4e00\u4e2a --with-libcurl \u914d\u7f6e\u6807\u5fd7\uff0c\u7528\u4e8e\u6dfb\u52a0\u6240\u9700\u7684\u7f16\u8bd1\u65f6\u5e93\u3002
\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfssl_tls13_ciphers\u4ee5\u5141\u8bb8\u6307\u5b9a\u591a\u4e2a\u4ee5\u5192\u53f7\u5206\u9694\u7684 TLSv1.3 \u5bc6\u7801\u5957\u4ef6\uff08Erica Zhang, Daniel Gustafsson\uff09\u00a7
", "text": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfssl_tls13_ciphers\u4ee5\u5141\u8bb8\u6307\u5b9a\u591a\u4e2a\u4ee5\u5192\u53f7\u5206\u9694\u7684 TLSv1.3 \u5bc6\u7801\u5957\u4ef6\uff08Erica Zhang, Daniel Gustafsson\uff09\u00a7", "title": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfssl_tls13_ciphers\u4ee5\u5141\u8bb8\u6307\u5b9a\u591a\u4e2a\u4ee5\u5192\u53f7\u5206\u9694\u7684 TLSv1.3 \u5bc6\u7801\u5957\u4ef6", "commits": ["45188c2ea"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "5d256d99caaf5046100077cd472e922ae375d82b0f5b45bcfbac3a79833692b5", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["45188c2ea"]], "identity_text": "Add server variable guc-ssl-tls13-ciphers to allow specification of multiple colon-separated TLSv1.3 cipher suites (Erica Zhang, Daniel Gustafsson)", "commit_aliases": ["45188c2ea"], "source_commits": ["45188c2ea"], "source_entry_id": "18.0/changes/053", "db_id": "13b081fb2e1030e7c402c99be84d674e", "patch_ids": ["b918cd02542986f670ea5e4ccce7bed8"], "statement_hash": "ffe4b310bcfc2b812bd9ca43729c6e6988676e615fa96ac501930ef3cd998db9", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-6419f0734c073f35", "migration": false}, {"id": "18.0-065524e3b98547b4", "cves": [], "html": "\u5c06\u670d\u52a1\u5668\u53d8\u91cfssl_groups\u7684\u9ed8\u8ba4\u503c\u66f4\u6539\u4e3a\u5305\u542b\u692d\u5706\u66f2\u7ebf X25519\uff08Daniel Gustafsson, Jacob Champion\uff09\u00a7
", "text": "\u5c06\u670d\u52a1\u5668\u53d8\u91cfssl_groups\u7684\u9ed8\u8ba4\u503c\u66f4\u6539\u4e3a\u5305\u542b\u692d\u5706\u66f2\u7ebf X25519\uff08Daniel Gustafsson, Jacob Champion\uff09\u00a7", "title": "\u5c06\u670d\u52a1\u5668\u53d8\u91cfssl_groups\u7684\u9ed8\u8ba4\u503c\u66f4\u6539\u4e3a\u5305\u542b\u692d\u5706\u66f2\u7ebf X25519", "commits": ["daa02c6bd"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "769ef4c7a0e583d2f4cb847ab408143dd1d5d440e558c0b751debd0c43265451", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["daa02c6bd"]], "identity_text": "Change server variable guc-ssl-groups 's default to include elliptic curve X25519 (Daniel Gustafsson, Jacob Champion)", "commit_aliases": ["daa02c6bd"], "source_commits": ["daa02c6bd"], "source_entry_id": "18.0/changes/054", "db_id": "0ff6b951577e789ccfcf50c5fdd16250", "patch_ids": ["b6419e2ab5092340bdb51279a882c575"], "statement_hash": "79f1b0ec5dbbc9c41cfae0c653c6b8af2978a2d458009ec866463efb3c895406", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-065524e3b98547b4", "migration": false}, {"id": "18.0-e389dbfe8645ccad", "cves": [], "html": "\u5c06\u670d\u52a1\u5668\u53d8\u91cf ssl_ecdh_curve \u91cd\u547d\u540d\u4e3assl_groups\uff0c\u5e76\u5141\u8bb8\u6307\u5b9a\u591a\u4e2a\u4ee5\u5192\u53f7\u5206\u9694\u7684ECDH\u66f2\u7ebf\uff08Erica Zhang, Daniel Gustafsson\uff09\u00a7
\u4ee5\u524d\u7684\u540d\u79f0\u4ecd\u7136\u6709\u6548\u3002
", "text": "\u5c06\u670d\u52a1\u5668\u53d8\u91cf ssl_ecdh_curve \u91cd\u547d\u540d\u4e3assl_groups\uff0c\u5e76\u5141\u8bb8\u6307\u5b9a\u591a\u4e2a\u4ee5\u5192\u53f7\u5206\u9694\u7684ECDH\u66f2\u7ebf\uff08Erica Zhang, Daniel Gustafsson\uff09\u00a7 \u4ee5\u524d\u7684\u540d\u79f0\u4ecd\u7136\u6709\u6548\u3002", "title": "\u5c06\u670d\u52a1\u5668\u53d8\u91cf ssl_ecdh_curve \u91cd\u547d\u540d\u4e3assl_groups\uff0c\u5e76\u5141\u8bb8\u6307\u5b9a\u591a\u4e2a\u4ee5\u5192\u53f7\u5206\u9694\u7684ECDH\u66f2\u7ebf", "commits": ["3d1ef3a15"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "69fc229fb451ba3569f10661789b08fd931063d5102c111408c2c761550da092", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["3d1ef3a15"]], "identity_text": "Rename server variable ssl_ecdh_curve to guc-ssl-groups and allow multiple colon-separated ECDH curves to be specified (Erica Zhang, Daniel Gustafsson) The previous name still works.", "commit_aliases": ["3d1ef3a15"], "source_commits": ["3d1ef3a15"], "source_entry_id": "18.0/changes/055", "db_id": "96a81164afdac0bf4ed0486ab950b9cc", "patch_ids": ["c2561d4875ae281fdaea78d9e93eaee2"], "statement_hash": "af282a32e71f1303e38dd9f838dce742a3ea5e5033c66e5a334acc730ab67445", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-e389dbfe8645ccad", "migration": false}, {"id": "18.0-8331e2d5ef9a11f8", "cves": [], "html": "\u5c06\u53d6\u6d88\u8bf7\u6c42\u5bc6\u94a5\u8bbe\u4e3a 256 \u4f4d\uff08Heikki Linnakangas, Jelte Fennema-Nio\uff09\u00a7 \u00a7
\n\u8fd9\u53ea\u6709\u5728\u670d\u52a1\u5668\u548c\u5ba2\u6237\u7aef\u652f\u6301\u672c\u7248\u672c\u4e2d\u5f15\u5165\u7684\u7ebf\u534f\u8bae\u7248\u672c3.2\u65f6\u624d\u53ef\u80fd\u5b9e\u73b0\u3002
", "text": "\u5c06\u53d6\u6d88\u8bf7\u6c42\u5bc6\u94a5\u8bbe\u4e3a 256 \u4f4d\uff08Heikki Linnakangas, Jelte Fennema-Nio\uff09\u00a7 \u00a7 \u8fd9\u53ea\u6709\u5728\u670d\u52a1\u5668\u548c\u5ba2\u6237\u7aef\u652f\u6301\u672c\u7248\u672c\u4e2d\u5f15\u5165\u7684\u7ebf\u534f\u8bae\u7248\u672c3.2\u65f6\u624d\u53ef\u80fd\u5b9e\u73b0\u3002", "title": "\u5c06\u53d6\u6d88\u8bf7\u6c42\u5bc6\u94a5\u8bbe\u4e3a 256 \u4f4d", "commits": ["9d9b9d46f", "a460251f0"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "4da7c6464ec24190e054671959a89c1342b41fd9c2df30a579e2cb4c8e608823", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["9d9b9d46f"], ["a460251f0"]], "identity_text": "Make cancel request keys 256 bits (Heikki Linnakangas, Jelte Fennema-Nio) This is only possible when the server and client support wire protocol version 3.2, introduced in this release.", "commit_aliases": ["9d9b9d46f", "a460251f0"], "source_commits": ["9d9b9d46f", "a460251f0"], "source_entry_id": "18.0/changes/056", "db_id": "d4bdcc752134e88e3b6f69045f91e32f", "patch_ids": ["3374f7d4348f979a16fb3f835b1434dd", "78aeb882063c4d9c0113cb769f6f63c8"], "statement_hash": "bf970fd6a3a870ec104cf3173699ac7821ccb4e686bb18b2d9050cfee203c953", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-8331e2d5ef9a11f8", "migration": false}, {"id": "18.0-e640f1a488be668b", "cves": [], "html": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfautovacuum_worker_slots\u4ee5\u6307\u5b9a\u540e\u53f0\u5de5\u4f5c\u8005\u7684\u6700\u5927\u6570\u91cf\uff08Nathan Bossart\uff09\u00a7
\n\u8bbe\u7f6e\u6b64\u53d8\u91cf\u540e\uff0cautovacuum_max_workers\u53ef\u4ee5\u5728\u8fd0\u884c\u65f6\u8c03\u6574\u5230\u6b64\u6700\u5927\u503c\uff0c\u800c\u65e0\u9700\u91cd\u65b0\u542f\u52a8\u670d\u52a1\u5668\u3002
", "text": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfautovacuum_worker_slots\u4ee5\u6307\u5b9a\u540e\u53f0\u5de5\u4f5c\u8005\u7684\u6700\u5927\u6570\u91cf\uff08Nathan Bossart\uff09\u00a7 \u8bbe\u7f6e\u6b64\u53d8\u91cf\u540e\uff0cautovacuum_max_workers\u53ef\u4ee5\u5728\u8fd0\u884c\u65f6\u8c03\u6574\u5230\u6b64\u6700\u5927\u503c\uff0c\u800c\u65e0\u9700\u91cd\u65b0\u542f\u52a8\u670d\u52a1\u5668\u3002", "title": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfautovacuum_worker_slots\u4ee5\u6307\u5b9a\u540e\u53f0\u5de5\u4f5c\u8005\u7684\u6700\u5927\u6570\u91cf", "commits": ["c758119e5"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "cccf9f941c4560c33011e635dcab0b9c28ae26749ffd1608f7169c4ecf499acc", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["c758119e5"]], "identity_text": "Add server variable guc-autovacuum-worker-slots to specify the maximum number of background workers (Nathan Bossart) With this variable set, guc-autovacuum-max-workers can be adjusted at runtime up to this maximum without a server restart.", "commit_aliases": ["c758119e5"], "source_commits": ["c758119e5"], "source_entry_id": "18.0/changes/057", "db_id": "14193c2c6216dac54ee9f03d74597315", "patch_ids": ["17efa2578b6fdfca54d1895a47b5d85c"], "statement_hash": "2340cf9dd0c8914c3ae78fcca1d6cb8a3eec267275fe98352062b37d256a1302", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-e640f1a488be668b", "migration": false}, {"id": "18.0-42921b23820eecfb", "cves": [], "html": "\u5141\u8bb8\u6307\u5b9a\u89e6\u53d1 autovacuum \u7684\u6b7b\u5143\u7ec4\u7684\u56fa\u5b9a\u6570\u91cf\uff08Nathan Bossart, Fr\u00e9d\u00e9ric Yhuel\uff09\u00a7
\n\u670d\u52a1\u5668\u53d8\u91cf\u662fautovacuum_vacuum_max_threshold\u3002\u767e\u5206\u6bd4\u4ecd\u7528\u4e8e\u89e6\u53d1\u3002
", "text": "\u5141\u8bb8\u6307\u5b9a\u89e6\u53d1 autovacuum \u7684\u6b7b\u5143\u7ec4\u7684\u56fa\u5b9a\u6570\u91cf\uff08Nathan Bossart, Fr\u00e9d\u00e9ric Yhuel\uff09\u00a7 \u670d\u52a1\u5668\u53d8\u91cf\u662fautovacuum_vacuum_max_threshold\u3002\u767e\u5206\u6bd4\u4ecd\u7528\u4e8e\u89e6\u53d1\u3002", "title": "\u5141\u8bb8\u6307\u5b9a\u89e6\u53d1 autovacuum \u7684\u6b7b\u5143\u7ec4\u7684\u56fa\u5b9a\u6570\u91cf", "commits": ["306dc520b"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "bugfix", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "fd553683edfb9d3b450f0a00d5e58d81232bb84ff144ad688ad048e97b11922e", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["306dc520b"]], "identity_text": "Allow specification of the fixed number of dead tuples that will trigger an autovacuum (Nathan Bossart, Fr\u00e9d\u00e9ric Yhuel) The server variable is guc-autovacuum-vacuum-max-threshold . Percentages are still used for triggering.", "commit_aliases": ["306dc520b"], "source_commits": ["306dc520b"], "source_entry_id": "18.0/changes/058", "db_id": "c6c8d0da14fc739954f67e4c3e8e297c", "patch_ids": ["fede0a2ed06d94a30aac6de8675efbce"], "statement_hash": "f26aed72e786336ffb0181c576796c1b0d66b6c0c79fa7ab8337a9deb9a04a70", "relations": [], "category_label": "BUG \u4fee\u590d", "url": "/docs/compare/?release=18.0#18.0-42921b23820eecfb", "migration": false}, {"id": "18.0-3bae7a931bd83da1", "cves": [], "html": "\u66f4\u6539\u670d\u52a1\u5668\u53d8\u91cfmax_files_per_process\u4ee5\u4ec5\u9650\u5236\u540e\u7aef\u6253\u5f00\u7684\u6587\u4ef6\uff08Andres Freund\uff09\u00a7
\n\u4ee5\u524d\uff0cpostmaster \u6253\u5f00\u7684\u6587\u4ef6\u4e5f\u8ba1\u5165\u6b64\u9650\u5236\u3002
", "text": "\u66f4\u6539\u670d\u52a1\u5668\u53d8\u91cfmax_files_per_process\u4ee5\u4ec5\u9650\u5236\u540e\u7aef\u6253\u5f00\u7684\u6587\u4ef6\uff08Andres Freund\uff09\u00a7 \u4ee5\u524d\uff0cpostmaster \u6253\u5f00\u7684\u6587\u4ef6\u4e5f\u8ba1\u5165\u6b64\u9650\u5236\u3002", "title": "\u66f4\u6539\u670d\u52a1\u5668\u53d8\u91cfmax_files_per_process\u4ee5\u4ec5\u9650\u5236\u540e\u7aef\u6253\u5f00\u7684\u6587\u4ef6", "commits": ["adb5f85fa"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "2618bfe12d00c39268c401694e59d9fad97443ba987c22b6d62e307da9068d9a", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["adb5f85fa"]], "identity_text": "Change server variable guc-max-files-per-process to limit only files opened by a backend (Andres Freund) Previously files opened by the postmaster were also counted toward this limit.", "commit_aliases": ["adb5f85fa"], "source_commits": ["adb5f85fa"], "source_entry_id": "18.0/changes/059", "db_id": "7d0f8a8401a0235fee5c42443323fd9f", "patch_ids": ["1253eb7b68a386abd794c882137adc02"], "statement_hash": "04e1a6687e91598505d1cd8239184c483171e03aa143374ed943a3e8b71c817c", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-3bae7a931bd83da1", "migration": false}, {"id": "18.0-0f2f3a9ba5d31cd7", "cves": [], "html": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfnum_os_semaphores\u4ee5\u62a5\u544a\u6240\u9700\u4fe1\u53f7\u91cf\u7684\u6570\u91cf\uff08Nathan Bossart\uff09\u00a7
\n\u8fd9\u5bf9\u4e8e\u64cd\u4f5c\u7cfb\u7edf\u914d\u7f6e\u5f88\u6709\u7528\u3002
", "text": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfnum_os_semaphores\u4ee5\u62a5\u544a\u6240\u9700\u4fe1\u53f7\u91cf\u7684\u6570\u91cf\uff08Nathan Bossart\uff09\u00a7 \u8fd9\u5bf9\u4e8e\u64cd\u4f5c\u7cfb\u7edf\u914d\u7f6e\u5f88\u6709\u7528\u3002", "title": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfnum_os_semaphores\u4ee5\u62a5\u544a\u6240\u9700\u4fe1\u53f7\u91cf\u7684\u6570\u91cf", "commits": ["0dcaea569"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "9ab5511113bd82e70e3a03fc12538f6345af41f77c718778b40bf3d3a03203b6", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["0dcaea569"]], "identity_text": "Add server variable guc-num-os-semaphores to report the required number of semaphores (Nathan Bossart) This is useful for operating system configuration.", "commit_aliases": ["0dcaea569"], "source_commits": ["0dcaea569"], "source_entry_id": "18.0/changes/060", "db_id": "baa925cc966c3797d6c1baeb8600b3af", "patch_ids": ["7cab2bba487b8dfdc88b894d86ebcb31"], "statement_hash": "db627bdf62b6a351d882ccec445c9221ec8e4d930aed5bf5e6b0b5b611bd8094", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-0f2f3a9ba5d31cd7", "migration": false}, {"id": "18.0-911f58cd6d2f91a5", "cves": [], "html": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfextension_control_path\u4ee5\u6307\u5b9a\u6269\u5c55\u63a7\u5236\u6587\u4ef6\u7684\u4f4d\u7f6e\uff08Peter Eisentraut, Matheus Alcantara\uff09\u00a7 \u00a7
", "text": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfextension_control_path\u4ee5\u6307\u5b9a\u6269\u5c55\u63a7\u5236\u6587\u4ef6\u7684\u4f4d\u7f6e\uff08Peter Eisentraut, Matheus Alcantara\uff09\u00a7 \u00a7", "title": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfextension_control_path\u4ee5\u6307\u5b9a\u6269\u5c55\u63a7\u5236\u6587\u4ef6\u7684\u4f4d\u7f6e", "commits": ["4f7f7b037", "81eaaa2c4"], "section": "\u670d\u52a1\u5668 / \u670d\u52a1\u5668\u914d\u7f6e", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-CONFIG", "source_hash": "9d62b8c0663f70e4f69542ec94abb0e3f367bb880d1661fa4b5ee26a52495548", "section_path": ["\u670d\u52a1\u5668", "\u670d\u52a1\u5668\u914d\u7f6e"], "commit_groups": [["4f7f7b037"], ["81eaaa2c4"]], "identity_text": "Add server variable guc-extension-control-path to specify the location of extension control files (Peter Eisentraut, Matheus Alcantara)", "commit_aliases": ["4f7f7b037", "81eaaa2c4"], "source_commits": ["4f7f7b037", "81eaaa2c4"], "source_entry_id": "18.0/changes/061", "db_id": "9a0ac630df36e673c00b61131cd0c2ff", "patch_ids": ["2c992ea1a18c7e56b1999e13915ad2f8", "95178da37b740ae32403368a9d5de091"], "statement_hash": "b2d063e72b9d991ddf32656536cdf6aa960609b5293a9f7685124d9018ed0d46", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-911f58cd6d2f91a5", "migration": false}, {"id": "18.0-89dab26f6ecf89b1", "cves": [], "html": "\u5141\u8bb8\u4f7f\u7528\u670d\u52a1\u5668\u53d8\u91cfidle_replication_slot_timeout\u81ea\u52a8\u4f7f\u975e\u6d3b\u52a8\u590d\u5236\u69fd\u5931\u6548\uff08Nisha Moond, Bharath Rupireddy\uff09\u00a7
", "text": "\u5141\u8bb8\u4f7f\u7528\u670d\u52a1\u5668\u53d8\u91cfidle_replication_slot_timeout\u81ea\u52a8\u4f7f\u975e\u6d3b\u52a8\u590d\u5236\u69fd\u5931\u6548\uff08Nisha Moond, Bharath Rupireddy\uff09\u00a7", "title": "\u5141\u8bb8\u4f7f\u7528\u670d\u52a1\u5668\u53d8\u91cfidle_replication_slot_timeout\u81ea\u52a8\u4f7f\u975e\u6d3b\u52a8\u590d\u5236\u69fd\u5931\u6548", "commits": ["ac0e33136"], "section": "\u670d\u52a1\u5668 / \u6d41\u590d\u5236\u4e0e\u6062\u590d", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-REPLICATION", "source_hash": "8c442254dde2045ae1b1e87460c9e70a650a5b8afddfac774dc1463a967d81ba", "section_path": ["\u670d\u52a1\u5668", "\u6d41\u590d\u5236\u4e0e\u6062\u590d"], "commit_groups": [["ac0e33136"]], "identity_text": "Allow inactive replication slots to be automatically invalidated using server variable guc-idle-replication-slot-timeout (Nisha Moond, Bharath Rupireddy)", "commit_aliases": ["ac0e33136"], "source_commits": ["ac0e33136"], "source_entry_id": "18.0/changes/062", "db_id": "7e52ed73d316bf78778f528fedb05f84", "patch_ids": ["df8d31e4efb6cb139d5c669e2215050c"], "statement_hash": "eb9a1e5c89e5b4fa71a37fedc208ddb8c2f0f95fbc1eec06821cbc772f3bd8fc", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-89dab26f6ecf89b1", "migration": false}, {"id": "18.0-b0ddcd66f9a0c6c5", "cves": [], "html": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfmax_active_replication_origins\u4ee5\u63a7\u5236\u6700\u5927\u6d3b\u52a8\u590d\u5236\u6e90\uff08Euler Taveira\uff09\u00a7
\n\u8fd9\u4ee5\u524d\u7531max_replication_slots\u63a7\u5236\uff0c\u4f46\u8fd9\u4e2a\u65b0\u8bbe\u7f6e\u5141\u8bb8\u5728\u9700\u8981\u8f83\u5c11\u69fd\u4f4d\u7684\u60c5\u51b5\u4e0b\u5177\u6709\u66f4\u9ad8\u7684\u6e90\u8ba1\u6570\u3002
", "text": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfmax_active_replication_origins\u4ee5\u63a7\u5236\u6700\u5927\u6d3b\u52a8\u590d\u5236\u6e90\uff08Euler Taveira\uff09\u00a7 \u8fd9\u4ee5\u524d\u7531max_replication_slots\u63a7\u5236\uff0c\u4f46\u8fd9\u4e2a\u65b0\u8bbe\u7f6e\u5141\u8bb8\u5728\u9700\u8981\u8f83\u5c11\u69fd\u4f4d\u7684\u60c5\u51b5\u4e0b\u5177\u6709\u66f4\u9ad8\u7684\u6e90\u8ba1\u6570\u3002", "title": "\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cfmax_active_replication_origins\u4ee5\u63a7\u5236\u6700\u5927\u6d3b\u52a8\u590d\u5236\u6e90", "commits": ["04ff636cb"], "section": "\u670d\u52a1\u5668 / \u6d41\u590d\u5236\u4e0e\u6062\u590d", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-REPLICATION", "source_hash": "33b1bea544f15476df511f7f493e700d5039ed734c0053ce03bf246913999aca", "section_path": ["\u670d\u52a1\u5668", "\u6d41\u590d\u5236\u4e0e\u6062\u590d"], "commit_groups": [["04ff636cb"]], "identity_text": "Add server variable guc-max-active-replication-origins to control the maximum active replication origins (Euler Taveira) This was previously controlled by guc-max-replication-slots , but this new setting allows a higher origin count in cases where fewer slots are required.", "commit_aliases": ["04ff636cb"], "source_commits": ["04ff636cb"], "source_entry_id": "18.0/changes/063", "db_id": "1428b3f7f6cc1a4506850622a40c3ffb", "patch_ids": ["a8c08a420a79bd1a161ea23d9bef6d71"], "statement_hash": "9e85b8d9968595a466cfb230295bcf24c446ed069e908115b73bf70ddbaf2392", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-b0ddcd66f9a0c6c5", "migration": false}, {"id": "18.0-cd9ea852d87af69a", "cves": [], "html": "\u5141\u8bb8\u751f\u6210\u5217\u7684\u503c\u8fdb\u884c\u903b\u8f91\u590d\u5236\uff08Shubham Khanna, Vignesh C, Zhijie Hou, Shlok Kyal, Peter Smith\uff09\u00a7 \u00a7 \u00a7 \u00a7
\n\u5982\u679c\u53d1\u5e03\u6307\u5b9a\u4e86\u5217\u5217\u8868\uff0c\u5219\u53d1\u5e03\u6240\u6709\u6307\u5b9a\u7684\u5217\uff08\u751f\u6210\u7684\u548c\u975e\u751f\u6210\u7684\uff09\u3002\u5982\u679c\u6ca1\u6709\u6307\u5b9a\u7684\u5217\u5217\u8868\uff0c\u5219\u53d1\u5e03\u9009\u9879 publish_generated_columns \u63a7\u5236\u662f\u5426\u53d1\u5e03\u751f\u6210\u7684\u5217\u3002\u4ee5\u524d\u751f\u6210\u7684\u5217\u4e0d\u8fdb\u884c\u590d\u5236\uff0c\u8ba2\u9605\u8005\u5fc5\u987b\u5728\u53ef\u80fd\u7684\u60c5\u51b5\u4e0b\u8ba1\u7b97\u503c\uff1b\u8fd9\u5bf9\u4e8e\u7f3a\u5c11\u6b64\u7c7b\u529f\u80fd\u7684\u975e PostgreSQL \u8ba2\u9605\u8005\u7279\u522b\u6709\u7528\u3002
\u5c06CREATE SUBSCRIPTION\u6d41\u5f0f\u9009\u9879\u7684\u9ed8\u8ba4\u503c\u4ece off \u66f4\u6539\u4e3a parallel\uff08Vignesh C\uff09\u00a7
\u5141\u8bb8ALTER SUBSCRIPTION\u66f4\u6539\u590d\u5236\u69fd\u7684\u4e24\u9636\u6bb5\u63d0\u4ea4\u884c\u4e3a\uff08Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou\uff09\u00a7 \u00a7
", "text": "\u5141\u8bb8ALTER SUBSCRIPTION\u66f4\u6539\u590d\u5236\u69fd\u7684\u4e24\u9636\u6bb5\u63d0\u4ea4\u884c\u4e3a\uff08Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou\uff09\u00a7 \u00a7", "title": "\u5141\u8bb8ALTER SUBSCRIPTION\u66f4\u6539\u590d\u5236\u69fd\u7684\u4e24\u9636\u6bb5\u63d0\u4ea4\u884c\u4e3a", "commits": ["1462aad2e", "4868c96bc"], "section": "\u670d\u52a1\u5668 / \u903b\u8f91\u590d\u5236", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-LOGICAL", "source_hash": "b96743f044a02e2201e5e678b547c8fdb56efd310343f8b3e4919fa6c862dfc7", "section_path": ["\u670d\u52a1\u5668", "\u903b\u8f91\u590d\u5236"], "commit_groups": [["1462aad2e"], ["4868c96bc"]], "identity_text": "Allow sql-altersubscription to change the replication slot's two-phase commit behavior (Hayato Kuroda, Ajin Cherian, Amit Kapila, Zhijie Hou)", "commit_aliases": ["1462aad2e", "4868c96bc"], "source_commits": ["1462aad2e", "4868c96bc"], "source_entry_id": "18.0/changes/066", "db_id": "41cd5554ab5a99df850ddc649a630bf5", "patch_ids": ["15c1439cde9cf963e340507c56e6bd57", "fd8060f9266b72de63d063d80a6bb2f9"], "statement_hash": "4c14605560e017cf4d89bb8a33a0ab993f4a9ff353648fde85d7e88cde571530", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-c3c5141f2b8caaa8", "migration": false}, {"id": "18.0-9779bf86a7039bec", "cves": [], "html": "\u5728\u5e94\u7528\u903b\u8f91\u590d\u5236\u66f4\u6539\u65f6\u8bb0\u5f55\u51b2\u7a81\uff08Zhijie Hou, Nisha Moond\uff09\u00a7 \u00a7 \u00a7 \u00a7 \u00a7
\n\u540c\u65f6\u5728 pg_stat_subscription_stats \u7684\u65b0\u5217\u4e2d\u62a5\u544a\u3002
\u5141\u8bb8\u751f\u6210\u5217\u91c7\u7528\u865a\u62df\u5f62\u5f0f\uff0c\u5e76\u5c06\u865a\u62df\u751f\u6210\u5217\u8bbe\u4e3a\u9ed8\u8ba4\u5f62\u5f0f\uff08Peter Eisentraut, Jian He, Richard Guo, Dean Rasheed\uff09\u00a7 \u00a7 \u00a7
\n\u865a\u62df\u751f\u6210\u5217\u5728\u8bfb\u53d6\u65f6\u751f\u6210\u5176\u503c\uff0c\u800c\u4e0d\u662f\u5728\u5199\u5165\u65f6\u751f\u6210\u3002\u5199\u5165\u884c\u4e3a\u4ecd\u7136\u53ef\u4ee5\u901a\u8fc7 STORED \u9009\u9879\u6307\u5b9a\u3002
\u4e3aDML\u67e5\u8be2\u4e2d\u7684 RETURNING \u6dfb\u52a0 OLD/NEW \u652f\u6301\uff08Dean Rasheed\uff09\u00a7
\u4ee5\u524d\uff0cRETURNING\u53ea\u8fd4\u56deINSERT\u548cUPDATE\u7684\u65b0\u503c\uff0c\u4ee5\u53caDELETE\u7684\u65e7\u503c\uff1bMERGE\u5219\u6839\u636e\u5b9e\u9645\u6267\u884c\u7684\u5185\u90e8\u67e5\u8be2\u8fd4\u56de\u76f8\u5e94\u7684\u503c\u3002\u65b0\u8bed\u6cd5\u5141\u8bb8INSERT/UPDATE/DELETE/MERGE\u7684RETURNING\u5217\u8868\u901a\u8fc7\u7279\u6b8a\u522b\u540dold\u548cnew\u663e\u5f0f\u8fd4\u56de\u65e7\u503c\u548c\u65b0\u503c\u3002\u8fd9\u4e9b\u522b\u540d\u53ef\u4ee5\u91cd\u547d\u540d\uff0c\u4ee5\u907f\u514d\u6807\u8bc6\u7b26\u51b2\u7a81\u3002
\u5141\u8bb8\u50cf\u73b0\u6709\u672c\u5730\u8868\u4e00\u6837\u521b\u5efa\u5916\u90e8\u8868\uff08Zhang Mingli\uff09\u00a7
\n\u8bed\u6cd5\u662f CREATE FOREIGN TABLE ... LIKE\u3002
\u5141\u8bb8 LIKE \u4e0e\u975e\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\u4e00\u8d77\u4f7f\u7528\uff08Peter Eisentraut\uff09\u00a7
\u5141\u8bb8\u6587\u672c\u4f4d\u7f6e\u641c\u7d22\u51fd\u6570\u4e0e\u975e\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\u4e00\u8d77\u4f7f\u7528\uff08Peter Eisentraut\uff09\u00a7
\n\u8fd9\u4e9b\u4ee5\u524d\u4f1a\u751f\u6210\u9519\u8bef\u3002
", "text": "\u5141\u8bb8\u6587\u672c\u4f4d\u7f6e\u641c\u7d22\u51fd\u6570\u4e0e\u975e\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\u4e00\u8d77\u4f7f\u7528\uff08Peter Eisentraut\uff09\u00a7 \u8fd9\u4e9b\u4ee5\u524d\u4f1a\u751f\u6210\u9519\u8bef\u3002", "title": "\u5141\u8bb8\u6587\u672c\u4f4d\u7f6e\u641c\u7d22\u51fd\u6570\u4e0e\u975e\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\u4e00\u8d77\u4f7f\u7528", "commits": ["329304c90"], "section": "\u5de5\u5177\u547d\u4ee4", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-UTILITY", "source_hash": "44de95f0bc4bf8dedce0af6fad80799804648813e2b8d379595f9119068daf23", "section_path": ["\u5de5\u5177\u547d\u4ee4"], "commit_groups": [["329304c90"]], "identity_text": "Allow text position search functions with nondeterministic collations (Peter Eisentraut) These used to generate an error.", "commit_aliases": ["329304c90"], "source_commits": ["329304c90"], "source_entry_id": "18.0/changes/072", "db_id": "1633612e398b9d62fc3745ae04ffbdcb", "patch_ids": ["43d52072e1fb7ccdaab204775ce5218b"], "statement_hash": "819c561a7502a24a171a66abb4e6b6d3543683ac066ea66ccff53a0fce4befea", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-2d24efb7f4f60a03", "migration": false}, {"id": "18.0-fa6e22f960ec67b4", "cves": [], "html": "\u6dfb\u52a0\u5185\u7f6e\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f PG_UNICODE_FAST\uff08Jeff Davis\uff09\u00a7
\u6b64\u533a\u57df\u8bbe\u7f6e\u652f\u6301\u5927\u5c0f\u5199\u6620\u5c04\uff0c\u4f46\u6309\u4ee3\u7801\u70b9\u987a\u5e8f\u6392\u5e8f\uff0c\u800c\u975e\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u3002
", "text": "\u6dfb\u52a0\u5185\u7f6e\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f PG_UNICODE_FAST\uff08Jeff Davis\uff09\u00a7 \u6b64\u533a\u57df\u8bbe\u7f6e\u652f\u6301\u5927\u5c0f\u5199\u6620\u5c04\uff0c\u4f46\u6309\u4ee3\u7801\u70b9\u987a\u5e8f\u6392\u5e8f\uff0c\u800c\u975e\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u3002", "title": "\u6dfb\u52a0\u5185\u7f6e\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f PG_UNICODE_FAST", "commits": ["d3d098316"], "section": "\u5de5\u5177\u547d\u4ee4", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-UTILITY", "source_hash": "c67e8fc3c341be4b77ad03dc233abe7dcf8538d89e6aa0f6ccdf7ecd5fced9ee", "section_path": ["\u5de5\u5177\u547d\u4ee4"], "commit_groups": [["d3d098316"]], "identity_text": "Add builtin collation provider PG_UNICODE_FAST (Jeff Davis) This locale supports case mapping, but sorts in code point order, not natural language order.", "commit_aliases": ["d3d098316"], "source_commits": ["d3d098316"], "source_entry_id": "18.0/changes/073", "db_id": "30595e5c571a05cc7aee9889ba3a082f", "patch_ids": ["04e3a10e98b76c4d3552450e42090216"], "statement_hash": "a2fd33890c8b434927b30005c495e84f2917c37b0d70177e7af7e169446cb0cc", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-fa6e22f960ec67b4", "migration": false}, {"id": "18.0-21f4954ffd8217fb", "cves": [], "html": "\u5141\u8bb8VACUUM\u548cANALYZE\u5904\u7406\u5206\u533a\u8868\u800c\u4e0d\u5904\u7406\u5176\u5b50\u8868\uff08Michael Harris\uff09\u00a7
\n\u8fd9\u901a\u8fc7\u65b0\u7684 ONLY \u9009\u9879\u542f\u7528\u3002\u8fd9\u5f88\u6709\u7528\uff0c\u56e0\u4e3a\u81ea\u52a8\u6e05\u7406\u4e0d\u5904\u7406\u5206\u533a\u8868\uff0c\u53ea\u5904\u7406\u5176\u5b50\u8868\u3002
\u6dfb\u52a0\u51fd\u6570\u4ee5\u4fee\u6539\u6bcf\u5173\u7cfb\u548c\u6bcf\u5217\u4f18\u5316\u5668\u7edf\u8ba1\u4fe1\u606f\uff08Corey Huinker\uff09\u00a7 \u00a7 \u00a7
\n\u8fd9\u4e9b\u51fd\u6570\u662f pg_restore_relation_stats()\u3001pg_restore_attribute_stats()\u3001pg_clear_relation_stats() \u548c pg_clear_attribute_stats()\u3002
\u6dfb\u52a0\u670d\u52a1\u5668\u53d8\u91cffile_copy_method\u4ee5\u63a7\u5236\u6587\u4ef6\u590d\u5236\u65b9\u6cd5\uff08Nazir Bilal Yavuz\uff09\u00a7
\n\u8fd9\u63a7\u5236 CREATE DATABASE ... STRATEGY=FILE_COPY \u548c ALTER DATABASE ... SET TABLESPACE \u662f\u4f7f\u7528\u6587\u4ef6\u590d\u5236\u8fd8\u662f\u514b\u9686\u3002
\u5141\u8bb8\u6307\u5b9a\u4e0d\u91cd\u53e0\u7684 PRIMARY KEY\u3001 UNIQUE \u548c\u5916\u952e\u7ea6\u675f\uff08Paul A. Jungwirth\uff09\u00a7 \u00a7
\u8fd9\u901a\u8fc7 WITHOUT OVERLAPS \u7528\u4e8e PRIMARY KEY \u548c UNIQUE\uff0c\u5e76\u901a\u8fc7 PERIOD \u7528\u4e8e\u5916\u952e\uff0c\u6240\u6709\u8fd9\u4e9b\u90fd\u5e94\u7528\u4e8e\u6700\u540e\u4e00\u4e2a\u6307\u5b9a\u7684\u5217\u3002
\u5141\u8bb8\u5c06 CHECK \u548c\u5916\u952e\u7ea6\u675f\u6307\u5b9a\u4e3a NOT ENFORCED\uff08Amul Sul\uff09\u00a7 \u00a7
\u8fd9\u8fd8\u6dfb\u52a0\u4e86\u5217 pg_constraint.conenforced\u3002
\u8981\u6c42\u4e3b\u952e/\u5916\u952e\u5173\u7cfb\u4f7f\u7528\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\u6216\u76f8\u540c\u7684\u975e\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\uff08Peter Eisentraut\uff09\u00a7
\n\u5982\u679c\u8fd9\u4e9b\u8981\u6c42\u4e0d\u6ee1\u8db3\uff0cpg_dump\u7684\u6062\u590d\uff08pg_upgrade\u4e5f\u4f7f\u7528\uff09\u5c06\u5931\u8d25\uff1b\u5fc5\u987b\u5bf9\u6a21\u5f0f\u8fdb\u884c\u66f4\u6539\u624d\u80fd\u4f7f\u8fd9\u4e9b\u5347\u7ea7\u65b9\u6cd5\u6210\u529f\u3002
", "text": "\u8981\u6c42\u4e3b\u952e/\u5916\u952e\u5173\u7cfb\u4f7f\u7528\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\u6216\u76f8\u540c\u7684\u975e\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\uff08Peter Eisentraut\uff09\u00a7 \u5982\u679c\u8fd9\u4e9b\u8981\u6c42\u4e0d\u6ee1\u8db3\uff0cpg_dump\u7684\u6062\u590d\uff08pg_upgrade\u4e5f\u4f7f\u7528\uff09\u5c06\u5931\u8d25\uff1b\u5fc5\u987b\u5bf9\u6a21\u5f0f\u8fdb\u884c\u66f4\u6539\u624d\u80fd\u4f7f\u8fd9\u4e9b\u5347\u7ea7\u65b9\u6cd5\u6210\u529f\u3002", "title": "\u8981\u6c42\u4e3b\u952e/\u5916\u952e\u5173\u7cfb\u4f7f\u7528\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219\u6216\u76f8\u540c\u7684\u975e\u786e\u5b9a\u6027\u6392\u5e8f\u89c4\u5219", "commits": ["9321d2fdf"], "section": "\u5de5\u5177\u547d\u4ee4 / \u7ea6\u675f", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-CONSTRAINTS", "source_hash": "2b17eb3b34045fd66a066a2076d863f0fa350f40aa79c07d72d3a50fcdeff6f3", "section_path": ["\u5de5\u5177\u547d\u4ee4", "\u7ea6\u675f"], "commit_groups": [["9321d2fdf"]], "identity_text": "Require primary/foreign key relationships to use either deterministic collations or the the same nondeterministic collations (Peter Eisentraut) The restore of a app-pgdump , also used by pgupgrade , will fail if these requirements are not met; schema changes must be made for these upgrade methods to succeed.", "commit_aliases": ["9321d2fdf"], "source_commits": ["9321d2fdf"], "source_entry_id": "18.0/changes/079", "db_id": "68a1f7d62d756e8a62c81960b94b7516", "patch_ids": ["0ce5a6d8a11a1381cec57c4513b145b6"], "statement_hash": "2618c39bc6d6dedcb5838152a2f2578f929d0e51755b824342e7609b6456ce31", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-456bfee91d8a1c5e", "migration": false}, {"id": "18.0-0bdb785dd7894611", "cves": [], "html": "\u5c06\u5217 NOT NULL \u89c4\u8303\u5b58\u50a8\u5728 pg_constraint \u4e2d\uff08\u00c1lvaro Herrera, Bernd Helmle\uff09\u00a7 \u00a7
\u8fd9\u5141\u8bb8\u4e3a NOT NULL \u7ea6\u675f\u6307\u5b9a\u540d\u79f0\u3002\u8fd9\u8fd8\u5411\u5916\u90e8\u8868\u6dfb\u52a0\u4e86 NOT NULL \u7ea6\u675f\uff0c\u5e76\u5411\u672c\u5730\u8868\u6dfb\u52a0\u4e86 NOT NULL \u7ee7\u627f\u63a7\u5236\u3002
\u5141\u8bb8ALTER TABLE\u8bbe\u7f6e NOT NULL \u7ea6\u675f\u7684 NOT VALID \u5c5e\u6027\uff08Rushabh Lathia, Jian He\uff09\u00a7
\u5141\u8bb8\u4fee\u6539 NOT NULL \u7ea6\u675f\u7684\u53ef\u7ee7\u627f\u6027\uff08Suraj Kharage, \u00c1lvaro Herrera\uff09\u00a7 \u00a7
\u8bed\u6cd5\u662f ALTER TABLE ... ALTER CONSTRAINT ... [NO] INHERIT\u3002
\u5141\u8bb8\u5206\u533a\u8868\u4e0a\u7684 NOT VALID \u5916\u952e\u7ea6\u675f\uff08Amul Sul\uff09\u00a7
\u5141\u8bb8\u5728\u5206\u533a\u8868\u4e0a\u4f7f\u7528 ONLY \u4e22\u5f03\u7ea6\u675f\uff08\u00c1lvaro Herrera\uff09\u00a7
\u8fd9\u4ee5\u524d\u88ab\u9519\u8bef\u5730\u7981\u6b62\u4e86\u3002
", "text": "\u5141\u8bb8\u5728\u5206\u533a\u8868\u4e0a\u4f7f\u7528 ONLY \u4e22\u5f03\u7ea6\u675f\uff08\u00c1lvaro Herrera\uff09\u00a7 \u8fd9\u4ee5\u524d\u88ab\u9519\u8bef\u5730\u7981\u6b62\u4e86\u3002", "title": "\u5141\u8bb8\u5728\u5206\u533a\u8868\u4e0a\u4f7f\u7528 ONLY \u4e22\u5f03\u7ea6\u675f", "commits": ["4dea33ce7"], "section": "\u5de5\u5177\u547d\u4ee4 / \u7ea6\u675f", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-CONSTRAINTS", "source_hash": "8c1219c56b3716c6e0669450727af7aed75763ee754fd98663afe83cdbb70624", "section_path": ["\u5de5\u5177\u547d\u4ee4", "\u7ea6\u675f"], "commit_groups": [["4dea33ce7"]], "identity_text": "Allow dropping of constraints ONLY on partitioned tables (\u00c1lvaro Herrera) This was previously erroneously prohibited.", "commit_aliases": ["4dea33ce7"], "source_commits": ["4dea33ce7"], "source_entry_id": "18.0/changes/084", "db_id": "18344143b41582623ed016d08d3724f0", "patch_ids": ["e01f71769bcebafa65ea9e9facbc8f0e"], "statement_hash": "2f709f0920ff299f36d06fa6d2c5e29a93df41901d6a0aa8e7f22d2226fd478d", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-eb1a7d0c44918ad3", "migration": false}, {"id": "18.0-886a8aa244f2b933", "cves": [], "html": "\u6dfb\u52a0 REJECT_LIMIT \u4ee5\u63a7\u5236 COPY FROM \u53ef\u4ee5\u5ffd\u7565\u7684\u65e0\u6548\u884c\u6570\uff08Atsushi Torikoshi\uff09\u00a7
\u8fd9\u5728 ON_ERROR = 'ignore' \u65f6\u53ef\u7528\u3002
\u5141\u8bb8 COPY TO \u4ece\u5df2\u586b\u5145\u7684\u7269\u5316\u89c6\u56fe\u590d\u5236\u884c\uff08Jian He\uff09\u00a7
\u6dfb\u52a0 COPY LOG_VERBOSITY \u7ea7\u522b silent \u4ee5\u6291\u5236\u88ab\u5ffd\u7565\u884c\u7684\u65e5\u5fd7\u8f93\u51fa\uff08Atsushi Torikoshi\uff09\u00a7
\u5f53 on_error = 'ignore' \u65f6\uff0c\u6b64\u65b0\u7ea7\u522b\u4f1a\u6291\u5236\u4e0e\u88ab\u4e22\u5f03\u8f93\u5165\u884c\u6709\u5173\u7684\u6d88\u606f\u8f93\u51fa\u3002
\u7981\u6b62\u5728\u5916\u90e8\u8868\u4e0a COPY FREEZE\uff08Nathan Bossart\uff09\u00a7
\u4ee5\u524d\uff0cCOPY \u53ef\u4ee5\u5de5\u4f5c\uff0c\u4f46 FREEZE \u4f1a\u88ab\u5ffd\u7565\uff0c\u6240\u4ee5\u7981\u6b62\u6b64\u547d\u4ee4\u3002
\u81ea\u52a8\u5c06 BUFFERS \u8f93\u51fa\u5305\u542b\u5728 EXPLAIN ANALYZE \u4e2d\uff08Guillaume Lelarge, David Rowley\uff09\u00a7
\u6dfb\u52a0\u5b8c\u6574WAL\u7f13\u51b2\u533a\u8ba1\u6570\u5230 EXPLAIN (WAL) \u8f93\u51fa\uff08Bertrand Drouvot\uff09\u00a7
\u5728 EXPLAIN ANALYZE \u4e2d\uff0c\u62a5\u544a\u6bcf\u4e2a\u7d22\u5f15\u626b\u63cf\u8282\u70b9\u4f7f\u7528\u7684\u7d22\u5f15\u67e5\u627e\u6b21\u6570\uff08Peter Geoghegan\uff09\u00a7
\u4fee\u6539 EXPLAIN \u4ee5\u8f93\u51fa\u5c0f\u6570\u884c\u8ba1\u6570\uff08Ibrar Ahmed, Ilia Evdokimov, Robert Haas\uff09\u00a7 \u00a7
\u5728 EXPLAIN \u8f93\u51fa\u4e2d\uff0c\u4e3a Material\u3001Window Aggregate \u548c\u901a\u7528\u8868\u8868\u8fbe\u5f0f\u8282\u70b9\u6dfb\u52a0\u5185\u5b58\u548c\u78c1\u76d8\u4f7f\u7528\u8be6\u60c5\uff08David Rowley, Tatsuo Ishii\uff09\u00a7 \u00a7 \u00a7 \u00a7
\u5c06\u7a97\u53e3\u51fd\u6570\u53c2\u6570\u7684\u8be6\u7ec6\u4fe1\u606f\u6dfb\u52a0\u5230 EXPLAIN \u8f93\u51fa\uff08Tom Lane\uff09\u00a7
\u5c06 Parallel Bitmap Heap Scan \u5de5\u4f5c\u8005\u7f13\u5b58\u7edf\u8ba1\u4fe1\u606f\u6dfb\u52a0\u5230 EXPLAIN ANALYZE\uff08David Geier, Heikki Linnakangas, Donghang Lin, Alena Rybakina, David Rowley\uff09\u00a7
\u5728 EXPLAIN ANALYZE \u8f93\u51fa\u4e2d\u6307\u793a\u5df2\u7981\u7528\u8282\u70b9\uff08Robert Haas, David Rowley, Laurenz Albe\uff09\u00a7 \u00a7 \u00a7
\u6539\u8fdb Unicode \u5168\u5927\u5c0f\u5199\u6620\u5c04\u548c\u8f6c\u6362\uff08Jeff Davis\uff09\u00a7 \u00a7
\n\u8fd9\u589e\u52a0\u4e86\u8fdb\u884c\u6761\u4ef6\u548c\u6807\u9898\u5927\u5c0f\u5199\u6620\u5c04\u7684\u80fd\u529b\uff0c\u4ee5\u53ca\u5c06\u5355\u4e2a\u5b57\u7b26\u5927\u5c0f\u5199\u6620\u5c04\u5230\u591a\u4e2a\u5b57\u7b26\u7684\u80fd\u529b\u3002
", "text": "\u6539\u8fdb Unicode \u5168\u5927\u5c0f\u5199\u6620\u5c04\u548c\u8f6c\u6362\uff08Jeff Davis\uff09\u00a7 \u00a7 \u8fd9\u589e\u52a0\u4e86\u8fdb\u884c\u6761\u4ef6\u548c\u6807\u9898\u5927\u5c0f\u5199\u6620\u5c04\u7684\u80fd\u529b\uff0c\u4ee5\u53ca\u5c06\u5355\u4e2a\u5b57\u7b26\u5927\u5c0f\u5199\u6620\u5c04\u5230\u591a\u4e2a\u5b57\u7b26\u7684\u80fd\u529b\u3002", "title": "\u6539\u8fdb Unicode \u5168\u5927\u5c0f\u5199\u6620\u5c04\u548c\u8f6c\u6362", "commits": ["286a365b9", "4e7f62bc3"], "section": "\u6570\u636e\u7c7b\u578b", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES", "source_hash": "44c26c92986f06630e401c20db860295e1e24fcd5259ea9ea934f4bf062fdd8e", "section_path": ["\u6570\u636e\u7c7b\u578b"], "commit_groups": [["286a365b9"], ["4e7f62bc3"]], "identity_text": "Improve Unicode full case mapping and conversion (Jeff Davis) This adds the ability to do conditional and title case mapping, and case map single characters to multiple characters.", "commit_aliases": ["286a365b9", "4e7f62bc3"], "source_commits": ["286a365b9", "4e7f62bc3"], "source_entry_id": "18.0/changes/097", "db_id": "1b2ed6a4886122496b4235e9bc502410", "patch_ids": ["0bc695a859154bdbe2aa4141a8c131d7", "c4d90a2c6dc576697ae6803230585a80"], "statement_hash": "02776b8149a82584d272cc2094e4a669aca778c5844f65839a5f72cf0687f143", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-3b5b364cf7dc2091", "migration": false}, {"id": "18.0-40f5a48bcd0f93e0", "cves": [], "html": "\u5141\u8bb8\u5728\u5c06 jsonb null \u503c\u8f6c\u6362\u4e3a\u6807\u91cf\u7c7b\u578b\u65f6\u8fd4\u56de NULL\uff08Tom Lane\uff09\u00a7
\u4ee5\u524d\u8fd9\u6837\u7684\u8f6c\u6362\u4f1a\u4ea7\u751f\u9519\u8bef\u3002
", "text": "\u5141\u8bb8\u5728\u5c06 jsonb null \u503c\u8f6c\u6362\u4e3a\u6807\u91cf\u7c7b\u578b\u65f6\u8fd4\u56de NULL\uff08Tom Lane\uff09\u00a7 \u4ee5\u524d\u8fd9\u6837\u7684\u8f6c\u6362\u4f1a\u4ea7\u751f\u9519\u8bef\u3002", "title": "\u5141\u8bb8\u5728\u5c06 jsonb null \u503c\u8f6c\u6362\u4e3a\u6807\u91cf\u7c7b\u578b\u65f6\u8fd4\u56de NULL", "commits": ["a5579a90a"], "section": "\u6570\u636e\u7c7b\u578b", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES", "source_hash": "1e15ce0182df8ba9bb4f5d3c70a693a1c71b87744e48c4280afcb76462804520", "section_path": ["\u6570\u636e\u7c7b\u578b"], "commit_groups": [["a5579a90a"]], "identity_text": "Allow jsonb null values to be cast to scalar types as NULL (Tom Lane) Previously such casts generated an error.", "commit_aliases": ["a5579a90a"], "source_commits": ["a5579a90a"], "source_entry_id": "18.0/changes/098", "db_id": "707a9526e8d1e6416419dcc4e0f8c1fb", "patch_ids": ["f6184b101cbccd529291b34b9ea43559"], "statement_hash": "e835773742df55f58b57f5dbf777b47ddc9916b939e5f10a60426d8f63610fdd", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-40f5a48bcd0f93e0", "migration": false}, {"id": "18.0-ae21c8cd0f07e687", "cves": [], "html": "\u5411 json{b}_strip_nulls \u6dfb\u52a0\u53ef\u9009\u53c2\u6570\uff0c\u4ee5\u5141\u8bb8\u5220\u9664\u6570\u7ec4\u4e2d\u7684\u7a7a\u503c\u5143\u7d20\uff08Florents Tselai\uff09\u00a7
\u6dfb\u52a0\u51fd\u6570 array_sort()\uff0c\u5b83\u5bf9\u6570\u7ec4\u7684\u7b2c\u4e00\u7ef4\u8fdb\u884c\u6392\u5e8f\uff08Junwang Zhao, Jian He\uff09\u00a7
\u6dfb\u52a0\u51fd\u6570 array_reverse()\uff0c\u5b83\u53cd\u8f6c\u6570\u7ec4\u7684\u7b2c\u4e00\u7ef4\uff08Aleksander Alekseev\uff09\u00a7
\u6dfb\u52a0\u51fd\u6570 reverse() \u4ee5\u53cd\u8f6c bytea \u5b57\u8282\uff08Aleksander Alekseev\uff09\u00a7
\u5141\u8bb8\u5728\u6574\u6570\u7c7b\u578b\u548c bytea \u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\uff08Aleksander Alekseev\uff09\u00a7
\u6574\u6570\u503c\u5b58\u50a8\u4e3a bytea \u4e8c\u8fdb\u5236\u8865\u7801\u503c\u3002
\u66f4\u65b0 Unicode \u6570\u636e\u81f3 Unicode 16.0.0\uff08Peter Eisentraut\uff09\u00a7
", "text": "\u66f4\u65b0 Unicode \u6570\u636e\u81f3 Unicode 16.0.0\uff08Peter Eisentraut\uff09\u00a7", "title": "\u66f4\u65b0 Unicode \u6570\u636e\u81f3 Unicode 16.0.0", "commits": ["82a46cca9"], "section": "\u6570\u636e\u7c7b\u578b", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES", "source_hash": "7b363edbf7fc1652e00ae639f016a531400b78a1501225262fbf76a7fc2c0dd8", "section_path": ["\u6570\u636e\u7c7b\u578b"], "commit_groups": [["82a46cca9"]], "identity_text": "Update Unicode data to Unicode 16.0.0 (Peter Eisentraut)", "commit_aliases": ["82a46cca9"], "source_commits": ["82a46cca9"], "source_entry_id": "18.0/changes/104", "db_id": "b3a13160940dac3f7a1a1af7f4cf764d", "patch_ids": ["37e8f514959e205b0155b61312d52d56"], "statement_hash": "dc448dd80b25033f629182d9bb00f6e6eb258933e0fc988309cd3ddbaf4be408", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-9e53e6011ccb2bae", "migration": false}, {"id": "18.0-ddc75ea0db8ffc49", "cves": [], "html": "\u6dfb\u52a0\u7231\u6c99\u5c3c\u4e9a\u8bed\u7684\u5168\u6587\u68c0\u7d22\u8bcd\u5e72\u63d0\u53d6\uff08Tom Lane\uff09\u00a7
", "text": "\u6dfb\u52a0\u7231\u6c99\u5c3c\u4e9a\u8bed\u7684\u5168\u6587\u68c0\u7d22\u8bcd\u5e72\u63d0\u53d6\uff08Tom Lane\uff09\u00a7", "title": "\u6dfb\u52a0\u7231\u6c99\u5c3c\u4e9a\u8bed\u7684\u5168\u6587\u68c0\u7d22\u8bcd\u5e72\u63d0\u53d6", "commits": ["b464e51ab"], "section": "\u6570\u636e\u7c7b\u578b", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-DATATYPES", "source_hash": "dd6878414ee23406689c7eefc1a641935c96e6bd890e0e1431ff6fd28bfca759", "section_path": ["\u6570\u636e\u7c7b\u578b"], "commit_groups": [["197427fb3", "7edd2cbc5", "8388cae55", "9c46d902b", "b464e51ab", "c0c364fa1"]], "identity_text": "Add full text search stemming for Estonian (Tom Lane)", "commit_aliases": ["197427fb3", "7edd2cbc5", "8388cae55", "9c46d902b", "b464e51ab", "c0c364fa1"], "source_commits": ["b464e51ab"], "source_entry_id": "18.0/changes/105", "db_id": "d02c90e2590d4a47f73a5782496b4966", "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"], "statement_hash": "765cc1defacc087129eb32bf5f736de4c5be16883a95fba7b8adca47a87ce874", "relations": [{"rule": 2, "type": "related", "target": "00feddbb8384a7a8cefe4217cd497215", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "related", "target": "43dbc69a435522e8a12bbf37193bcbca", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "related", "target": "c2850458f2850974df366bef8a85488e", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "related", "target": "d6bf0f560b8ac8cad3c1d6a070b45594", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}, {"rule": 2, "type": "related", "target": "fe6fa87c7f7a2f01e5226fc8b75d4395", "evidence": {"same_day": false, "patch_ids": ["d20fbffc83ee90d1348f1d03836b8f18"]}}], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-ddc75ea0db8ffc49", "migration": false}, {"id": "18.0-b8b7af2d05807f76", "cves": [], "html": "\u6539\u8fdb XML \u9519\u8bef\u4ee3\u7801\u4ee5\u66f4\u63a5\u8fd1SQL\u6807\u51c6\uff08Tom Lane\uff09\u00a7
\u8fd9\u4e9b\u9519\u8bef\u901a\u8fc7 SQLSTATE \u62a5\u544a\u3002
\u6dfb\u52a0\u51fd\u6570 casefold() \u4ee5\u5141\u8bb8\u66f4\u590d\u6742\u7684\u5ffd\u7565\u5927\u5c0f\u5199\u5339\u914d\uff08Jeff Davis\uff09\u00a7
\u8fd9\u5141\u8bb8\u66f4\u51c6\u786e\u7684\u6bd4\u8f83\uff0c\u5373\u4e00\u4e2a\u5b57\u7b26\u53ef\u4ee5\u6709\u591a\u4e2a\u5927\u5199\u6216\u5c0f\u5199\u7b49\u4ef7\u7269\uff0c\u6216\u8005\u5927\u5199\u6216\u5c0f\u5199\u8f6c\u6362\u4f1a\u6539\u53d8\u5b57\u7b26\u7684\u6570\u91cf\u3002
", "text": "\u6dfb\u52a0\u51fd\u6570 casefold() \u4ee5\u5141\u8bb8\u66f4\u590d\u6742\u7684\u5ffd\u7565\u5927\u5c0f\u5199\u5339\u914d\uff08Jeff Davis\uff09\u00a7 \u8fd9\u5141\u8bb8\u66f4\u51c6\u786e\u7684\u6bd4\u8f83\uff0c\u5373\u4e00\u4e2a\u5b57\u7b26\u53ef\u4ee5\u6709\u591a\u4e2a\u5927\u5199\u6216\u5c0f\u5199\u7b49\u4ef7\u7269\uff0c\u6216\u8005\u5927\u5199\u6216\u5c0f\u5199\u8f6c\u6362\u4f1a\u6539\u53d8\u5b57\u7b26\u7684\u6570\u91cf\u3002", "title": "\u6dfb\u52a0\u51fd\u6570 casefold() \u4ee5\u5141\u8bb8\u66f4\u590d\u6742\u7684\u5ffd\u7565\u5927\u5c0f\u5199\u5339\u914d", "commits": ["bfc599206"], "section": "\u51fd\u6570", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-FUNCTIONS", "source_hash": "45cb069e223659d8f877c9a2110d431b847abaa3d2bf90c2d51977f38f2e6cb4", "section_path": ["\u51fd\u6570"], "commit_groups": [["bfc599206"]], "identity_text": "Add function casefold() to allow for more sophisticated case-insensitive matching (Jeff Davis) This allows more accurate comparisons, i.e., a character can have multiple upper or lower case equivalents, or upper or lower case conversion changes the number of characters.", "commit_aliases": ["bfc599206"], "source_commits": ["bfc599206"], "source_entry_id": "18.0/changes/107", "db_id": "b6349fdce5ba2ae112d0be3d05e38198", "patch_ids": ["0684a21f7afe3e30c9299aaa67789314"], "statement_hash": "c9d001f8f460c1f05dad5d20c8956c701fd640f0996cec7198b5decd3f545c09", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-e2d27c73a2e364fd", "migration": false}, {"id": "18.0-ce3995bf22cc0e40", "cves": [], "html": "\u5141\u8bb8\u5728\u6570\u7ec4\u548c\u590d\u5408\u7c7b\u578b\u4e0a\u8fdb\u884c MIN()/MAX() \u805a\u5408\uff08Aleksander Alekseev, Marat Buharov\uff09\u00a7 \u00a7
\u5411 EXTRACT() \u6dfb\u52a0 WEEK \u9009\u9879\uff08Tom Lane\uff09\u00a7
\u6539\u8fdb EXTRACT(QUARTER ...) \u5bf9\u8d1f\u503c\u7684\u8f93\u51fa\uff08Tom Lane\uff09\u00a7
\u5411 to_number() \u6dfb\u52a0\u7f57\u9a6c\u6570\u5b57\u652f\u6301\uff08Hunaid Sohail\uff09\u00a7
\u8fd9\u901a\u8fc7 RN \u6a21\u5f0f\u8bbf\u95ee\u3002
\u6dfb\u52a0 UUID \u7248\u672c7\u751f\u6210\u51fd\u6570 uuidv7()\uff08Andrey Borodin\uff09\u00a7
\u6b64 UUID \u503c\u53ef\u6309\u65f6\u95f4\u6392\u5e8f\u3002\u5df2\u6dfb\u52a0\u51fd\u6570\u522b\u540d uuidv4() \u4ee5\u663e\u5f0f\u751f\u6210\u7248\u672c4 UUID\u3002
\u6dfb\u52a0\u51fd\u6570 crc32() \u548c crc32c() \u4ee5\u8ba1\u7b97CRC\u503c\uff08Aleksander Alekseev\uff09\u00a7
\u6dfb\u52a0\u6570\u5b66\u51fd\u6570 gamma() \u548c lgamma()\uff08Dean Rasheed\uff09\u00a7
\u5141\u8bb8\u5728 PL/pgSQL \u4e2d\u4f7f\u7528 => \u8bed\u6cd5\u6307\u5b9a\u5177\u540d\u6e38\u6807\u53c2\u6570\uff08Pavel Stehule\uff09\u00a7
\u6211\u4eec\u4ee5\u524d\u53ea\u63a5\u53d7 :=\u3002
\u5141\u8bb8 regexp_match[es]()/regexp_like()/regexp_replace()/regexp_count()/regexp_instr()/regexp_substr()/regexp_split_to_table()/regexp_split_to_array() \u4f7f\u7528\u547d\u540d\u53c2\u6570\uff08Jian He\uff09\u00a7
\u6dfb\u52a0\u51fd\u6570 PQfullProtocolVersion() \u4ee5\u62a5\u544a\u5b8c\u6574\u7684\uff08\u5305\u62ec\u6b21\u8981\u7248\u672c\uff09\u534f\u8bae\u7248\u672c\u53f7\uff08Jacob Champion, Jelte Fennema-Nio\uff09\u00a7
\u6dfb\u52a0 libpq \u8fde\u63a5\u53c2\u6570\u548c\u73af\u5883\u53d8\u91cf\u4ee5\u6307\u5b9a\u8fde\u63a5\u7684\u6700\u5c0f\u548c\u6700\u5927\u53ef\u63a5\u53d7\u534f\u8bae\u7248\u672c\uff08Jelte Fennema-Nio\uff09\u00a7 \u00a7
", "text": "\u6dfb\u52a0 libpq \u8fde\u63a5\u53c2\u6570\u548c\u73af\u5883\u53d8\u91cf\u4ee5\u6307\u5b9a\u8fde\u63a5\u7684\u6700\u5c0f\u548c\u6700\u5927\u53ef\u63a5\u53d7\u534f\u8bae\u7248\u672c\uff08Jelte Fennema-Nio\uff09\u00a7 \u00a7", "title": "\u6dfb\u52a0 libpq \u8fde\u63a5\u53c2\u6570\u548c\u73af\u5883\u53d8\u91cf\u4ee5\u6307\u5b9a\u8fde\u63a5\u7684\u6700\u5c0f\u548c\u6700\u5927\u53ef\u63a5\u53d7\u534f\u8bae\u7248\u672c", "commits": ["285613c60", "507034910"], "section": "Libpq", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-LIBPQ", "source_hash": "dd8e24e0798022c5e49d33b8f037eae94f69ab39a4a885b8b176f5e16dbcf97e", "section_path": ["Libpq"], "commit_groups": [["285613c60"], ["507034910"]], "identity_text": "Add libpq connection parameters and environment variables to specify the minimum and maximum acceptable protocol version for connections (Jelte Fennema-Nio)", "commit_aliases": ["285613c60", "507034910"], "source_commits": ["285613c60", "507034910"], "source_entry_id": "18.0/changes/118", "db_id": "324ad8ffd0dc73072b6cae1163bbd895", "patch_ids": ["534b2c53e2e1a92c27d124b03e588165", "75729722b6f7aba5cfb305b2f8099d9d"], "statement_hash": "5bc66e57f7b5710b779499207adb20134778a80ccd962165684afde348719556", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-93af92d9546daff9", "migration": false}, {"id": "18.0-207d234a979be0ba", "cves": [], "html": "\u5411\u5ba2\u6237\u7aef\u62a5\u544asearch_path\u66f4\u6539\uff08Alexander Kukushkin, Jelte Fennema-Nio, Tomas Vondra\uff09\u00a7 \u00a7
", "text": "\u5411\u5ba2\u6237\u7aef\u62a5\u544asearch_path\u66f4\u6539\uff08Alexander Kukushkin, Jelte Fennema-Nio, Tomas Vondra\uff09\u00a7 \u00a7", "title": "\u5411\u5ba2\u6237\u7aef\u62a5\u544asearch_path\u66f4\u6539", "commits": ["0d06a7eac", "28a1121fd"], "section": "Libpq", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-LIBPQ", "source_hash": "1b3b66fd3e804bfd9a8f8eb4900833f7becb2d7ae3e27f57d8450450272b7e24", "section_path": ["Libpq"], "commit_groups": [["0d06a7eac"], ["28a1121fd"]], "identity_text": "Report guc-search-path changes to the client (Alexander Kukushkin, Jelte Fennema-Nio, Tomas Vondra)", "commit_aliases": ["0d06a7eac", "28a1121fd"], "source_commits": ["0d06a7eac", "28a1121fd"], "source_entry_id": "18.0/changes/119", "db_id": "218352fe6746ce16b55b280a597a34c3", "patch_ids": ["5ff7e1b21d24cbfadde9ec259d6a73c7", "6773d35e5f3a311c7ff50c9c2faf3885"], "statement_hash": "50991c451a4bfb5e106b4ba60fe467da4d2e687a547ce099c82004fbe44fd3e9", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-207d234a979be0ba", "migration": false}, {"id": "18.0-beeeaad682b3e543", "cves": [], "html": "\u6dfb\u52a0 PQtrace() \u8f93\u51fa\uff0c\u7528\u4e8e\u6240\u6709\u6d88\u606f\u7c7b\u578b\uff0c\u5305\u62ec\u8ba4\u8bc1\uff08Jelte Fennema-Nio\uff09\u00a7 \u00a7 \u00a7 \u00a7 \u00a7
\u6dfb\u52a0 libpq \u8fde\u63a5\u53c2\u6570 sslkeylogfile\uff0c\u8be5\u53c2\u6570\u4f1a\u8f6c\u50a8SSL\u5bc6\u94a5\u6750\u6599\uff08Abhishek Chanda, Daniel Gustafsson\uff09\u00a7
\u8fd9\u5bf9\u4e8e\u8c03\u8bd5\u5f88\u6709\u7528\u3002
", "text": "\u6dfb\u52a0 libpq \u8fde\u63a5\u53c2\u6570 sslkeylogfile\uff0c\u8be5\u53c2\u6570\u4f1a\u8f6c\u50a8SSL\u5bc6\u94a5\u6750\u6599\uff08Abhishek Chanda, Daniel Gustafsson\uff09\u00a7 \u8fd9\u5bf9\u4e8e\u8c03\u8bd5\u5f88\u6709\u7528\u3002", "title": "\u6dfb\u52a0 libpq \u8fde\u63a5\u53c2\u6570 sslkeylogfile\uff0c\u8be5\u53c2\u6570\u4f1a\u8f6c\u50a8SSL\u5bc6\u94a5\u6750\u6599", "commits": ["2da74d8d6"], "section": "Libpq", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-LIBPQ", "source_hash": "8a53c283c907184c5c28dc8b1a80814c955c04574c96f11e2d4b6d6ad07852f9", "section_path": ["Libpq"], "commit_groups": [["2da74d8d6"]], "identity_text": "Add libpq connection parameter sslkeylogfile which dumps out SSL key material (Abhishek Chanda, Daniel Gustafsson) This is useful for debugging.", "commit_aliases": ["2da74d8d6"], "source_commits": ["2da74d8d6"], "source_entry_id": "18.0/changes/121", "db_id": "dec95e8329f62b657fc15ccfb7d006fb", "patch_ids": ["5c9abb135b2e6fb82671370102be25d3"], "statement_hash": "0cbbb246f331bdcf188172740da0fa02fe152d60204197e426ec23a6c89278c5", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-ef7c9ed7c8f229dc", "migration": false}, {"id": "18.0-f56e310a693fee70", "cves": [], "html": "\u4fee\u6539\u4e00\u4e9b libpq \u51fd\u6570\u7b7e\u540d\u4ee5\u4f7f\u7528 int64_t\uff08Thomas Munro\uff09\u00a7
\u8fd9\u4e9b\u4ee5\u524d\u4f7f\u7528 pg_int64\uff0c\u73b0\u5df2\u5f03\u7528\u3002
\u5141\u8bb8 psql \u89e3\u6790\u3001\u7ed1\u5b9a\u548c\u5173\u95ed\u547d\u540d\u9884\u5904\u7406\u8bed\u53e5\uff08Anthonin Bonnefoy, Michael Paquier\uff09\u00a7 \u00a7
\n\u8fd9\u901a\u8fc7\u65b0\u547d\u4ee4 \\parse\u3001\\bind_named \u548c \\close_prepared \u5b8c\u6210\u3002
\u6dfb\u52a0 psql \u53cd\u659c\u6760\u547d\u4ee4\u4ee5\u5141\u8bb8\u53d1\u51fa\u7ba1\u9053\u67e5\u8be2\uff08Anthonin Bonnefoy\uff09\u00a7 \u00a7 \u00a7
\n\u65b0\u547d\u4ee4\u662f \\startpipeline\u3001\\syncpipeline\u3001\\sendpipeline\u3001\\endpipeline\u3001\\flushrequest\u3001\\flush \u548c \\getresults\u3002
\u5141\u8bb8\u5c06\u7ba1\u9053\u72b6\u6001\u6dfb\u52a0\u5230 psql \u63d0\u793a\u7b26\u5e76\u6dfb\u52a0\u76f8\u5173\u72b6\u6001\u53d8\u91cf\uff08Anthonin Bonnefoy\uff09\u00a7
\n\u65b0\u7684\u63d0\u793a\u7b26\u5b57\u7b26\u662f %P\uff0c\u65b0\u7684 psql \u53d8\u91cf\u662f PIPELINE_SYNC_COUNT\u3001PIPELINE_COMMAND_COUNT \u548c PIPELINE_RESULT_COUNT\u3002
\u5141\u8bb8\u5c06\u8fde\u63a5\u670d\u52a1\u540d\u79f0\u6dfb\u52a0\u5230 psql \u63d0\u793a\u7b26\u6216\u901a\u8fc7 psql \u53d8\u91cf\u8bbf\u95ee\u5b83\uff08Michael Banck\uff09\u00a7
", "text": "\u5141\u8bb8\u5c06\u8fde\u63a5\u670d\u52a1\u540d\u79f0\u6dfb\u52a0\u5230 psql \u63d0\u793a\u7b26\u6216\u901a\u8fc7 psql \u53d8\u91cf\u8bbf\u95ee\u5b83\uff08Michael Banck\uff09\u00a7", "title": "\u5141\u8bb8\u5c06\u8fde\u63a5\u670d\u52a1\u540d\u79f0\u6dfb\u52a0\u5230 psql \u63d0\u793a\u7b26\u6216\u901a\u8fc7 psql \u53d8\u91cf\u8bbf\u95ee\u5b83", "commits": ["477728b5d"], "section": "psql", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PSQL", "source_hash": "d708d70528e3a3f746395fa23b8324b7dfe19e3fa2560f0d3fb61d86a8f4af8b", "section_path": ["psql"], "commit_groups": [["477728b5d"]], "identity_text": "Allow adding the connection service name to the psql prompt or access it via psql variable (Michael Banck)", "commit_aliases": ["477728b5d"], "source_commits": ["477728b5d"], "source_entry_id": "18.0/changes/126", "db_id": "b448890a42701668cc28db2c98fe65af", "patch_ids": ["8bc6eb53f480b1773dba3d9ca6fa27ef"], "statement_hash": "b7b84052ccad3b3cdd4e58fd81d7e92d01dcd30e03a638017f02df36fe51481c", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-997c75493a7de85c", "migration": false}, {"id": "18.0-b431886faffda5ff", "cves": [], "html": "\u6dfb\u52a0 psql \u9009\u9879\uff0c\u5728\u6240\u6709\u5217\u8868\u547d\u4ee4\u4e0a\u4f7f\u7528\u6269\u5c55\u6a21\u5f0f\uff08Dean Rasheed\uff09\u00a7
\n\u6dfb\u52a0\u53cd\u659c\u6760\u540e\u7f00 x \u542f\u7528\u6b64\u529f\u80fd\u3002
\u66f4\u6539 psql \u7684\\conninfo\u4ee5\u4f7f\u7528\u8868\u683c\u683c\u5f0f\u5e76\u5305\u542b\u66f4\u591a\u4fe1\u606f\uff08\u00c1lvaro Herrera, Maiquel Grassi, Hunaid Sohail\uff09\u00a7
\u5c06\u51fd\u6570\u7684\u9632\u6cc4\u6f0f\u6307\u793a\u5668\u6dfb\u52a0\u5230 psql \u7684 \\df+\u3001\\do+\u3001\\dAo+ \u548c \\dC+ \u8f93\u51fa\uff08Yugo Nagata\uff09\u00a7
\u5728 \\dP+ \u4e2d\u4e3a\u5206\u533a\u5173\u7cfb\u6dfb\u52a0\u8bbf\u95ee\u65b9\u6cd5\u8be6\u7ec6\u4fe1\u606f\uff08Justin Pryzby\uff09\u00a7
\u5c06 default_version \u6dfb\u52a0\u5230 psql \\dx \u6269\u5c55\u8f93\u51fa\uff08Magnus Hagander\uff09\u00a7
\u6dfb\u52a0 psql \u53d8\u91cfWATCH_INTERVAL\u4ee5\u8bbe\u7f6e\u9ed8\u8ba4\u7684 \\watch \u7b49\u5f85\u65f6\u95f4\uff08Daniel Gustafsson\uff09\u00a7
\u66f4\u6539initdb\u9ed8\u8ba4\u542f\u7528\u6821\u9a8c\u548c\uff08Greg Sabino Mullane\uff09\u00a7 \u00a7
\n\u65b0\u7684 initdb \u9009\u9879 --no-data-checksums \u7981\u7528\u6821\u9a8c\u548c\u3002
\u6dfb\u52a0 initdb \u9009\u9879 --no-sync-data-files \u4ee5\u907f\u514d\u540c\u6b65\u5806/\u7d22\u5f15\u6587\u4ef6\uff08Nathan Bossart\uff09\u00a7
initdb \u9009\u9879 --no-sync \u4ecd\u7136\u53ef\u7528\uff0c\u4ee5\u907f\u514d\u540c\u6b65\u4efb\u4f55\u6587\u4ef6\u3002
\u6dfb\u52a0vacuumdb\u9009\u9879 --missing-stats-only \u4ee5\u4ec5\u8ba1\u7b97\u7f3a\u5931\u7684\u4f18\u5316\u5668\u7edf\u8ba1\u4fe1\u606f\uff08Corey Huinker, Nathan Bossart\uff09\u00a7 \u00a7
\u6b64\u9009\u9879\u53ea\u80fd\u7531\u8d85\u7ea7\u7528\u6237\u8fd0\u884c\uff0c\u5e76\u4e14\u53ea\u80fd\u4e0e\u9009\u9879 --analyze-only \u548c --analyze-in-stages \u4e00\u8d77\u4f7f\u7528\u3002
\u6dfb\u52a0pg_combinebackup\u9009\u9879 -k/--link \u4ee5\u542f\u7528\u786c\u94fe\u63a5\uff08Israel Barth Rubio, Robert Haas\uff09\u00a7
\u53ea\u6709\u67d0\u4e9b\u6587\u4ef6\u53ef\u4ee5\u786c\u94fe\u63a5\u3002\u5982\u679c\u5907\u4efd\u5c06\u72ec\u7acb\u4f7f\u7528\uff0c\u5219\u4e0d\u5e94\u4f7f\u7528\u6b64\u529f\u80fd\u3002
", "text": "\u6dfb\u52a0pg_combinebackup\u9009\u9879 -k/--link \u4ee5\u542f\u7528\u786c\u94fe\u63a5\uff08Israel Barth Rubio, Robert Haas\uff09\u00a7 \u53ea\u6709\u67d0\u4e9b\u6587\u4ef6\u53ef\u4ee5\u786c\u94fe\u63a5\u3002\u5982\u679c\u5907\u4efd\u5c06\u72ec\u7acb\u4f7f\u7528\uff0c\u5219\u4e0d\u5e94\u4f7f\u7528\u6b64\u529f\u80fd\u3002", "title": "\u6dfb\u52a0pg_combinebackup\u9009\u9879 -k/--link \u4ee5\u542f\u7528\u786c\u94fe\u63a5", "commits": ["99aeb8470"], "section": "\u670d\u52a1\u5668\u5e94\u7528", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-APPS", "source_hash": "eefef01cb696f44d91b49f7817d447e5f2b2aeac8ca97a0513d80a36ce3eab22", "section_path": ["\u670d\u52a1\u5668\u5e94\u7528"], "commit_groups": [["99aeb8470"]], "identity_text": "Add app-pgcombinebackup option -k/--link to enable hard linking (Israel Barth Rubio, Robert Haas) Only some files can be hard linked. This should not be used if the backups will be used independently.", "commit_aliases": ["99aeb8470"], "source_commits": ["99aeb8470"], "source_entry_id": "18.0/changes/136", "db_id": "cbac9921cfb2186e54629d635e3729f3", "patch_ids": ["b2774e6278fb43524469fa415bf7c504"], "statement_hash": "5736af1019c3d5e2bd2ae443e4a9261637afca5e0e0ff655d599e24adaf4ea01", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-b755aca78d27d72f", "migration": false}, {"id": "18.0-ed3c2d316129795e", "cves": [], "html": "\u5141\u8bb8pg_verifybackup\u9a8c\u8bc1 tar \u683c\u5f0f\u5907\u4efd\uff08Amul Sul\uff09\u00a7
", "text": "\u5141\u8bb8pg_verifybackup\u9a8c\u8bc1 tar \u683c\u5f0f\u5907\u4efd\uff08Amul Sul\uff09\u00a7", "title": "\u5141\u8bb8pg_verifybackup\u9a8c\u8bc1 tar \u683c\u5f0f\u5907\u4efd", "commits": ["8dfd31290"], "section": "\u670d\u52a1\u5668\u5e94\u7528", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SERVER-APPS", "source_hash": "e2b0d86a1a6fe34a3eaef7656a3093c8fef2bcf4bb4045b3b394c42b6e595297", "section_path": ["\u670d\u52a1\u5668\u5e94\u7528"], "commit_groups": [["8dfd31290"]], "identity_text": "Allow app-pgverifybackup to verify tar-format backups (Amul Sul)", "commit_aliases": ["8dfd31290"], "source_commits": ["8dfd31290"], "source_entry_id": "18.0/changes/137", "db_id": "4a31265bb9d301899f61cbb72dc938fe", "patch_ids": ["f61db0ff36a5aaba1fefc4551593c41a"], "statement_hash": "033fcbd8882efc5f140f40a57fd1009957f6354e0fff3b3c07f05be1d2c1ce01", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-ed3c2d316129795e", "migration": false}, {"id": "18.0-51cd1c3ad2116931", "cves": [], "html": "\u5982\u679cpg_rewind\u7684 --source-server \u6307\u5b9a\u4e86\u6570\u636e\u5e93\u540d\u79f0\uff0c\u5219\u5728 --write-recovery-conf \u8f93\u51fa\u4e2d\u4f7f\u7528\u5b83\uff08Masahiko Sawada\uff09\u00a7
\u6dfb\u52a0pg_resetwal\u9009\u9879 --char-signedness \u4ee5\u66f4\u6539\u9ed8\u8ba4\u7684 char \u6709\u7b26\u53f7\u6027\uff08Masahiko Sawada\uff09\u00a7
\u6dfb\u52a0pg_dump\u9009\u9879 --statistics\uff08Jeff Davis\uff09\u00a7 \u00a7
\u6dfb\u52a0 pg_dump \u548cpg_dumpall\u9009\u9879 --sequence-data \u4ee5\u8f6c\u50a8\u901a\u5e38\u4f1a\u88ab\u6392\u9664\u7684\u5e8f\u5217\u6570\u636e\uff08Nathan Bossart\uff09\u00a7 \u00a7
\u6dfb\u52a0pg_dump\u3001pg_dumpall\u548cpg_restore\u9009\u9879 --statistics-only\u3001--no-statistics\u3001--no-data \u548c --no-schema\uff08Corey Huinker, Jeff Davis\uff09\u00a7
\u6dfb\u52a0\u9009\u9879 --no-policies \u4ee5\u7981\u7528pg_dump\u3001pg_dumpall\u3001pg_restore\u4e2d\u7684\u884c\u7ea7\u5b89\u5168\u7b56\u7565\u5904\u7406\uff08Nikolay Samokhvalov\uff09\u00a7
\u8fd9\u5bf9\u4e8e\u8fc1\u79fb\u5230\u5177\u6709\u4e0d\u540c\u7b56\u7565\u7684\u7cfb\u7edf\u5f88\u6709\u7528\u3002
", "text": "\u6dfb\u52a0\u9009\u9879 --no-policies \u4ee5\u7981\u7528pg_dump\u3001pg_dumpall\u3001pg_restore\u4e2d\u7684\u884c\u7ea7\u5b89\u5168\u7b56\u7565\u5904\u7406\uff08Nikolay Samokhvalov\uff09\u00a7 \u8fd9\u5bf9\u4e8e\u8fc1\u79fb\u5230\u5177\u6709\u4e0d\u540c\u7b56\u7565\u7684\u7cfb\u7edf\u5f88\u6709\u7528\u3002", "title": "\u6dfb\u52a0\u9009\u9879 --no-policies \u4ee5\u7981\u7528pg_dump\u3001pg_dumpall\u3001pg_restore\u4e2d\u7684\u884c\u7ea7\u5b89\u5168\u7b56\u7565\u5904\u7406", "commits": ["cd3c45125"], "section": "\u670d\u52a1\u5668\u5e94\u7528 / pg_dump/pg_dumpall/pg_restore", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGDUMP", "source_hash": "9231fdf3af2971c21ef9738044c6bf6fc9a4e82d61c155057f623aeacf8d1381", "section_path": ["\u670d\u52a1\u5668\u5e94\u7528", "pg_dump/pg_dumpall/pg_restore"], "commit_groups": [["cd3c45125"]], "identity_text": "Add option --no-policies to disable row level security policy processing in app-pgdump , app-pg-dumpall , app-pgrestore (Nikolay Samokhvalov) This is useful for migrating to systems with different policies.", "commit_aliases": ["cd3c45125"], "source_commits": ["cd3c45125"], "source_entry_id": "18.0/changes/143", "db_id": "f65a09f6ed8414315ea3ab15d44b063d", "patch_ids": ["e8632c1f2c717fcff1a04211ab59a0c3"], "statement_hash": "c2544d757037ea2d9f0d54209afb5dfcd831c83b0fb375579be57d3ffb98b730", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-452c1c147611899f", "migration": false}, {"id": "18.0-b708d651d189458f", "cves": [], "html": "\u5141\u8bb8 pg_upgrade \u4fdd\u7559\u4f18\u5316\u5668\u7edf\u8ba1\u4fe1\u606f\uff08Corey Huinker, Jeff Davis, Nathan Bossart\uff09\u00a7 \u00a7 \u00a7 \u00a7
\n\u4e0d\u4fdd\u7559\u6269\u5c55\u7edf\u8ba1\u4fe1\u606f\u3002\u540c\u65f6\u6dfb\u52a0 pg_upgrade \u9009\u9879 --no-statistics \u4ee5\u7981\u7528\u7edf\u8ba1\u4fe1\u606f\u4fdd\u7559\u3002
\u5141\u8bb8 pg_upgrade \u5e76\u884c\u5904\u7406\u6570\u636e\u5e93\u68c0\u67e5\uff08Nathan Bossart\uff09\u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7
\n\u8fd9\u7531\u73b0\u6709 --jobs \u9009\u9879\u63a7\u5236\u3002
\u6dfb\u52a0 pg_upgrade \u9009\u9879 --swap \u4ee5\u4ea4\u6362\u76ee\u5f55\u800c\u4e0d\u662f\u590d\u5236\u3001\u514b\u9686\u6216\u94fe\u63a5\u6587\u4ef6\uff08Nathan Bossart\uff09\u00a7
\u6b64\u6a21\u5f0f\u53ef\u80fd\u662f\u6700\u5feb\u7684\u3002
", "text": "\u6dfb\u52a0 pg_upgrade \u9009\u9879 --swap \u4ee5\u4ea4\u6362\u76ee\u5f55\u800c\u4e0d\u662f\u590d\u5236\u3001\u514b\u9686\u6216\u94fe\u63a5\u6587\u4ef6\uff08Nathan Bossart\uff09\u00a7 \u6b64\u6a21\u5f0f\u53ef\u80fd\u662f\u6700\u5feb\u7684\u3002", "title": "\u6dfb\u52a0 pg_upgrade \u9009\u9879 --swap \u4ee5\u4ea4\u6362\u76ee\u5f55\u800c\u4e0d\u662f\u590d\u5236\u3001\u514b\u9686\u6216\u94fe\u63a5\u6587\u4ef6", "commits": ["626d7236b"], "section": "\u670d\u52a1\u5668\u5e94\u7528 / pg_upgrade", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGUPGRADE", "source_hash": "5105f96fe345879f059f5dec740fcdf62c3fb86f637efc061ea65ff41062563f", "section_path": ["\u670d\u52a1\u5668\u5e94\u7528", "pg_upgrade"], "commit_groups": [["626d7236b"]], "identity_text": "Add pg_upgrade option --swap to swap directories rather than copy, clone, or link files (Nathan Bossart) This mode is potentially the fastest.", "commit_aliases": ["626d7236b"], "source_commits": ["626d7236b"], "source_entry_id": "18.0/changes/146", "db_id": "f554eecffc9529fc8a7bf5df05f1ee48", "patch_ids": ["925b13034396ed82973d22527b295ac1"], "statement_hash": "446dc8dd0a3efeea98cbe5eef953503f703ba461702c2ad5d7041434781f351e", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-06d87c4ff487ca68", "migration": false}, {"id": "18.0-d2c23c9432e26b4b", "cves": [], "html": "\u6dfb\u52a0 pg_upgrade \u9009\u9879 --set-char-signedness \u4ee5\u8bbe\u7f6e\u65b0\u96c6\u7c07\u7684\u9ed8\u8ba4 char \u7b26\u53f7\u6027\uff08Masahiko Sawada\uff09\u00a7 \u00a7
\u8fd9\u662f\u4e3a\u4e86\u5904\u7406 PostgreSQL 18 \u4e4b\u524d\u96c6\u7c07\u7684\u9ed8\u8ba4CPU\u7b26\u53f7\u6027\u4e0e\u65b0\u96c6\u7c07\u4e0d\u5339\u914d\u7684\u60c5\u51b5\u3002
", "text": "\u6dfb\u52a0 pg_upgrade \u9009\u9879 --set-char-signedness \u4ee5\u8bbe\u7f6e\u65b0\u96c6\u7c07\u7684\u9ed8\u8ba4 char \u7b26\u53f7\u6027\uff08Masahiko Sawada\uff09\u00a7 \u00a7 \u8fd9\u662f\u4e3a\u4e86\u5904\u7406 PostgreSQL 18 \u4e4b\u524d\u96c6\u7c07\u7684\u9ed8\u8ba4CPU\u7b26\u53f7\u6027\u4e0e\u65b0\u96c6\u7c07\u4e0d\u5339\u914d\u7684\u60c5\u51b5\u3002", "title": "\u6dfb\u52a0 pg_upgrade \u9009\u9879 --set-char-signedness \u4ee5\u8bbe\u7f6e\u65b0\u96c6\u7c07\u7684\u9ed8\u8ba4 char \u7b26\u53f7\u6027", "commits": ["1aab68059", "a8238f87f"], "section": "\u670d\u52a1\u5668\u5e94\u7528 / pg_upgrade", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGUPGRADE", "source_hash": "81fc7dfeaecc0c2acbed8c77a91318171c093256de3f1c6509e4ddb9b3506a2b", "section_path": ["\u670d\u52a1\u5668\u5e94\u7528", "pg_upgrade"], "commit_groups": [["1aab68059"], ["a8238f87f"]], "identity_text": "Add pg_upgrade option --set-char-signedness to set the default char signedness of new cluster (Masahiko Sawada) This is to handle cases where a pre-PostgreSQL 18 cluster's default CPU signedness does not match the new cluster.", "commit_aliases": ["1aab68059", "a8238f87f"], "source_commits": ["1aab68059", "a8238f87f"], "source_entry_id": "18.0/changes/147", "db_id": "512ccd3d1bb4f010fe11b0eb637be55c", "patch_ids": ["85f2c26487e180e9e34c5a419dbbbf35", "b55f3df554d6f4f601f40f9bd71932dc"], "statement_hash": "5d736231626605165fd5a2523999bf34662259ec86505d0abb98425210873d2d", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-d2c23c9432e26b4b", "migration": false}, {"id": "18.0-d19757fdc61ec769", "cves": [], "html": "\u6dfb\u52a0pg_createsubscriber\u9009\u9879 --all \u4ee5\u521b\u5efa\u6240\u6709\u6570\u636e\u5e93\u7684\u903b\u8f91\u526f\u672c\uff08Shubham Khanna\uff09\u00a7
\u6dfb\u52a0 pg_createsubscriber \u9009\u9879 --clean \u4ee5\u5220\u9664\u53d1\u5e03\uff08Shubham Khanna\uff09\u00a7 \u00a7
\u6dfb\u52a0 pg_createsubscriber \u9009\u9879 --enable-two-phase \u4ee5\u542f\u7528\u9884\u5907\u4e8b\u52a1\uff08Shubham Khanna\uff09\u00a7
\u6dfb\u52a0pg_recvlogical\u9009\u9879 --enable-failover \u4ee5\u6307\u5b9a\u6545\u969c\u5207\u6362\u69fd\uff08Hayato Kuroda\uff09\u00a7
\u8fd8\u6dfb\u52a0\u9009\u9879 --enable-two-phase \u4f5c\u4e3a --two-phase \u7684\u540c\u4e49\u8bcd\uff0c\u5e76\u5f03\u7528\u540e\u8005\u3002
\u5141\u8bb8 pg_recvlogical --drop-slot \u5728\u6ca1\u6709 --dbname \u7684\u60c5\u51b5\u4e0b\u5de5\u4f5c\uff08Hayato Kuroda\uff09\u00a7
\u5206\u79bb\u6ce8\u5165\u70b9\u7684\u52a0\u8f7d\u548c\u8fd0\u884c\uff08Michael Paquier, Heikki Linnakangas\uff09\u00a7 \u00a7
\n\u73b0\u5728\u53ef\u4ee5\u901a\u8fc7 INJECTION_POINT_LOAD() \u521b\u5efa\u6ce8\u5165\u70b9\u4f46\u4e0d\u8fd0\u884c\uff0c\u5e76\u4e14\u53ef\u4ee5\u901a\u8fc7 INJECTION_POINT_CACHED() \u8fd0\u884c\u8fd9\u4e9b\u6ce8\u5165\u70b9\u3002
\u652f\u6301\u6ce8\u5165\u70b9\u4e2d\u7684\u8fd0\u884c\u65f6\u53c2\u6570\uff08Michael Paquier\uff09\u00a7
", "text": "\u652f\u6301\u6ce8\u5165\u70b9\u4e2d\u7684\u8fd0\u884c\u65f6\u53c2\u6570\uff08Michael Paquier\uff09\u00a7", "title": "\u652f\u6301\u6ce8\u5165\u70b9\u4e2d\u7684\u8fd0\u884c\u65f6\u53c2\u6570", "commits": ["371f2db8b"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "05301770ccd349689d8b69904a931228a96e0662899a3ade25f228442b6353fc", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["371f2db8b"]], "identity_text": "Support runtime arguments in injection points (Michael Paquier)", "commit_aliases": ["371f2db8b"], "source_commits": ["371f2db8b"], "source_entry_id": "18.0/changes/154", "db_id": "18e4ff23a56d78d29d6ae66814cb5956", "patch_ids": ["904e25b09a2067d4faafaee411020747"], "statement_hash": "5628295a828190147d169e94449983354f8ae8ff5a86e747e2323a9fafe55684", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-4750fcaf325e66eb", "migration": false}, {"id": "18.0-47c2086c6c32cddf", "cves": [], "html": "\u5141\u8bb8\u4f7f\u7528 IS_INJECTION_POINT_ATTACHED() \u7684\u5185\u8054\u6ce8\u5165\u70b9\u6d4b\u8bd5\u4ee3\u7801\uff08Heikki Linnakangas\uff09\u00a7
\u4f7f\u7528 SIMD\uff08\u5355\u6307\u4ee4\u591a\u6570\u636e\uff09\u6539\u8fdb\u5904\u7406\u957fJSON\u5b57\u7b26\u4e32\u7684\u6027\u80fd\uff08David Rowley\uff09\u00a7
\u4f7f\u7528 x86 AVX-512 \u6307\u4ee4\u52a0\u901f CRC32C \u8ba1\u7b97\uff08Raghuveer Devulapalli, Paul Amonson\uff09\u00a7
", "text": "\u4f7f\u7528 x86 AVX-512 \u6307\u4ee4\u52a0\u901f CRC32C \u8ba1\u7b97\uff08Raghuveer Devulapalli, Paul Amonson\uff09\u00a7", "title": "\u4f7f\u7528 x86 AVX-512 \u6307\u4ee4\u52a0\u901f CRC32C \u8ba1\u7b97", "commits": ["3c6e8c123"], "section": "\u6e90\u4ee3\u7801", "category": "performance", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "5c411d4b51c4b6be50ef868a21271a59e4a75118bd9ef67ecd94fe284fa402d6", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["3c6e8c123"]], "identity_text": "Speed up CRC32C calculations using x86 AVX-512 instructions (Raghuveer Devulapalli, Paul Amonson)", "commit_aliases": ["3c6e8c123"], "source_commits": ["3c6e8c123"], "source_entry_id": "18.0/changes/157", "db_id": "ecafb4a5cc6e92dddebe2ea023f597fc", "patch_ids": ["019ee0d01e78e91881714ff3219df19d"], "statement_hash": "9ebfb29bd90710429d9371df23815bf2b5a56103e50f8fd93d29218148000bd5", "relations": [], "category_label": "\u6027\u80fd\u6539\u8fdb", "url": "/docs/compare/?release=18.0#18.0-2da13651125031b5", "migration": false}, {"id": "18.0-800b2833fc9c07cb", "cves": [], "html": "\u6dfb\u52a0\u7528\u4e8e popcount\uff08\u6574\u6570\u4f4d\u8ba1\u6570\uff09\u7684ARM Neon \u548cSVE CPU\u5185\u5728\u51fd\u6570\uff08Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi\uff09\u00a7 \u00a7
", "text": "\u6dfb\u52a0\u7528\u4e8e popcount\uff08\u6574\u6570\u4f4d\u8ba1\u6570\uff09\u7684ARM Neon \u548cSVE CPU\u5185\u5728\u51fd\u6570\uff08Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi\uff09\u00a7 \u00a7", "title": "\u6dfb\u52a0\u7528\u4e8e popcount\uff08\u6574\u6570\u4f4d\u8ba1\u6570\uff09\u7684ARM Neon \u548cSVE CPU\u5185\u5728\u51fd\u6570", "commits": ["519338ace", "6be53c276"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "09d6f13a948bcd90f3f3ac8e4018d0c533c115226c68a7db35a0bca2856dc813", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["519338ace"], ["6be53c276"]], "identity_text": "Add ARM Neon and SVE CPU intrinsics for popcount (integer bit counting) (Chiranmoy Bhattacharya, Devanga Susmitha, Rama Malladi)", "commit_aliases": ["519338ace", "6be53c276"], "source_commits": ["519338ace", "6be53c276"], "source_entry_id": "18.0/changes/158", "db_id": "e50b80ab8e5fdb402e0beb48a5db4bc9", "patch_ids": ["205916923c7dd75d0231c55476cd4c48", "fd2f2d7fbcf88e0449c66f9f417165fc"], "statement_hash": "ee09c22e85fe2068ac5f7492e13742c8aea22c6679a441f8015237ca7bdeeca7", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-800b2833fc9c07cb", "migration": false}, {"id": "18.0-0ce7fe540ff763c1", "cves": [], "html": "\u63d0\u9ad8\u6570\u503c\u4e58\u6cd5\u548c\u9664\u6cd5\u7684\u901f\u5ea6\uff08Joel Jacobson, Dean Rasheed\uff09\u00a7 \u00a7 \u00a7 \u00a7
", "text": "\u63d0\u9ad8\u6570\u503c\u4e58\u6cd5\u548c\u9664\u6cd5\u7684\u901f\u5ea6\uff08Joel Jacobson, Dean Rasheed\uff09\u00a7 \u00a7 \u00a7 \u00a7", "title": "\u63d0\u9ad8\u6570\u503c\u4e58\u6cd5\u548c\u9664\u6cd5\u7684\u901f\u5ea6", "commits": ["8dc28d7eb", "9428c001f", "c4e44224c", "ca481d3c9"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "6edd099ca744adedc636a8415e8be30ad6220455ffa27ad1859cf8db0e9e45b0", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["8dc28d7eb"], ["9428c001f"], ["c4e44224c"], ["ca481d3c9"]], "identity_text": "Improve the speed of numeric multiplication and division (Joel Jacobson, Dean Rasheed)", "commit_aliases": ["8dc28d7eb", "9428c001f", "c4e44224c", "ca481d3c9"], "source_commits": ["8dc28d7eb", "9428c001f", "c4e44224c", "ca481d3c9"], "source_entry_id": "18.0/changes/159", "db_id": "a7dfad9e7ea9413b1f4feb4de2d8c632", "patch_ids": ["2f55166563d7d9ec64de99e0bf6e591a", "674fb4fd8062e095c5e8fbfa7beab186", "8d573b00acf40046627605c19414157d", "eb6faba6db5698c6310910540adef0d3"], "statement_hash": "8921ae4e40b001cd77fce579693d0a2e93ba934d8c04d74b261b43866655c114", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-0ce7fe540ff763c1", "migration": false}, {"id": "18.0-7ed66c101b89375c", "cves": [], "html": "\u6dfb\u52a0\u914d\u7f6e\u9009\u9879--with-libnuma\u4ee5\u542f\u7528NUMA\u611f\u77e5\u529f\u80fd\uff08Jakub Wartak, Bertrand Drouvot\uff09\u00a7 \u00a7 \u00a7
\u51fd\u6570pg_numa_available() \u62a5\u544a\u662f\u5426\u5177\u5907NUMA\u611f\u77e5\u80fd\u529b\uff1b\u7cfb\u7edf\u89c6\u56fe pg_shmem_allocations_numa \u548cpg_buffercache_numa \u62a5\u544a\u5171\u4eab\u5185\u5b58\u5728NUMA\u8282\u70b9\u4e4b\u95f4\u7684\u5206\u5e03\u3002
\u5c06TOAST\u8868\u6dfb\u52a0\u5230pg_index\uff0c\u4ee5\u5141\u8bb8\u521b\u5efa\u8d85\u5927\u578b\u8868\u8fbe\u5f0f\u7d22\u5f15\uff08Nathan Bossart\uff09\u00a7
\u79fb\u9664\u5217pg_attribute.attcacheoff\uff08David Rowley\uff09\u00a7
\u6dfb\u52a0\u5217pg_class.relallfrozen\uff08Melanie Plageman\uff09\u00a7
\u5c06amgettreeheight\u3001amconsistentequality\u548camconsistentordering\u6dfb\u52a0\u5230\u7d22\u5f15\u8bbf\u95ee\u65b9\u6cd5API\uff08Mark Dilger\uff09\u00a7 \u00a7
\u6dfb\u52a0GiST\u652f\u6301\u51fd\u6570stratnum()\uff08Paul A. Jungwirth\uff09\u00a7
\u5728pg_controldata\u4e2d\u8bb0\u5f55CPU\u5bf9char\u7c7b\u578b\u7684\u9ed8\u8ba4\u6709\u7b26\u53f7\u6027\uff08Masahiko Sawada\uff09\u00a7
\u5728PL/Python\u4e2d\u6dfb\u52a0\u5bf9 Python\u201cLimited API\u201d\u7684\u652f\u6301\uff08Peter Eisentraut\uff09\u00a7\u00a7
\n\u8fd9\u6709\u52a9\u4e8e\u9632\u6b62\u7531\u4e8ePython 3.x \u7248\u672c\u4e0d\u5339\u914d\u5f15\u8d77\u7684\u95ee\u9898\u3002
", "text": "\u5728PL/Python\u4e2d\u6dfb\u52a0\u5bf9 Python\u201cLimited API\u201d\u7684\u652f\u6301\uff08Peter Eisentraut\uff09\u00a7\u00a7 \u8fd9\u6709\u52a9\u4e8e\u9632\u6b62\u7531\u4e8ePython 3.x \u7248\u672c\u4e0d\u5339\u914d\u5f15\u8d77\u7684\u95ee\u9898\u3002", "title": "\u5728PL/Python\u4e2d\u6dfb\u52a0\u5bf9 Python\u201cLimited API\u201d\u7684\u652f\u6301", "commits": ["0793ab810", "72a3d0462"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "f49def5963789b61e9e11e6b78ad16b391ce6657675eb5e12857c3d90c25063f", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["0793ab810"], ["72a3d0462"]], "identity_text": "Add support for Python \"Limited API\" in PL/Python (Peter Eisentraut) This helps prevent problems caused by Python 3.x version mismatches.", "commit_aliases": ["0793ab810", "72a3d0462"], "source_commits": ["0793ab810", "72a3d0462"], "source_entry_id": "18.0/changes/167", "db_id": "d9d289d7c17d30019901f5104438a9b5", "patch_ids": ["cbf73ec20c058f368547efbe37a75ed9", "d615c6575bcf9dabc148901891890deb"], "statement_hash": "bf3af05933e7d77673abcb674c13915120867f48aac15d60053f750a42d0d7d0", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-02a1ef16c8d55c42", "migration": false}, {"id": "18.0-a91e1aed4a58b3e8", "cves": [], "html": "\u5c06\u6700\u4f4e\u652f\u6301\u7684Python\u7248\u672c\u66f4\u6539\u4e3a3.6.8\uff08Jacob Champion\uff09\u00a7
", "text": "\u5c06\u6700\u4f4e\u652f\u6301\u7684Python\u7248\u672c\u66f4\u6539\u4e3a3.6.8\uff08Jacob Champion\uff09\u00a7", "title": "\u5c06\u6700\u4f4e\u652f\u6301\u7684Python\u7248\u672c\u66f4\u6539\u4e3a3.6.8", "commits": ["45363fca6"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "edfc0a822c1e6decb577eb651c059faf6285be5446a2ae201393b823c93a7b4a", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["45363fca6"]], "identity_text": "Change the minimum supported Python version to 3.6.8 (Jacob Champion)", "commit_aliases": ["45363fca6"], "source_commits": ["45363fca6"], "source_entry_id": "18.0/changes/168", "db_id": "3803d2204af4aafb31861db9c07294df", "patch_ids": ["d238a5c385201266bab1298ddc3d6937"], "statement_hash": "8e0582a6e94665c56a736b1daf82f2826837a955bf1ad3c8fed3ee41c1854b9b", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-a91e1aed4a58b3e8", "migration": false}, {"id": "18.0-569734334a6b98e9", "cves": [], "html": "\u79fb\u9664\u5bf9\u65e9\u4e8e1.1.1\u7248\u672c\u7684OpenSSL\u7684\u652f\u6301\uff08Daniel Gustafsson\uff09\u00a7 \u00a7
", "text": "\u79fb\u9664\u5bf9\u65e9\u4e8e1.1.1\u7248\u672c\u7684OpenSSL\u7684\u652f\u6301\uff08Daniel Gustafsson\uff09\u00a7 \u00a7", "title": "\u79fb\u9664\u5bf9\u65e9\u4e8e1.1.1\u7248\u672c\u7684OpenSSL\u7684\u652f\u6301", "commits": ["6c66b7443", "a70e01d43"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "fef36e34b98c4cf8afc0e87fda7cd8014955b79b409cd798e1776f2cbb3cc19d", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["6c66b7443"], ["a70e01d43"]], "identity_text": "Remove support for OpenSSL versions older than 1.1.1 (Daniel Gustafsson)", "commit_aliases": ["6c66b7443", "a70e01d43"], "source_commits": ["6c66b7443", "a70e01d43"], "source_entry_id": "18.0/changes/169", "db_id": "48cbbe1a33f004fe33768f2881d5d92f", "patch_ids": ["abb2eed446c79007a20dabd90ec11e07", "e230f75c4521f002154fbc695ab93e0a"], "statement_hash": "c8e7dae9a85d85423b23da56e2d21b96b7f26438f93b7ac8c175a38b66b24100", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-569734334a6b98e9", "migration": false}, {"id": "18.0-bd09bbc2d989193e", "cves": [], "html": "\u5982\u679c\u542f\u7528LLVM\uff0c\u5219\u8981\u6c42\u7248\u672c14\u6216\u66f4\u9ad8\uff08Thomas Munro\uff09\u00a7
", "text": "\u5982\u679c\u542f\u7528LLVM\uff0c\u5219\u8981\u6c42\u7248\u672c14\u6216\u66f4\u9ad8\uff08Thomas Munro\uff09\u00a7", "title": "\u5982\u679c\u542f\u7528LLVM\uff0c\u5219\u8981\u6c42\u7248\u672c14\u6216\u66f4\u9ad8", "commits": ["972c2cd28"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "312a91a833836d352538d85b42e2e70e2f3593c02b219f7e95f80da5e10bfaf4", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["972c2cd28"]], "identity_text": "If LLVM is enabled, require version 14 or later (Thomas Munro)", "commit_aliases": ["972c2cd28"], "source_commits": ["972c2cd28"], "source_entry_id": "18.0/changes/170", "db_id": "50c7a44be3192eea399751ed1200e8e8", "patch_ids": ["8a4ef85fef8148a0752a6381c6a739bb"], "statement_hash": "36fc6c5974c10ca846263ab84a10c91abb0ab4d1f95effb5f1513c71c37a4bbe", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-bd09bbc2d989193e", "migration": false}, {"id": "18.0-0f56f248bf4ec2a9", "cves": [], "html": "\u6dfb\u52a0\u5b8fPG_MODULE_MAGIC_EXT\u4ee5\u5141\u8bb8\u6269\u5c55\u62a5\u544a\u5176\u540d\u79f0\u548c\u7248\u672c\uff08Andrei Lepikhov\uff09\u00a7
\u6b64\u4fe1\u606f\u53ef\u4ee5\u901a\u8fc7\u65b0\u51fd\u6570pg_get_loaded_modules()\u8bbf\u95ee\u3002
\u6587\u6863\u6307\u51faSPI_connect()/SPI_connect_ext()\u603b\u662f\u8fd4\u56de\u6210\u529f\uff08SPI_OK_CONNECT\uff09\uff08Stepan Neretin\uff09\u00a7
\u9519\u8bef\u603b\u662f\u901a\u8fc7ereport()\u62a5\u544a\u3002
\u6dfb\u52a0\u5173\u4e8eAPI\u548cABI\u517c\u5bb9\u6027\u7684\u6587\u6863\u7ae0\u8282\uff08David Wheeler, Peter Eisentraut\uff09\u00a7
", "text": "\u6dfb\u52a0\u5173\u4e8eAPI\u548cABI\u517c\u5bb9\u6027\u7684\u6587\u6863\u7ae0\u8282\uff08David Wheeler, Peter Eisentraut\uff09\u00a7", "title": "\u6dfb\u52a0\u5173\u4e8eAPI\u548cABI\u517c\u5bb9\u6027\u7684\u6587\u6863\u7ae0\u8282", "commits": ["e54a42ac9"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "90c971529d419760d77397cb587a82b521c16886289aebdd0a9950e6910000f9", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["e54a42ac9"]], "identity_text": "Add documentation section about API and ABI compatibility (David Wheeler, Peter Eisentraut)", "commit_aliases": ["e54a42ac9"], "source_commits": ["e54a42ac9"], "source_entry_id": "18.0/changes/173", "db_id": "bce92895bdc4d2128762d0826b82afe5", "patch_ids": ["ed9bc344aa72386c8e767c718632ec82"], "statement_hash": "0295a4b203df0b9501cc58312ecd1041db9220faa5a8a3ae88d0fb981ee922f4", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-f038496a550a3a46", "migration": false}, {"id": "18.0-4788a1f5f1370946", "cves": [], "html": "\u79fb\u9664Meson\u4e0aWindows\u6784\u5efa\u7684\u5b9e\u9a8c\u6027\u6807\u8bb0\uff08Aleksander Alekseev\uff09\u00a7
", "text": "\u79fb\u9664Meson\u4e0aWindows\u6784\u5efa\u7684\u5b9e\u9a8c\u6027\u6807\u8bb0\uff08Aleksander Alekseev\uff09\u00a7", "title": "\u79fb\u9664Meson\u4e0aWindows\u6784\u5efa\u7684\u5b9e\u9a8c\u6027\u6807\u8bb0", "commits": ["5afaba629"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "6fa8dda0e2cd9ac5555c784bf5c0ef8242c1206143e83bc3f734bc4ebaecdc2a", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["5afaba629"]], "identity_text": "Remove the experimental designation of Meson builds on Windows (Aleksander Alekseev)", "commit_aliases": ["5afaba629"], "source_commits": ["5afaba629"], "source_entry_id": "18.0/changes/174", "db_id": "65f45b8de45e88579fb3a07c1fc5ca82", "patch_ids": ["7f3733853ec88ef6dcc506c3f311ca02"], "statement_hash": "4b791d0ce6d561df0dc9266dbc1c032420c8b1a17d776165cd28778ec4824762", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-4788a1f5f1370946", "migration": false}, {"id": "18.0-6b5e40a77fbcbf1d", "cves": [], "html": "\u79fb\u9664\u914d\u7f6e\u9009\u9879--disable-spinlocks\u548c--disable-atomics\uff08Thomas Munro\uff09\u00a7 \u00a7
\u73b0\u5728\u9700\u898132\u4f4d\u539f\u5b50\u64cd\u4f5c\u3002
", "text": "\u79fb\u9664\u914d\u7f6e\u9009\u9879--disable-spinlocks\u548c--disable-atomics\uff08Thomas Munro\uff09\u00a7 \u00a7 \u73b0\u5728\u9700\u898132\u4f4d\u539f\u5b50\u64cd\u4f5c\u3002", "title": "\u79fb\u9664\u914d\u7f6e\u9009\u9879--disable-spinlocks\u548c--disable-atomics", "commits": ["813852613", "e25626677"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "dea8d45db1e65b97fa1c42d83d77ae1a21b44ff4bf947e134c0ae0c51fec84eb", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["813852613"], ["e25626677"]], "identity_text": "Remove configure options --disable-spinlocks and --disable-atomics (Thomas Munro) Thirty-two-bit atomic operations are now required.", "commit_aliases": ["813852613", "e25626677"], "source_commits": ["813852613", "e25626677"], "source_entry_id": "18.0/changes/175", "db_id": "cb76202d341bfde3157c7f5662fdca08", "patch_ids": ["1adba83a13269f9fe1796e4c938f5668", "c5a68b790cc12df3a522cd1c85e50f75"], "statement_hash": "f075e693a989fc62b94be60cc6414f54094d772e3fc9f2cc5a1a1beefdca9437", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-6b5e40a77fbcbf1d", "migration": false}, {"id": "18.0-e7a698f98f5c42cc", "cves": [], "html": "\u79fb\u9664\u5bf9HPPA/PA-RISC\u67b6\u6784\u7684\u652f\u6301\uff08Tom Lane\uff09\u00a7
", "text": "\u79fb\u9664\u5bf9HPPA/PA-RISC\u67b6\u6784\u7684\u652f\u6301\uff08Tom Lane\uff09\u00a7", "title": "\u79fb\u9664\u5bf9HPPA/PA-RISC\u67b6\u6784\u7684\u652f\u6301", "commits": ["edadeb071"], "section": "\u6e90\u4ee3\u7801", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-SOURCE-CODE", "source_hash": "8f4d3cb0f0e25fcd326fb98621d0aefc3e51c019fd35d16cfdf8c01567fe96be", "section_path": ["\u6e90\u4ee3\u7801"], "commit_groups": [["edadeb071"]], "identity_text": "Remove support for the HPPA/PA-RISC architecture (Tom Lane)", "commit_aliases": ["edadeb071"], "source_commits": ["edadeb071"], "source_entry_id": "18.0/changes/176", "db_id": "a167452f08dbddf1b2de4b6f87175253", "patch_ids": ["4c7fcd694e4cfcfdf4d2b66e07bcc93b"], "statement_hash": "34e0e62ec64cf13e242497f80e1704894b16ff8d2f43db397bcdbb5fd4d87a42", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-e7a698f98f5c42cc", "migration": false}, {"id": "18.0-7300ae371e3a1273", "cves": [], "html": "\u6dfb\u52a0\u6269\u5c55pg_logicalinspect\u4ee5\u68c0\u67e5\u903b\u8f91\u5feb\u7167\uff08Bertrand Drouvot\uff09\u00a7
", "text": "\u6dfb\u52a0\u6269\u5c55pg_logicalinspect\u4ee5\u68c0\u67e5\u903b\u8f91\u5feb\u7167\uff08Bertrand Drouvot\uff09\u00a7", "title": "\u6dfb\u52a0\u6269\u5c55pg_logicalinspect\u4ee5\u68c0\u67e5\u903b\u8f91\u5feb\u7167", "commits": ["7cdfeee32"], "section": "\u9644\u52a0\u6a21\u5757", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "2687560225facdefa50011e45e121f7d2ba43f8c8dbd44cf574154afa1445beb", "section_path": ["\u9644\u52a0\u6a21\u5757"], "commit_groups": [["7cdfeee32"]], "identity_text": "Add extension pglogicalinspect to inspect logical snapshots (Bertrand Drouvot)", "commit_aliases": ["7cdfeee32"], "source_commits": ["7cdfeee32"], "source_entry_id": "18.0/changes/177", "db_id": "67c4f0ce87d750c9d1fc47621ad4ca18", "patch_ids": ["a7b197beccb692abf2aeb8c35a0a48a1"], "statement_hash": "aacda762c76e2c1fbfdaa69e9c927a9740a1692b0b61c349e5016a3c3b699a0a", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-7300ae371e3a1273", "migration": false}, {"id": "18.0-cd656e77492d840c", "cves": [], "html": "\u6dfb\u52a0\u6269\u5c55pg_overexplain\uff0c\u5b83\u5411EXPLAIN\u8f93\u51fa\u6dfb\u52a0\u8c03\u8bd5\u7ec6\u8282\uff08Robert Haas\uff09\u00a7
\u5411postgres_fdw_get_connections()\u6dfb\u52a0\u8f93\u51fa\u5217\uff08Hayato Kuroda, Sagar Dilip Shedge\uff09\u00a7 \u00a7 \u00a7 \u00a7
\u65b0\u7684\u8f93\u51fa\u5217used_in_xact\u6307\u793a\u5916\u90e8\u6570\u636e\u5305\u88c5\u5668\u662f\u5426\u6b63\u5728\u88ab\u5f53\u524d\u4e8b\u52a1\u4f7f\u7528\uff0cclosed\u6307\u793a\u5b83\u662f\u5426\u5df2\u5173\u95ed\uff0cuser_name\u6307\u793a\u7528\u6237\u540d\uff0cremote_backend_pid\u6307\u793a\u8fdc\u7a0b\u540e\u7aef\u8fdb\u7a0b\u6807\u8bc6\u7b26\u3002
\u5141\u8bb8\u5c06\u5ba2\u6237\u7aef\u7684SCRAM\u8ba4\u8bc1\u4f20\u9012\u7ed9postgres_fdw\u670d\u52a1\u5668\uff08Matheus Alcantara, Peter Eisentraut\uff09\u00a7
\n\u8fd9\u907f\u514d\u4e86\u5728\u6570\u636e\u5e93\u4e2d\u5b58\u50a8postgres_fdw\u8ba4\u8bc1\u4fe1\u606f\uff0c\u5e76\u901a\u8fc7postgres_fdw use_scram_passthrough\u8fde\u63a5\u9009\u9879\u542f\u7528\u3002libpq\u4f7f\u7528\u65b0\u7684\u8fde\u63a5\u53c2\u6570scram_client_key\u548cscram_server_key\u3002
\u5141\u8bb8\u5c06\u5ba2\u6237\u7aef\u7684SCRAM\u8ba4\u8bc1\u4f20\u9012\u7ed9dblink\u670d\u52a1\u5668\uff08Matheus Alcantara\uff09\u00a7
", "text": "\u5141\u8bb8\u5c06\u5ba2\u6237\u7aef\u7684SCRAM\u8ba4\u8bc1\u4f20\u9012\u7ed9dblink\u670d\u52a1\u5668\uff08Matheus Alcantara\uff09\u00a7", "title": "\u5141\u8bb8\u5c06\u5ba2\u6237\u7aef\u7684SCRAM\u8ba4\u8bc1\u4f20\u9012\u7ed9dblink\u670d\u52a1\u5668", "commits": ["3642df265"], "section": "\u9644\u52a0\u6a21\u5757", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "d5d459964678c5f8377c3bd875649fc44172ce4cb2a1b6401f0950b80fc6ba4a", "section_path": ["\u9644\u52a0\u6a21\u5757"], "commit_groups": [["3642df265"]], "identity_text": "Allow SCRAM authentication from the client to be passed to dblink servers (Matheus Alcantara)", "commit_aliases": ["3642df265"], "source_commits": ["3642df265"], "source_entry_id": "18.0/changes/181", "db_id": "db82382f896f8242594f26f0e98cd318", "patch_ids": ["071743b3a560980bed101b42da01a888"], "statement_hash": "606c662a7292efbe14169ab67273e036f3695f6e116ffb4735ab23da0a7f3415", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-b79a6af7a72eb39c", "migration": false}, {"id": "18.0-b232c340f3e456c9", "cves": [], "html": "\u4e3afile_fdw\u6dfb\u52a0on_error\u548clog_verbosity\u9009\u9879\uff08Atsushi Torikoshi\uff09\u00a7
\u8fd9\u4e9b\u63a7\u5236file_fdw\u5982\u4f55\u5904\u7406\u548c\u62a5\u544a\u65e0\u6548\u6587\u4ef6\u884c\u3002
", "text": "\u4e3afile_fdw\u6dfb\u52a0on_error\u548clog_verbosity\u9009\u9879\uff08Atsushi Torikoshi\uff09\u00a7 \u8fd9\u4e9b\u63a7\u5236file_fdw\u5982\u4f55\u5904\u7406\u548c\u62a5\u544a\u65e0\u6548\u6587\u4ef6\u884c\u3002", "title": "\u4e3afile_fdw\u6dfb\u52a0on_error\u548clog_verbosity\u9009\u9879", "commits": ["a1c4c8a9e"], "section": "\u9644\u52a0\u6a21\u5757", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "115a0c8a418b7106acd2734d853b844db562b082c4bda8f83428f4e298314284", "section_path": ["\u9644\u52a0\u6a21\u5757"], "commit_groups": [["a1c4c8a9e"]], "identity_text": "Add on_error and log_verbosity options to file-fdw (Atsushi Torikoshi) These control how file_fdw handles and reports invalid file rows.", "commit_aliases": ["a1c4c8a9e"], "source_commits": ["a1c4c8a9e"], "source_entry_id": "18.0/changes/182", "db_id": "6982b0c41f58b8ad05599dd36f57aaa9", "patch_ids": ["21992e0340c7459eca57bac98530eee3"], "statement_hash": "c5180a0af1dd4fdd3162754e1b488f348273f6c2f9209b82ebf3d374fabffd98", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-b232c340f3e456c9", "migration": false}, {"id": "18.0-270f462ffe8c1a9e", "cves": [], "html": "\u6dfb\u52a0reject_limit\u4ee5\u63a7\u5236file_fdw\u53ef\u4ee5\u5ffd\u7565\u7684\u65e0\u6548\u884c\u6570\uff08Atsushi Torikoshi\uff09\u00a7
\u8fd9\u5728ON_ERROR = 'ignore'\u65f6\u6fc0\u6d3b\u3002
\u5411passwordcheck\u6dfb\u52a0\u53ef\u914d\u7f6e\u53d8\u91cfmin_password_length\uff08Emanuele Musella, Maurizio Boriani\uff09\u00a7
\u8fd9\u63a7\u5236\u6700\u5c0f\u5bc6\u7801\u957f\u5ea6\u3002
", "text": "\u5411passwordcheck\u6dfb\u52a0\u53ef\u914d\u7f6e\u53d8\u91cfmin_password_length\uff08Emanuele Musella, Maurizio Boriani\uff09\u00a7 \u8fd9\u63a7\u5236\u6700\u5c0f\u5bc6\u7801\u957f\u5ea6\u3002", "title": "\u5411passwordcheck\u6dfb\u52a0\u53ef\u914d\u7f6e\u53d8\u91cfmin_password_length", "commits": ["f7e1b3828"], "section": "\u9644\u52a0\u6a21\u5757", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "1b94e879146707658c8624a2cc1d0d5d51823ca6cec56d81901b4e94cb11b78c", "section_path": ["\u9644\u52a0\u6a21\u5757"], "commit_groups": [["f7e1b3828"]], "identity_text": "Add configurable variable min_password_length to passwordcheck (Emanuele Musella, Maurizio Boriani) This controls the minimum password length.", "commit_aliases": ["f7e1b3828"], "source_commits": ["f7e1b3828"], "source_entry_id": "18.0/changes/184", "db_id": "c2f3e4981e48c781d80d8d683bfeafdc", "patch_ids": ["8adca4662ef9e316e20e61eac39f5953"], "statement_hash": "3c96a08392c835400e1601043498429b0df9c4a3c6205b65fa827329a880c71d", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-21c3262257dd838f", "migration": false}, {"id": "18.0-261498b314e3db45", "cves": [], "html": "\u8ba9pgbench\u5728\u6bcf\u811a\u672c\u62a5\u544a\u4e2d\u62a5\u544a\u5931\u8d25\u3001\u91cd\u8bd5\u6216\u8df3\u8fc7\u7684\u4e8b\u52a1\u6570\uff08Yugo Nagata\uff09\u00a7
", "text": "\u8ba9pgbench\u5728\u6bcf\u811a\u672c\u62a5\u544a\u4e2d\u62a5\u544a\u5931\u8d25\u3001\u91cd\u8bd5\u6216\u8df3\u8fc7\u7684\u4e8b\u52a1\u6570\uff08Yugo Nagata\uff09\u00a7", "title": "\u8ba9pgbench\u5728\u6bcf\u811a\u672c\u62a5\u544a\u4e2d\u62a5\u544a\u5931\u8d25\u3001\u91cd\u8bd5\u6216\u8df3\u8fc7\u7684\u4e8b\u52a1\u6570", "commits": ["cae0f3c40"], "section": "\u9644\u52a0\u6a21\u5757", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "b6ab8471bd55acbc24e7b6d8e4dbc4490126311ba216112a2325d59926d09340", "section_path": ["\u9644\u52a0\u6a21\u5757"], "commit_groups": [["cae0f3c40"]], "identity_text": "Have pgbench report the number of failed, retried, or skipped transactions in per-script reports (Yugo Nagata)", "commit_aliases": ["cae0f3c40"], "source_commits": ["cae0f3c40"], "source_entry_id": "18.0/changes/185", "db_id": "7d68f2a4e71d87ab7e6b4494d5b3c176", "patch_ids": ["7ae9139da216927d66da497ea952bf95"], "statement_hash": "18f1805b3f36c44aa22e9a7c871bfc854cae06d2d1ba7d54f1c9ef8c03dabac0", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-261498b314e3db45", "migration": false}, {"id": "18.0-e465d00ad3f4615d", "cves": [], "html": "\u6dfb\u52a0isn\u670d\u52a1\u5668\u53d8\u91cfweak\u4ee5\u63a7\u5236\u662f\u5426\u63a5\u53d7\u65e0\u6548\u7684\u6821\u9a8c\u4f4d\uff08Viktor Holmberg\uff09\u00a7
\u8fd9\u4ee5\u524d\u4ec5\u7531\u51fd\u6570isn_weak()\u63a7\u5236\u3002
\u5141\u8bb8\u5bf9\u503c\u8fdb\u884c\u6392\u5e8f\u4ee5\u52a0\u5febbtree_gist\u7d22\u5f15\u7684\u6784\u5efa\uff08Bernd Helmle, Andrey Borodin\uff09\u00a7
", "text": "\u5141\u8bb8\u5bf9\u503c\u8fdb\u884c\u6392\u5e8f\u4ee5\u52a0\u5febbtree_gist\u7d22\u5f15\u7684\u6784\u5efa\uff08Bernd Helmle, Andrey Borodin\uff09\u00a7", "title": "\u5141\u8bb8\u5bf9\u503c\u8fdb\u884c\u6392\u5e8f\u4ee5\u52a0\u5febbtree_gist\u7d22\u5f15\u7684\u6784\u5efa", "commits": ["e4309f73f"], "section": "\u9644\u52a0\u6a21\u5757", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "212669f707e1fce095f4a15af5bba9c3db22d8a44760a389af1d2d2f668d8dde", "section_path": ["\u9644\u52a0\u6a21\u5757"], "commit_groups": [["e4309f73f"]], "identity_text": "Allow values to be sorted to speed btree-gist index builds (Bernd Helmle, Andrey Borodin)", "commit_aliases": ["e4309f73f"], "source_commits": ["e4309f73f"], "source_entry_id": "18.0/changes/187", "db_id": "7e911d1361965be0a82fa600d4ebef9d", "patch_ids": ["cffdd969af417cd314b82e92cb6a914f"], "statement_hash": "cebec6909a36bdf2166bf54e64bff4c820d6b198d1e688f1c4007e765cf72614", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-56cc1e29ee633d41", "migration": false}, {"id": "18.0-ee8b77296d44e546", "cves": [], "html": "\u6dfb\u52a0amcheck\u68c0\u67e5\u51fd\u6570gin_index_check()\u4ee5\u9a8c\u8bc1GIN\u7d22\u5f15\uff08Grigory Kryachko, Heikki Linnakangas, Andrey Borodin\uff09\u00a7
\u6dfb\u52a0\u51fd\u6570pg_buffercache_evict_relation()\u548cpg_buffercache_evict_all()\u4ee5\u9010\u51fa\u672a\u9489\u4f4f\u7684\u5171\u4eab\u7f13\u51b2\u533a\uff08Nazir Bilal Yavuz\uff09\u00a7
\u73b0\u6709\u51fd\u6570pg_buffercache_evict()\u73b0\u5728\u8fd4\u56de\u7f13\u51b2\u533a\u5237\u65b0\u72b6\u6001\u3002
\u5141\u8bb8\u6269\u5c55\u5b89\u88c5\u81ea\u5b9a\u4e49\u7684EXPLAIN\u9009\u9879\uff08Robert Haas, Sami Imseih\uff09\u00a7 \u00a7 \u00a7
", "text": "\u5141\u8bb8\u6269\u5c55\u5b89\u88c5\u81ea\u5b9a\u4e49\u7684EXPLAIN\u9009\u9879\uff08Robert Haas, Sami Imseih\uff09\u00a7 \u00a7 \u00a7", "title": "\u5141\u8bb8\u6269\u5c55\u5b89\u88c5\u81ea\u5b9a\u4e49\u7684EXPLAIN\u9009\u9879", "commits": ["4fd02bf7c", "50ba65e73", "c65bc2e1d"], "section": "\u9644\u52a0\u6a21\u5757", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "126c1e252fd401d5cbcf8667b52299d2f5510b10142a7ea6310dcbba82c8bd12", "section_path": ["\u9644\u52a0\u6a21\u5757"], "commit_groups": [["4fd02bf7c"], ["50ba65e73"], ["c65bc2e1d"]], "identity_text": "Allow extensions to install custom sql-explain options (Robert Haas, Sami Imseih)", "commit_aliases": ["4fd02bf7c", "50ba65e73", "c65bc2e1d"], "source_commits": ["4fd02bf7c", "50ba65e73", "c65bc2e1d"], "source_entry_id": "18.0/changes/190", "db_id": "17128679b68e62fcef0d48d266afb493", "patch_ids": ["4a90cb7809dd3268e814052cb9d568f6", "a7446b42cbf558abedd81726ef25be11", "b1d23fea200234c95397b7e93fd14848"], "statement_hash": "e8646573cbbb7286af9b4ad50cc583bc6310d49c513b0e947a6bca0270e16301", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-8919235b177c8b00", "migration": false}, {"id": "18.0-384d5964db6a292c", "cves": [], "html": "\u5141\u8bb8\u6269\u5c55\u4f7f\u7528\u670d\u52a1\u5668\u7684\u7d2f\u8ba1\u7edf\u8ba1\u4fe1\u606fAPI\uff08Michael Paquier\uff09\u00a7 \u00a7
", "text": "\u5141\u8bb8\u6269\u5c55\u4f7f\u7528\u670d\u52a1\u5668\u7684\u7d2f\u8ba1\u7edf\u8ba1\u4fe1\u606fAPI\uff08Michael Paquier\uff09\u00a7 \u00a7", "title": "\u5141\u8bb8\u6269\u5c55\u4f7f\u7528\u670d\u52a1\u5668\u7684\u7d2f\u8ba1\u7edf\u8ba1\u4fe1\u606fAPI", "commits": ["2eff9e678", "7949d9594"], "section": "\u9644\u52a0\u6a21\u5757", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-MODULES", "source_hash": "7611ce1609aa627ae59449ba16bf0a6a11d238cb4b3f48d277fa6399e2615ef5", "section_path": ["\u9644\u52a0\u6a21\u5757"], "commit_groups": [["2eff9e678"], ["7949d9594"]], "identity_text": "Allow extensions to use the server's cumulative statistics API (Michael Paquier)", "commit_aliases": ["2eff9e678", "7949d9594"], "source_commits": ["2eff9e678", "7949d9594"], "source_entry_id": "18.0/changes/191", "db_id": "51ed37dd51200e7f7a59592baf05f997", "patch_ids": ["3eb79f54769a802749d52f97f9f8c4cd", "4af802e5801cb1008a49bbd7ffb1b4c6"], "statement_hash": "a6e76441b49e4dfc8c5b6323c846f1efe63f20730e0cc0450e6f197b1eb9b2a0", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-384d5964db6a292c", "migration": false}, {"id": "18.0-097a6648e4c5022b", "cves": [], "html": "\u5141\u8bb8CREATE TABLE AS\u548cDECLARE\u7684\u67e5\u8be2\u88abpg_stat_statements\u8ddf\u8e2a\uff08Anthonin Bonnefoy\uff09\u00a7
\n\u5b83\u4eec\u73b0\u5728\u4e5f\u88ab\u5206\u914d\u4e86\u67e5\u8be2ID\u3002
", "text": "\u5141\u8bb8CREATE TABLE AS\u548cDECLARE\u7684\u67e5\u8be2\u88abpg_stat_statements\u8ddf\u8e2a\uff08Anthonin Bonnefoy\uff09\u00a7 \u5b83\u4eec\u73b0\u5728\u4e5f\u88ab\u5206\u914d\u4e86\u67e5\u8be2ID\u3002", "title": "\u5141\u8bb8CREATE TABLE AS\u548cDECLARE\u7684\u67e5\u8be2\u88abpg_stat_statements\u8ddf\u8e2a", "commits": ["6b652e6ce"], "section": "\u9644\u52a0\u6a21\u5757 / pg_stat_statements", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGSTATSTATEMENTS", "source_hash": "a71330cbf6ff1fcbcb3577f9497064f4234185cd87242388194c557aabf1ba1b", "section_path": ["\u9644\u52a0\u6a21\u5757", "pg_stat_statements"], "commit_groups": [["6b652e6ce"]], "identity_text": "Allow the queries of sql-createtableas and sql-declare to be tracked by pg_stat_statements (Anthonin Bonnefoy) They are also now assigned query ids.", "commit_aliases": ["6b652e6ce"], "source_commits": ["6b652e6ce"], "source_entry_id": "18.0/changes/192", "db_id": "222e3bfb3e07da2a4bb138e9b89a9ea9", "patch_ids": ["6f27bba477d5d34ec287e6d1f0cb4c01"], "statement_hash": "529743a734ea4d3d2e0ab03ec1c2bc3a516f21292fd3896db229b7e1ee80bdfd", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-097a6648e4c5022b", "migration": false}, {"id": "18.0-1104b155543e7f0f", "cves": [], "html": "\u5141\u8bb8\u5728pg_stat_statements\u4e2d\u5bf9SET\u7684\u503c\u8fdb\u884c\u53c2\u6570\u5316\uff08Greg Sabino Mullane, Michael Paquier\uff09\u00a7
\n\u8fd9\u51cf\u5c11\u4e86\u7531\u4e8e\u5177\u6709\u4e0d\u540c\u5e38\u91cf\u7684SET\u8bed\u53e5\u5f15\u8d77\u7684\u6570\u636e\u81a8\u80c0\u3002
\u6dfb\u52a0pg_stat_statements\u5217\u4ee5\u62a5\u544a\u5e76\u884c\u6d3b\u52a8\uff08Guillaume Lelarge\uff09\u00a7
\u65b0\u5217\u662f parallel_workers_to_launch \u548c parallel_workers_launched\u3002
\u6dfb\u52a0pg_stat_statements.wal_buffers_full\u4ee5\u62a5\u544a\u6ee1WAL\u7f13\u51b2\u533a\uff08Bertrand Drouvot\uff09\u00a7
\u6dfb\u52a0pgcrypto\u7b97\u6cd5sha256crypt\u548csha512crypt\uff08Bernd Helmle\uff09\u00a7
\u4e3apgcrypto\u7684\u52a0\u5bc6\u548c\u89e3\u5bc6\u6dfb\u52a0CFB\u6a21\u5f0f\uff08Umar Hayat\uff09\u00a7
", "text": "\u4e3apgcrypto\u7684\u52a0\u5bc6\u548c\u89e3\u5bc6\u6dfb\u52a0CFB\u6a21\u5f0f\uff08Umar Hayat\uff09\u00a7", "title": "\u4e3apgcrypto\u7684\u52a0\u5bc6\u548c\u89e3\u5bc6\u6dfb\u52a0CFB\u6a21\u5f0f", "commits": ["9ad1b3d01"], "section": "\u9644\u52a0\u6a21\u5757 / pgcrypto", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGCRYPTO", "source_hash": "7f5b08debbba5d1cc71560caa889a862bb5b8108f756e758ad8bc02d4921180a", "section_path": ["\u9644\u52a0\u6a21\u5757", "pgcrypto"], "commit_groups": [["9ad1b3d01"]], "identity_text": "Add CFB mode to pgcrypto encryption and decryption (Umar Hayat)", "commit_aliases": ["9ad1b3d01"], "source_commits": ["9ad1b3d01"], "source_entry_id": "18.0/changes/197", "db_id": "ec341ecdfcaabcd1827eb401ea40905d", "patch_ids": ["b040d33a3888055fc5edf9f0c6e56795"], "statement_hash": "7c89f9937951f96c3f497c06864857f8e8c21ba76f5ef791d1eed77d00a71e81", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-f2a1521602d2427c", "migration": false}, {"id": "18.0-612c4479d75f9942", "cves": [], "html": "\u6dfb\u52a0\u51fd\u6570fips_mode()\u4ee5\u62a5\u544a\u670d\u52a1\u5668\u7684FIPS\u6a21\u5f0f\uff08Daniel Gustafsson\uff09\u00a7
\u6dfb\u52a0pgcrypto\u670d\u52a1\u5668\u53d8\u91cfbuiltin_crypto_enabled\u4ee5\u5141\u8bb8\u7981\u7528\u5185\u7f6e\u975eFIPS\u6a21\u5f0f\u5bc6\u7801\u5b66\u51fd\u6570\uff08Daniel Gustafsson, Joe Conway\uff09\u00a7
\u8fd9\u5bf9\u4e8e\u4fdd\u8bc1FIPS\u6a21\u5f0f\u884c\u4e3a\u5f88\u6709\u7528\u3002
", "text": "\u6dfb\u52a0pgcrypto\u670d\u52a1\u5668\u53d8\u91cfbuiltin_crypto_enabled\u4ee5\u5141\u8bb8\u7981\u7528\u5185\u7f6e\u975eFIPS\u6a21\u5f0f\u5bc6\u7801\u5b66\u51fd\u6570\uff08Daniel Gustafsson, Joe Conway\uff09\u00a7 \u8fd9\u5bf9\u4e8e\u4fdd\u8bc1FIPS\u6a21\u5f0f\u884c\u4e3a\u5f88\u6709\u7528\u3002", "title": "\u6dfb\u52a0pgcrypto\u670d\u52a1\u5668\u53d8\u91cfbuiltin_crypto_enabled\u4ee5\u5141\u8bb8\u7981\u7528\u5185\u7f6e\u975eFIPS\u6a21\u5f0f\u5bc6\u7801\u5b66\u51fd\u6570", "commits": ["035f99cbe"], "section": "\u9644\u52a0\u6a21\u5757 / pgcrypto", "category": "feature", "source_url": "/docs/release/18.0/#RELEASE-18-PGCRYPTO", "source_hash": "7ec37d9ad093c24c937b540278b9a28ded5495aa79ee7e13b25b399ad32123f6", "section_path": ["\u9644\u52a0\u6a21\u5757", "pgcrypto"], "commit_groups": [["035f99cbe"]], "identity_text": "Add pgcrypto server variable builtin_crypto_enabled to allow disabling builtin non-FIPS mode cryptographic functions (Daniel Gustafsson, Joe Conway) This is useful for guaranteeing FIPS mode behavior.", "commit_aliases": ["035f99cbe"], "source_commits": ["035f99cbe"], "source_entry_id": "18.0/changes/199", "db_id": "85292659fb670a2d9202838e30370170", "patch_ids": ["c996d7a6dfbb6918d1e1c1bdc8763d5d"], "statement_hash": "9c517ea3b0ae09d9ac23588dcc459bf5530faea31bee9ef47a11255f44c8ee81", "relations": [], "category_label": "\u65b0\u529f\u80fd", "url": "/docs/compare/?release=18.0#18.0-9f4716da4a9ae5c8", "migration": false}], "initial_entry_count": 210, "migration_html": "\u5bf9\u4e8e\u5e0c\u671b\u4ece\u4efb\u4f55\u4ee5\u524d\u7684\u7248\u672c\u8fc1\u79fb\u6570\u636e\u7684\u4eba\u6765\u8bf4\uff0c\u9700\u8981\u4f7f\u7528pg_dumpall\u8fdb\u884c\u8f6c\u50a8/\u6062\u590d\uff0c\u6216\u8005\u4f7f\u7528pg_upgrade\u6216\u903b\u8f91\u590d\u5236\u3002\u6709\u5173\u8fc1\u79fb\u5230\u65b0\u4e3b\u8981\u7248\u672c\u7684\u901a\u7528\u4fe1\u606f\uff0c\u8bf7\u53c2\u9605\u7b2c\u00a018.6\u00a0\u8282\u3002
\n\u7248\u672c 18 \u5305\u542b\u8bb8\u591a\u53ef\u80fd\u5f71\u54cd\u4e0e\u4ee5\u524d\u7248\u672c\u517c\u5bb9\u6027\u7684\u66f4\u6539\u3002\u8bf7\u6ce8\u610f\u4ee5\u4e0b\u4e0d\u517c\u5bb9\u9879\uff1a
\n