diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 7bd1da3..e079d23 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -673,7 +673,7 @@ Indexes:
valid, once all partitions acquire the index.) Note, however, that
any partition that is created in the future using
CREATE TABLE ... PARTITION OF will automatically
- contain the index regardless of whether ONLY was
+ contain the index regardless of ONLY being
specified.
diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml
index a945502..bb7d4c5 100644
--- a/doc/src/sgml/release-11.sgml
+++ b/doc/src/sgml/release-11.sgml
@@ -49,7 +49,7 @@
- Allow creation of a "default" partition for storing rows which are
+ Allow creation of a "default" partition for storing rows which are
excluded by bounds of all other partitions.
@@ -591,8 +591,9 @@
-->
- Allow UNIQUE indexes on partitioned tables if
- the partition key is included in the index (Álvaro Herrera, Amit Langote)
+ Allow UNIQUE indexes on partitioned tables when
+ the partition key is included in the index key (Álvaro Herrera,
+ Amit Langote)
@@ -606,14 +607,14 @@
- This is not a global index, but rather a mechanism to create indexes on
- on each partition of a partitioned table.
+ This is not a global index, but rather a mechanism to create indexes on
+ on each partition of a partitioned table.
The new command ALTER
- INDEX ATTACH PARTITION allows an index on a partition
- to be inherited by the index on its partitioned tables.
+ INDEX ATTACH PARTITION allows an index on a partition
+ to be inherited by the index on its partitioned tables.
@@ -656,7 +657,7 @@
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.
@@ -669,14 +670,16 @@
-->
- 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)
- This feature is disabled by default
- but can be enabled by changing enable_partitionwise_join.
+ 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
+ enable_partitionwise_join.
+
@@ -687,14 +690,13 @@
-->
- Allow first performing aggregate functions on each partition and then
- merging 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)
- This feature is disabled by default
- but can be enabled by changing enable_partitionwise_aggregate.
+ This feature is disabled by default but can be enabled by changing
+ enable_partitionwise_aggregate.
@@ -875,8 +877,9 @@ same commits as above
- 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.
@@ -1097,7 +1100,8 @@ same commits as above
This feature requires LLVM to be
- available, and it is currently disabled by default.
+ available. Even in builds that include LLVM,
+ JIT compilation is disabled by default.
@@ -1493,7 +1497,7 @@ same commits as above
- The new unit suffix 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".
@@ -1529,12 +1533,12 @@ same commits as above
-->
- Retain WAL for a single checkpoint, only.
+ Retain WAL spanning a single checkpoint, only.
(Simon Riggs)
- Previously, WAL was retained for two checkpoints.
+ Previously, WAL spanning two checkpoints was retained.
@@ -1626,7 +1630,6 @@ same commits as above
This allows efficient advancing of replication slots when the
-????
contents do not need to be consumed. This is performed by
pg_replication_slot_advance().
@@ -1706,8 +1709,8 @@ same commits as above
-->
- Allow ALTER TABLE to avoid a table rewrite when
- adding a column with a non-null default (Andrew Dunstan, Serge Rielau)
+ When adding a column with a non-null default, avoid rewriting the table.
+ (Andrew Dunstan, Serge Rielau)
@@ -1970,7 +1973,7 @@ DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
PROCEDURE command and invoked via CALL. The new
ALTER/DROP ROUTINE commands
- allow altering/dropping of procedures, functions, and aggregates.
+ allow for altering/dropping of procedures, functions, and aggregates.
@@ -2030,7 +2033,7 @@ DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
Add extension jsonb_plpython to
- transform JSONB to/from PL/Python types (Anthony
+ transform JSONB to/from PL/Python types (Anthony
Bykov)
@@ -2042,7 +2045,7 @@ DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
Add extension jsonb_plperl to transform
- JSONB to/from PL/Perl types (Anthony Bykov)
+ JSONB to/from PL/Perl types (Anthony Bykov)
@@ -2121,7 +2124,7 @@ DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
Add psql 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)
@@ -2154,7 +2157,7 @@ DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
- Specifically , the syntax :{?variable_name}
+ Specifically, the syntax :{?variable_name}
allows a variable's existence to be tested in an \if statement.
@@ -2290,7 +2293,7 @@ DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
-->
- Add pgbench expressions support for
+ Add pgbench expression support for
NULLs, booleans, and some functions and operators (Fabien Coelho)
@@ -2358,7 +2361,7 @@ DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
Allow pgbench to do exponentiation
- with pow() and power()
+ with pow() and power()
(Raúl Marín Rodríguez)
@@ -2791,7 +2794,7 @@ DOES THIS NEED TO BE IN "COMPATIBILITY NOTES"?
Make the computation of
pg_class.reltuples
- by VACUUM consistent with computation by ANALYZE (Tomas Vondra)
+ by VACUUM consistent with the computation by ANALYZE (Tomas Vondra)