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

Commit708c111

Browse files
committed
Updates from Tom Lane.
1 parentcf6dbd8 commit708c111

File tree

2 files changed

+25
-17
lines changed

2 files changed

+25
-17
lines changed

‎HISTORY‎

Lines changed: 12 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -15,9 +15,10 @@ With WAL, only one log file must be flushed to disk, greatly improving
1515
performance. If you have been using -F in previous releases to disable
1616
disk flushes, you may want to consider discontinuing its use.
1717

18-
TOAST - Previous releases had an 8k (or 32k) row length limit.
19-
This limit made storage of long text fields difficult. With TOAST, long
20-
rows of any length can be stored with good performance.
18+
TOAST - Previous releases had a compiled-in row length limit,
19+
typically 8k - 32k. This limit made storage of long text fields
20+
difficult. With TOAST, long rows of any length can be stored with good
21+
performance.
2122

2223
Outer Joins - We now support outer joins. The UNION/NOT IN
2324
workaround for outer joins is no longer required. We use the SQL92
@@ -73,13 +74,13 @@ Allow UNION/INTERSECT/EXCEPT to be used with ALL, subqueries, views,
7374
Fix parser failures during aborted transactions (Tom)
7475
Allow temporary relations to properly clean up indexes (Bruce)
7576
Fix VACUUM problem with moving rows in same page (Tom)
76-
Modify pg_dumpso it dumps onlyuser-defined items, not system-defined (Philip)
77+
Modify pg_dumpto better handleuser-defined items in template1 (Philip)
7778
Allow LIMIT in VIEW (Tom)
7879
Require cursor FETCH to honor LIMIT (Tom)
7980
Allow PRIMARY/FOREIGN Key definitions on inherited columns (Stephan)
8081
Allow ORDER BY, LIMIT in sub-selects (Tom)
8182
Allow UNION in CREATE RULE (Tom)
82-
Make DROP TABLE rollback-able (Tom)
83+
MakeALTER/DROP TABLE rollback-able (Vadim,Tom)
8384
Store initdb collation in pg_control so collation cannot be changed (Tom)
8485
Fix INSERT...SELECT with rules (Tom)
8586
Fix FOR UPDATE inside views and subselects (Tom)
@@ -151,7 +152,6 @@ Allow postmaster to listen on a specific IP address (David J. MacKenzie)
151152
Allow socket path name to be specified in hostname by using leading slash
152153
(David J. MacKenzie)
153154
Allow CREATE DATABASE to specify template database (Tom)
154-
New template0 database that contains no user additions(Tom)
155155

156156
Types
157157
-----
@@ -161,6 +161,7 @@ Allow BIGINT as synonym for INT8 (Peter E)
161161
New int2 and int8 comparison operators (Tom)
162162
New BIT and BIT VARYING types (Adriaan Joubert, Tom)
163163
CHAR() no longer faster than VARCHAR() because of TOAST (Tom)
164+
New GIST seg/cube examples (Gene Selkov)
164165

165166
Performance
166167
-----------
@@ -179,7 +180,7 @@ SGI portability fixes (David Kaelbling)
179180
New configure --enable-syslog option (Marc)
180181
New BSDI README (Bruce)
181182
configure script moved to top level, not /src (Peter E)
182-
Makefile/configuration/compilationcleanups (Peter E)
183+
Makefile/configuration/compilationoverhaul (Peter E)
183184
New configure --with-python option (Peter E)
184185
Solaris cleanups (Peter E)
185186
Overhaul /contrib Makefiles (Karel)
@@ -196,10 +197,13 @@ New BeOS port (David Reid, Cyril Velter)
196197
Add proofreader's changes to docs (Addison-Wesley, Bruce)
197198
New Alpha spinlock code (Adriaan Joubert, Compaq)
198199
Unixware port overhaul (Peter E)
199-
New Darwin/Mac OSX port (Bruce Hartzler)
200+
New Darwin/Mac OSX port (Peter Bierman,Bruce Hartzler)
200201
New FreeBSD Alpha port (Alfred)
201202
Overhaul shared memory segments (Tom)
202203
Add IBM S/390 support (Neale Ferguson)
204+
Moved macmanuf to /contrib (Larry Rosenman)
205+
Syslog improvements (Larry Rosenman)
206+
New template0 database that contains no user additions(Tom)
203207

