From: | Jens-Wolfhard Schicke <drahflow(at)gmx(dot)de> |
---|---|
To: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [patch] gsoc, improving hash index v2 |
Date: | 2008-08-06 01:40:47 |
Message-ID: | 4899011F.1040403@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Kreen | 2008-08-06 06:20:15 | Re: plan invalidation vs stored procedures |
Previous Message | Xiao Meng | 2008-08-06 01:39:49 | Re: [patch] gsoc, improving hash index v2 |