From a3f42e85464c4e6ed87a74d8903923e2bd734e0c Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 18 Jun 2016 18:05:27 -0400 Subject: [PATCH] Update 9.6 release notes through today. --- doc/src/sgml/release-9.6.sgml | 29 ++++++++++++++++++++++++----- 1 file changed, 24 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/release-9.6.sgml b/doc/src/sgml/release-9.6.sgml index a14545d5d8..74b5bcaa50 100644 --- a/doc/src/sgml/release-9.6.sgml +++ b/doc/src/sgml/release-9.6.sgml @@ -7,7 +7,7 @@ Release Date 2016-??-?? - Current as of 2016-05-08 (commit 6f69b9639) + Current as of 2016-06-18 (commit 100340e2d) @@ -136,6 +136,8 @@ 2016-04-05 [11c8669c0] Add parallel query support functions for assorted aggreg 2016-04-08 [25fe8b5f1] Add a 'parallel_degree' reloption. 2016-04-27 [59eb55127] Fix EXPLAIN VERBOSE output for parallel aggregate. +2016-06-09 [c9ce4a1c6] Eliminate "parallel degree" terminology. +2016-06-16 [75be66464] Invent min_parallel_relation_size GUC to replace a hard- --> Parallel queries (Robert Haas, Amit Kapila, David Rowley, many others) @@ -155,8 +157,9 @@ configuration parameters , , - , and - . + , + , and + . @@ -255,6 +258,7 @@ 2016-03-08 [77a1d1e79] Department of second thoughts: remove PD_ALL_FROZEN. 2016-03-10 [fd31cd265] Don't vacuum all-frozen pages. 2016-03-11 [7087166a8] pg_upgrade: Convert old visibility map format to new for +2016-06-17 [ede62e56f] Add VACUUM (DISABLE_PAGE_SKIPPING) for emergencies. --> Avoid re-vacuuming pages containing only frozen tuples @@ -269,6 +273,13 @@ transaction wraparound prevention. This should greatly reduce the cost of maintaining large tables containing mostly-unchanging data. + + + If necessary, vacuum can be forced to process all-frozen pages + using its new DISABLE_PAGE_SKIPPING option. This + should never be needed normally, but it might help for example + in recovering from visibility-map corruption. + @@ -349,6 +360,7 @@ 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. +2016-06-10 [4bc0f165c] Change default of backend_flush_after GUC to 0 (disabled --> Where feasible, trigger kernel writeback after a configurable number @@ -446,14 +458,16 @@ - Use foreign key relationships to infer selectivity for multi-column + Use foreign key relationships to infer selectivity for join predicates (Tomas Vondra, David Rowley) - If a table t has a multi-column foreign key restriction, + If a table t has a foreign key restriction, say (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 @@ -2044,6 +2058,7 @@ This commit is also listed under libpq and psql Extend PL/Python's error-reporting and message-reporting functions to @@ -2366,6 +2381,7 @@ This commit is also listed under psql and PL/pgSQL Improve the headers output by the \watch command @@ -2376,6 +2392,8 @@ This commit is also listed under psql and PL/pgSQL Include the \pset title string if one has been set, and shorten the prefabricated part of the header to be timestamp (every Ns). + Also, the timestamp format now obeys psql's locale + environment. @@ -3268,6 +3286,7 @@ This commit is also listed under libpq and PL/pgSQL Transmit query cancellation requests to the remote server -- 2.40.0