Re: Suggestions for benchmarking 7.4RC2 against 7.3 - Mailing list pgsql-performance

From Rajesh Kumar Mallah
Subject Re: Suggestions for benchmarking 7.4RC2 against 7.3
Date
Msg-id 3FB2A540.2000808@trade-india.com
Whole thread Raw
In response to Re: Suggestions for benchmarking 7.4RC2 against 7.3  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-performance
<br /><br /> RC2 is running in production without any apparent problems<br /> till now.  Well its difficult to say at
themoment how much speed<br /> gain is there unless the heavy duty batch SQL scripts are run by<br /> cron. <br /><br
/>Count(*) and group by on large tables are significantly (5x) faster<br /> and better error reporting has made it
easierto spot the faulty data.<br /> eg in fkey violation.<br /><br /> Will post the OSDB .15 versions' results on 7.3
&7.4 soon.<br /><br /> Regds<br /> Mallah.<br /><br /> Christopher Browne wrote:<br /><blockquote
cite="midm34qxau6bb.fsf@wolfe.cbbrowne.com"type="cite"><pre wrap="">After a long battle with technology,<a
class="moz-txt-link-abbreviated"href="mailto:mallah@trade-india.com">mallah@trade-india.com</a> (Rajesh Kumar Mallah),
anearthling, wrote: </pre><blockquote type="cite"><pre wrap="">the error mentioned in first email has been overcome
 
by running osdb on the same machine hosting the DB server.   </pre></blockquote><pre wrap="">
Yes, it seems unrealistic to try to run the "client" on a separate
host from the database.  

I got the osdb benchmark running last week, and had to separate client
from server.  I had to jump through a fair number of hoops including
copying data files over to the server.  The benchmark software needs a
bit more work... </pre></blockquote><br />

pgsql-performance by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: Suggestions for benchmarking 7.4RC2 against 7.3
Next
From: "scott.marlowe"
Date:
Subject: Re: *very* slow query to summarize data for a month ...