|
20 | 20 |
|
21 | 21 | <itemizedlist> |
22 | 22 |
|
23 | | - <listitem><para>XXX</para></listitem> |
| 23 | + <listitem> |
| 24 | + <para> |
| 25 | + Major improvements to partitioning: |
| 26 | + <itemizedlist> |
| 27 | + <listitem> |
| 28 | + <para> |
| 29 | + Partitioning by a hash key |
| 30 | + </para> |
| 31 | + </listitem> |
| 32 | + <listitem> |
| 33 | + <para> |
| 34 | + <command>UPDATE</command> statements that change a partition key |
| 35 | + now move affected rows to the appropriate partitions |
| 36 | + </para> |
| 37 | + </listitem> |
| 38 | + <listitem> |
| 39 | + <para> |
| 40 | + Improved <command>SELECT</command> query performance due to |
| 41 | + enhanced partition elimination during query processing and |
| 42 | + execution |
| 43 | + </para> |
| 44 | + </listitem> |
| 45 | + <listitem> |
| 46 | + <para> |
| 47 | + Support for <literal>PRIMARY KEY</literal>, <literal>FOREIGN |
| 48 | + KEY</literal>, indexes, and triggers on partitioned tables |
| 49 | + </para> |
| 50 | + </listitem> |
| 51 | + </itemizedlist> |
| 52 | + </para> |
| 53 | + </listitem> |
| 54 | + |
| 55 | + <listitem> |
| 56 | + <para> |
| 57 | + Improvements to parallelism: |
| 58 | + <itemizedlist> |
| 59 | + <listitem> |
| 60 | + <para> |
| 61 | + Parallelized hash joins |
| 62 | + </para> |
| 63 | + </listitem> |
| 64 | + <listitem> |
| 65 | + <para> |
| 66 | + Parallelized <command>CREATE INDEX</command> for B-tree indexes |
| 67 | + </para> |
| 68 | + </listitem> |
| 69 | + <listitem> |
| 70 | + <para> |
| 71 | + Parallelized <command>CREATE TABLE .. AS</command>, |
| 72 | + <command>CREATE MATERIALIZED VIEW</command>, and certain |
| 73 | + queries using <literal>UNION</literal> |
| 74 | + </para> |
| 75 | + </listitem> |
| 76 | + </itemizedlist> |
| 77 | + </para> |
| 78 | + </listitem> |
| 79 | + |
| 80 | + <listitem> |
| 81 | + <para> |
| 82 | + SQL stored procedures, with support for embedded transactions |
| 83 | + </para> |
| 84 | + </listitem> |
| 85 | + |
| 86 | + <listitem> |
| 87 | + <para> |
| 88 | + JIT compilation of some SQL code, including support for fast evaluation |
| 89 | + of expressions |
| 90 | + </para> |
| 91 | + </listitem> |
| 92 | + |
| 93 | + <listitem> |
| 94 | + <para> |
| 95 | + Window functions now support all options shown in the SQL:2011 |
| 96 | + standard, including <literal>RANGE <replaceable>distance</replaceable> |
| 97 | + PRECEDING/FOLLOWING</literal>, <literal>GROUPS</literal> mode, and |
| 98 | + frame exclusion options |
| 99 | + </para> |
| 100 | + </listitem> |
| 101 | + |
| 102 | + <listitem> |
| 103 | + <para> |
| 104 | + Channel binding for SCRAM authentication, to prevent potential |
| 105 | + man-in-the-middle attacks on database connections |
| 106 | + </para> |
| 107 | + </listitem> |
| 108 | + |
| 109 | + <listitem> |
| 110 | + <para> |
| 111 | + Many other useful performance improvements, including making |
| 112 | + <command>ALTER TABLE .. ADD COLUMN</command> with a |
| 113 | + non-null column default faster |
| 114 | + </para> |
| 115 | + </listitem> |
| 116 | + |
24 | 117 | </itemizedlist> |
25 | 118 |
|
26 | 119 | <para> |
|