Re: [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 <mx(dot)cogito(at)gmail(dot)com> wrote:

> 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 BuildTime IndexSize
> ---- ---- ----
> btree 874470.339ms 1027MB
> hash-patch 513026.381 ms 1024MB
>
> I use pgbench to test the time of a custom query script.
> There are 2000 statements in the script.
> It looks like this:
> select * from dict where word='123456789a0'
> ...
> The time of the two index is
> btree: 1/0.174700=5.00250125
> hash-patch: 1/0.199900=5.724098
>
> ---------------btree------------------
> $ pgbench -n -f /tmp/query.sql dict
> transaction type: Custom query
> scaling factor: 1
> query mode: simple
> number of clients: 1
> number of transactions per client: 10
> number of transactions actually processed: 10/10
> tps = 0.174694 (including connections establishing)
> tps = 0.174700 (excluding connections establishing)
>
> ---------------hash patch-------------
> $ pgbench -n -f /tmp/query.sql dict
> transaction type: Custom query
> scaling factor: 1
> query mode: simple
> number of clients: 1
> number of transactions per client: 10
> number of transactions actually processed: 10/10
> tps = 0.199892 (including connections establishing)
> tps = 0.199900 (excluding connections establishing)
>
> --
> Best Regards,
> Xiao Meng
>
> DKERC, Harbin Institute of Technology, China
> Gtalk: mx(dot)cogito(at)gmail(dot)com
> MSN: cnEnder(at)live(dot)com
> http://xiaomeng.yo2.cn
>

--
Best Regards,
Xiao Meng

DKERC, Harbin Institute of Technology, China
Gtalk: mx(dot)cogito(at)gmail(dot)com
MSN: cnEnder(at)live(dot)com
http://xiaomeng.yo2.cn