From: Jonathan S. Katz <jkatz@postgresql.org>
To: Bruce Momjian <bruce@momjian.us>
Cc: Michael Banck <michael.banck@credativ.de>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Postgres 11 release notes
Date: Sun, 16 Sep 2018 11:17:02 -0400
Message-ID: <f3f01817-4040-2e03-5afb-c724cd86e17e@postgresql.org> (raw)
In-Reply-To: <20180916151406.GA26796@momjian.us>
References: <20180511150852.GA18510@momjian.us>
<20180912173406.GB2884@nighthawk.caipicrew.dd-dns.de>
<e51e850c-99fa-d4fe-4919-9210e3d5b848@postgresql.org>
<20180916151406.GA26796@momjian.us>
On 9/16/18 11:14 AM, Bruce Momjian wrote:
> On Sat, Sep 15, 2018 at 11:06:04AM -0400, Jonathan Katz wrote:
>> <listitem>
>> <para>
>> - Partitioning by a hash key
>> + Partitioning by a hash key (a.k.a. "hash partitioning")
>
> I question whether a.k.a (also known as) is familiar enough to our
> readers to appear in the releaes notes. I think the "a.k.a." can be
> simply removed.
Fine by me. I've reattached the patches.
Thanks,
Jonathan
Attachments:download all (3 files, .tar.gz)0001-Updates-to-major-improvements-section-of-release-not.patch (text/plain, 3.8K) download
From c0a40e7831b19f75178a45d8db00f5e91d606e33 Mon Sep 17 00:00:00 2001
From: "Jonathan S. Katz" <jonathan.katz@excoventures.com>
Date: Sat, 15 Sep 2018 10:43:44 -0400
Subject: [PATCH 1/2] Updates to major improvements section of release notes.
---
doc/src/sgml/release-11.sgml | 45 ++++++++++++++++++++++++++++++--------------
1 file changed, 31 insertions(+), 14 deletions(-)
diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgmlindex 684d34c091..f81dd929e3 100644--- a/doc/src/sgml/release-11.sgml+++ b/doc/src/sgml/release-11.sgml@@ -6,7 +6,7 @@
<formalpara>
<title>Release date:</title>
- <para>2018-??-?? (CURRENT AS OF 2018-07-30)</para>+ <para>2018-10-?? (CURRENT AS OF 2018-09-20)</para>
</formalpara>
<sect2>
@@ -22,7 +22,7 @@
<listitem>
<para>
- Major improvements to partitioning:+ Improvements to partitioning functionality, including:
<itemizedlist>
<listitem>
<para>
@@ -37,9 +37,8 @@
</listitem>
<listitem>
<para>
- Improved <command>SELECT</command> query performance due to- enhanced partition elimination during query processing and- execution+ Improved <command>SELECT</command> performance from enhanced partition+ elimination strategies during query processing and execution
</para>
</listitem>
<listitem>
@@ -48,29 +47,37 @@
KEY</literal>, indexes, and triggers on partitioned tables
</para>
</listitem>
+ <listitem>+ <para>+ Having a "default" partition for storing data that does not match a+ partition key+ </para>+ </listitem>
</itemizedlist>
</para>
</listitem>
<listitem>
<para>
- Improvements to parallelism:+ Improvements to parallelism, including:
<itemizedlist>
<listitem>
<para>
- Parallelized hash joins+ B-tree indexes can now be built in parallel with+ <command>CREATE INDEX</command>
</para>
</listitem>
<listitem>
<para>
- Parallelized <command>CREATE INDEX</command> for B-tree indexes+ Parallelized <command>CREATE TABLE .. AS</command>,+ <command>CREATE MATERIALIZED VIEW</command>, and certain+ queries using <literal>UNION</literal>
</para>
</listitem>
<listitem>
<para>
- Parallelized <command>CREATE TABLE .. AS</command>,- <command>CREATE MATERIALIZED VIEW</command>, and certain- queries using <literal>UNION</literal>+ Performance improvements for parallelized hash joins and parallelized+ sequential scans
</para>
</listitem>
</itemizedlist>
@@ -79,14 +86,17 @@
<listitem>
<para>
- SQL stored procedures, with support for embedded transactions+ SQL stored procedures that support embedded transactions. Stored+ procedures can be created with <link linkend="sql-createprocedure">+ <command>CREATE PROCEDURE</command></link> and executed with+ <link linkend="sql-call"><command>CALL</command></link>
</para>
</listitem>
<listitem>
<para>
- JIT compilation of some SQL code, including support for fast evaluation- of expressions+ Introduction of <link linkend="jit">just-in-time</link> (JIT) compilation+ during query execution
</para>
</listitem>
@@ -99,6 +109,13 @@
</para>
</listitem>
+ <listitem>+ <para>+ Covering indexes, which can be utilized using the+ <literal>INCLUDE</literal> clause of <command>CREATE INDEX</command>+ </para>+ </listitem>+
<listitem>
<para>
Many other useful performance improvements, including making
--
2.14.3 (Apple Git-98)
0002-Remove-or-modify-placeholders-for-v11-release-notes.patch (text/plain, 2.6K) download
From 5d86d059faa3a85626acdddf8429a197cc787a60 Mon Sep 17 00:00:00 2001
From: "Jonathan S. Katz" <jonathan.katz@excoventures.com>
Date: Sat, 15 Sep 2018 11:01:35 -0400
Subject: [PATCH 2/2] Remove or modify placeholders for v11 release notes.
---
doc/src/sgml/release-11.sgml | 21 ++++++---------------
1 file changed, 6 insertions(+), 15 deletions(-)
diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgmlindex f81dd929e3..700fd02090 100644--- a/doc/src/sgml/release-11.sgml+++ b/doc/src/sgml/release-11.sgml@@ -196,10 +196,6 @@
would be dumped without such specifications if the database locale
and encoding matched the old cluster's defaults.
</para>
-- <para>- DID I GET EVERYTHING?- </para>
</listitem>
<listitem>
@@ -614,8 +610,7 @@
The new command <link linkend="sql-alterindex"><command>ALTER
INDEX ATTACH PARTITION</command></link> allows indexes to be
attached to partitions. This does not behave as a global index
- since the contents are private to each index. WARN WHEN USING- AN EXISTING INDEX?+ since the contents are private to each index.
</para>
</listitem>
@@ -924,7 +919,7 @@ same commits as above
</para>
<para>
- This reduces the likelihood of serialization conflicts. ACCURATE?+ This reduces the likelihood of serialization conflicts.
</para>
</listitem>
@@ -1991,7 +1986,6 @@ same commits as above
<command>CALL</command>s or in nested PL/pgSQL DO and
<command>CALL</command> blocks that only contain other PL/pgSQL
<command>DO</command> and <command>CALL</command> blocks.
- ACCURATE?
</para>
</listitem>
@@ -2414,12 +2408,8 @@ same commits as above
The option <option>--create-slot</option> creates
the named replication slot (<option>--slot</option>)
when the <acronym>WAL</acronym> streaming method
- (<option>--wal-method=stream</option>) is used.- </para>-- <para>- IS IT CLEAR FROM THE DOCS THAT THE REPLICATION SLOT IS NOT- TEMPORARY?+ (<option>--wal-method=stream</option>) is used. The replication slot is+ available until it is explicitly dropped.
</para>
</listitem>
@@ -2915,7 +2905,8 @@ same commits as above
</para>
<para>
- This is useful for KNN-GiST searches. HOW?+ This is useful for KNN-GiST searches when looking for coordinates in+ descending order.
</para>
</listitem>
--
2.14.3 (Apple Git-98)
signature.asc (application/pgp-signature, 832B) download
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, michael.banck@credativ.de, pgsql-hackers@postgresql.org
Subject: Re: Postgres 11 release notes
In-Reply-To: <f3f01817-4040-2e03-5afb-c724cd86e17e@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