Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id BF07064FCD8
	for <pgsql-hackers-postgresql.org@postgresql.org>;
	Thu,  4 Sep 2008 10:03:54 -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 56811-07 for
	<pgsql-hackers-postgresql.org@postgresql.org>;
	Thu,  4 Sep 2008 10:03:49 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ti-out-0910.google.com (ti-out-0910.google.com
 [209.85.142.189])
	by postgresql.org (Postfix) with ESMTP id E680464FCEF
	for <pgsql-hackers@postgresql.org>;
	Thu,  4 Sep 2008 10:03:48 -0300 (ADT)
Received: by ti-out-0910.google.com with SMTP id y8so2092138tia.5
	for <pgsql-hackers@postgresql.org>;
	Thu, 04 Sep 2008 06:03:45 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:in-reply-to:mime-version:content-type:references;
	bh=/pIdNu6a7DmtsFTFOfkKRYrvwEDsn10qmp7epHlNvJM=;
	b=MjJxy80SY75AyCBaHNyEd/UJYq9eXCWtb5xe5r86yl/SspNaDfFvBCp+R1TrS9o56k
	h3E+cEkd0o2V49FA//vVeDiNKDwHkTtQG8QGjJk6xZrivQ5MHrYdcFmrRFSe04aEM5Jx
	FMGyHC9UFb5eeiQ9WtBnll2p1N+7YseS6MVbc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:references;
	b=qUkJwDrIvZYoTMq15y+jhjYDgD5XrNpcdJuXIUGnIl9AXC5gDo3L2p/GA7n80XBub4
	WQ6KLwasIefOF0Tc1RgTq/qCKsHhYEFVKql1bClYqDiHBDMwaj3hHJNhvfN+DoNIT6Ku
	y5C9E5TdWp/zxQd/7AxjLY1SX/Fic0ti1Rik8=
Received: by 10.110.31.5 with SMTP id e5mr13031557tie.1.1220533425343;
	Thu, 04 Sep 2008 06:03:45 -0700 (PDT)
Received: by 10.110.8.14 with HTTP; Thu, 4 Sep 2008 06:03:45 -0700 (PDT)
Message-ID: <ded849dd0809040603h5db026e7l6df516c3f1e5dd74@mail.gmail.com>
Date: Thu, 4 Sep 2008 21:03:45 +0800
From: "Xiao Meng" <mx.cogito@gmail.com>
To: "Simon Riggs" <simon@2ndquadrant.com>, pgsql-hackers@postgresql.org
Subject: Re: [PATCHES] hash index improving v3
In-Reply-To: <1220494002.4371.813.camel@ebony.2ndQuadrant>
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_89024_24092264.1220533425341"
References: <ded849dd0808171846g2c6c65adub942bd2510a6c94f@mail.gmail.com>
	<1220494002.4371.813.camel@ebony.2ndQuadrant>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200809/247
X-Sequence-Number: 123376

------=_Part_89024_24092264.1220533425341
Content-Type: multipart/alternative;
	boundary="----=_Part_89025_24270467.1220533425341"

------=_Part_89025_24270467.1220533425341
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Thu, Sep 4, 2008 at 10:06 AM, Simon Riggs <simon@2ndquadrant.com> wrote:

> You don't give the text of the query used to do these performance tests,
> so I can't validate your test results.
>

The attachment is the code to generate the text.
Just
$g++ my-permu-code.cpp
$./a.out > /tmp/words

-- 
Best Regards,
Xiao Meng

DKERC, Harbin Institute of Technology, China
Gtalk: mx.cogito@gmail.com
MSN: cnEnder@live.com
http://xiaomeng.yo2.cn

------=_Part_89025_24270467.1220533425341
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">On Thu, Sep 4, 2008 at 10:06 AM, Simon Riggs <span dir="ltr">&lt;<a href="mailto:simon@2ndquadrant.com">simon@2ndquadrant.com</a>&gt;</span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">You don&#39;t give the text of the query used to do these performance tests,<br></div>
so I can&#39;t validate your test results.<br></blockquote></div><br>The attachment is the code to generate the text. <br>Just <br>$g++ my-permu-code.cpp<br>$./a.out &gt; /tmp/words<br clear="all"><br>-- <br>Best Regards,<br>
Xiao Meng<br><br>DKERC, Harbin Institute of Technology, China<br>Gtalk: <a href="mailto:mx.cogito@gmail.com">mx.cogito@gmail.com</a><br>MSN: <a href="mailto:cnEnder@live.com">cnEnder@live.com</a><br><a href="http://xiaomeng.yo2.cn">http://xiaomeng.yo2.cn</a><br>

</div>

------=_Part_89025_24270467.1220533425341--

------=_Part_89024_24092264.1220533425341
Content-Type: text/x-c++src; name=my-permu-code.cpp
Content-Transfer-Encoding: base64
X-Attachment-Id: f_fkpe1dwl0
Content-Disposition: attachment; filename=my-permu-code.cpp

