From c1602c7a1b2e49acbba680cb72949d4fa3a8d2ee Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 8 Sep 2017 16:59:26 -0400 Subject: [PATCH] Doc: update v10 release notes through today. Also, another round of copy-editing. I merged a few items that didn't seem to be meaningfully different from a user's perspective. --- doc/src/sgml/release-10.sgml | 290 +++++++++++++++++------------------ 1 file changed, 144 insertions(+), 146 deletions(-) diff --git a/doc/src/sgml/release-10.sgml b/doc/src/sgml/release-10.sgml index 1a9110614d..7ace37c8b6 100644 --- a/doc/src/sgml/release-10.sgml +++ b/doc/src/sgml/release-10.sgml @@ -6,7 +6,7 @@ Release date: - 2017-??-?? (current as of 2017-08-26, commit 145ca364d) + 2017-??-?? (current as of 2017-09-07, commit 08cb36417) @@ -20,12 +20,11 @@ - (yet to be finalized) Logical replication using publish/subscribe - Declarative Table Partitioning - Improved Query Parallelism + Declarative table partitioning + Improved query parallelism Significant general performance improvements - SCRAM-SHA-256 strong authentication + Stronger password authentication based on SCRAM-SHA-256 Improved monitoring and control @@ -56,11 +55,12 @@ Hash indexes must be rebuilt after pg_upgrade-ing from any previous major PostgreSQL version (Mithun - Cy, Robert Haas) + Cy, Robert Haas, Amit Kapila) @@ -329,8 +329,8 @@ Changing this setting from the default value caused queries referencing parent tables to not include child tables. The SQL - standard requires such behavior and this has been the default since - PostgreSQL 7.1. + standard requires them to be included, however, and this has been the + default since PostgreSQL 7.1. @@ -393,8 +393,8 @@ This removes configure's @@ -403,7 +403,7 @@ 2016-10-11 [2f1eaf87e] Drop server support for FE/BE protocol version 1.0. --> - Remove support for client/server protocol version 1.0 (Tom Lane) + Remove server support for client/server protocol version 1.0 (Tom Lane) @@ -424,8 +424,8 @@ This replaces the hardcoded, undocumented file name dh1024.pem. Note that dh1024.pem is - no longer examined by default; you must set this option to use custom - DH parameters. + no longer examined by default; you must set this option if you want + to use custom DH parameters. @@ -485,9 +485,9 @@ - These were deprecated since PostgreSQL 9.1. Instead, - use CREATE EXTENSION and DROP EXTENSION - directly. + These had been deprecated since PostgreSQL 9.1. + Instead, use CREATE EXTENSION and DROP + EXTENSION directly. @@ -626,25 +626,41 @@ - Add SP-GiST index support for INET and - CIDR data types (Emre Hasegeli) + Add write-ahead logging support to hash indexes (Amit Kapila) - These data types already had GiST support. + This makes hash indexes crash-safe and replicatable. + The former warning message about their use is removed. - Reduce page locking during vacuuming of GIN indexes - (Andrey Borodin) + Improve hash index performance (Amit Kapila, Mithun Cy, Ashutosh + Sharma) + + + + + + + Add SP-GiST index support for INET and + CIDR data types (Emre Hasegeli) @@ -658,8 +674,8 @@ - Specifically, a new CREATE - INDEX option allows auto-summarization of the + A new CREATE + INDEX option enables auto-summarization of the previous BRIN page range when a new page range is created. @@ -705,65 +721,17 @@ - - - - <link linkend="indexes-types">Hash Indexes</link> - - - - - - - Add write-ahead logging support to hash indexes (Amit Kapila) - - - - This makes hash indexes crash-safe and replicatable. - The former warning message about their use is removed. - - - - - - - Improve hash index bucket split performance by reducing locking - requirements (Amit Kapila, Mithun Cy) - - - - Also cache hash index meta-information for faster lookups. - - - - - - - Improve efficiency of hash index growth (Amit Kapila, Mithun Cy) - - - - + - - Allow page-at-a-time hash index pruning (Ashutosh Sharma) - - - - + + Reduce page locking during vacuuming of GIN indexes + (Andrey Borodin) + + - + @@ -986,17 +954,6 @@ - - Properly update the statistics collector during REFRESH MATERIALIZED - VIEW (Jim Mlodgenski) - - - - - @@ -1010,6 +967,17 @@ + + + + Properly update the statistics collector during REFRESH MATERIALIZED + VIEW (Jim Mlodgenski) + + + @@ -1120,25 +1088,17 @@ - Add pg_stat_activity reporting of latch wait states - (Michael Paquier, Robert Haas) + Add pg_stat_activity reporting of low-level wait + states (Michael Paquier, Robert Haas, Rushabh Lathia) - This includes the remaining wait events, like client reads, - client writes, and synchronous replication. - - - - - - - Add pg_stat_activity reporting of waits on reads, - writes, and fsyncs (Rushabh Lathia) + This change enables reporting of numerous low-level wait conditions, + including latch waits, file reads/writes/fsyncs, client reads/writes, + and synchronous replication. @@ -1315,8 +1275,8 @@ 2017-03-27 [1b02be21f] Fsync directory after creating or unlinking file. --> - Perform an fsync on the directory after creating or unlinking files - (Michael Paquier) + After creating or unlinking files, perform an fsync on their parent + directory (Michael Paquier) @@ -1367,7 +1327,7 @@ - Larger WAL segment sizes allows for fewer + A larger WAL segment size allows for fewer invocations and fewer WAL files to manage. @@ -1400,7 +1360,7 @@ Logical replication allows more flexibility than physical replication does, including replication between different major - versions of PostgreSQL and selective-table + versions of PostgreSQL and selective replication. @@ -1455,7 +1415,7 @@ Previously pg_hba.conf's replication connection - lines were commented out. This is particularly useful for + lines were commented out by default. This is particularly useful for . @@ -1654,7 +1614,7 @@ Previously all security policies were permissive, meaning that any - matching policy allowed access. Optional restrictive policies must + matching policy allowed access. A restrictive policy must match for access to be granted. These policy types can be combined. @@ -1829,7 +1789,7 @@ This complements the existing support for EUI-48 MAC addresses - as macaddr. + (type macaddr). @@ -2253,22 +2213,6 @@ - - Improve psql's \d (display relation) - and \dD (display domain) commands to show collation, - nullable, and default properties in separate columns (Peter - Eisentraut) - - - - Previous they were shown in a single Modifiers column. - - - - - @@ -2311,6 +2255,47 @@ + + Add variables showing server version and psql version + (Fabien Coelho) + + + + + + + Improve psql's \d (display relation) + and \dD (display domain) commands to show collation, + nullable, and default properties in separate columns (Peter + Eisentraut) + + + + Previously they were shown in a single Modifiers column. + + + + + + + Make the various \d commands handle no-matching-object + cases more consistently (Daniel Gustafsson) + + + + They now all print the message about that to stderr, not stdout, + and the message wording is more consistent. + + + + + + + tupconvert.c functions no longer convert tuples just to + embed a different composite-type OID in them (Ashutosh Bapat, Tom Lane) + + + + The majority of callers don't care about the composite-type OID; + but if the result tuple is to be used as a composite Datum, steps + should be taken to make sure the correct OID is inserted in it. + + + - Push aggregates to foreign data wrapper servers, where possible + In postgres_fdw, + push aggregate functions to the remote server, when possible (Jeevan Chalke, Ashutosh Bapat) - This reduces the amount of data that must be passed - from the foreign data wrapper server, and offloads - aggregate computation from the requesting server. The postgres_fdw FDW is able to - perform this optimization. There are also improvements in - pushing down joins involving extensions. + This reduces the amount of data that must be passed from the remote + server, and offloads aggregate computation from the requesting server. - Allow push down of FULL JOIN queries containing - subqueries in the - FROM clause to foreign servers (Etsuro Fujita) + In postgres_fdw, push joins to the remote server in + more cases (David Rowley, Ashutosh Bapat, Etsuro Fujita) @@ -3072,7 +3070,7 @@ - This allows it to be less disruptive when run on production systems. + This makes it less disruptive when run on production systems. -- 2.40.0