Re: Concurrent COPY commands - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: Concurrent COPY commands
Date
Msg-id 200807090945.37485@hal.medialogik.com
Whole thread Raw
In response to Re: Concurrent COPY commands  ("Phillip Sitbon" <phillip@sitbon.net>)
Responses Re: Concurrent COPY commands  ("Phillip Sitbon" <phillip@sitbon.net>)
List pgsql-novice
On Wednesday 09 July 2008, "Phillip Sitbon" <phillip@sitbon.net> wrote:
> I only have two fast SATA drives on software RAID, but that really isn't
> the issue- while the copy commands are going, disk activity is relatively
> low.

Define low. 2 disks maxed out doing random I/O could show as little as 2 or
3 MB/sec in vmstat.

You say one CPU core is maxed out - what state is it mostly in at 100% -
user, system, or wait?


--
Alan

pgsql-novice by date:

Previous
From: "Phillip Sitbon"
Date:
Subject: Re: Concurrent COPY commands
Next
From: "Phillip Sitbon"
Date:
Subject: Re: Concurrent COPY commands