Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit1a99847

Browse files
committed
Update 9.1 release notes to reflect commits through today.
Also do another pass of copy-editing.
1 parent2dada0c commit1a99847

File tree

1 file changed

+99
-52
lines changed

1 file changed

+99
-52
lines changed

‎doc/src/sgml/release-9.1.sgml

Lines changed: 99 additions & 52 deletions
Original file line numberDiff line numberDiff line change
@@ -9,33 +9,25 @@
99
<simpara>2011-??-??</simpara>
1010
</note>
1111

12-
<para>CURRENT AS OF 2011-07-07</para>
12+
<para>CURRENT AS OF 2011-08-17</para>
1313

1414
<sect2>
1515
<title>Overview</title>
1616

1717
<para>
1818
This release shows <productname>PostgreSQL</> moving beyond the
19-
traditional relational feature set with new, ground-breaking
19+
traditional relational-database feature set with new, ground-breaking
2020
functionality that is unique to <productname>PostgreSQL</>.
21-
Additionally, this release improves streaming replication by adding
22-
a synchronous option and monitoring improvements. Major enhancements
23-
include:
21+
The streaming replication feature introduced in release 9.0 is
22+
significantly enhanced by adding a synchronous-replication option,
23+
streaming backups, and monitoring improvements.
24+
Major enhancements include:
2425
</para>
2526

2627
<itemizedlist>
2728

2829
<!-- This list duplicates items below, but without authors or details-->
2930

30-
<listitem>
31-
<para>
32-
Support unlogged tables using the <link
33-
linkend="SQL-CREATETABLE-description"><literal>UNLOGGED</></link>
34-
option in <link linkend="SQL-CREATETABLE"><command>CREATE
35-
TABLE</></link>
36-
</para>
37-
</listitem>
38-
3931
<listitem>
4032
<para>
4133
Allow <link linkend="synchronous-replication">synchronous
@@ -59,16 +51,23 @@
5951

6052
<listitem>
6153
<para>
62-
Adda<link linkend="SQL-SECURITY-LABEL"><command>SECURITY
63-
LABEL</></link> command
54+
Add <link linkend="extend-extensions">extensions</link> which
55+
simplify packaging of additions to <productname>PostgreSQL</>
6456
</para>
6557
</listitem>
6658

6759
<listitem>
6860
<para>
6961
Add a true <link
70-
linkend="xact-serializable">serializable</link> isolation
71-
level
62+
linkend="xact-serializable">serializable isolation level</link>
63+
</para>
64+
</listitem>
65+
66+
<listitem>
67+
<para>
68+
Support unlogged tables using the <literal>UNLOGGED</>
69+
option in <link linkend="SQL-CREATETABLE"><command>CREATE
70+
TABLE</></link>
7271
</para>
7372
</listitem>
7473

@@ -89,8 +88,9 @@
8988

9089
<listitem>
9190
<para>
92-
Add <link linkend="extend-extensions">extensions</link> which
93-
simplify packaging of additions to <productname>PostgreSQL</>
91+
Add a <link linkend="SQL-SECURITY-LABEL"><command>SECURITY
92+
LABEL</></link> command and support for
93+
<link linkend="sepgsql"><acronym>SELinux</> permissions control</link>
9494
</para>
9595
</listitem>
9696

@@ -146,6 +146,17 @@
146146
strings are the proper way to embed backslash escapes in strings and are
147147
unaffected by this change.
148148
</para>
149+
150+
<warning>
151+
<para>
152+
This change can break applications that are not expecting it and
153+
do their own string escaping according to the old rules. The
154+
consequences could be as severe as introducing SQL-injection security
155+
holes. Be sure to test applications that are exposed to untrusted
156+
input, to ensure that they correctly handle single quotes and
157+
backslashes in text strings.
158+
</para>
159+
</warning>
149160
</listitem>
150161

151162
</itemizedlist>
@@ -383,7 +394,8 @@
383394

384395
<listitem>
385396
<para>
386-
Treat <application>ECPG</> cursor names as case-insensitive (Zoltan Boszormenyi)
397+
Treat <application>ECPG</> cursor names as case-insensitive
398+
(Zoltan Boszormenyi)
387399
</para>
388400
</listitem>
389401

@@ -394,9 +406,12 @@
394406

395407
<sect2>
396408
<title>Changes</title>
397-
<para>
398-
Version 9.1 has ...
399-
</para>
409+
410+
<para>
411+
Below you will find a detailed account of the changes between
412+
<productname>PostgreSQL</productname> 9.1 and the previous major
413+
release.
414+
</para>
400415

