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-12 09:14:58 |
Message-ID: | 48CA3312.1040508@sun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Alex Hunsaker napsal(a):
> On Wed, Sep 10, 2008 at 10:27 AM, Alex Hunsaker <badalex(at)gmail(dot)com> wrote:
>> On Wed, Sep 10, 2008 at 8:47 AM, Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2008-09-12 09:20:25 | Re: Transaction Snapshots and Hot Standby |
Previous Message | Peter Eisentraut | 2008-09-12 09:02:32 | Re: pg_regress inputdir |
From | Date | Subject | |
---|---|---|---|
Next Message | Kenneth Marshall | 2008-09-12 14:29:21 | Re: hash index improving v3 |
Previous Message | Alex Hunsaker | 2008-09-12 02:51:53 | Re: hash index improving v3 |