Re: hash index improving v3

Zdenek Kotala <[email protected]> Fri, 12 Sep 2008 11:14:58 +0200

Newsgroups	gmane.comp.db.postgresql.devel.patches
Message-ID	<[email protected]>

Alex Hunsaker napsal(a):
> On Wed, Sep 10, 2008 at 10:27 AM, Alex Hunsaker <[email protected]> wrote:
>> On Wed, Sep 10, 2008 at 8:47 AM, Zdenek Kotala <[email protected]> wrote:
>>> 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.
>> Err yes this was UTF8, Ill see about doing a C locale.
>>
> 
> And here it with a C locale:
> 
> pgbench -c1 -n -t100000 -f bench.sql
> cvs head: tps = 5142.784262
> v5:           tps = 6169.405965


If I look on both results

		C	UTF8	difference
-----------------------------------
cvs head:	5140	5050	-2%
v5:		6170	5750	-7%
improvement:	20%	14%

than I little bit wonder. I personally expected bigger difference of UTF8 
comparing between CVS a v5. This test also shows that locale selection has 
bigger impact on performance in v5 case, but result is still better than cvs head.

		Zdenek



-- 
Zdenek Kotala              Sun Microsystems
Prague, Czech Republic     http://sun.com/postgresql


-- 
Sent via pgsql-patches mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches