Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group