What's New in PostgreSQL 9.6:
← Older revision
Revision as of 23:18, 9 May 2016
Line 3:
Line 3:
This page is a work in progress which will include details of PostgreSQL 9.6 features and changes. Many thanks to Thom Brown for assembling the original list.
This page is a work in progress which will include details of PostgreSQL 9.6 features and changes. Many thanks to Thom Brown for assembling the original list.
+
== Parallel Query ==
−
===
Extension cascade support to install dependencies
===
+
===
Parallel sequential scans
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1ZiPzU
-
0004m0
-
Lq
@gemulon.postgresql.org
Add CASCADE support for CREATE EXTENSION
. ]
+
* [http://www.postgresql.org/message-id/
E1ZwVzN
-
0000Xz
-
5e
@gemulon.postgresql.org
Generate parallel sequential scan plans in simple cases. ]
+
+
=== parallel joins ===
+
+
Links:
+
+
* [http://www.postgresql.org/message-id/E1aLyct-000314-UZ@gemulon.postgresql.org Support parallel joins, and make related improvements
. ]
−
===
Parallel sequential scans,
===
+
===
parallel aggregates
===
Links:
Links:
Line 16:
Line 23:
* [http://www.postgresql.org/message-id/E1ahzxY-0004qA-GJ@gemulon.postgresql.org Support parallel aggregation. ]
* [http://www.postgresql.org/message-id/E1ahzxY-0004qA-GJ@gemulon.postgresql.org Support parallel aggregation. ]
−
===
Cube extension kNN support
===
+
==
postgres_fdw
=
=
+
+
=== Sort pushdown
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1a9tQP
-
0004Qd
-
R7
@gemulon.postgresql.org
Cube extension kNN support
]
+
* [http://www.postgresql.org/message-id/
E1aBS4o
-
0002l1
-
Tv
@gemulon.postgresql.org
postgres_fdw: postgres_fdw: Consider requesting sorted data so we can do a merge join.
]
−
===
Sort
pushdown
,
===
+
===
join pushdown ===
+
+
Links:
+
+
* [http://www.postgresql.org/message-id/E1aTDlV-0007xw-Vj@gemulon.postgresql.org postgres_fdw: Push down joins to remote servers. ]
+
+
=== DML (UPDATE/DELETE)
pushdown ===
Links:
Links:
* [http://www.postgresql.org/message-id/E1agzA4-00074P-QW@gemulon.postgresql.org Directly modify foreign tables. ]
* [http://www.postgresql.org/message-id/E1agzA4-00074P-QW@gemulon.postgresql.org Directly modify foreign tables. ]
−
for postgres_fdw
+
−
===
pg_visibility extension for examining visibility maps
===
+
+
===
Extension cascade support to install dependencies
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1adHwi
-
0007KB
-
TM
@gemulon.postgresql.org Add
pg_visibility contrib module
. ]
+
* [http://www.postgresql.org/message-id/
E1ZiPzU
-
0004m0
-
Lq
@gemulon.postgresql.org Add
CASCADE support for CREATE EXTENSION
. ]
−
===
Command progress reporting
===
+
==
Synchronous Replication
=
=
+
+
=== New remote_apply replication mode which waits for confirmation that a standby has applied changes
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1adhjH
-
0008RE
-
TV
@gemulon.postgresql.org Add
a generic command progress reporting facility
. ]
+
* [http://www.postgresql.org/message-id/
E1al4z1
-
0004qD
-
GW
@gemulon.postgresql.org Add
new replication mode synchronous_commit = 'remote_apply'
. ]
−
===
Detailed wait information in pg_stat_activity
===
+
===
Support for multiple synchronous standbys
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1ae5kR
-
0007wV
-
LY
@gemulon.postgresql.org
Provide much better wait information in pg_stat_activity
. ]
+
* [http://www.postgresql.org/message-id/
E1aniiT
-
00083J
-
4W
@gemulon.postgresql.org
Support multiple synchronous standby servers. ]
+
+
== Transactions, VACUUM and the Visibility Map ==
+
+
=== pg_visibility extension for examining visibility maps ===
+
+
Links:
+
+
* [http://www.postgresql.org/message-id/E1adHwi-0007KB-TM@gemulon.postgresql.org Add pg_visibility contrib module
. ]
=== Frozen page data in visibility map for skipping vacuum on already-frozen data ===
=== Frozen page data in visibility map for skipping vacuum on already-frozen data ===
Line 52:
Line 78:
* [http://www.postgresql.org/message-id/E1ae7wj-0001mM-Ib@gemulon.postgresql.org Don't vacuum all-frozen pages. ]
* [http://www.postgresql.org/message-id/E1ae7wj-0001mM-Ib@gemulon.postgresql.org Don't vacuum all-frozen pages. ]
−
===
New remote_apply replication mode which waits for confirmation that a standby has applied changes
===
+
===
User-defined expiration of snapshots to control table bloat
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1al4z1
-
0004qD
-
GW
@gemulon.postgresql.org Add
new replication mode synchronous_commit = 'remote_apply'.
]
+
* [http://www.postgresql.org/message-id/
E1aocLh
-
0006C7
-
2W
@gemulon.postgresql.org Add
the "snapshot too old" feature
]
−
===
Index-only scans for partial indexes
===
+
==
Other Features
=
=
+
+
=== Cube extension kNN support
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1alhet
-
0001o8
-
Hg
@gemulon.postgresql.org
Support using index-only scans with partial indexes in more case
]
+
* [http://www.postgresql.org/message-id/
E1a9tQP
-
0004Qd
-
R7
@gemulon.postgresql.org
Cube extension kNN support
]
−
===
Support for multiple synchronous standbys
===
+
+
===
Command progress reporting
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1aniiT
-
00083J
-
4W
@gemulon.postgresql.org
Support multiple synchronous standby servers
. ]
+
* [http://www.postgresql.org/message-id/
E1adhjH
-
0008RE
-
TV
@gemulon.postgresql.org
Add a generic command progress reporting facility
. ]
−
===
Phrase full text search
===
+
===
Detailed wait information in pg_stat_activity
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1aoCJy
-
0004bp
-
HI
@gemulon.postgresql.org
Phrase full text search
. ]
+
* [http://www.postgresql.org/message-id/
E1ae5kR
-
0007wV
-
LY
@gemulon.postgresql.org
Provide much better wait information in pg_stat_activity
. ]
−
===
User
-
defined expiration of snapshots to control table bloat
===
+
+
===
Index
-
only scans for partial indexes
===
Links:
Links:
−
* [http://www.postgresql.org/message-id/
E1aocLh
-
0006C7
-
2W
@gemulon.postgresql.org
Add the "snapshot too old" feature
]
+
* [http://www.postgresql.org/message-id/
E1alhet
-
0001o8
-
Hg
@gemulon.postgresql.org
Support using index-only scans with partial indexes in more case ]
+
+
+
=== Phrase full text search ===
+
+
Links:
+
+
* [http://www.postgresql.org/message-id/E1aoCJy-0004bp-HI@gemulon.postgresql.org Phrase full text search.
]