From 3ec369be5df5a699e1d57dd6b061a84eb261bd7a Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 18 Sep 2006 22:43:16 +0000 Subject: [PATCH] Updates from Jim Nasby. --- doc/src/sgml/release.sgml | 47 ++++++++++++++++----------------------- 1 file changed, 19 insertions(+), 28 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index aaad148902..aa93d90b52 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -85,9 +85,9 @@ For new features, add links to the documentation sections. Additional Changes - Below you will find a detailed account of the additional changes - between PostgreSQL 8.2 and the - previous major release. + Below you will find a detailed account of the additional + changes between PostgreSQL 8.2 and + the previous major release. @@ -230,7 +230,15 @@ For new features, add links to the documentation sections. - Improve performance of statistics monitoring, especially pg_stat_activity (Tom) + Improve performance of statistics monitoring, especially + stats_command_string (Tom, Bruce) + + + + This release sets stats_command_string to + on by default, now that its overhead is minimal. + This means pg_stat_activity now will show all + active queries by default. @@ -319,17 +327,6 @@ For new features, add links to the documentation sections. - - - Default stats_command_string to on, now that its overhead is minimal - (Bruce) - - - - This means pg_stat_activity now will show all active queries by default. - - - Add GUC update_process_title to control whether the ps display is @@ -587,9 +584,9 @@ For new features, add links to the documentation sections. - The old behavior is still available by omitting .*. The new behavior is - substantially more useful since it allows, for example, triggers to check - for data changes with if row(new.*) IS DISTINCT FROM row(old.*). + The new behavior is substantially more useful since it allows, for example, + triggers to check for data changes with IF row(new.*) IS DISTINCT FROM row(old.*). + The old behavior is still available by omitting .*. @@ -799,7 +796,7 @@ For new features, add links to the documentation sections. - Allow placeholder (shell) types to be create (Martijn van Oosterhout) + Allow placeholder (shell) types to be created (Martijn van Oosterhout) @@ -904,12 +901,6 @@ For new features, add links to the documentation sections. - - - Remove dead index entries during btree page split (Junji Teramoto) - - - Allow VACUUM to expire rows without being affected by other concurrent @@ -919,13 +910,13 @@ For new features, add links to the documentation sections. - Avoid extra scan of table during VACUUM of index-less table (Greg Stark) + Avoid extra scan of tables during VACUUM of index-less table (Greg Stark) - Add option to allow indexes to be created indexes without blocking + Add option to allow indexes to be created without blocking concurrent writes to the table (Greg Stark) @@ -1549,7 +1540,7 @@ Tom) - Rtree has been re implemented using GIST. + Rtree has been re-implemented using GIST. -- 2.39.5