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
评论