PostgreSQL 15 and beyond.pdf
5墨值下载
PostgreSQL 15
and beyond
Amit Kapila
PostgreSQL Committer
and Major Contributor
Fujitsu-Public
2
© Fujitsu 2022
● Ongoing version upgrades once a year
● Enhanced support for large volume data in recent years
6.0
First PostgreSQL Release
Inherits Postgres project at the
University of California, Berkeley, which
had been running since 1986
1997
9.0
•
Streaming Replication
2010
9.1
•
Synchronous
R
eplication
•
Foreign tables
•
Unlogged tables
2011
9.2
•
Index-only scans
•
json data type
2012
9.4
•
jsonb data type
2014
9.3
•
Update to Foreign
Data Wrapper
•
Materialized views
2013
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 xacts
•
Reduce bloat for B-tree index updates
•
Parallel foreign table scans via
postgres_fdw
2021
9.5
•
Row-level security
•
BRIN Index
2016
(Jan)
9.6
•
Parallel Sequential Scan
•
Multiple standby servers in
sync rep
2016
(Sep)
15
2022
•
Merge command
•
Shared memory stats
•
Row/Column Filtering in
Logical Replication
•
Server-side compression for
backups
16
2023
(Q3)
Evolution of the OSS database PostgreSQL
of 32
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论