Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0560364FCBD for ; Fri, 12 Sep 2008 06:15:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68451-08 for ; Fri, 12 Sep 2008 06:15:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gmp-eb-inf-1.sun.com (gmp-eb-inf-1.sun.com [192.18.6.21]) by postgresql.org (Postfix) with ESMTP id EC35A64FCD2 for ; Fri, 12 Sep 2008 06:15:22 -0300 (ADT) Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe2.eu.sun.com [192.18.6.11]) by gmp-eb-inf-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m8C9FJng006468 for ; Fri, 12 Sep 2008 09:15:19 GMT Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0K7200301S1AGY00@fe-emea-09.sun.com> (original mail from Zdenek.Kotala@Sun.COM) for pgsql-patches@postgresql.org; Fri, 12 Sep 2008 10:15:19 +0100 (BST) Received: from [192.168.1.101] ([89.102.161.149]) by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0K7200CR3SD224C0@fe-emea-09.sun.com>; Fri, 12 Sep 2008 10:15:03 +0100 (BST) Date: Fri, 12 Sep 2008 11:14:58 +0200 From: Zdenek Kotala Subject: Re: hash index improving v3 In-reply-to: <34d269d40809102045t2f8037a4jfe862264f6f04454@mail.gmail.com> To: Alex Hunsaker Cc: Tom Lane , Xiao Meng , pgsql-patches@postgresql.org, "Jonah H. Harris" Message-id: <48CA3312.1040508@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT 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> User-Agent: Thunderbird 2.0.0.16 (X11/20080811) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200809/118 X-Sequence-Number: 7133 Alex Hunsaker napsal(a): > On Wed, Sep 10, 2008 at 10:27 AM, Alex Hunsaker wrote: >> On Wed, Sep 10, 2008 at 8:47 AM, Zdenek Kotala 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