Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9D27564FD33 for ; Thu, 4 Sep 2008 13:57:02 -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 15056-08 for ; Thu, 4 Sep 2008 13:56:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136016.authsmtp.co.uk (outmail136016.authsmtp.co.uk [62.13.136.16]) by postgresql.org (Postfix) with ESMTP id 7B67F64FCEF for ; Thu, 4 Sep 2008 13:56:57 -0300 (ADT) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m84Gurqr027408; Thu, 4 Sep 2008 17:56:53 +0100 (BST) Received: from [192.168.0.2] (85-211-229-97.dyn.gotadsl.co.uk [85.211.229.97]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m84Guqqs031403; Thu, 4 Sep 2008 17:56:52 +0100 (BST) Subject: Re: [PATCHES] hash index improving v3 From: Simon Riggs To: Xiao Meng Cc: pgsql-hackers@postgresql.org In-Reply-To: References: <1220494002.4371.813.camel@ebony.2ndQuadrant> Content-Type: text/plain Date: Thu, 04 Sep 2008 17:57:04 +0100 Message-Id: <1220547424.4371.991.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 7922c6a1-7aa2-11dd-8155-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAFbflxB HGQLW1xEUVp7XGV/ bggfZQBDYEtPQQdo WVZARU1QEQdtHhxP WxYaJVwzNkZGe390 ZUUsX3NSWwp9fER/ EUgFFHABNDZidWEe BBRFfwJRdR5Kfh5E YlUrV3QKMjRJBC9q VzwLFgwaHRhkHWxV SxoNZVMUTUsbVj85 XwoFAzQpEgUbHE0g X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1186/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/265 X-Sequence-Number: 123394 On Thu, 2008-09-04 at 21:03 +0800, Xiao Meng wrote: > On Thu, Sep 4, 2008 at 10:06 AM, Simon Riggs > 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 That generates the data, fine. What about the test query? You say you are running this command line pgbench -U postgres -n -f /tmp/query.sql dict Where is query.sql? It doesn't seem a big ask to be shown the SQL statement that is being executed, so we understand what is going on. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support