From 4aad161c9a6de56ceb470277038d9583e4260425 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 21 May 2018 12:36:59 -0400 Subject: [PATCH] Doc: preliminary list of PG11 major features. This might get bike-shedded a bit later, but it's better than shipping beta1 with no list. Jonathan Katz Discussion: https://postgr.es/m/D73971C5-8277-44F2-95D9-C0B6E46EB55B@postgresql.org --- doc/src/sgml/release-11.sgml | 95 +++++++++++++++++++++++++++++++++++- 1 file changed, 94 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml index 9dd8dff0813..dedeb9d1862 100644 --- a/doc/src/sgml/release-11.sgml +++ b/doc/src/sgml/release-11.sgml @@ -20,7 +20,100 @@ - XXX + + + Major improvements to partitioning: + + + + Partitioning by a hash key + + + + + UPDATE statements that change a partition key + now move affected rows to the appropriate partitions + + + + + Improved SELECT query performance due to + enhanced partition elimination during query processing and + execution + + + + + Support for PRIMARY KEY, FOREIGN + KEY, indexes, and triggers on partitioned tables + + + + + + + + + Improvements to parallelism: + + + + Parallelized hash joins + + + + + Parallelized CREATE INDEX for B-tree indexes + + + + + Parallelized CREATE TABLE .. AS, + CREATE MATERIALIZED VIEW, and certain + queries using UNION + + + + + + + + + SQL stored procedures, with support for embedded transactions + + + + + + JIT compilation of some SQL code, including support for fast evaluation + of expressions + + + + + + Window functions now support all options shown in the SQL:2011 + standard, including RANGE distance + PRECEDING/FOLLOWING, GROUPS mode, and + frame exclusion options + + + + + + Channel binding for SCRAM authentication, to prevent potential + man-in-the-middle attacks on database connections + + + + + + Many other useful performance improvements, including making + ALTER TABLE .. ADD COLUMN with a + non-null column default faster + + + -- 2.39.5