From 98c2d3332b30006ff71add99bc9d619c9457e71f Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 24 Sep 2016 16:25:35 -0400 Subject: [PATCH] Do a final round of updates on the 9.6 release notes. Set release date, document a few recent commits, do one last pass of copy-editing. --- doc/src/sgml/catalogs.sgml | 9 +++- doc/src/sgml/release-9.6.sgml | 83 +++++++++++++++++++++++++++-------- 2 files changed, 71 insertions(+), 21 deletions(-) diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 322d8d6dc7..29738b07cb 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -7596,6 +7596,11 @@ application. + + By default, the pg_config view can be read + only by superusers. + + <structname>pg_config</> Columns @@ -7771,8 +7776,8 @@ - The pg_file_settings view can be read only by - superusers. + By default, the pg_file_settings view can be read + only by superusers.
diff --git a/doc/src/sgml/release-9.6.sgml b/doc/src/sgml/release-9.6.sgml index ddd280c85a..5c40910c72 100644 --- a/doc/src/sgml/release-9.6.sgml +++ b/doc/src/sgml/release-9.6.sgml @@ -6,8 +6,7 @@ Release Date - 2016-??-?? - Current as of 2016-08-27 (commit b9fe6cbc8) + 2016-09-29 @@ -56,7 +55,7 @@ Substantial performance improvements, especially in the area of - scalability on multi-CPU-socket servers + scalability on multi-CPU-socket servers @@ -269,7 +268,7 @@ This commit is also listed under libpq and psql Write (or its abbreviation ) explicitly to obtain the old - behavior. Scripts modified this way will still work with old + behavior. Scripts so modified will still work with old versions of psql. @@ -371,6 +370,7 @@ and many others in the same vein 2016-06-09 [c9ce4a1c6] Eliminate "parallel degree" terminology. 2016-06-16 [75be66464] Invent min_parallel_relation_size GUC to replace a hard- 2016-08-16 [f85b1a841] Disable parallel query by default. +2016-09-15 [72ce78162] Make min_parallel_relation_size's default value platform --> Parallel queries (Robert Haas, Amit Kapila, David Rowley, @@ -504,6 +504,7 @@ and many others in the same vein Improve sorting performance by using quicksort, not replacement @@ -693,7 +694,7 @@ and many others in the same vein (a,b) REFERENCES r (x,y), then a WHERE condition such as t.a = r.x AND t.b = r.y cannot select more than one r row per t row. - The planner formerly considered AND conditions + The planner formerly considered these AND conditions to be independent and would often drastically misestimate selectivity as a result. Now it compares the WHERE conditions to applicable foreign key constraints and produces @@ -731,7 +732,7 @@ and many others in the same vein containing only already-frozen tuples are identified in the table's visibility map, and can be skipped by vacuum even when doing transaction wraparound prevention. This should greatly reduce the - cost of maintaining large tables containing mostly-unchanged data. + cost of maintaining large tables containing mostly-unchanging data. @@ -872,7 +873,8 @@ and many others in the same vein from where it will be flushed to physical storage in due time. Many operating systems are not smart about managing this and allow large amounts of dirty data to accumulate before deciding to flush - it all at once, leading to long delays for new I/O requests. + it all at once, causing long delays for new I/O requests until the + flushing finishes. This change attempts to alleviate this problem by explicitly requesting data flushes after a configurable interval. @@ -1209,7 +1211,7 @@ and many others in the same vein 2016-04-08 [34c33a1f0] Add BSD authentication method. --> - Add a bsd authentication + Add a BSD authentication method to allow use of the BSD Authentication service for PostgreSQL client authentication (Marisa Emerson) @@ -1300,6 +1302,16 @@ and many others in the same vein + + Raise the maximum allowed value + of to 24 hours (Simon Riggs) + + + + + @@ -1346,9 +1358,9 @@ and many others in the same vein Making a distinction between these settings is no longer useful, - and is part of a planned future simplification of replication - setup. The old names are still accepted but are converted - internally. + and merging them is a step towards a planned future simplification + of replication setup. The old names are still accepted but are + converted to replica internally. @@ -1375,7 +1387,7 @@ and many others in the same vein --> Allow the server's SSL key file to have group read - access if owned by root (Christoph Berg) + access if it is owned by root (Christoph Berg) @@ -1616,7 +1628,7 @@ XXX this is pending backpatch, may need to remove Previously, such cases failed if the same target column was mentioned more than once, e.g., INSERT INTO tab (x[1], - x[2]) VALUES .... + x[2]) VALUES (...). @@ -1797,9 +1809,9 @@ XXX this is pending backpatch, may need to remove 2016-03-23 [473b93287] Support CREATE ACCESS METHOD --> - Introduce CREATE ACCESS METHOD to allow extensions - to create index access methods (Alexander Korotkov, Petr - Jelínek) + Introduce CREATE + ACCESS METHOD to allow extensions to create index access + methods (Alexander Korotkov, Petr Jelínek) @@ -1912,7 +1924,7 @@ XXX this is pending backpatch, may need to remove Formerly, many security-sensitive functions contained hard-wired checks that would throw an error if they were called by a - non-superuser role. This forced the use of superuser roles for + non-superuser. This forced the use of superuser roles for some relatively pedestrian tasks. The hard-wired error checks are now gone in favor of making initdb revoke the default public EXECUTE privilege on these functions. @@ -1931,6 +1943,11 @@ XXX this is pending backpatch, may need to remove that can be used to grant access to what were previously superuser-only functions (Stephen Frost) + + + Currently the only such role is pg_signal_backend, + but more are expected to be added in future. + @@ -2211,7 +2228,7 @@ XXX this is pending backpatch, may need to remove Allow ts_stat() and tsvector_update_trigger() to operate on values that are of types binary-compatible with the - expected argument type, not only that argument type; for example + expected argument type, not just exactly that type; for example allow citext where text is expected (Teodor Sigaev) @@ -2623,10 +2640,26 @@ This commit is also listed under psql and PL/pgSQL + + Allow pg_dump to dump non-extension-owned objects + that are within an extension-owned schema + (Martín Marqués) + + + + Previously such objects were ignored because they were mistakenly + assumed to belong to the extension owning their schema. + + + + + - In pg_dump, include the table name in object + In pg_dump output, include the table name in object tags for object types that are only uniquely named per-table (for example, triggers) (Peter Eisentraut) @@ -2912,6 +2945,7 @@ This commit is also listed under libpq and PL/pgSQL Allow changing the selection probabilities (weights) for scripts @@ -3011,6 +3045,7 @@ This commit is also listed under libpq and PL/pgSQL Speed up initdb by using just one @@ -3420,6 +3455,16 @@ This commit is also listed under libpq and PL/pgSQL + + + + Support OpenSSL 1.1.0 (Andreas Karlsson, Heikki Linnakangas) + + + -- 2.40.0