Skip to content

Commit 890ce39

Browse files
committed
Further release-note editorialization.
1 parent 425417d commit 890ce39

File tree

1 file changed

+54
-60
lines changed

1 file changed

+54
-60
lines changed

doc/src/sgml/release.sgml

Lines changed: 54 additions & 60 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
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

44
Typical 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&oslash;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&oslash;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

Comments
 (0)