Re: Concurrent COPY commands

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Concurrent COPY commands
Date: 2008-07-09 16:45:37
Message-ID: 200807090945.37485@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wednesday 09 July 2008, "Phillip Sitbon" <phillip(at)sitbon(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Phillip Sitbon 2008-07-09 17:07:13 Re: Concurrent COPY commands
Previous Message Phillip Sitbon 2008-07-09 16:35:15 Re: Concurrent COPY commands