pg.ddx.io  pgsql-patches@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Zdenek Kotala <Zdenek.Kotala@Sun.COM>
To: Alex Hunsaker <badalex@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Xiao Meng <mx.cogito@gmail.com>
Cc: pgsql-patches@postgresql.org, "Jonah H. Harris" <jonah.harris@gmail.com>
Subject: Re: hash index improving v3
Date: Fri, 12 Sep 2008 11:14:58 +0200
Message-ID: <48CA3312.1040508@sun.com> (raw)
In-Reply-To: <34d269d40809102045t2f8037a4jfe862264f6f04454@mail.gmail.com>
References: <10995.1220577198@sss.pgh.pa.us>
	<34d269d40809051321w2ed16037od0373a4a29c311f1@mail.gmail.com>
	<34d269d40809052249h59750f83v4b19a50d0555580@mail.gmail.com>
	<22574.1220728178@sss.pgh.pa.us>
	<34d269d40809061923k4c731481gf580d46d259defb0@mail.gmail.com>
	<20080909134839.GC6714@it.is.rice.edu>
	<34d269d40809091823t204e252fl246443be71aed9ff@mail.gmail.com>
	<34d269d40809092004q10b5da87r6fa3fe86926476ff@mail.gmail.com>
	<48C7DDF9.6020507@sun.com>
	<34d269d40809100927n20864e41p65c068c4ec6f6d74@mail.gmail.com>
	<34d269d40809102045t2f8037a4jfe862264f6f04454@mail.gmail.com>

Alex Hunsaker napsal(a):
> On Wed, Sep 10, 2008 at 10:27 AM, Alex Hunsaker <badalex@gmail.com> wrote:
>> On Wed, Sep 10, 2008 at 8:47 AM, Zdenek Kotala <Zdenek.Kotala@sun.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




view thread (63+ messages)  latest in thread

Message-ID: <48CA3312.1040508@sun.com>
Permalink:  ../48CA3312.1040508@sun.com/
Also on:    postgresql.org/message-id/48CA3312.1040508@sun.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-patches@postgresql.org
  Cc: Zdenek.Kotala@Sun.COM, badalex@gmail.com, tgl@sss.pgh.pa.us, mx.cogito@gmail.com, jonah.harris@gmail.com
  Subject: Re: hash index improving v3
  In-Reply-To: <48CA3312.1040508@sun.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox