On Thu, 2008-09-04 at 21:03 +0800, Xiao Meng wrote: > On Thu, Sep 4, 2008 at 10:06 AM, Simon Riggs <[EMAIL PROTECTED]> > 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers