Postgres Pro
Downloads
Home   >   mailing lists

Re: [patch] gsoc, improving hash index v2 - Mailing list pgsql-hackers

From Jens-Wolfhard Schicke
Subject Re: [patch] gsoc, improving hash index v2
Date
Msg-id 4899011F.1040403@gmx.de
Whole thread Raw
In response to Re: [patch] gsoc, improving hash index v2  ("Xiao Meng" <mx.cogito@gmail.com>)
List pgsql-hackers
Tree view 
-----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-patch: 1/0.199900=5.00250125

Hence the hash _is_ actually faster.

> ---------------btree------------------
> $ pgbench -n -f /tmp/query.sql dict
> ...
> 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
> ...
> tps = 0.199892 (including connections establishing)
> tps = 0.199900 (excluding connections establishing)

Jens
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFImQEZzhchXT4RR5ARAi2nAJ98ujYi+ZOHZybSQaOw11JFpkilIACg5DGu
0Mo+UPGsdd2ZFTGirMplFm4=
=Qj5C
-----END PGP SIGNATURE-----

pgsql-hackers by date:

Previous
From: "Xiao Meng"
Date:
Subject: Re: [patch] gsoc, improving hash index v2
Next
From: "Marko Kreen"
Date:
Subject: Re: plan invalidation vs stored procedures