Re: - Mailing list pgsql-performance

From Robert Treat
Subject Re:
Date
Msg-id 200705090058.01284.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re:  (Carlos Moreno <moreno_pg@mochima.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re:
Next
From: "Magnus Hagander"
Date:
Subject: Re: Throttling PostgreSQL's CPU usage