大家好，我是考100分的小小码 ，祝大家学习进步，加薪顺利呀。今天说一说PostgreSQL 13 new feature,希望您对编程的造诣更进一步.
https://www.postgresql.org/docs/13/release-13.html
1. A big performance leap from 10 to 11. No much difference between 11 and 12 in terms of performance
2. Vacuum, Security and Consistency, Partition-wise join
3. Vacuum
– performance for parallel vacuum of indexes
– Auto vacuum for append-only transacitons
4. Security and Consistency
– libpq channel binding
* stop man in the middle attacks
* Only for SCRAM authentication
– New capability for pg_catcheck
* tool for detect the catalog corruption
5. partition-wise join
6. logical replication for partitioned table. from partitioned to non-partitioned and vice versa
7. Backup manifests. part of pg_backbackup.
– new tool: pg_verifybackup – read manifects and verify the backups
8.Monitoring
Allow EXPLAIN, auto_explain, autovacuum, and pg_stat_statements to track WAL usage statistics
9.General Performance
Allow hash aggregation to use disk storage for large aggregation result sets
PPAS
– Partition automation: automatically create partitions when needed without locking
– Interval partition
– Automatic partition for LIST. When enabled, inserting a value not in the initial list, a new partition will be created to accommodate the new value
– Automatic HASH partitioning: PARTITIONS <number> STORE IN <tablespaces>. HASH would be distributed automatically across the specified tablespaces
– EDB*Loader. If any duplicate row, the operation can be configured not to abort but record the duplicated one into BAD file
– Add more Oracle-compatible features
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
转载请注明出处: https://daima100.com/6849.html
