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

Commitfc6a229

Browse files
committed
Add UPDATE entry for row reuse.
>> * Allow heap reuse of UPDATEd rows if old and new versions are on the> same heap page?>> This is possible for same-page updates because a single index row> can point to both old and new values.>http://archives.postgresql.org/pgsql-hackers/2006-06/msg01305.php
1 parent50aa69a commitfc6a229

File tree

2 files changed

+15
-2
lines changed

2 files changed

+15
-2
lines changed

‎doc/TODO

Lines changed: 8 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer:Bruce Momjian (bruce@momjian.us)
5-
Last updated:Sun Jun18 15:32:30 EDT 2006
5+
Last updated:Sat Jun24 19:44:48 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -1131,6 +1131,13 @@ Vacuum
11311131

11321132
http://archives.postgresql.org/pgsql-patches/2006-03/msg00142.php
11331133

1134+
* Allow heap reuse of UPDATEd rows if old and new versions are on the
1135+
same heap page?
1136+
1137+
This is possible for same-page updates because a single index row
1138+
can point to both old and new values.
1139+
http://archives.postgresql.org/pgsql-hackers/2006-06/msg01305.php
1140+
11341141
* Auto-vacuum
11351142

11361143
o Use free-space map information to guide rfilling

‎doc/src/FAQ/TODO.html

Lines changed: 7 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">
99
<h1><aname="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
11-
Last updated:Sun Jun18 15:32:30 EDT 2006
11+
Last updated:Sat Jun24 19:44:48 EDT 2006
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -1019,6 +1019,12 @@ <h1><a name="section_16">Vacuum</a></h1>
10191019
in maintaining clustering?
10201020
</li><li>Consider shrinking expired tuples to just their headers
10211021
<p><ahref="http://archives.postgresql.org/pgsql-patches/2006-03/msg00142.php">http://archives.postgresql.org/pgsql-patches/2006-03/msg00142.php</a>
1022+
</p>
1023+
</li><li>Allow heap reuse of UPDATEd rows if old and new versions are on the
1024+
same heap page?
1025+
<p> This is possible for same-page updates because a single index row
1026+
can point to both old and new values.
1027+
<ahref="http://archives.postgresql.org/pgsql-hackers/2006-06/msg01305.php">http://archives.postgresql.org/pgsql-hackers/2006-06/msg01305.php</a>
10221028
</p>
10231029
</li><li>Auto-vacuum
10241030
<ul>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp