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 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: [EMAIL PROTECTED] > MSN: [EMAIL PROTECTED] > http://xiaomeng.yo2.cn > -- Best Regards, Xiao Meng DKERC, Harbin Institute of Technology, China Gtalk: [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] http://xiaomeng.yo2.cn
