X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C053F3A563D for ; Mon, 24 Jan 2005 19:33:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89893-02 for ; Mon, 24 Jan 2005 19:33:39 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 7EE2E3A5515 for ; Mon, 24 Jan 2005 19:33:30 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 24 Jan 2005 13:33:28 -0600 Subject: Re: benchmarks with pgbench From: Scott Marlowe To: "Kavan, Dan (IMS)" Cc: pgsql-admin@postgresql.org In-Reply-To: <782D2A81EC812642B857B03B506E0B44326389@granite.omni.imsweb.com> References: <782D2A81EC812642B857B03B506E0B44326389@granite.omni.imsweb.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1106595208.16640.112.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 24 Jan 2005 13:33:28 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/260 X-Sequence-Number: 16119 On Mon, 2005-01-24 at 13:19, Kavan, Dan (IMS) wrote: > I hate to admit this publically, but I've been reading my results > backwards. > > I was getting 100 tps on Solaris - postgres 64 bit and 300 tps on SUSE > postgres both x86-64. > So, 300 is better than 100 right? I was reading it backwards. > I was thinking 300 was the actual speed to process a certain amount of > transactions, but actually the x86-64 system is performing better than > all, not worse. > > ~Dj > > > > Yes, they are both running on the same hardware - NAS. Yep, 300 is better than 100. Glad to hear it.