|
6 | 6 |
|
7 | 7 | <formalpara> |
8 | 8 | <title>Release date:</title> |
9 | | - <para>2021-??-?? (AS OF 2021-09-18)</para> |
| 9 | + <para>2021-09-30</para> |
10 | 10 | </formalpara> |
11 | 11 |
|
12 | 12 | <sect2> |
|
20 | 20 | <itemizedlist> |
21 | 21 | <listitem> |
22 | 22 | <para> |
23 | | - TO BE ADDED |
| 23 | + Stored procedures can now return data via <literal>OUT</literal> |
| 24 | + parameters. |
| 25 | + </para> |
| 26 | + </listitem> |
| 27 | + |
| 28 | + <listitem> |
| 29 | + <para> |
| 30 | + The SQL-standard <literal>SEARCH</literal> |
| 31 | + and <literal>CYCLE</literal> options for common table expressions |
| 32 | + have been implemented. |
| 33 | + </para> |
| 34 | + </listitem> |
| 35 | + |
| 36 | + <listitem> |
| 37 | + <para> |
| 38 | + Subscripting can now be applied to any data type for which |
| 39 | + it is a useful notation, not only arrays. In this release, |
| 40 | + the <type>jsonb</type> and <type>hstore</type> types have gained |
| 41 | + subscripting operators. |
| 42 | + </para> |
| 43 | + </listitem> |
| 44 | + |
| 45 | + <listitem> |
| 46 | + <para> |
| 47 | + Range types have been extended by adding multiranges, allowing |
| 48 | + representation of noncontiguous data ranges. |
| 49 | + </para> |
| 50 | + </listitem> |
| 51 | + |
| 52 | + <listitem> |
| 53 | + <para> |
| 54 | + Numerous performance improvements have been made for parallel |
| 55 | + queries, heavily-concurrent workloads, partitioned tables, logical |
| 56 | + replication, and vacuuming. |
| 57 | + </para> |
| 58 | + </listitem> |
| 59 | + |
| 60 | + <listitem> |
| 61 | + <para> |
| 62 | + B-tree index updates are managed more efficiently, reducing index |
| 63 | + bloat. |
| 64 | + </para> |
| 65 | + </listitem> |
| 66 | + |
| 67 | + <listitem> |
| 68 | + <para> |
| 69 | + <command>VACUUM</command> automatically becomes more aggressive, and |
| 70 | + skips inessential cleanup, if the database starts to approach a |
| 71 | + transaction ID wraparound condition. |
| 72 | + </para> |
| 73 | + </listitem> |
| 74 | + |
| 75 | + <listitem> |
| 76 | + <para> |
| 77 | + Extended statistics can now be collected on expressions, allowing |
| 78 | + better planning results for complex queries. |
| 79 | + </para> |
| 80 | + </listitem> |
| 81 | + |
| 82 | + <listitem> |
| 83 | + <para> |
| 84 | + <application>libpq</application> now has the ability to pipeline |
| 85 | + multiple queries, which can boost throughput over high-latency |
| 86 | + connections. |
24 | 87 | </para> |
25 | 88 | </listitem> |
26 | 89 | </itemizedlist> |
|