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