X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BA74BD1B531 for ; Tue, 11 Nov 2003 21:25:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 32185-02 for ; Tue, 11 Nov 2003 17:25:09 -0400 (AST) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id 0AFB0D1B4FE for ; Tue, 11 Nov 2003 17:25:07 -0400 (AST) Received: (qmail 4307 invoked from network); 11 Nov 2003 21:26:18 -0000 Received: from unknown (HELO trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 11 Nov 2003 21:26:18 -0000 Message-ID: <3FB2A540.2000808@trade-india.com> Date: Thu, 13 Nov 2003 02:55:20 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030630 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christopher Browne Cc: pgsql-performance@postgresql.org Subject: Re: Suggestions for benchmarking 7.4RC2 against 7.3 References: <3FB247FE.4080808@trade-india.com> <3FB24C15.1020907@trade-india.com> In-Reply-To: Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/48 X-Sequence-Number: 4608

RC2 is running in production without any apparent problems
till now.  Well its difficult to say at the moment how much speed
gain is there unless the heavy duty batch SQL scripts are run by
cron.

Count(*) and group by on large tables are significantly (5x) faster
and better error reporting has made it easier to spot the faulty data.
eg in fkey violation.

Will post the OSDB .15 versions' results on 7.3 & 7.4 soon.

Regds
Mallah.

Christopher Browne wrote:
After a long battle with technology,mallah@trade-india.com (Rajesh Kumar Mallah), an earthling, wrote:
  
the error mentioned in first email has been overcome
by running osdb on the same machine hosting the DB server.
    

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...