[HACKERS] Building Hash Index by Presorting Tuples

2007-07-30 Thread twraney
Hi, We are trying to sort the index tuples before inserting them into hash buckets, to improve build speed. Here is our plan: 1. Build a spool that contains all the index tuples to be inserted into the buckets. - this is done. 2. sort the index tuples in the spool according to the bucket

[HACKERS] todo: Hash index creation

2007-06-27 Thread twraney
Is anyone currently working on this TODO item? During index creation, pre-sort the tuples to improve build speed http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php A few of us would like to tackle it and see if we can add some value here. Tom, Shreya