PostgreSQL_13_GA_New_Features_Example.pdf
5墨值下载
© 2019-2020 Hewlett Packard Enterprise Japan Co, Ltd.
1
September 27, 2020
PostgreSQL 13 New Features
With Examples (GA)
Hewlett Packard Enterprise Japan Co, Ltd.
Noriyoshi Shinoda
© 2019-2020 Hewlett Packard Enterprise Japan Co, Ltd.
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. Improve analytic query performance ................................................................................. 7
2.2. Improve reliability .......................................................................................................... 7
2.3. Improved maintainability ................................................................................................. 8
2.4. Preparing for future new features...................................................................................... 8
2.5. Incompatibility ............................................................................................................. 10
2.5.1. configure ................................................................................................................ 10
2.5.2. createuser ............................................................................................................... 10
2.5.3. CSV log format ...................................................................................................... 10
2.5.4. Extension ............................................................................................................... 10
2.5.5. opaque .................................................................................................................... 11
2.5.6. Require version of OpenSSL .................................................................................... 11
2.5.7. pg_regress ............................................................................................................... 11
2.5.8. psql default prompt .................................................................................................. 11
2.5.9. to_date/to_timestamp .............................................................................................. 12
2.5.10. Promotion during recovery .................................................................................... 12
2.5.11. Partition key ......................................................................................................... 12
2.5.12. Wait Event ............................................................................................................ 12
2.5.13. SIMILAR TO ESCAPE ......................................................................................... 13
3. New Feature Detail .............................................................................................................. 14
3.1. Architecture .................................................................................................................. 14
3.1.1. Modified catalogs ................................................................................................... 14
3.1.2. Data types .............................................................................................................. 19
3.1.3. Disk-based hash aggregation ................................................................................... 20
3.1.4. Incremental sort ...................................................................................................... 21
3.1.5. Backup manifests .................................................................................................... 22
of 81
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论