| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | Carlos Moreno <moreno_pg(at)mochima(dot)com> |
| Subject: | Re: |
| Date: | 2007-05-09 04:58:00 |
| Message-ID: | 200705090058.01284.xzilla@users.sourceforge.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2007-05-09 05:56:40 | Re: Throttling PostgreSQL's CPU usage |
| Previous Message | Greg Smith | 2007-05-09 04:14:42 | Re: |