401416
<sect3>
402417
<title>Server</title>
@@ -408,8 +423,7 @@
408423

409424
<listitem>
410425
<para>
411-
Support unlogged tables using the <link
412-
linkend="SQL-CREATETABLE-description"><literal>UNLOGGED</></link>
426+
Support unlogged tables using the <literal>UNLOGGED</>
413427
option in <link linkend="SQL-CREATETABLE"><command>CREATE
414428
TABLE</></link> (Robert Haas)
415429
</para>
@@ -440,8 +454,11 @@
440454

441455
<listitem>
442456
<para>
443-
Merge duplicate fsync requests on busy systems (Robert Haas,
444-
Greg Smith)
457+
Merge duplicate fsync requests (Robert Haas, Greg Smith)
458+
</para>
459+
460+
<para>
461+
This greatly improves performance under heavy write loads.
445462
</para>
446463
</listitem>
447464

@@ -584,7 +601,9 @@
584601
</para>
585602

586603
<para>
587-
The old term is still accepted for backward compatibility.
604+
The old term is still accepted for backward compatibility, but since
605+
the two methods are fundamentally different, it seemed better to adopt
606+
different names for them.
588607
</para>
589608
</listitem>
590609

@@ -634,6 +653,18 @@
634653
</para>
635654
</listitem>
636655

656+
<listitem>
657+
<para>
658+
Reduce the default maximum line length for <application>syslog</>
659+
logging to 900 bytes plus prefixes (Noah Misch)
660+
</para>
661+
662+
<para>
663+
This avoids truncation of long log lines on syslog implementations
664+
that have a 1KB length limit, rather than the more common 2KB.
665+
</para>
666+
</listitem>
667+
637668
</itemizedlist>
638669

639670
</sect4>
@@ -1000,8 +1031,8 @@
10001031
</para>
10011032

10021033
<para>
1003-
This allows external cluster management software totakecontrol
1004-
ofwhetherservers restart or not.
1034+
This allows external cluster management software to control
1035+
whetherthe database server restarts or not.
10051036
</para>
10061037
</listitem>
10071038

@@ -1032,8 +1063,8 @@
10321063
<listitem>
10331064
<para>
10341065
Add a true <link
1035-
linkend="xact-serializable">serializable</link> isolation
1036-
level(Kevin Grittner, Dan Ports)
1066+
linkend="xact-serializable">serializable isolation level</link>
1067+
(Kevin Grittner, Dan Ports)
10371068
</para>
10381069

10391070
<para>
@@ -1444,11 +1475,11 @@
14441475
<listitem>
14451476
<para>
14461477
Prevent <link linkend="autovacuum">autovacuum</link> from
1447-
waiting if it cannot acquire a lock (Robert Haas)
1478+
waiting if it cannot acquire atablelock (Robert Haas)
14481479
</para>
14491480

14501481
<para>
1451-
It will try to vacuum later.
1482+
It will try to vacuumthat tablelater.
14521483
</para>
14531484
</listitem>
14541485

@@ -1486,6 +1517,12 @@
14861517
<para>
14871518
This allows <acronym>GiST</> indexes to quickly return the
14881519
<replaceable>N</> closest values in a query with <literal>LIMIT</>.
1520+
For example
1521+
<programlisting><![CDATA[
1522+
SELECT * FROM places ORDER BY location <-> point '(101,456)' LIMIT 10;
1523+
]]>
1524+
</programlisting>
1525+
finds the ten places closest to a given target point.
14891526
</para>
14901527
</listitem>
14911528

@@ -1851,7 +1888,7 @@
18511888
<listitem>
18521889
<para>
18531890
Add <link linkend="plpgsql-foreach-array"><command>FOREACH IN
1854-
ARRAY</></link> to<link linkend="plpgsql">PL/pgSQL</link>
1891+
ARRAY</></link> to PL/pgSQL
18551892
(Pavel Stehule)
18561893
</para>
18571894

@@ -1962,7 +1999,7 @@
19621999

19632000
<listitem>
19642001
<para>
1965-
AddPL/Pythonexplicit subtransactions (Jan Urbanski)
2002+
Add explicit subtransactions to PL/Python (Jan Urbanski)
19662003
</para>
19672004
</listitem>
19682005

@@ -2055,7 +2092,7 @@
20552092

