From ca2c61caacdcc0f590a27bb15bf93d6685e7ab46 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 29 Apr 2010 20:43:22 +0000 Subject: [PATCH] Update 9.0 release notes to current; add major items and introductory text. --- doc/src/sgml/release-9.0.sgml | 245 +++++++++++++++++++++++++++++++--- 1 file changed, 223 insertions(+), 22 deletions(-) diff --git a/doc/src/sgml/release-9.0.sgml b/doc/src/sgml/release-9.0.sgml index bd1b1e7e104..8a6923555aa 100644 --- a/doc/src/sgml/release-9.0.sgml +++ b/doc/src/sgml/release-9.0.sgml @@ -1,4 +1,4 @@ - + @@ -13,21 +13,165 @@ Overview - ADD HERE + Based on overwhelming user demand, this release of + PostgreSQL adds features that have been requested + for years, like easy-to-use replication, a mass permission + facility, and anonymous blocks. While past major releases have + been quite conservative in their scope, this release shows a + bold new desire to provide facilities that every new and existing + user of PostgreSQL will embrace. This has all + been done with few incompatibilities. The major areas of + enhancement are: - + - - The above items are explained in more detail in the sections below. - + + + + + Allow continuous archive standby systems to accept read-only queries + + + + + + Allow continuous archive (WAL) files to be streamed to a + standby system + + + + + + Add the ability to make mass permission changes per + schema using the new GRANT/REVOKE + IN SCHEMA clause + + + + + + Add the ability to control large object permissions with + GRANT/REVOKE + + + + + + Implement anonymous functions using the DO statement + + + + + + Allow function calls to supply parameter names and match them to named + parameters in the function definition (Pavel Stehule) + + + + + + Install server-side language PL/pgSQL by default + + + + + + Major PL/Perl enhancements + + + + + + Allow SQL-compliant per-column triggers + + + + + + Add deferrable + unique constraints + + + + + + Have LISTEN/NOTIFY store events + in a memory queue, rather than a system table + + + + + + Allow NOTIFY + to pass an optional string to listeners + + + + + + Change VACUUM FULL to rewrite the entire table and + indexes, rather than moving around single rows to compact space + + + + + + Add prefix support for the full text search synonym dictionary + + + + + + Use red-black trees for GIN index creation + + + + + + Add get_bit() + and set_bit() functions for bit + strings, mirroring those for bytea + + + + + + Add the ability for clients to set an application + name, which is displayed in + pg_stat_activity + + + + + + Add support for compiling on 64-bit + Windows and running in 64-bit + mode + + + + + + The above items are explained in more detail in the sections below. + + + + Migration to Version 9.0 - CURRENT AS OF 2010-03-15 + CURRENT AS OF 2010-04-29 A dump/restore using pg_dump is @@ -60,6 +204,15 @@ + + + It is now necessary to set wal_level to + archive to do continuous archiving. + (Heikki Linnakangas) + + + @@ -152,7 +305,6 @@ - @@ -218,7 +370,7 @@ Allow continuous archive standby systems to accept read-only queries - (Simon, Heikki) + (Simon Riggs, Heikki Linnakangas) @@ -232,7 +384,7 @@ Allow continuous archive (WAL) files to be streamed to a - standby system (Fujii Masao, Heikki) + standby system (Fujii Masao, Heikki Linnakangas) @@ -251,7 +403,7 @@ linkend="functions-recovery-info-table">pg_last_xlog_receive_location() and pg_last_xlog_replay_location(), which can be used to monitor standby server WAL - activity (Simon, Fujii Masao, Heikki) + activity (Simon Riggs, Fujii Masao, Heikki Linnakangas) @@ -552,6 +704,19 @@ + + + Add boolean variable enable_material, which + controls the use of materialize nodes in the optimizer + (Robert Haas) + + + + The default is on. + + + Log changed parameter values when postgresql.conf is @@ -559,6 +724,20 @@ + + + Add proper permissions for custom variables (Tom Lane) + + + + Custom variables can now only be created by super-users, + but can be modified by ordinary users if variable + permissions allow it. This makes custom variables + appropriate for security settings. Previously, any user + could create or modify custom variables. + + + @@ -838,7 +1017,7 @@ Add the ability to control large object permissions with - GRANT/REVOKE(KaiGai Kohei) + GRANT/REVOKE (KaiGai Kohei) @@ -972,7 +1151,7 @@ Change VACUUM FULL to rewrite the entire table and indexes, rather than moving around single rows to compact space - (Itagaki Takahiro, Tom) + (Itagaki Takahiro, Tom Lane) @@ -1109,6 +1288,13 @@ + + + Use more standards-compliant rules for URL + parsing (Tom Lane) + + + @@ -1162,7 +1348,7 @@ Have to_char() honor 'FM' (fill mode) in 'Y', 'YY', and - 'YYY' specifications (Bruce Momjian) + 'YYY' specifications (Bruce Momjian, Tom Lane) @@ -1170,6 +1356,14 @@ + + + Fix to_char() to output the proper localized + numeric and monetary characters on Windows + (Hiroshi Inoue, Itagaki Takahir, Bruce Momjian) + + + Correct calculations of pg_dump @@ -1947,6 +2141,13 @@ + + + Allow ecpg to use variable names in + free()(Michael Meskes) + + + Have ecpg return zero for non-SQL3 data types @@ -2018,7 +2219,7 @@ Add a compile-time option to allow the Linux out-of-memory killer - to kill backends (Alex Hunsaker, Tom) + to kill backends (Alex Hunsaker, Tom Lane) @@ -2176,7 +2377,7 @@ - Improve speed of memory allocation (Tom, Greg Stark) + Improve speed of memory allocation (Tom Lane, Greg Stark) @@ -2202,14 +2403,14 @@ Improve source code test coverage, including /contrib, PL/Python, - and PL/Perl (Peter, Andrew) + and PL/Perl (Peter Eisentraut, Andrew Dustan) - Remove the use of flat files for system table bootstrapping (Tom, - Alvaro) + Remove the use of flat files for system table bootstrapping + (Tom Lane, Alvaro Herrera) @@ -2317,7 +2518,7 @@ Allow use of C++ functions in backend code (Kurt - Harriman, Peter) + Harriman, Peter Eisentraut) @@ -2531,7 +2732,7 @@ to use /proc/self/oom_adj to disable the Linux out-of-memory (OOM) killer (Alex - Hunsaker, Tom) + Hunsaker, Tom Lane) -- 2.39.5