fine-tune-jonathan-justin.patch
text/x-diff
Filename: fine-tune-jonathan-justin.patch
Type: text/x-diff
Part: 0
Message:
Re: fine tune v11 release notes
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: unified
| File | + | − |
|---|---|---|
| doc/src/sgml/release-11.sgml | 53 | 48 |
diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml
index 5df6a41..5594d43 100644
--- a/doc/src/sgml/release-11.sgml
+++ b/doc/src/sgml/release-11.sgml
@@ -49,8 +49,8 @@
</listitem>
<listitem>
<para>
- Having a "default" partition for storing data that does not match any
- of the remaining partitions
+ Allow creation of a "default" partition for storing rows which are
+ excluded by bounds of all other partitions.
</para>
</listitem>
</itemizedlist>
@@ -63,7 +63,7 @@
<itemizedlist>
<listitem>
<para>
- B-tree indexes can now be built in parallel with
+ A B-tree index can now be built in parallel with
<command>CREATE INDEX</command>
</para>
</listitem>
@@ -118,9 +118,9 @@
<listitem>
<para>
- Many other useful performance improvements, including a significant
- speedup to the <command>ALTER TABLE .. ADD COLUMN</command> with a
- non-null column default as it no longer rewrites the full table.
+ Many other useful performance improvements, including the ability to avoid
+ a table rewrite when using <command>ALTER TABLE .. ADD COLUMN</command>
+ with a non-null column default.
</para>
</listitem>
@@ -591,8 +591,8 @@
-->
<para>
- Allow <literal>UNIQUE</literal> indexes on partitioned tables if
- the partition key guarantees uniqueness (Álvaro Herrera,
+ Allow <literal>UNIQUE</literal> indexes on partitioned tables when
+ the partition key is included in the index key (Álvaro Herrera,
Amit Langote)
</para>
</listitem>
@@ -603,15 +603,18 @@
-->
<para>
- Allow indexes on a partitioned table to be automatically created
- in any child partitions (Álvaro Herrera)
+ Support indexes on partitioned tables (Álvaro Herrera)
+ </para>
+
+ <para>
+ This is not a global index, but rather a mechanism to create indexes on
+ on each partition of a partitioned table.
</para>
<para>
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.
+ INDEX ATTACH PARTITION</command></link> allows an index on a partition
+ to be inherited by the index on its partitioned tables.
</para>
</listitem>
@@ -654,7 +657,7 @@
<para>
Creation of a trigger on partitioned tables automatically creates
- triggers on all existing and future partitions.
+ triggers on all existing and any future partitions.
This also allows deferred unique constraints on partitioned tables.
</para>
</listitem>
@@ -667,14 +670,16 @@
-->
<para>
- Allow partitioned tables to be joined directly for equality joins with
- identically partitioned child tables. (Ashutosh Bapat)
+ Allow joins between partitioned tables to be performed directly
+ on partitions. (Ashutosh Bapat)
</para>
<para>
- This feature is disabled by default
- but can be enabled by changing <link
- linkend="guc-enable-partitionwise-join"><varname>enable_partitionwise_join</varname></link>.
+ This applies to equality joins between partitioned tables whose
+ partitions have exactly the same partition bounds.
+ This feature is disabled by default but can be enabled by changing
+ <link linkend="guc-enable-partitionwise-join"><varname>enable_partitionwise_join</varname></link>.
+
</para>
</listitem>
@@ -685,14 +690,13 @@
-->
<para>
- Perform aggregation on each partition, and then merge the results
- (Jeevan Chalke, Ashutosh Bapat, Robert Haas)
+ Allow aggregate functions on partitioned tables to be evaluated
+ directly on partitions. (Jeevan Chalke, Ashutosh Bapat, Robert Haas)
</para>
<para>
- This feature is disabled by default
- but can be enabled by changing <link
- linkend="guc-enable-partitionwise-aggregate"><varname>enable_partitionwise_aggregate</varname></link>.
+ This feature is disabled by default but can be enabled by changing
+ <link linkend="guc-enable-partitionwise-aggregate"><varname>enable_partitionwise_aggregate</varname></link>.
</para>
</listitem>
@@ -763,7 +767,7 @@ same commits as above
-->
<para>
- Allow partition scans to more efficiently use parallel workers
+ Allow partition scans to use parallel workers
(Amit Khandekar, Robert Haas, Amul Sul)
</para>
</listitem>
@@ -873,8 +877,9 @@ same commits as above
</para>
<para>
- This is also useful for including columns that don't have btree
- support.
+ This is also useful for including columns in a unique or
+ exclusion constraint which shouldn't participate in uniqueness, or
+ for including columns that don't have btree support.
</para>
</listitem>
@@ -886,8 +891,8 @@ same commits as above
<para>
Remember the highest btree index page to optimize future
- monotonically increasing index additions (Pavan Deolasee, Peter
- Geoghegan)
+ insertions of values for the case that those values are increasing
+ monotonically (Pavan Deolasee, Peter Geoghegan)
</para>
</listitem>
@@ -1008,8 +1013,8 @@ same commits as above
chosen based on their frequency compared to all column
values. Now, <acronym>MCV</acronym> are chosen based on their
significance compared to the non-<acronym>MCV</acronym> values.
- This improves the statistics for uniform (fewer) and non-uniform
- (more) distributions.
+ This allows improved estimates for both uniform and non-uniform
+ distributions.
</para>
</listitem>
@@ -1051,8 +1056,8 @@ same commits as above
-->
<para>
- Improve row count optimizer estimates for <literal>EXISTS</literal>
- and <literal>NOT EXISTS</literal> queries (Tom Lane)
+ Improve row count estimates for <literal>EXISTS</literal> and
+ <literal>NOT EXISTS</literal> queries (Tom Lane)
</para>
</listitem>
@@ -1095,7 +1100,7 @@ same commits as above
<para>
This feature requires <application>LLVM</application> to be
- available. Even in builds that include <application>LLVM</application>,
+ available. Even in builds that include <application>LLVM</application>,
<acronym>JIT</acronym> compilation is disabled by default.
</para>
</listitem>
@@ -1488,11 +1493,11 @@ same commits as above
<para>
Allow server options related to memory and file sizes to be
- specified as number of bytes (Beena Emerson)
+ specified in units of bytes (Beena Emerson)
</para>
<para>
- The new unit is "B". This is in addition to "kB", "MB", "GB"
+ The new suffix is "B". This is in addition to "kB", "MB", "GB"
and "TB".
</para>
@@ -1528,12 +1533,12 @@ same commits as above
-->
<para>
- Retain <acronym>WAL</acronym> for a single checkpoint, only.
+ Retain <acronym>WAL</acronym> spanning a single checkpoint, only.
(Simon Riggs)
</para>
<para>
- Previously, <acronym>WAL</acronym> was retained for two checkpoints.
+ Previously, <acronym>WAL</acronym> spanning two checkpoints was retained.
</para>
</listitem>
@@ -1704,9 +1709,8 @@ same commits as above
-->
<para>
- Allow <command>ALTER TABLE</command> to add a column with
- a non-null default without a table rewrite (Andrew Dunstan,
- Serge Rielau)
+ When adding a column with a non-null default, avoid rewriting the table.
+ (Andrew Dunstan, Serge Rielau)
</para>
</listitem>
@@ -1750,6 +1754,7 @@ same commits as above
</para>
<para>
+DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
Also, if any table mentioned in <command>VACUUM</command> uses
a column list, then the <command>ANALYZE</command> keyword must be
supplied; previously, <command>ANALYZE</command> was implied in
@@ -2028,7 +2033,7 @@ same commits as above
<para>
Add extension <application>jsonb_plpython</application> to
- transform <type>JSONB </type>to/from PL/Python types (Anthony
+ transform <type>JSONB</type> to/from PL/Python types (Anthony
Bykov)
</para>
</listitem>
@@ -2040,7 +2045,7 @@ same commits as above
<para>
Add extension <application>jsonb_plperl</application> to transform
- <type>JSONB </type>to/from PL/Perl types (Anthony Bykov)
+ <type>JSONB</type> to/from PL/Perl types (Anthony Bykov)
</para>
</listitem>
@@ -2119,7 +2124,7 @@ same commits as above
<para>
Add <application>psql</application> command \gdesc to display
- the column names and types of the query output (Pavel Stehule)
+ the names and types of the columns in query results (Pavel Stehule)
</para>
</listitem>
@@ -2152,7 +2157,7 @@ same commits as above
</para>
<para>
- Specifically , the syntax <literal>:{?variable_name}</literal>
+ Specifically, the syntax <literal>:{?variable_name}</literal>
allows a variable's existence to be tested in an \if statement.
</para>
</listitem>
@@ -2288,7 +2293,7 @@ same commits as above
-->
<para>
- Add <application>pgbench</application> expressions support for
+ Add <application>pgbench</application> expression support for
NULLs, booleans, and some functions and operators (Fabien Coelho)
</para>
</listitem>
@@ -2356,7 +2361,7 @@ same commits as above
<para>
Allow <application>pgbench</application> to do exponentiation
- with <function>pow()</function> and <function>power()</function>
+ with <function>pow()</function> and <function>power()</function>
(Raúl Marín Rodríguez)
</para>
</listitem>
@@ -2789,7 +2794,7 @@ same commits as above
<para>
Make the computation of
<structname>pg_class</structname>.<structfield>reltuples</structfield>
- by VACUUM consistent with computation by ANALYZE (Tomas Vondra)
+ by VACUUM consistent with the computation by ANALYZE (Tomas Vondra)
</para>
</listitem>