Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 553F71337BDA for ; Wed, 2 Mar 2011 14:30:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 01250-02 for ; Wed, 2 Mar 2011 18:30:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id B98F61337BD5 for ; Wed, 2 Mar 2011 14:30:07 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id CC04734804C; Wed, 2 Mar 2011 10:30:06 -0800 (PST) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 7lpToyEA95Yq; Wed, 2 Mar 2011 10:30:04 -0800 (PST) Received: from [192.168.1.137] (71-94-248-62.dhcp.mdfd.or.charter.com [71.94.248.62]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id C396B34804A; Wed, 2 Mar 2011 10:30:03 -0800 (PST) Subject: Re: Performance Test for PostgreSQL9 From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Robert Haas Cc: Selva manickaraja , pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Organization: Command Prompt, Inc. Date: Wed, 02 Mar 2011 10:29:55 -0800 Message-ID: <1299090595.25659.135.camel@jd-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201103/24 X-Sequence-Number: 42703 On Wed, 2011-03-02 at 13:19 -0500, Robert Haas wrote: > On Sun, Feb 27, 2011 at 10:26 PM, Selva manickaraja wrote: > > We have installed PostgreSQL9 and setup standby(s). Now we have to test the > > performance before we migrate all the data from Informix. The PostgreSQL9 > > that we installed is the Linux version from EnterpriseDB which runs on Red > > Hat. The documentation on PostgreSQL website shows that we have gmake from > > source. So for that purpose we downloaded the source into a UBuntu machine > > to gmake and install it. But UBuntu on the other hand complaints that it > > can't find gmake. So looks like we are stuck here. > > I am a bit confused. Why would you need to install from source > instead of using an installer (either from EnterpriseDB or installing > via apt-get)? To be rude but honest. If you can't solve that problem you really should contract with someone to help you with your performance tests because you are not going to be able to adequately tune PostgreSQL for a proper test. That said, the reason you can't find make is that you don't have the proper development tools installed. +1 to what Robert said. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt