暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
PostgreSQL 17 and beyond.pdf
88
33页
0次
2024-06-09
5墨值下载
Amit Kapila
PostgreSQL Committer and Major Contributor
Fujitsu
PostgreSQL 17
and beyond
2 © Fujitsu 2024
Fujitsu - Public
Evolution of the OSS database PostgreSQL
Ongoing version
upgrades once a year
Enhanced support for
large volume data in
recent years
10
Declarative Partitioning
Logical Replication
2017
11
SQL stored procedures
Partitioning by hash key
2018
12
Partitioning performance
enhancements
Table Access Methods
2019
13
De-duplication in
B-tree index
Incremental sorting
Parallelized vacuum for indexes
2020
14
Snapshot scalability (better reads)
Logical Replication for in-progress txns
Reduce bloat for B-tree index updates
Parallel foreign table scans
via postgres_fdw
2021
15
2022
Merge command
Shared memory stats
Row/column filtering
in Logical Replication
Server-side backupcompression
16
2023
Logical replication from standby
Parallel apply of large txns
SQL/JSON standard compliance
Faster relation extension
Load balancing via libpq
17
2024
Failover slots
Incremental backups
Remove 1GB limit for vacuum cleanup
SQL/JSON standard JSON_TABLE
SPLIT/MERGE partitions
1997-2016
6.0
9.6
-
Streaming Replication
Synchronous Replication
Row-level security
Materialized views
json/jsonb data types
Foreign tables
Update to Foreign Data Wrapper
Index-only scan
Parallel sequential scan
Unlogged tables
BRIN Index
of 33
5墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