-----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----- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
