Re: [HACKERS] [patch] gsoc, improving hash index v2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Xiao Meng wrote: > Hi, hackers. Here is some test I run on a bigger set. > > The time of the two index is > btree: 1/0.174700=5.00250125 > hash-patch: 1/0.199900=5.724098 Just to bring it to attention of everybody: btree: 1/0.174700=5.724098 hash-pat

Re: [HACKERS] [patch] gsoc, improving hash index v2

sorry, I made some mistake here. The time of the script on two indexes should be btree: 1/0.174700=5.724098s hash-patch: 1/0.199900=5.00250125s On Wed, Aug 6, 2008 at 9:33 AM, Xiao Meng <[EMAIL PROTECTED]> wrote: > Hi, hackers. Here is some test I run on a bigger set. > > Use a word list of 3991

Re: [HACKERS] [patch] gsoc, improving hash index v2

Hi, hackers. Here is some test I run on a bigger set. Use a word list of 39916800 unique words The table size is 1529MB. Index BuildTimeIndexSize btree 874470.339ms 1027MB hash-patch 513026.381 ms 1024MB I use pgbench to test the time of a cust

[HACKERS] [patch] gsoc, improving hash index v2

Hi, hackers. I've post a hash patch in a previous thread http://archives.postgresql.org/pgsql-hackers/2008-07/msg00794.php I do apologize for the bad readability of previous patch. Thank you all for your comments. Here is a new patch which fixed some bugs in the previous one. I post it here to get