From 35417de81347232630fa5842d1778938cf5b09e4 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 9 Apr 2009 23:22:49 +0000 Subject: [PATCH] Update release notes through yesterday; some minor wordsmithing. --- doc/src/sgml/release.sgml | 407 +++++++++++++++++++++++++++++++------- 1 file changed, 336 insertions(+), 71 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 180a55873f..cca4f0b51a 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -69,7 +69,7 @@ do it for earlier branch release files. Release date - 2009-XX-XX, ITEMS CURRENT AS OF 2009-03-16 + 2009-XX-XX, ITEMS CURRENT AS OF 2009-04-08 @@ -89,7 +89,97 @@ do it for earlier branch release files. - *MAJOR ITEM LIST GOES HERE* + Windowing Functions + + + + + + Common Table Expressions and Recursive Joins + + + + + + Default and variadic parameters for functions + + + + + + Parallel Restore + + + + + + Column Permissions + + + + + + Per-database locale settings + + + + + + Improved hash indexes + + + + + + Improved join performance for EXISTS and NOT EXISTS queries + + + + + + Easier-to-use Warm Standby + + + + + + Automatic sizing of the Free Space Map + + + + + + Visibility Map (greatly reduces vacuum overhead for slowly-changing tables) + + + + + + Version-aware psql (backslash commands work against older servers) + + + + + + Support SSL certificates for authentication + + + + + + Per-function runtime statistics + + + + + + Easy editing of functions in psql + + + + + + New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin @@ -150,24 +240,24 @@ do it for earlier branch release files. - Change postgresql.conf default for log_min_messages - to warning (previously notice) to reduce - log file volume (Tom) + Change postgresql.conf default for + log_min_messages to warning (previously + notice) to reduce log file volume (Tom) - Have debug_print_parse, debug_print_rewritten, and debug_print_plan - output appear as LOG message level, not - DEBUG1 (Tom) bjm: inconsistency because of var - names? + Have debug_print_parse, debug_print_rewritten, + and debug_print_plan + output appear at LOG message level, not + DEBUG1 as formerly (Tom) - Have debug_pretty_print default to on (Tom) + Make debug_pretty_print default to on (Tom) @@ -181,7 +271,7 @@ do it for earlier branch release files. Disable appending of the epoch date/time when no % - escapes are present in log_filename (Robert Haas) + escapes are present in log_filename (Robert Haas) @@ -240,16 +330,15 @@ do it for earlier branch release files. - Have children inherit CHECK constraints from parents + Force child tables to inherit CHECK constraints from parents (Alex Hunsaker, Nikhil Sontakke, Tom Lane) - - - Force child tables to have the same CHECK constraints - as parents (Alex Hunsaker, Nikhil Sontakke, Tom Lane) bjm: - verify + Formerly it was possible to delete such a constraint from a child + table, allowing rows that violate the constraint to be visible + when scanning the parent table. This was deemed inconsistent, + as well as contrary to SQL standard. @@ -284,13 +373,6 @@ do it for earlier branch release files. - - - Make DISCARD ALL also discard advisory locks (Marko - Kreen) - - - @@ -320,7 +402,7 @@ do it for earlier branch release files. - The changed behavior is more IEEE-standards + The changed behavior is more IEEE-standard compliant. @@ -335,16 +417,37 @@ do it for earlier branch release files. Remove ~=~ and ~<>~ operators - used for LIKE index comparisons (Tom) bjm: needed, - pg_upgrade impact? + formerly used for LIKE index comparisons (Tom) + + + + Pattern indexes now use the regular equality operator. + + + + + + xpath() now passes its arguments to libxml + without any changes (Andrew) + + + + This means that the XML argument must be a well-formed XML document. + The previous coding attempted to allow XML fragments, but it did not + work well. + + + + + + Make xmlelement() format attribute values just like + content values (Peter) - A not-immediately-obvious incompatibility is that the sort - order within bpchar_pattern_ops indexes changes - --- it had been identical to plain strcmp(), but - is now trailing-blank-insensitive. This will impact in-place - upgrades, if those ever happen. + Previously, attribute values were formatted according to the + normal SQL output behavior, which is sometimes at odds with + XML rules. @@ -452,11 +555,13 @@ do it for earlier branch release files. - This causes SELECT DISTINCT no longer always produces - sorted output; add an ORDER BY clause. The old - SELECT DISTINCT behavior can be restored by disabling - enable_hashagg. SELECT DISTINCT ON does not use - hashing. bjm: enable_hashagg accurate? + This means that these types of queries no longer automatically + produce sorted output. The recommended response is to add an + ORDER BY clause if needed. As a short-term workaround, + the previous behavior can be restored by + disabling enable_hashagg, but that is a very + performance-expensive fix. SELECT DISTINCT ON never + uses hashing. @@ -468,7 +573,7 @@ do it for earlier branch release files. While semi-joins merely replace existing IN joins, anti-joins are a new capability for NOT EXISTS - clauses (Tom) This improves optimization possibilities. + clauses. This improves optimization possibilities. @@ -560,6 +665,29 @@ do it for earlier branch release files. + + + Improve performance of multi-batch hash joins by providing a special + case for join key values that are especially common in the outer + relation (Bryce Cutt, Ramon Lawrence) + + + + + + Reduce volume of temporary data in multi-batch hash joins + by suppressing physical tlist optimization (Michael + Henderson, Ramon Lawrence) + + + + + + Avoid waiting for idle-in-transaction sessions during + CREATE INDEX CONCURRENTLY (Simon) + + + @@ -742,6 +870,18 @@ do it for earlier branch release files. Continuous Archiving + + + Provide an option to pg_start_backup() to force its + implied checkpoint to finish as quickly as possible (Tom) + + + + The default behavior avoids excess I/O consumption, but that is + pointless if no concurrent query activity is going on. + + + Have pg_stop_backup() wait for modified WAL @@ -910,10 +1050,8 @@ do it for earlier branch release files. - Support set-returning functions in the target lists of Agg and - Group plan nodes. This is a pretty ugly feature but since we - don't yet have a plausible substitute, we'd better support it - everywhere (Tom) bjm: details? + Support set-returning functions in the output of aggregation + and grouping queries (Tom) @@ -932,34 +1070,32 @@ do it for earlier branch release files. There are no remote or external SQL/MED capabilities - yet. bjm: accurate? + yet, but this change provides a standardized and future-proof + system for managing connection information for modules like + dblink and plproxy. - Invalidate cached plans when schemas, operators, or operator - classes are modified (Tom) bjm: effect? + Invalidate cached plans when referenced schemas, functions, operators, + or operator classes are modified (Martin Pihlak, Tom) - - - Improve the plan cache invalidation mechanism to make it - invalidate plans when user-defined functions used in a plan - are modified (Tom, Martin Pihlak) bjm: explain + This improves the system's ability to respond to on-the-fly + DDL changes. - Allow comparison of composite types and allow arrays of - possibly-anonymous composite types (Tom) bjm: clear? + anonymous composite types (Tom) - Specifically this allows array[ row(1,2), row(3,4)] - and row(1,1.1) = any (array[ row(7,7.7), row(1,1.0). + Specifically this allows array[row(1,2), row(3,4)] + and row(1,1.1) = any (array[row(7,7.7), row(1,1.0)]). This is particularly useful for recursive queries. @@ -1036,6 +1172,13 @@ do it for earlier branch release files. + + + Make EXPLAIN identify subplans and initplans with + individual labels (Tom) + + + Have EXPLAIN honor debug_print_plan (Tom) @@ -1072,11 +1215,12 @@ do it for earlier branch release files. - Add SQL-standards syntax for + Add SQL-standard syntax for LIMIT/OFFSET capabilities (Peter) + To wit, OFFSET num {ROW|ROWS} FETCH {FIRST|NEXT} [num] {ROW|ROWS} ONLY. @@ -1139,7 +1283,8 @@ do it for earlier branch release files. - This simplifies creation of data types like existing types. + This simplifies creation of data types that use the same internal + representation as an existing type. @@ -1335,8 +1480,19 @@ do it for earlier branch release files. - Special xxx_pattern_ops LIKE indexes can now be - used for simple equality comparisons (Tom) + Implement fast update for GIN indexes (Teodor, Oleg) + + + + This option greatly improves update speed at a small penalty in search + speed. + + + + + + xxx_pattern_ops indexes can now be used for simple + equality comparisons, not only LIKE (Tom) @@ -1381,6 +1537,12 @@ do it for earlier branch release files. + + + Improve support for Nepali language and Devanagari alphabet (Teodor) + + + Support multi-column GIN indexes (Teodor Sigaev) @@ -1506,6 +1668,13 @@ do it for earlier branch release files. + + + Allow spaces around NaN in the input string for + type numeric (Sam Mason) + + + @@ -1949,11 +2118,7 @@ do it for earlier branch release files. Improve the RAISE command: (Pavel Stehule) - - - - @@ -2004,12 +2169,27 @@ do it for earlier branch release files. + + + Make FETCH and MOVE set the + GET DIAGNOSTICS ROW_COUNT variable + (Andrew Gierth) + + + Add message translation support (Alvaro) + + + Avoid memory leakage when the same function is called at varying + exception-block nesting depths (Tom) + + + @@ -2181,12 +2361,14 @@ do it for earlier branch release files. - Have all \d* commands show system objects only - if S is specified (Greg Sabino Mullane) + Make \d* commands that do not have a pattern argument + show system objects only if the S modifier is specified + (Greg Sabino Mullane, Bruce) - \dt already behaved this way. bjm: accuate? + The former behavior was inconsistent across different variants + of \d, and provided no easy way to see just user objects. @@ -2221,6 +2403,20 @@ do it for earlier branch release files. + + + Make \df not hide functions that take or return + type cstring (Tom) + + + + Previously, such functions were hidden because most of them are + datatype I/O functions, which were deemed uninteresting. The new + policy about hiding system functions by default makes this wart + unnecessary. + + + @@ -2240,7 +2436,22 @@ do it for earlier branch release files. - Remove -i/--ignore-version option from + Remove + + + These options were too frequently confused with the option to + select a database name in other PostgreSQL + client applications. The functionality is still available, + but you must spell out the long option name + + + + + + Remove @@ -2261,7 +2472,7 @@ do it for earlier branch release files. Add pg_dump/pg_dumpall option - --lock-wait-timeout (David Gould) + @@ -2411,15 +2622,22 @@ do it for earlier branch release files. + + + Add a PQinitOpenSSL function to allow greater control + over OpenSSL/libcrypto initialization (Andrew Chernow) + + + Properly unregister OpenSSL callbacks when - libpq is done with all connection (Bruce, Magnus, Russell Smith) + libpq is done with all connections (Bruce, Magnus, Russell Smith) - This is required for applications that unload the libpq library - so no invalid OpenSSL callbacks remain. + This is required for applications that unload the libpq library, + otherwise invalid OpenSSL callbacks will remain. @@ -2572,6 +2790,18 @@ do it for earlier branch release files. + + + Use the system's getopt_long() on Solaris + (Zdenek Kotala, Tom) + + + + This makes option processing more consistent with what Solaris users + expect. + + + Add support for the Sun Studio compiler on @@ -2628,6 +2858,13 @@ do it for earlier branch release files. + + + Improve gettext support to allow better translation + of plurals (Peter) + + + Add DTrace probes (Robert Lor) @@ -2648,6 +2885,13 @@ do it for earlier branch release files. + + + Add a relistemp column to pg_class + to ease identification of temporary tables (Tom) + + + Improve logic for shared cache invalidation (Tom) @@ -2656,7 +2900,7 @@ do it for earlier branch release files. - Make name char-aligned (Tom) bjm: pg_upgrade? + Make name char-aligned (Tom) @@ -2784,6 +3028,13 @@ do it for earlier branch release files. + + + Add /contrib/btree_gin to allow GIN indexes to + handle more datatypes (Oleg, Teodor) + + + Add /contrib/citext as a case-insensitive, @@ -2831,6 +3082,20 @@ do it for earlier branch release files. + + + Remove /contrib/intarray's definitions of the + <@ and @> operators (Tom) + + + + This avoids confusion with the equivalent built-in operators. + If necessary, the /contrib/intarray implementations + are still available under their historical names @ + and ~. + + + Add /contrib/auto_explain to automatically run -- 2.39.5