Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Re: Concurrent ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 5 Topic 3157 of 3255
Post > Topic >>

Re: Concurrent COPY commands

by ahodgson@[EMAIL PROTECTED] (Alan Hodgson) Jul 9, 2008 at 09:45 AM

On Wednesday 09 July 2008, "Phillip Sitbon" <phillip@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 5 Posts in Topic:
Concurrent COPY commands
phillip@[EMAIL PROTECTED]  2008-07-02 09:44:21 
Re: Concurrent COPY commands
ahodgson@[EMAIL PROTECTED  2008-07-02 10:02:48 
Re: Concurrent COPY commands
phillip@[EMAIL PROTECTED]  2008-07-09 09:35:15 
Re: Concurrent COPY commands
ahodgson@[EMAIL PROTECTED  2008-07-09 09:45:37 
Re: Concurrent COPY commands
phillip@[EMAIL PROTECTED]  2008-07-09 10:07:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 14:40:21 CDT 2008.