diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2018-05-21 12:36:59 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2018-05-21 12:37:12 -0400 |
| commit | 4aad161c9a6de56ceb470277038d9583e4260425 (patch) | |
| tree | 03e47f556d84f1253eeea0dcedb14bb485e3570f | |
| parent | 917a68f010eb4c7e91b11ae1abe229cad722f675 (diff) | |
| download | postgresql-4aad161c9a6de56ceb470277038d9583e4260425.tar.gz postgresql-4aad161c9a6de56ceb470277038d9583e4260425.zip | |
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
| -rw-r--r-- | doc/src/sgml/release-11.sgml | 95 |
1 files changed, 94 insertions, 1 deletions
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 @@ <itemizedlist> - <listitem><para>XXX</para></listitem> + <listitem> + <para> + Major improvements to partitioning: + <itemizedlist> + <listitem> + <para> + Partitioning by a hash key + </para> + </listitem> + <listitem> + <para> + <command>UPDATE</command> statements that change a partition key + now move affected rows to the appropriate partitions + </para> + </listitem> + <listitem> + <para> + Improved <command>SELECT</command> query performance due to + enhanced partition elimination during query processing and + execution + </para> + </listitem> + <listitem> + <para> + Support for <literal>PRIMARY KEY</literal>, <literal>FOREIGN + KEY</literal>, indexes, and triggers on partitioned tables + </para> + </listitem> + </itemizedlist> + </para> + </listitem> + + <listitem> + <para> + Improvements to parallelism: + <itemizedlist> + <listitem> + <para> + Parallelized hash joins + </para> + </listitem> + <listitem> + <para> + Parallelized <command>CREATE INDEX</command> for B-tree indexes + </para> + </listitem> + <listitem> + <para> + Parallelized <command>CREATE TABLE .. AS</command>, + <command>CREATE MATERIALIZED VIEW</command>, and certain + queries using <literal>UNION</literal> + </para> + </listitem> + </itemizedlist> + </para> + </listitem> + + <listitem> + <para> + SQL stored procedures, with support for embedded transactions + </para> + </listitem> + + <listitem> + <para> + JIT compilation of some SQL code, including support for fast evaluation + of expressions + </para> + </listitem> + + <listitem> + <para> + Window functions now support all options shown in the SQL:2011 + standard, including <literal>RANGE <replaceable>distance</replaceable> + PRECEDING/FOLLOWING</literal>, <literal>GROUPS</literal> mode, and + frame exclusion options + </para> + </listitem> + + <listitem> + <para> + Channel binding for SCRAM authentication, to prevent potential + man-in-the-middle attacks on database connections + </para> + </listitem> + + <listitem> + <para> + Many other useful performance improvements, including making + <command>ALTER TABLE .. ADD COLUMN</command> with a + non-null column default faster + </para> + </listitem> + </itemizedlist> <para> |