204208

205209

‎doc/src/sgml/release.sgml‎

Lines changed: 13 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.64 2000/12/1620:12:42 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.65 2000/12/18 04:20:44 momjian Exp $
33
-->
44

55
<chapter id="release">
@@ -51,9 +51,10 @@ disk flushes, you may want to consider discontinuing its use.
5151
</term>
5252
<listitem>
5353
<para>
54-
Previous releases had an 8k (or 32k) row length limit.
55-
This limit made storage of long text fields difficult. With TOAST, long
56-
rows of any length can be stored with good performance.
54+
TOAST - Previous releases had a compiled-in row length limit,
55+
typically 8k - 32k. This limit made storage of long text fields
56+
difficult. With TOAST, long rows of any length can be stored with good
57+
performance.
5758
</para>
5859
</listitem>
5960
</varlistentry>
@@ -149,13 +150,13 @@ Allow UNION/INTERSECT/EXCEPT to be used with ALL, subqueries, views,
149150
Fix parser failures during aborted transactions (Tom)
150151
Allow temporary relations to properly clean up indexes (Bruce)
151152
Fix VACUUM problem with moving rows in same page (Tom)
152-
Modify pg_dumpso it dumps onlyuser-defined items, not system-defined (Philip)
153+
Modify pg_dumpto better handleuser-defined items in template1 (Philip)
153154
Allow LIMIT in VIEW (Tom)
154155
Require cursor FETCH to honor LIMIT (Tom)
155156
Allow PRIMARY/FOREIGN Key definitions on inherited columns (Stephan)
156157
Allow ORDER BY, LIMIT in sub-selects (Tom)
157158
Allow UNION in CREATE RULE (Tom)
158-
Make DROP TABLE rollback-able (Tom)
159+
MakeALTER/DROP TABLE rollback-able (Vadim,Tom)
159160
Store initdb collation in pg_control so collation cannot be changed (Tom)
160161
Fix INSERT...SELECT with rules (Tom)
161162
Fix FOR UPDATE inside views and subselects (Tom)
@@ -227,7 +228,6 @@ Allow postmaster to listen on a specific IP address (David J. MacKenzie)
227228
Allow socket path name to be specified in hostname by using leading slash
228229
(David J. MacKenzie)
229230
Allow CREATE DATABASE to specify template database (Tom)
230-
New template0 database that contains no user additions(Tom)
231231

232232
Types
233233
-----
@@ -237,6 +237,7 @@ Allow BIGINT as synonym for INT8 (Peter E)
237237
New int2 and int8 comparison operators (Tom)
238238
New BIT and BIT VARYING types (Adriaan Joubert, Tom)
239239
CHAR() no longer faster than VARCHAR() because of TOAST (Tom)
240+
New GIST seg/cube examples (Gene Selkov)
240241

241242
Performance
242243
-----------
@@ -255,7 +256,7 @@ SGI portability fixes (David Kaelbling)
255256
New configure --enable-syslog option (Marc)
256257
New BSDI README (Bruce)
257258
configure script moved to top level, not /src (Peter E)
258-
Makefile/configuration/compilationcleanups (Peter E)
259+
Makefile/configuration/compilationoverhaul (Peter E)
259260
New configure --with-python option (Peter E)
260261
Solaris cleanups (Peter E)
261262
Overhaul /contrib Makefiles (Karel)
@@ -272,10 +273,13 @@ New BeOS port (David Reid, Cyril Velter)
272273
Add proofreader's changes to docs (Addison-Wesley, Bruce)
273274
New Alpha spinlock code (Adriaan Joubert, Compaq)
274275
Unixware port overhaul (Peter E)
275-
New Darwin/Mac OSX port (Bruce Hartzler)
276+
New Darwin/Mac OSX port (Peter Bierman,Bruce Hartzler)
276277
New FreeBSD Alpha port (Alfred)
277278
Overhaul shared memory segments (Tom)
278279
Add IBM S/390 support (Neale Ferguson)
280+
Moved macmanuf to /contrib (Larry Rosenman)
281+
Syslog improvements (Larry Rosenman)
282+
New template0 database that contains no user additions(Tom)
279283
</programlisting>
280284
</para>
281285
</sect2>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp