pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Suggestions for benchmarking 7.4RC2 against 7.3
Date: Thu, 13 Nov 2003 02:55:20 +0530
Message-ID: <3FB2A540.2000808@trade-india.com> (raw)
In-Reply-To: <m34qxau6bb.fsf@wolfe.cbbrowne.com>
References: <3FB247FE.4080808@trade-india.com>
	<3FB24C15.1020907@trade-india.com>
	<m34qxau6bb.fsf@wolfe.cbbrowne.com>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<br>
<br>
RC2 is running in production without any apparent problems<br>
till now.&nbsp; Well its difficult to say at the moment 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 easier to spot the faulty data.<br>
eg in fkey violation.<br>
<br>
Will post the OSDB .15 versions' results on 7.3 &amp; 7.4 soon.<br>
<br>
Regds<br>
Mallah.<br>
<br>
Christopher Browne wrote:<br>
<blockquote type="cite" cite="midm34qxau6bb.fsf@wolfe.cbbrowne.com">
  <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), an earthling, 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>
</body>
</html>




view thread (6+ messages)

Message-ID: <3FB2A540.2000808@trade-india.com>
Permalink:  ../3FB2A540.2000808@trade-india.com/
Also on:    postgresql.org/message-id/3FB2A540.2000808@trade-india.com

 · 

reply

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-performance@postgresql.org
  Cc: mallah@trade-india.com, cbbrowne@acm.org
  Subject: Re: Suggestions for benchmarking 7.4RC2 against 7.3
  In-Reply-To: <3FB2A540.2000808@trade-india.com>

* 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