|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/release-9.0.sgml,v 2.44 2010/07/29 21:18:11 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/release-9.0.sgml,v 2.45 2010/08/06 17:56:43 rhaas Exp $ --> |
2 | 2 |
|
3 | 3 | <sect1 id="release-9-0"> |
4 | 4 | <title>Release 9.0</title> |
|
51 | 51 | </para> |
52 | 52 | </listitem> |
53 | 53 |
|
| 54 | + <listitem> |
| 55 | + <para> |
| 56 | + Add support for compiling on <link |
| 57 | + linkend="install-win32-full">64-bit |
| 58 | + <productname>Windows</></link> and running in 64-bit |
| 59 | + mode. |
| 60 | + </para> |
| 61 | + </listitem> |
| 62 | + |
54 | 63 | <listitem> |
55 | 64 | <para> |
56 | 65 | Broadly enhanced stored procedure support. |
|
62 | 71 | </para> |
63 | 72 | </listitem> |
64 | 73 |
|
| 74 | + <listitem> |
| 75 | + <para> |
| 76 | + More advanced reporting queries with additional windowing functions |
| 77 | + (PRECEDING and FOLLOWING) and the ability to ORDER BY inside aggregate |
| 78 | + functions. |
| 79 | + </para> |
| 80 | + </listitem> |
| 81 | + |
65 | 82 | <listitem> |
66 | 83 | <para> |
67 | 84 | Triggers now support two new features, |
|
80 | 97 |
|
81 | 98 | <listitem> |
82 | 99 | <para> |
83 | | -Exclusion constraints let database designers define uniqueness |
84 | | -based on complex criteria, including for non-scalar data such |
85 | | -as time periods, ranges and arrays. |
| 100 | +New and enhanced security features, including RADIUS authentication, |
| 101 | +LDAP authentication improvements, and the new checkpassword optional module |
| 102 | +for testing password strength. |
86 | 103 | </para> |
87 | 104 | </listitem> |
88 | 105 |
|
|
97 | 114 | </para> |
98 | 115 | </listitem> |
99 | 116 |
|
| 117 | + <listitem> |
| 118 | + <para> |
| 119 | + Add <link linkend="pgupgrade"><filename>/contrib/pg_upgrade</></link> |
| 120 | + to support in-place upgrades from 8.3 or 8.4 to 9.0. |
| 121 | + </para> |
| 122 | + </listitem> |
| 123 | + |
| 124 | + <listitem> |
| 125 | + <para> |
| 126 | + Multiple performance enhancements for specific types of queries, |
| 127 | + including join elimination, which optimizes automatically generated |
| 128 | + queries, such as those produced by object-relational mappers (ORMs). |
| 129 | + </para> |
| 130 | + </listitem> |
| 131 | + |
| 132 | + <listitem> |
| 133 | + <para> |
| 134 | + Exclusion constraints let database designers define uniqueness |
| 135 | + based on complex criteria, including for non-scalar data such |
| 136 | + as time periods, ranges and arrays. |
| 137 | + </para> |
| 138 | + </listitem> |
| 139 | + |
100 | 140 | <listitem> |
101 | 141 | <para> |
102 | 142 | As part of our decade-long effort to eliminate the pain of VACUUM, |
103 | | - <command>VACUUM FULL</> isnow substantially faster by |
| 143 | + <command>VACUUM FULL</> isnot substantially faster by |
104 | 144 | rewriting the entire table and |
105 | 145 | indexes, rather than moving around single rows to compact space. |
106 | 146 | </para> |
107 | 147 | </listitem> |
108 | 148 |
|
109 | 149 | <listitem> |
110 | 150 | <para> |
111 | | - Add support for compiling on <link |
112 | | - linkend="install-win32-full">64-bit |
113 | | - <productname>Windows</></link> and running in 64-bit |
114 | | - mode. |
| 151 | + EXPLAIN plans are now available in JSON, XML and YAML format, and include |
| 152 | + buffer utilization and other data not previously available. |
115 | 153 | </para> |
116 | 154 | </listitem> |
117 | 155 |
|
118 | 156 | <listitem> |
119 | 157 | <para> |
120 | | -Add <link linkend="pgupgrade"><filename>/contrib/pg_upgrade</></link> |
121 | | -to support in-place upgrades from 8.3 or 8.4 to 9.0. |
| 158 | +The HStore optional module has been improved with new functions and greater |
| 159 | +data capacity to make it a high-performance key-value store. |
122 | 160 | </para> |
123 | 161 | </listitem> |
124 | 162 |
|
|