From d46f9cd3bd8cac73a793c69be672fb99a04f9153 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 29 Oct 2003 23:28:59 +0000 Subject: [PATCH] Update more release descriptions. --- doc/src/sgml/release.sgml | 129 +++++++++++++++++++++++++++++++++++++++++----- 1 file changed, 115 insertions(+), 14 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 5dea8473a4..f6b9a73cea 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ @@ -301,19 +301,67 @@ required for those wishing to migrate data from any previous release. Fix SSL to handle errors cleanly (Nathan Mueller) - In prior releases, + In prior releases, certain rare SSL API error reports were not + handled correctly. This release fixes those problems. + gracefully. + + + +SSL protocol security and performance improvements (Sean Chittenden) + + + SSL key renegotiation was happening too frequently, causing poor SSL + performance. Also, initial key handling was improved. + + + +Print lock information when a deadlock is detected (Tom) + + + This allows easier debugging of deadlock situations. + + + +Update /tmp socket mod. times regularly to avoid their removal (Tom) + + + This should help prevent /tmp directory cleaner + administration scripts from removing server socket files. -SSL protocol security and performance improvements (Sean Chittenden) -Print lock information when a deadlock is detected (Tom) -Update /tmp socket mod. times regularly to avoid their removal (Tom) Enable PAM for MAC OS X (Aaron Hillegass) -Make btree indexes fully WAL-safe (Tom) +Make btree indexes fully WAL-safe (Tom) + + + In prior releases, under certain rare cases, a server crash could + cause btree indexes to become corrupt. This release removes those + last few rare cases. + + + Allow btree index compaction and empty page reuse (Tom) -Fix inconsistent index lookups during split of first root page (Tom) +Fix inconsistent index lookups during split of first root page (Tom) + + + In prior releases, when a single-page index split into two page, + there was a brief period when another database session would miss + seeing an index entry. This failure was possible primarly on + multi-cpu machines. This release fixes that rare failure case. + + + Improve free space map allocation logic (Tom) -Preserve free space information between postmaster restarts (Tom) +Preserve free space information between postmaster restarts (Tom) + + + In prior releases, the free space map was not saved when the + postmaster was stopped, so newly started servers has no free space + information. This release saves the free space map, which is loaded + when the server is restarted. + + + Set proper schema permissions in initdb (Peter) Add start time to pg_stat_activity (Neil) New code to detect corrupt disk pages; erase with zero_damaged_pages (Tom) @@ -334,12 +382,36 @@ required for those wishing to migrate data from any previous release. Allow multi-key hash joins (Tom) Improve constant folding (Tom) Add ability to inline simple SQL functions (Tom) -Reduce memory usage for queries using complex functions (Tom) -Improve GEQO optimizer performance (Tom) +Reduce memory usage for queries using complex functions (Tom) + + + In prior releases, functions returning allocated memory would + not free it until the query completed. This release allows the + freeing of function-allocated memory when the function call + completes, reducing the total memory used by functions. + + + +Improve GEQO optimizer performance (Tom) + + + There were several inefficiencies in the way the GEQO optimizer + managed potential query paths. This release fixes this. + + + Allow IN/NOT IN to be handled via hash tables (Tom) Improve NOT IN (subquery) performance (Tom) Allow most IN subqueries to be processed as joins (Tom) -Allow the postmaster to preload libraries using preload_libraries (Joe) +Allow the postmaster to preload libraries using preload_libraries (Joe) + + + For shared libraries that require a long time to load, this option + is available so the library can be pre-loaded in the postmaster and + inherited by all database sessions. + + + Improve optimizer cost computations, particularly for subqueries (Tom) Avoid sort when subquery ORDER BY matches upper query (Tom) Assume WHERE a.x = b.y and b.y = 42 also means a.x = 42 (Tom) @@ -353,15 +425,44 @@ required for those wishing to migrate data from any previous release. Improve trigger/constraint performance (Stephan) Improve speed of col IN (const, const, const, ...) (Tom) Fix hash indexes which were broken in rare cases (Tom) -Improve hash index concurrency and speed (Tom) -Align shared buffers on 32-byte boundary for copy speed improvement (Manfred Spraul) -The NUMERIC datatype has been reimplemented for better performance (Tom) +Improve hash index concurrency and speed (Tom) + + + Prior releases suffered from poor hash index performance, + particularly for high concurrency situations. This release fixes + that, and the development group is interested in reports comparing + btree and hash index performance. + + + +Align shared buffers on 32-byte boundary for copy speed improvement (Manfred Spraul) + + + Certain CPU's perform faster data copies when addresses are 32-bit + aligned. + + + +The NUMERIC datatype has been reimplemented for better performance (Tom) + + + NUMERIC used to be stored in base-100. The new code uses base-10000, + for significantly better performance. + + + Server Configuration Rename server parameter server_min_messages to log_min_messages (Bruce) + + + This was done so most parameters that control the server logs being + with log_>/>. + + Rename show_*_stats to log_*_stats (Bruce) Rename show_source_port to log_source_port (Bruce) Rename hostname_lookup to log_hostname (Bruce) -- 2.11.0