Index: release-9.0.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/release-9.0.sgml,v
retrieving revision 2.31
diff -c -r2.31 release-9.0.sgml
*** release-9.0.sgml 14 Jun 2010 02:18:43 -0000 2.31
--- release-9.0.sgml 16 Jun 2010 17:07:58 -0000
***************
*** 108,114 ****
Add support for compiling on 64-bit
Windows> and running in 64-bit
! mode
--- 108,114 ----
Add support for compiling on 64-bit
Windows> and running in 64-bit
! mode.
***************
*** 133,145 ****
CURRENT AS OF 2010-06-03
! A dump/restore using pg_dump is
! required for those wishing to migrate data from any previous
release.
! Observe the following incompatibilities:
--- 133,149 ----
CURRENT AS OF 2010-06-03
! A dump/restore using pg_dump
! or use of pg_upgrade is required
! for those wishing to migrate data from any previous
release.
! Version 9.0 contains a number of changes which selectively break backwards compatibility
! in order to support new features and code quality improvements. Particularly, users
! who make extensive use of PL/pgSQL and/or PITR and Warm Standby should test their
! solutions for breakage. Observe the following incompatibilities:
***************
*** 488,493 ****
--- 492,503 ----
linkend="guc-geqo-seed">geqo_seed to randomize
the starting value of the random plan generator.
+
+
+ This gives GEQO query response times and resource usage
+ repeatability and predictability.
+
+
***************
*** 623,628 ****
--- 633,643 ----
name, which is displayed in
pg_stat_activity> (Dave Page)
+
+
+ This allows DBAs to characterize database traffic
+ and troubleshoot problems by source application.
+
***************
*** 688,694 ****
--- 703,713 ----
in the new pg_db_role_setting> system table. A new
psql> \drds> command shows these settings.
Backwards-compatible system views do not show this information.
+ The primary use of this feature is setting schema
+ search_path.
+
+
***************
*** 722,727 ****
--- 741,752 ----
Log changed parameter values when postgresql.conf> is
reloaded (Peter Eisentraut)
+
+
+ This lets DBAs and security staff to audit when database settings
+ were changed.
+
+
***************
*** 795,800 ****
--- 820,831 ----
+ For drivers which support this feature, this saves an entire
+ round-trip to the client, allowing result counts and pagination
+ to be calculated without a second COUNT query.
+
+
+ psql> does not display these counts.
***************
*** 909,915 ****
Such operations either complete fully or are rolled back, so
WAL> archiving can be skipped, unless running in continuous
! archiving mode.
--- 940,946 ----
Such operations either complete fully or are rolled back, so
WAL> archiving can be skipped, unless running in continuous
! archiving mode. This reduces I/O overhead and improves performance.
***************
*** 1274,1279 ****
--- 1305,1317 ----
PQescapeByteaConn()> now uses the hex format
for PostgreSQL> 9.0 servers.
+
+
+ The new hex format will be directly compatible with more applications
+ which use binary data, allowing them to store and retrieve
+ it without conversion.
+
+
***************
*** 1417,1423 ****
For example, this is now supported, array_agg(a ORDER BY
b)>. This is useful for aggregates where the order of values is
! significant.
--- 1455,1462 ----
For example, this is now supported, array_agg(a ORDER BY
b)>. This is useful for aggregates where the order of values is
! significant, and eliminates the need to have a subquery for
! the ordering.