Ly8tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLSAgLy8KLy8KLy8gRklMRSBOQU1FICAgICAgIDogIFg5MzdvdXQu
Y3BwCi8vCi8vIERFU0NSSVBUSVZFIE5BTUU6ICBQcm92aWRlcyBYOTM3IE91dHB1dCBQbHVnLWlu
IEFQSXMKLy8KLy8gQVVUSE9SICAgICAgICAgIDogIFNyaW5pdmFzYW4gTVMKLy8KLy8gTU9EVUxF
IFRZUEUgICAgIDogIEMrKyBTb3VyY2UgRmlsZQovLwovLy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tICAvLwoK
CiNpbmNsdWRlPGlvc3RyZWFtPgp1c2luZyBuYW1lc3BhY2Ugc3RkOwoKbG9uZyBsb25nIHRvdENv
dW50IDsKCi8vIHRoaXMgZnVuY3Rpb24gZmluZHMgdGhlIG90aGVyCi8vIHBlcm11dGF0aW9ucyBi
eSByb3RhdGluZyB0aGUgc3RyaW5nCi8vIGluIGNpcmN1bGFyIG1hbm5lcgoKdm9pZCBjaXJjdWxh
clByaW50KGNoYXIgKnN0cikgewoKICAgIGludCAgbGVuID0gc3RybGVuKHN0cik7CiAgICBjaGFy
ICpteXN0ciA9IG5ldyBjaGFyIFtsZW4gKzFdOwogICAgaW50IGksajsKCiAgICBmb3IoaT0wOyBp
IDxsZW47IGkrKyApIHsKICAgICAgICBmb3Ioaj0wO2o8bGVuOyBqKysgKQogICAgICAgICAgICBt
eXN0cltqXSA9IHN0clsoaStqKSVsZW5dOwogICAgICAgIG15c3RyW2pdID0wOwoJdG90Q291bnQr
KzsKICAgICAgICAvLyBjb21tZW50IHRoZSBsaW5lIGJlbG93IHRvIHN1cHJlc3MgdGhlIHN0cmlu
ZyBvdXRwdXQKICAgICAgICBjb3V0IDw8IG15c3RyICA8PCBlbmRsOwoKICAgIH0KCiAgICBkZWxl
dGUgW11teXN0cjsKICAgIHJldHVybiA7Cn0KCgp2b2lkIHBlcm11dGF0aW9uKGNoYXIgcHJlZml4
W10sY2hhciBzdWZmaXhbXSkKewogIGludCBsZW5ndGg9c3RybGVuKHN1ZmZpeCk7CiAgaW50IGxl
biA9IHN0cmxlbihwcmVmaXgpIDsKICBpbnQgaT0wLCBqPTA7CiAgY2hhciAqbXlwcmVmaXggPSBu
ZXcgY2hhciBbbGVuXTsKCiAgaWYobGVuICkgewogICAgc3RybmNweShteXByZWZpeCwgcHJlZml4
LCBsZW4gLSAxICk7CiAgICBteXByZWZpeFtsZW4tMV09IDA7CgogICAgZm9yKGk9MDsgaTwgbGVu
Z3RoIDsgaSsrKSB7CgogIAljaGFyICpteXN1ZmZpeCA9IG5ldyBjaGFyIFtsZW5ndGgrMl07CiAg
ICAgICAgbXlzdWZmaXhbMF0gPSBwcmVmaXhbbGVuLTFdOwoKICAgICAgICAvLyByb3RhdGUgdGhl
IGN1cnJlbnQgYXBwZW5kIGFuZCBwcmVwYXJlIGFwcGVuZCBmb3IgbmV4dAogICAgICAgIGZvcihq
PTA7IGo8IGxlbmd0aCA7IGorKyApIHsKICAgICAgICAgICAgbXlzdWZmaXhbaisxXSA9IHN1ZmZp
eFsoaStqKSVsZW5ndGhdOwogICAgICAgIH0KCiAgICAgICAgbXlzdWZmaXggW2orMV09IDA7CiAg
ICAgICAgcGVybXV0YXRpb24obXlwcmVmaXgsIG15c3VmZml4KTsKICAgICAgICBkZWxldGUgW11t
eXN1ZmZpeDsKICAgIH0KICB9CiAgZWxzZSB7CiAgICAvLyBmb3VuZCBwZXJtdXRhdGlvbiwgbm93
IGZpbmQgb3RoZXIKICAgIC8vIHBlcm11dGF0aW9ucyBieSByb3RhdGluZyB0aGUgc3RyaW5nCiAg
ICBjaXJjdWxhclByaW50KHN1ZmZpeCk7CiAgfQogIGRlbGV0ZSBbXW15cHJlZml4Owp9CgoKaW50
IG1haW4oKQp7CgogIGNoYXIgcHJlZml4W109IjEyMzQ1Njc4OWEiOyAvLyBmaXJzdCBOLTEgY2hh
cmFjdGVycyBvZiB0aGUgc3RyaW5nIG9mIGxlbmd0aCBOCiAgY2hhciBzdWZmaXhbXT0iMCI7ICAg
ICAvLyBsYXN0IGNoYXJhY3RlciBvZiB0aGUgc3RyaW5nCiAgdGltZV90IHQxLCB0MjsKCgogIC8v
IGZpbmQgcGVybXV0YXRpb24KICBwZXJtdXRhdGlvbihwcmVmaXgsIHN1ZmZpeCk7CgogIHJldHVy
biAwOwp9Cgo=
------=_Part_89024_24092264.1220533425341--