65
65
<listitem>
66
66
<para>
67
67
<command>CREATE INDEX</command> can now use parallel processing
68
- while building B-tree indexes
68
+ while building a B-tree index
69
69
</para>
70
70
</listitem>
71
71
<listitem>
117
117
118
118
<listitem>
119
119
<para>
120
- Many other useful performance improvements, including a significant
121
- speedup to <command>ALTER TABLE ... ADD COLUMN</command> with a
122
- non-null column default, as it no longer rewrites the table data
120
+ Many other useful performance improvements, including the ability to
121
+ avoid a table rewrite for <command>ALTER TABLE ... ADD COLUMN</command>
122
+ with a non-null column default
123
123
</para>
124
124
</listitem>
125
125
570
570
571
571
<listitem>
572
572
<!--
573
+ 2018-01-19 [8b08f7d48] Local partitioned indexes
573
574
2018-02-19 [eb7ed3f30] Allow UNIQUE indexes on partitioned tables
574
575
2018-03-26 [555ee77a9] Handle INSERT .. ON CONFLICT with partitioned tables
575
576
-->
576
577
577
578
<para>
578
- Allow <literal>UNIQUE</literal> indexes on partitioned tables if
579
- the partition key is part of the index (Álvaro Herrera,
579
+ Support indexes on partitioned tables (Álvaro Herrera,
580
580
Amit Langote)
581
581
</para>
582
- </listitem>
583
582
584
- <listitem>
585
- <!--
586
- 2018-01-19 [8b08f7d48] Local partitioned indexes
587
- -->
583
+ <para>
584
+ An <quote>index</quote> on a partitioned table is not a physical
585
+ index across the whole partitioned table, but rather a template for
586
+ automatically creating similar indexes on each partition of the
587
+ table.
588
+ </para>
588
589
589
590
<para>
590
- Allow indexes on a partitioned table to be automatically created
591
- in new child partitions (Álvaro Herrera)
591
+ If the partition key is part of the index's column set, a
592
+ partitioned index may be declared <literal>UNIQUE</literal>.
593
+ It will represent a valid uniqueness constraint across the whole
594
+ partitioned table, even though each physical index only enforces
595
+ uniqueness within its own partition.
592
596
</para>
593
597
594
598
<para>
595
599
The new command <link linkend="sql-alterindex"><command>ALTER
596
- INDEX ATTACH PARTITION</command></link> allows indexes to be
597
- attached to partitions. This does not behave as a global index
598
- since the contents are private to each index.
600
+ INDEX ATTACH PARTITION</command></link> causes an existing index on
601
+ a partition to be associated with a matching index template for its
602
+ partitioned table. This provides flexibility in setting up a new
603
+ partitioned index for an existing partitioned table.
599
604
</para>
600
605
</listitem>
601
606
733
738
-->
734
739
735
740
<para>
736
- Perform aggregation on each partition, and then merge the results
741
+ Allow aggregate functions on partitioned tables to be evaluated
742
+ separately for each partition, subsequently merging the results
737
743
(Jeevan Chalke, Ashutosh Bapat, Robert Haas)
738
744
</para>
739
745
@@ -1564,11 +1570,11 @@ same commits as above
1564
1570
1565
1571
<para>
1566
1572
Allow server options related to memory and file sizes to be
1567
- specified as a number of bytes (Beena Emerson)
1573
+ specified in units of bytes (Beena Emerson)
1568
1574
</para>
1569
1575
1570
1576
<para>
1571
- The new unit is <quote>B</quote>. This is in addition to the
1577
+ The new unit suffix is <quote>B</quote>. This is in addition to the
1572
1578
existing units <quote>kB</quote>, <quote>MB</quote>, <quote>GB</quote>
1573
1579
and <quote>TB</quote>.
1574
1580
</para>
@@ -2199,8 +2205,8 @@ same commits as above
2199
2205
2200
2206
<para>
2201
2207
Add <application>psql</application> command <literal>\gdesc</literal>
2202
- to display the column names and types of the query output (Pavel
2203
- Stehule)
2208
+ to display the names and types of the columns in a query result
2209
+ (Pavel Stehule)
2204
2210
</para>
2205
2211
</listitem>
2206
2212
0 commit comments