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>

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to