Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 954AE9FB6FD for ; Wed, 9 May 2007 01:58:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 89739-03 for ; Wed, 9 May 2007 01:58:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by postgresql.org (Postfix) with ESMTP id 35EA99FB6E3 for ; Wed, 9 May 2007 01:58:31 -0300 (ADT) Received: from new-host.home ([71.166.59.121]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JHR00JU1CH9S02K@vms046.mailsrvcs.net> for pgsql-performance@postgresql.org; Tue, 08 May 2007 23:58:22 -0500 (CDT) Date: Wed, 09 May 2007 00:58:00 -0400 From: Robert Treat Subject: Re: In-reply-to: <464113CD.1020308@mochima.com> To: pgsql-performance@postgresql.org Cc: Carlos Moreno Message-id: <200705090058.01284.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <868BCE5A6576F44A862F1FBBC3E14A01042559C3@ms17.mse9.exchange.ms> <4641103B.7000802@commandprompt.com> <464113CD.1020308@mochima.com> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/173 X-Sequence-Number: 24563 On Tuesday 08 May 2007 20:20, Carlos Moreno wrote: > Joshua D. Drake wrote: > >> CPU is unlikely your bottleneck.. You failed to mention anything > >> about your I/O setup. [...] > > > > He also fails to mention if he is doing the inserts one at a time or > > as batch. > > Would this really be important? I mean, would it affect a *comparison*?? > As long as he does it the same way for all the hardware setups, seems ok > to me. > Sure. He looks i/o bound, and single inserts vs. batch inserts will skew results even further depending on which way your doing it. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL