From: Simon Riggs <simon@2ndQuadrant.com>
To: Xiao Meng <mx.cogito@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: [PATCHES] hash index improving v3
Date: Thu, 04 Sep 2008 17:57:04 +0100
Message-ID: <1220547424.4371.991.camel@ebony.2ndQuadrant> (raw)
In-Reply-To: <ded849dd0809040603h5db026e7l6df516c3f1e5dd74@mail.gmail.com>
References: <ded849dd0808171846g2c6c65adub942bd2510a6c94f@mail.gmail.com>
<1220494002.4371.813.camel@ebony.2ndQuadrant>
<ded849dd0809040603h5db026e7l6df516c3f1e5dd74@mail.gmail.com>
On Thu, 2008-09-04 at 21:03 +0800, Xiao Meng wrote:
> 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
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
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: simon@2ndQuadrant.com, mx.cogito@gmail.com, pgsql-hackers@postgresql.org
Subject: Re: [PATCHES] hash index improving v3
In-Reply-To: <1220547424.4371.991.camel@ebony.2ndQuadrant>
* 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