1- <!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.478 2006/10/21 18:15:44 momjian Exp $ -->
1+ <!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.479 2006/10/21 18:41:53 tgl Exp $ -->
22<!--
33
44Typical markup:
@@ -279,7 +279,7 @@ links to the main documentation.
279279
280280 <para>
281281 This changes the previous behavior where concatenation
282- would adjust the lower array dimensions .
282+ would modify the array lower bound .
283283 </para>
284284 </listitem>
285285
@@ -459,19 +459,26 @@ links to the main documentation.
459459
460460 <listitem>
461461 <para>
462- Improve efficiency of <link
463- linkend="functions-comparisons"><literal>IN</>
464- (list-of-expressions)</link> clauses (Tom)
462+ Allow the planner to reorder <link linkend="queries-join">outer
463+ joins</link> in some circumstances (Tom)
464+ </para>
465+
466+ <para>
467+ In previous releases, outer joins would always be evaluated in
468+ the order written in the query. This change allows the
469+ query optimizer to consider reordering outer joins, in cases where
470+ it can determine that the join order can be changed without
471+ altering the meaning of the query. This can make a
472+ considerable performance difference for queries involving
473+ multiple outer joins or mixed inner and outer joins.
465474 </para>
466475 </listitem>
467476
468477 <listitem>
469478 <para>
470- Increase default values for <link
471- linkend="guc-shared-buffers"><varname>shared_buffers</></link>
472- and <link
473- linkend="guc-max-fsm-pages"><varname>max_fsm_pages</></link>
474- (Andrew)
479+ Improve efficiency of <link
480+ linkend="functions-comparisons"><literal>IN</>
481+ (list-of-expressions)</link> clauses (Tom)
475482 </para>
476483 </listitem>
477484
@@ -503,6 +510,16 @@ links to the main documentation.
503510 </para>
504511 </listitem>
505512
513+ <listitem>
514+ <para>
515+ Increase default values for <link
516+ linkend="guc-shared-buffers"><varname>shared_buffers</></link>
517+ and <link
518+ linkend="guc-max-fsm-pages"><varname>max_fsm_pages</></link>
519+ (Andrew)
520+ </para>
521+ </listitem>
522+
506523 <listitem>
507524 <para>
508525 Improve locking performance by breaking the lock manager tables into
@@ -532,28 +549,11 @@ links to the main documentation.
532549
533550 <listitem>
534551 <para>
535- Allow the planner to reorder <link linkend="queries-join">outer
536- joins</link> in some circumstances (Tom)
537- </para>
538-
539- <para>
540- In previous releases, outer joins would always be evaluated in
541- the order written in the query. This change allows the
542- query optimizer to consider reordering outer joins, in cases where
543- it can determine that the join order can be changed without
544- altering the meaning of the query. This can make a
545- considerable performance difference for queries involving
546- multiple outer joins or mixed inner and outer joins.
547- </para>
548- </listitem>
549-
550- <listitem>
551- <para>
552- Improve the optimizer statistics used by <link
552+ Improve the optimizer's selectivity estimates for <link
553553 linkend="functions-like"><literal>LIKE</></link>, <link
554554 linkend="functions-like"><literal>ILIKE</></link>, and
555- <link linkend="functions-posix-regexp">regular expression
556- operations</link> (Tom)
555+ <link linkend="functions-posix-regexp">regular expression</link>
556+ operations (Tom)
557557 </para>
558558 </listitem>
559559
@@ -1136,7 +1136,8 @@ links to the main documentation.
11361136 </para>
11371137
11381138 <para>
1139- This allows the new table to receive matching constraints.
1139+ This allows easy copying of <literal>CHECK</> constraints to a new
1140+ table.
11401141 </para>
11411142 </listitem>
11421143
@@ -1270,10 +1271,10 @@ links to the main documentation.
12701271 <para>
12711272 Previously, comments attached to databases were stored in individual
12721273 databases, making them ineffective, and there was no provision
1273- at all for comments on roles. This change adds a new
1274- <link
1274+ at all for comments on roles or tablespaces . This change adds a new
1275+ shared catalog <link
12751276 linkend="catalog-pg-shdescription"><structname>pg_shdescription</structname></link>
1276- system catalog and stores comments on databases and roles therein.
1277+ and stores comments on databases, roles, and tablespaces therein.
12771278 </para>
12781279 </listitem>
12791280
@@ -1628,8 +1629,14 @@ links to the main documentation.
16281629
16291630 <listitem>
16301631 <para>
1631- Add <literal>table_name</> and <literal>table_schema</> as
1632- trigger data (Andrew)
1632+ Add <literal>TG_table_name</> and <literal>TG_table_schema</> to
1633+ trigger parameters (Andrew)
1634+ </para>
1635+
1636+ <para>
1637+ <literal>TG_relname</> is now deprecated. Comparable
1638+ changes have been made in the trigger parameters for the other
1639+ PLs as well.
16331640 </para>
16341641 </listitem>
16351642
@@ -1671,12 +1678,8 @@ links to the main documentation.
16711678
16721679 <listitem>
16731680 <para>
1674- Add <literal>table_name</> and <literal>table_schema</> as
1675- trigger data (Adam Sjøgren)
1676- </para>
1677-
1678- <para>
1679- <literal>relname</> is kept but now deprecated.
1681+ Add <literal>table_name</> and <literal>table_schema</> to
1682+ trigger parameters (Adam Sjøgren)
16801683 </para>
16811684 </listitem>
16821685
@@ -1697,14 +1700,6 @@ links to the main documentation.
16971700 </para>
16981701 </listitem>
16991702
1700- <listitem>
1701- <para>
1702- Honor <link
1703- linkend="guc-check-function-bodies"><varname>check_function_bodies</></link>
1704- (Tom)
1705- </para>
1706- </listitem>
1707-
17081703 </itemizedlist>
17091704
17101705 </sect3>
@@ -1715,34 +1710,34 @@ links to the main documentation.
17151710
17161711 <listitem>
17171712 <para>
1718- Add <literal>table_name</> and <literal>table_schema</> as
1719- trigger data (Andrew )
1713+ Named parameters are passed as ordinary variables, as well as in the
1714+ <literal>args[]</> array (Sven Suursoho )
17201715 </para>
17211716 </listitem>
17221717
17231718 <listitem>
17241719 <para>
1725- Allow returning of composite types and result sets (Sven Suursoho)
1720+ Add <literal>table_name</> and <literal>table_schema</> to
1721+ trigger parameters (Andrew)
17261722 </para>
17271723 </listitem>
17281724
17291725 <listitem>
17301726 <para>
1731- Return result-set as <literal>list</>, <literal>iterator</>,
1732- or <literal>generator </>(Sven Suursoho)
1727+ Allow returning of composite types and result sets (Sven Suursoho)
17331728 </para>
17341729 </listitem>
17351730
17361731 <listitem>
17371732 <para>
1738- Allow functions to return <literal>void</> (Neil)
1733+ Return result-set as <literal>list</>, <literal>iterator</>,
1734+ or <literal>generator </>(Sven Suursoho)
17391735 </para>
17401736 </listitem>
17411737
17421738 <listitem>
17431739 <para>
1744- Add named parameters to the <literal>args[]</> array (Sven
1745- Suursoho)
1740+ Allow functions to return <literal>void</> (Neil)
17461741 </para>
17471742 </listitem>
17481743
@@ -2114,8 +2109,7 @@ links to the main documentation.
21142109
21152110 <listitem>
21162111 <para>
2117- Improve ability to relocate installs in more complex
2118- configurations (Tom)
2112+ Improve ability to relocate installation directories (Tom)
21192113 </para>
21202114 </listitem>
21212115
0 commit comments