From 2b49e5d3cb8b6a71797969c50f5c247f232de989 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 21 Mar 2007 21:25:46 +0000 Subject: [PATCH] Add: < < > o During index creation, pre-sort the tuples to improve build speed > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php > --- doc/TODO | 8 +++++--- doc/src/FAQ/TODO.html | 5 ++++- 2 files changed, 9 insertions(+), 4 deletions(-) diff --git a/doc/TODO b/doc/TODO index 40ffbf6bd7..9ccb45eee3 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 3625a87bb3..9c76929af5 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,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. @@ -921,6 +921,9 @@ first. There is also a developer's wiki at
of the key itself

  • Add WAL logging for crash recovery
  • Allow multi-column hash indexes +
  • During index creation, pre-sort the tuples to improve build speed +

    http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php +

    • Fsync

    -- 2.40.0