20562093
<listitem>
20572094
<para>
2058-
Add <option>S</> (<quote>system</>) option to <application>psql</>'s
2095+
Addthe<option>S</> (<quote>system</>) option to <application>psql</>'s
20592096
<literal>\dn</> (list schemas) command (Tom Lane)
20602097
</para>
20612098

@@ -2207,7 +2244,8 @@
22072244

22082245
<listitem>
22092246
<para>
2210-
Add a libpq connection option <literal>client_encoding</>
2247+
Add a libpq connection option <link
2248+
linkend="libpq-connect-client-encoding"><literal>client_encoding</></link>
22112249
which behaves like the <envar>PGCLIENTENCODING</> environment
22122250
variable (Heikki Linnakangas)
22132251
</para>
@@ -2234,10 +2272,11 @@
22342272

22352273
<listitem>
22362274
<para>
2237-
Allow libpq database clients to
2238-
check the user name of the server process using <link
2275+
Allow libpq-using clients to
2276+
check the user name of the server process
2277+
when connecting via Unix-domain sockets, with the new <link
22392278
linkend="libpq-connect-requirepeer"><literal>requirepeer</></link>
2240-
when connecting via Unix-domain sockets
2279+
connection option
22412280
(Peter Eisentraut)
22422281
</para>
22432282

@@ -2272,8 +2311,16 @@
22722311

22732312
<listitem>
22742313
<para>
2275-
Allow ECPG to accept dynamic cursor names even in
2276-
<literal>WHERE CURRENT OF</literal> clauses
2314+
Allow ECPG to accept dynamic cursor names even in
2315+
<literal>WHERE CURRENT OF</literal> clauses
2316+
(Zoltan Boszormenyi)
2317+
</para>
2318+
</listitem>
2319+
2320+
<listitem>
2321+
<para>
2322+
Make <application>ecpglib</> write <type>double</> values with a
2323+
precision of 15 digits, not 14 as formerly (Akira Kurosawa)
22772324
</para>
22782325
</listitem>
22792326

@@ -2422,8 +2469,8 @@
24222469

24232470
<listitem>
24242471
<para>
2425-
Add latches to the source code towait for events (Heikki
2426-
Linnakangas)
2472+
Add latches to the source code tosupport waiting for events (Heikki
2473+
Linnakangas)
24272474
</para>
24282475
</listitem>
24292476

@@ -2561,7 +2608,7 @@
25612608

25622609
<listitem>
25632610
<para>
2564-
Add nearest-neighbor support to <link
2611+
Add nearest-neighborsearchsupport to <link
25652612
linkend="pgtrgm"><filename>contrib/pg_trgm</></link> and <link
25662613
linkend="btree-gist"><filename>contrib/btree_gist</></link>
25672614
(Teodor Sigaev)
@@ -2672,7 +2719,7 @@
26722719
<listitem>
26732720
<para>
26742721
Add <link linkend="sepgsql"><filename>contrib/sepgsql</></link>
2675-
to interface permission checks with <acronym>SE</>-Linux (KaiGai Kohei)
2722+
to interface permission checks with <acronym>SELinux</> (KaiGai Kohei)
26762723
</para>
26772724

26782725
<para>
@@ -2698,7 +2745,7 @@
26982745

26992746
<listitem>
27002747
<para>
2701-
Add <link linkend="dummy-seclabel">dummy_seclabel</link>
2748+
Add <link linkend="dummy-seclabel"><filename>dummy_seclabel</></link>
27022749
contrib module (KaiGai Kohei)
27032750
</para>
27042751

@@ -2808,8 +2855,8 @@
28082855

28092856
<listitem>
28102857
<para>
2811-
Extensive <link linkend="ecpg"><application>ECPG</> documentation</link>
2812-
improvements (Satoshi Nagayasu)
2858+
Extensive <link linkend="ecpg"><application>ECPG</></link>
2859+
documentationimprovements (Satoshi Nagayasu)
28132860
</para>
28142861
</listitem>
28152862

@@ -2864,7 +2911,7 @@
28642911

28652912
<listitem>
28662913
<para>
2867-
Mergedocs for <command>CREATE CONSTRAINT TRIGGER</> and <link
2914+
Mergedocumentation for <command>CREATE CONSTRAINT TRIGGER</> and <link
28682915
linkend="SQL-CREATETRIGGER"><command>CREATE TRIGGER</></link>
28692916
(Alvaro Herrera)
28702917
</para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp