From: Jonathan S. Katz <jkatz@postgresql.org>
To: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Postgres 11 release notes
Date: Fri, 18 May 2018 11:56:22 -0400
Message-ID: <D73971C5-8277-44F2-95D9-C0B6E46EB55B@postgresql.org> (raw)
In-Reply-To: <20180511150852.GA18510@momjian.us>
References: <20180511150852.GA18510@momjian.us>
> 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
Attachments:pg11features.diff (application/octet-stream, 3.1K) downloaddiff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgmlindex 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 <distance> 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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-www@postgresql.org
Cc: jkatz@postgresql.org, bruce@momjian.us, pgsql-hackers@postgresql.org
Subject: Re: Postgres 11 release notes
In-Reply-To: <D73971C5-8277-44F2-95D9-C0B6E46EB55B@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox