On 9/6/19 9:56 AM, Tom Lane wrote: > Peter Eisentraut <peter.eisentr...@2ndquadrant.com> writes: >> On 2019-09-05 22:27, Jonathan S. Katz wrote: >>> PostgreSQL 12 Beta 4 will be released on 2019-09-12. Please make sure >>> that fixes for bugs and other open items[1] are committed by the end of >>> the weekend. > >> Could we get the list of major items in the release notes done by then? > > I'll try to make a pass over the notes today, and incorporate text for > that from Jonathan's draft press release.
If it helps, I already made said pass (attached) where I tried to make them match the tone of the release notes. Also, attached is a separate patch that has an example for PG_COLORS. Thanks, Jonathan
diff --git a/doc/src/sgml/release-12.sgml b/doc/src/sgml/release-12.sgml
index 8b668ade0f..e05aacaf3c 100644
--- a/doc/src/sgml/release-12.sgml
+++ b/doc/src/sgml/release-12.sgml
@@ -2479,7 +2479,9 @@ Author: Peter Eisentraut <pe...@eisentraut.org>
<para>
This is enabled with by setting environment variable
- <envar>PG_COLORS</envar>. EXAMPLE?
+ <envar>PG_COLORS</envar> using ANSI escape codes for colors. For
example,
+ the default setting is
+ <literal>PG_COLORS="error=01;31:warning=01;35:locus=01"</literal>
</para>
</listitem>
diff --git a/doc/src/sgml/release-12.sgml b/doc/src/sgml/release-12.sgml
index 8b668ade0f..62ab9fb21f 100644
--- a/doc/src/sgml/release-12.sgml
+++ b/doc/src/sgml/release-12.sgml
@@ -21,7 +21,125 @@
<itemizedlist>
<listitem>
- <para>big item</para>
+ <para>
+ General performance improvements, including:
+ <itemizedlist>
+ <listitem>
+ <para>
+ Optimizations to space utilization and read/write performance for
+ B-tree indexes that are frequently modified
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Partitioning enhancements that include query performance improvements
+ on tables with thousands of partitions, improved performance with
+ <xref linkend="sql-insert"/> and <xref linkend="sql-copy"/>, and the
+ ability to execute <link linkend="sql-altertable">
+ <command>ATTACH PARTITION</command></link> without blocking queries
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <link linkend="queries-with">Common table expressions</link>
+ (<acronym>CTE</acronym>) can now be automatically inlined
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Reduction of <acronym>WAL</acronym> overhead of
+ <link linkend="gist">GiST</link>, <link linkend="gin">GIN</link>, and
+ <link linkend="spgist">SP-GiST</link> indexes and added support
+ for covering indexes via the <link linkend="sql-createindex">
+ <literal>INCLUDE</literal></link> clause for
+ <link linkend="gist">GiST</link> indexes
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <xref linkend="sql-createstatistics"/> now supports most-common value
+ (MCV) statistics to support improved query plans for columns that are
+ nonuniformly distributed
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Enhancements to administrative functionality, including:
+ <itemizedlist>
+ <listitem>
+ <para>
+ Rebuild an index without blocking writes to a table with the
+ <link linkend="sql-reindex">
+ <command>REINDEX CONCURRENTLY</command></link> command
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <xref linkend="app-pgchecksums"/> can enable/disable page checksums,
+ used for detecting data corruption, in an offline cluster
+ </para>
+ <para>
+ Progress reporting statistics for <xref linkend="sql-createindex"/>,
+ <xref linkend="sql-reindex"/>, <xref linkend="sql-cluster"/>,
+ <link linkend="sql-vacuum">VACUUM FULL</link>, and
+ <xref linkend="app-pgchecksums"/>
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Support for the <acronym>SQL/JSON</acronym>
+ <link linkend="functions-json-processing-table">path</link> language
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Stored <link linkend="sql-createtable">generated columns</link>
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Nondeterministic ICU
+ <link linkend="sql-createcollation">collations</link> that enable
+ case-insensitive and accent-insensitive ordering
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ New authentication features, including:
+ <itemizedlist>
+ <listitem>
+ <para>
+ Client and server-side encryption for authentication over the
+ <link linkend="gssapi-auth"><acronym>GSSAPI</acronym></link>
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Discovery of LDAP servers if <productname>PostgreSQL</productname> is
+ built with <productname>OpenLDAP</productname>
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ Support multifactor authentication with the <link linkend="auth-cert">
+ <literal>clientcert=verify-full</literal></link> option when combined
+ with an additional authentication method in
+ <filename>pg_hba.conf</filename>
+ </para>
+ </listitem>
+ </itemizedlist>
+ </para>
</listitem>
</itemizedlist>
signature.asc
Description: OpenPGP digital signature
