PostgreSQL 16 新特性大全（带示例）-Hewlett Packard.pdf
免费下载
© 2022-2023 Hewlett Packard Enterprise Japan G.K.
1
September 19, 2023
PostgreSQL 16 New Features
With Examples (GA)
Hewlett Packard Enterprise Japan G.K.
Noriyoshi Shinoda
© 2022-2023 Hewlett Packard Enterprise Japan G.K.
2
Index
Index ........................................................................................................................................ 2
1. About This Document ............................................................................................................ 5
1.1. Purpose .......................................................................................................................... 5
1.2. Audience ........................................................................................................................ 5
1.3. Scope ............................................................................................................................. 5
1.4. Software Version ............................................................................................................. 5
1.5. The Question, comment, and Responsibility ...................................................................... 6
1.6. Notation ......................................................................................................................... 6
2. New Features Summary ......................................................................................................... 7
2.1. Improvements to adapt to large scale environments ........................................................... 7
2.2. Improved reliability ......................................................................................................... 7
2.3. Improved maintainability ................................................................................................. 8
2.4. Improvements in Programming ........................................................................................ 8
2.5. Preparing for future new features...................................................................................... 8
2.6. Incompatibility ............................................................................................................... 9
2.6.1. End of support .......................................................................................................... 9
2.6.2. Promotion ................................................................................................................ 9
2.6.3. Bootstrap user attribute ............................................................................................. 9
2.6.4. WAL Archive ......................................................................................................... 10
2.6.5. Extension ................................................................................................................ 11
2.6.6. Datetime string format ............................................................................................. 11
2.6.7. ASCII string conversion .......................................................................................... 12
2.6.8. ALTER DEFAULT PRIVILEGES statement ............................................................. 12
2.6.9. ALTER TABLE statement ....................................................................................... 12
2.6.10. CREATE RULE statement ..................................................................................... 13
2.6.11. CREATE TABLE statement ................................................................................... 13
2.6.12. CREATEROLE attribute ....................................................................................... 13
2.6.13. POWER function .................................................................................................. 14
2.6.14. RESET statement .................................................................................................. 15
2.6.15. Pg_stat_get_backend_idset function ....................................................................... 15
2.6.16. Pg_walinspect extension ........................................................................................ 16
2.6.17. Postmaster ............................................................................................................ 17
2.6.18. Psql ..................................................................................................................... 17
2.6.19. Libpq ................................................................................................................... 18
of 98
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论