From 306ff0aaf8ef2a4c69a799faf7e6c72fea1c4709 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 5 May 2016 22:37:30 -0400 Subject: [PATCH] Further 9.6 release note improvements. Call out the major enhancements in this release as identified by pgsql-advocacy discussion, and rearrange some of the entries to make those items more prominent. Other minor improvements per advice from Vitaly Burovoy, Masahiko Sawada, Peter Geoghegan, and Andres Freund. --- doc/src/sgml/release-9.6.sgml | 234 ++++++++++++++++++---------------- 1 file changed, 125 insertions(+), 109 deletions(-) diff --git a/doc/src/sgml/release-9.6.sgml b/doc/src/sgml/release-9.6.sgml index 3a8e228d93..4fb25b3a93 100644 --- a/doc/src/sgml/release-9.6.sgml +++ b/doc/src/sgml/release-9.6.sgml @@ -17,13 +17,46 @@ Major enhancements in PostgreSQL 9.6 include: - + - To be filled in, but see below for the long version + Parallel sequential scans, joins and aggregates + + + + + + Elimination of repetitive scanning of old data by autovacuum + + + + + + Synchronous replication now allows multiple standby servers for + increased reliability + + + + + + Full-text search for phrases + + + + + + Support for remote joins, sorts, and updates + in postgres_fdw + + + + + + Substantial performance improvements, especially in the area of + improving scalability on many-CPU servers @@ -315,6 +348,7 @@ 2016-04-24 [8f91d87d4] Fix documentation & config inconsistencies around 428b1d 2016-04-26 [72a98a639] Don't open formally non-existent segments in _mdfd_getse 2016-05-04 [a71248708] Fix transient mdsync() errors of truncated relations due +2016-02-16 [7975c5e0a] Allow the WAL writer to flush WAL at a reduced rate. --> Where feasible, trigger kernel writeback after a configurable number @@ -549,16 +583,6 @@ - - Reduce the WAL writer's flush rate to reduce storage bottlenecks - (Andres Freund) - - - - - @@ -567,14 +591,14 @@ - This reduces kernel traffic and improves scalability when multiple - processes are inserting into the same relation. + This improves scalability by decreasing contention. Improve sorting performance by using quicksort, not replacement @@ -582,17 +606,11 @@ - This behavior can be adjusted via the new configuration - parameter . - - - - - - - Improve memory management for external sorts (Peter Geoghegan) + The new approach makes better use of CPU cache for typical cache + sizes and data volumes. Where necessary, the behavior can be + adjusted via the new configuration + parameter , + which see for further details. @@ -610,29 +628,31 @@ - Speed up sorting of uuid-type columns (Peter Geoghegan) + Speed up sorting of uuid, bytea, + and char(n) fields by using abbreviated keys + (Peter Geoghegan) - - - - Speed up CREATE INDEX CONCURRENTLY by treating TIDs - as 64-bit integers during the sort phase (Peter Geoghegan) + Support for abbreviated keys has also been added to the non-default + operator classes text_pattern_ops, + varchar_pattern_ops, and bpchar_pattern_ops. + Processing of ordered-set aggregates can also now exploit + abbreviated keys. - Improve performance of ordered-set aggregates by reusing - abbreviated-key information (Peter Geoghegan) + Speed up CREATE INDEX CONCURRENTLY by treating TIDs + as 64-bit integers during the sort phase (Peter Geoghegan) @@ -1179,6 +1199,41 @@ XXX this is pending backpatch, may need to remove + + Support synchronous replication with multiple synchronous standby + servers, not just one (Masahiko Sawada, Beena Emerson, Michael + Paquier, Fujii Masao, Kyotaro Horiguchi) + + + + The number of standby servers that must acknowledge a commit before + it's considered done is now configurable. + + + + + + + Add new setting remote_apply for configuration parameter + (Thomas Munro) + + + + In this mode, the master waits for the transaction to be applied on + the standby server, not just written to disk. That means that you + can count on a transaction started on the standby to see all commits + previously acknowledged by the master. + + + + + @@ -1222,36 +1277,6 @@ XXX this is pending backpatch, may need to remove - - - - Support synchronous replication with multiple synchronous standby - servers, not just one (Sawada Masahiko, Beena Emerson, Michael - Paquier, Fujii Masao, Kyotaro Horiguchi) - - - - - - - Add new setting remote_apply for configuration parameter - (Thomas Munro) - - - - In this mode, the master waits for the transaction to be applied on - the standby server, not just written to disk. That means that you - can count on a transaction started on the standby to see all commits - previously acknowledged by the master. - - - @@ -1379,7 +1404,7 @@ XXX this is pending backpatch, may need to remove Add options to ALTER OPERATOR to change the selectivity functions associated with an existing operator - (Uriy Zhuravlev) + (Yury Zhuravlev) @@ -1578,7 +1603,7 @@ XXX this is pending backpatch, may need to remove Allow omitting one or both boundaries in an array slice specifier, for example array_col[3:] - (YUriy Zhuravlev) + (Yury Zhuravlev) @@ -1637,7 +1662,7 @@ XXX this is pending backpatch, may need to remove 2016-04-07 [bb140506d] Phrase full text search. --> - Improve full text search to support searching for phrases, that is, + Improve full-text search to support searching for phrases, that is, lexemes appearing adjacent to each other in a specific order, or with at most a specified distance between them (Teodor Sigaev, Oleg Bartunov, Dmitry Ivanov) @@ -1844,7 +1869,7 @@ XXX this is pending backpatch, may need to remove - These are delete(), filter(), + These are ts_delete(), ts_filter(), unnest(), tsvector_to_array(), array_to_tsvector(), and a variant of setweight() that sets the weight only for specified @@ -1944,7 +1969,7 @@ XXX this is pending backpatch, may need to remove --> Add pg_size_bytes() function to convert human-readable - size strings to numbers (Pavel Stehule, Vitaly Burovoy) + size strings to numbers (Pavel Stehule, Vitaly Burovoy, Dean Rasheed) @@ -2459,8 +2484,9 @@ This commit is also listed under libpq and PL/pgSQL 2016-05-05 [7a622b273] Rename pgbench min/max to least/greatest, and fix handli --> - Support some built-in - functions in expressions in backslash commands (Fabien Coelho) + Support floating-point arithmetic, as well as + some built-in functions, + in expressions in backslash commands (Fabien Coelho) @@ -2756,16 +2782,6 @@ This commit is also listed under libpq and PL/pgSQL - - Generalize the SortSupport for text so that it can be - used by other types such as bpchar (Peter Geoghegan) - - - - - @@ -3038,7 +3054,7 @@ This commit is also listed under libpq and PL/pgSQL --> Add selectivity estimation functions for contrib/intarray - operators, to improve plans for queries using those operators (Uriy + operators, to improve plans for queries using those operators (Yury Zhuravlev, Alexander Korotkov) @@ -3189,31 +3205,6 @@ This commit is also listed under libpq and PL/pgSQL - - Use a single foreign-server connection for local user IDs that all - map to the same remote user (Ashutosh Bapat) - - - - - - - Allow the fetch size to be set as a server or table option - (Corey Huinker) - - - - Formerly, postgres_fdw always fetched 100 rows at a time - from remote queries; now that behavior is adjustable. - - - - - @@ -3253,6 +3244,31 @@ This commit is also listed under libpq and PL/pgSQL + + Allow the fetch size to be set as a server or table option + (Corey Huinker) + + + + Formerly, postgres_fdw always fetched 100 rows at a time + from remote queries; now that behavior is adjustable. + + + + + + + Use a single foreign-server connection for local user IDs that all + map to the same remote user (Ashutosh Bapat) + + + + + -- 2.40.0