Skip site navigation (1) Skip section navigation (2)

Re: hash index improving v3

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Alex Hunsaker <badalex(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Xiao Meng <mx(dot)cogito(at)gmail(dot)com>, pgsql-patches(at)postgresql(dot)org, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Subject: Re: hash index improving v3
Date: 2008-09-10 14:47:21
Message-ID: 48C7DDF9.6020507@sun.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Alex Hunsaker napsal(a):

> 
> wide:
> # NOTE not on the same machine as the "narrow" test was run!
> 
> # spit out 2, 000, 000 random 100 length strings
> perl gen.pl > data.sql
> create table test_hash (wide text);
> copy test_hash from './data.sql';
> create index test_hash_num_idx on test_hash using hash (wide);
> 
> bench.sql:
> select a.wide from test_hash as a inner join test_hash as b on b.wide
> = a.wide where a.wide =
> 'BJNORSLMITGKHJCWDBLKLYRSJTVPTYXZJPWNBKXGHYFNDHRAKNFMDHRMUXLDXNTRBJMTHPGPBFJZPAENZXDHAHCUSCJTUPUXWCXUH';
> 
> # ^ that string is in data.sql
> 
> # 3 runs each
> pgbench -c1 -n -t100000 -f bench.sql
> cvs head: tps = 5073.463498, 5110.620923, 4955.347610
> v5:           tps = 5870.681336, 5740.007837, 5699.002942

What locale did you use? It would be nice to have also comparing between 
C and any UTF8 locale. I think we should see big benefit when non C 
locale is used.

		Thanks Zdenek

In response to

Responses

pgsql-hackers by date

Next:From: Zdenek KotalaDate: 2008-09-10 15:14:13
Subject: Re: New FSM patch
Previous:From: Mark MielkeDate: 2008-09-10 14:44:00
Subject: Re: Base64 decode/encode performance

pgsql-patches by date

Next:From: Ryan BradetichDate: 2008-09-10 15:03:55
Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2]
Previous:From: Kenneth MarshallDate: 2008-09-10 13:04:01
Subject: Re: hash index improving v3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group