summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian2007-03-21 21:25:46 +0000
committerBruce Momjian2007-03-21 21:25:46 +0000
commit2b49e5d3cb8b6a71797969c50f5c247f232de989 (patch)
tree2ff4e4dfd4416e23c07964a3d90d4c19d13e559d
parent5fc7ba76dd7e8e599cacf8392e2e5fc12a5a02d3 (diff)
Add:
< < > o During index creation, pre-sort the tuples to improve build speed > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php >
-rw-r--r--doc/TODO8
-rw-r--r--doc/src/FAQ/TODO.html5
2 files changed, 9 insertions, 4 deletions
diff --git a/doc/TODO b/doc/TODO
index 40ffbf6bd7b..9ccb45eee3b 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -2,7 +2,7 @@
PostgreSQL TODO List
====================
Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Wed Mar 21 17:21:13 EDT 2007
+Last updated: Wed Mar 21 17:25:43 EDT 2007
The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -1031,12 +1031,14 @@ Indexes
o Consider sorting hash buckets so entries can be found using a
binary search, rather than a linear scan
-
o In hash indexes, consider storing the hash value with or instead
of the key itself
-
o Add WAL logging for crash recovery
o Allow multi-column hash indexes
+ o During index creation, pre-sort the tuples to improve build speed
+
+ http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php
+
Fsync
diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html
index 3625a87bb39..9c76929af55 100644
--- a/doc/src/FAQ/TODO.html
+++ b/doc/src/FAQ/TODO.html
@@ -8,7 +8,7 @@
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
<p>Current maintainer: Bruce Momjian (<a href="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>
-Last updated: Wed Mar 21 17:21:13 EDT 2007
+Last updated: Wed Mar 21 17:25:43 EDT 2007
</p>
<p>The most recent version of this document can be viewed at<br/>
<a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -921,6 +921,9 @@ first. There is also a developer's wiki at<br/>
of the key itself
</li><li>Add WAL logging for crash recovery
</li><li>Allow multi-column hash indexes
+ </li><li>During index creation, pre-sort the tuples to improve build speed
+<p> <a href="http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php">http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php</a>
+</p>
</li></ul>
</li></ul>
<h1><a name="section_13">Fsync</a></h1>