From 1a998474a7d88e8b340b179130b8368b734a3c30 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 17 Aug 2011 20:18:15 -0400 Subject: [PATCH] Update 9.1 release notes to reflect commits through today. Also do another pass of copy-editing. --- doc/src/sgml/release-9.1.sgml | 151 ++++++++++++++++++++++------------ 1 file changed, 99 insertions(+), 52 deletions(-) diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml index de80141959b..9a6ee0a50e5 100644 --- a/doc/src/sgml/release-9.1.sgml +++ b/doc/src/sgml/release-9.1.sgml @@ -9,33 +9,25 @@ 2011-??-?? - CURRENT AS OF 2011-07-07 + CURRENT AS OF 2011-08-17 Overview This release shows PostgreSQL moving beyond the - traditional relational feature set with new, ground-breaking + traditional relational-database feature set with new, ground-breaking functionality that is unique to PostgreSQL. - Additionally, this release improves streaming replication by adding - a synchronous option and monitoring improvements. Major enhancements - include: + The streaming replication feature introduced in release 9.0 is + significantly enhanced by adding a synchronous-replication option, + streaming backups, and monitoring improvements. + Major enhancements include: - - - Support unlogged tables using the UNLOGGED - option in CREATE - TABLE - - - Allow synchronous @@ -59,16 +51,23 @@ - Add a SECURITY - LABEL command + Add extensions which + simplify packaging of additions to PostgreSQL Add a true serializable isolation - level + linkend="xact-serializable">serializable isolation level + + + + + + Support unlogged tables using the UNLOGGED + option in CREATE + TABLE @@ -89,8 +88,9 @@ - Add extensions which - simplify packaging of additions to PostgreSQL + Add a SECURITY + LABEL command and support for + SELinux permissions control @@ -146,6 +146,17 @@ strings are the proper way to embed backslash escapes in strings and are unaffected by this change. + + + + This change can break applications that are not expecting it and + do their own string escaping according to the old rules. The + consequences could be as severe as introducing SQL-injection security + holes. Be sure to test applications that are exposed to untrusted + input, to ensure that they correctly handle single quotes and + backslashes in text strings. + + @@ -383,7 +394,8 @@ - Treat ECPG cursor names as case-insensitive (Zoltan Boszormenyi) + Treat ECPG cursor names as case-insensitive + (Zoltan Boszormenyi) @@ -394,9 +406,12 @@ Changes - - Version 9.1 has ... - + + + Below you will find a detailed account of the changes between + PostgreSQL 9.1 and the previous major + release. + Server @@ -408,8 +423,7 @@ - Support unlogged tables using the UNLOGGED + Support unlogged tables using the UNLOGGED option in CREATE TABLE (Robert Haas) @@ -440,8 +454,11 @@ - Merge duplicate fsync requests on busy systems (Robert Haas, - Greg Smith) + Merge duplicate fsync requests (Robert Haas, Greg Smith) + + + + This greatly improves performance under heavy write loads. @@ -584,7 +601,9 @@ - The old term is still accepted for backward compatibility. + The old term is still accepted for backward compatibility, but since + the two methods are fundamentally different, it seemed better to adopt + different names for them. @@ -634,6 +653,18 @@ + + + Reduce the default maximum line length for syslog + logging to 900 bytes plus prefixes (Noah Misch) + + + + This avoids truncation of long log lines on syslog implementations + that have a 1KB length limit, rather than the more common 2KB. + + + @@ -1000,8 +1031,8 @@ - This allows external cluster management software to take control - of whether servers restart or not. + This allows external cluster management software to control + whether the database server restarts or not. @@ -1032,8 +1063,8 @@ Add a true serializable isolation - level (Kevin Grittner, Dan Ports) + linkend="xact-serializable">serializable isolation level + (Kevin Grittner, Dan Ports) @@ -1444,11 +1475,11 @@ Prevent autovacuum from - waiting if it cannot acquire a lock (Robert Haas) + waiting if it cannot acquire a table lock (Robert Haas) - It will try to vacuum later. + It will try to vacuum that table later. @@ -1486,6 +1517,12 @@ This allows GiST indexes to quickly return the N closest values in a query with LIMIT. + For example + point '(101,456)' LIMIT 10; +]]> + + finds the ten places closest to a given target point. @@ -1851,7 +1888,7 @@ Add FOREACH IN - ARRAY to PL/pgSQL + ARRAY to PL/pgSQL (Pavel Stehule) @@ -1962,7 +1999,7 @@ - Add PL/Python explicit subtransactions (Jan Urbanski) + Add explicit subtransactions to PL/Python (Jan Urbanski) @@ -2055,7 +2092,7 @@ - Add @@ -2207,7 +2244,8 @@ - Add a libpq connection option client_encoding + Add a libpq connection option client_encoding which behaves like the PGCLIENTENCODING environment variable (Heikki Linnakangas) @@ -2234,10 +2272,11 @@ - Allow libpq database clients to - check the user name of the server process using requirepeer - when connecting via Unix-domain sockets + connection option (Peter Eisentraut) @@ -2272,8 +2311,16 @@ - Allow ECPG to accept dynamic cursor names even in - WHERE CURRENT OF clauses + Allow ECPG to accept dynamic cursor names even in + WHERE CURRENT OF clauses + (Zoltan Boszormenyi) + + + + + + Make ecpglib write double values with a + precision of 15 digits, not 14 as formerly (Akira Kurosawa) @@ -2422,8 +2469,8 @@ - Add latches to the source code to wait for events (Heikki - Linnakangas) + Add latches to the source code to support waiting for events (Heikki + Linnakangas) @@ -2561,7 +2608,7 @@ - Add nearest-neighbor support to contrib/pg_trgm and contrib/btree_gist (Teodor Sigaev) @@ -2672,7 +2719,7 @@ Add contrib/sepgsql - to interface permission checks with SE-Linux (KaiGai Kohei) + to interface permission checks with SELinux (KaiGai Kohei) @@ -2698,7 +2745,7 @@ - Add dummy_seclabel + Add dummy_seclabel contrib module (KaiGai Kohei) @@ -2808,8 +2855,8 @@ - Extensive ECPG documentation - improvements (Satoshi Nagayasu) + Extensive ECPG + documentation improvements (Satoshi Nagayasu) @@ -2864,7 +2911,7 @@ - Merge docs for CREATE CONSTRAINT TRIGGER and CREATE CONSTRAINT TRIGGER and CREATE TRIGGER (Alvaro Herrera) -- 2.30.2