From 8f850f2cad2df69a14fd1ad1b360cf004f17e8db Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 13 Oct 2018 21:39:20 -0400 Subject: [PATCH] Doc: still further copy-editing for v11 release notes. Justin Pryzby and myself. Discussion: https://postgr.es/m/20181006134249.GD871@telsasoft.com --- doc/src/sgml/release-11.sgml | 48 ++++++++++++++++++++---------------- 1 file changed, 27 insertions(+), 21 deletions(-) diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml index 188222fb54..87409ac58a 100644 --- a/doc/src/sgml/release-11.sgml +++ b/doc/src/sgml/release-11.sgml @@ -65,7 +65,7 @@ CREATE INDEX can now use parallel processing - while building B-tree indexes + while building a B-tree index @@ -117,9 +117,9 @@ - Many other useful performance improvements, including a significant - speedup to ALTER TABLE ... ADD COLUMN with a - non-null column default, as it no longer rewrites the table data + Many other useful performance improvements, including the ability to + avoid a table rewrite for ALTER TABLE ... ADD COLUMN + with a non-null column default @@ -570,32 +570,37 @@ - Allow UNIQUE indexes on partitioned tables if - the partition key is part of the index (Álvaro Herrera, + Support indexes on partitioned tables (Álvaro Herrera, Amit Langote) - - - + + An index on a partitioned table is not a physical + index across the whole partitioned table, but rather a template for + automatically creating similar indexes on each partition of the + table. + - Allow indexes on a partitioned table to be automatically created - in new child partitions (Álvaro Herrera) + If the partition key is part of the index's column set, a + partitioned index may be declared UNIQUE. + It will represent a valid uniqueness constraint across the whole + partitioned table, even though each physical index only enforces + uniqueness within its own partition. The new command ALTER - INDEX ATTACH PARTITION 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 causes an existing index on + a partition to be associated with a matching index template for its + partitioned table. This provides flexibility in setting up a new + partitioned index for an existing partitioned table. @@ -733,7 +738,8 @@ --> - Perform aggregation on each partition, and then merge the results + Allow aggregate functions on partitioned tables to be evaluated + separately for each partition, subsequently merging the results (Jeevan Chalke, Ashutosh Bapat, Robert Haas) @@ -1564,11 +1570,11 @@ same commits as above Allow server options related to memory and file sizes to be - specified as a number of bytes (Beena Emerson) + specified in units of bytes (Beena Emerson) - The new unit is B. This is in addition to the + The new unit suffix is B. This is in addition to the existing units kB, MB, GB and TB. @@ -2199,8 +2205,8 @@ same commits as above Add psql command \gdesc - to display the column names and types of the query output (Pavel - Stehule) + to display the names and types of the columns in a query result + (Pavel Stehule) -- 2.40.0