Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1fJhkC-0000iL-CF
	for pgsql-hackers@arkaria.postgresql.org; Fri, 18 May 2018 15:56:36 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1fJhkB-0001P6-9B
	for pgsql-hackers@arkaria.postgresql.org; Fri, 18 May 2018 15:56:35 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <jkatz@postgresql.org>)
	id 1fJhkA-0001Ow-V2
	for pgsql-hackers@lists.postgresql.org; Fri, 18 May 2018 15:56:35 +0000
Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <jkatz@postgresql.org>)
	id 1fJhk8-0003qs-6U
	for pgsql-hackers@postgresql.org; Fri, 18 May 2018 15:56:33 +0000
Received: from [2600:8807:c240:c600:249d:8cb8:69fb:c345]
	by meldrar.postgresql.org with esmtpsa
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <jkatz@postgresql.org>)
	id 1fJhk2-00005n-Np; Fri, 18 May 2018 15:56:29 +0000
From: "Jonathan S. Katz" <jkatz@postgresql.org>
Message-Id: <D73971C5-8277-44F2-95D9-C0B6E46EB55B@postgresql.org>
Content-Type: multipart/mixed;
 boundary="Apple-Mail=_334BB169-A709-4807-85F3-EF2728153F20"
Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\))
Subject: Re: Postgres 11 release notes
Date: Fri, 18 May 2018 11:56:22 -0400
In-Reply-To: <20180511150852.GA18510@momjian.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
To: Bruce Momjian <bruce@momjian.us>
References: <20180511150852.GA18510@momjian.us>
X-Mailer: Apple Mail (2.3273)
X-Host-Lookup-Failed: Reverse DNS lookup failed for
 2600:8807:c240:c600:249d:8cb8:69fb:c345 (failed)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk


--Apple-Mail=_334BB169-A709-4807-85F3-EF2728153F20
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=us-ascii


> On May 11, 2018, at 11:08 AM, Bruce Momjian <bruce@momjian.us> wrote:
> 
> I have committed the first draft of the Postgres 11 release notes.  I
> will add more markup soon.  You can view the most current version here:
> 
> 	http://momjian.us/pgsql_docs/release-11.html
> 
> I expect a torrent of feedback.  ;-)

Per feedback from many asynchronous threads, attached is the proposed
patch for the list of major features. I also expect a torrent of feedback. I
will have a corresponding press release for Beta 1 in the very near future.

This being my first doc patch proposal, I tried to follow the formatting I
saw in the existing SGML. Please let me know if I can make improvements.

Thanks,

Jonathan



--Apple-Mail=_334BB169-A709-4807-85F3-EF2728153F20
Content-Disposition: attachment;
	filename=pg11features.diff
Content-Type: application/octet-stream;
	x-unix-mode=0644;
	name="pg11features.diff"
Content-Transfer-Encoding: 7bit

diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml
index 9dd8dff081..6adc312871 100644
--- a/doc/src/sgml/release-11.sgml
+++ b/doc/src/sgml/release-11.sgml
@@ -20,7 +20,104 @@
 
    <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 issued to 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
+                </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 with <literal>UNION</literal>
+                </para>
+             </listitem>
+
+            </itemizedlist>
+        </para>
+    </listitem>
+
+    <listitem>
+        <para>
+         SQL stored procedures with support for embedded transactions
+        </para>
+    </listitem>
+
+    <listitem>
+        <para>
+         JIT compilation introduced, 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 &lt;distance&gt; 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
+       </para>
+    </listitem>
+
+    <listitem>
+       <para>
+        Many other useful performance improvements, including fast
+        <command>ALTER TABLE .. ADD COLUMN</command> with a
+        non-<literal>NULL</literal> default
+       </para>
+    </listitem>
    </itemizedlist>
 
    <para>

--Apple-Mail=_334BB169-A709-4807-85F3-EF2728153F20--