Re: pg_restore --multi-thread - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: pg_restore --multi-thread
Date
Msg-id 1235153374.31546.93.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: pg_restore --multi-thread  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Fri, 2009-02-20 at 11:57 -0600, Kevin Grittner wrote:
>  
> > But you are right that there isn't a simple formula.
>  
> Perhaps the greater of the number of CPUs or effective spindles?
>  
> (24 sounds suspiciously close to effective spindles on a 50 spindle
> box
> with RAID 10.)

It does except that you aren't accounting for 7200RPM vs 10k vs 15k vs
iSCSI vs FibreChannel etc...

You would have to literally do the math to figure it all out. Those 50
spindles were DAS. You go iSCSI and all of a sudden you have turned
those 50 spindles into and effective 8 DAS spindles. Not to mention if
you only have a single path for your FibreChannel etc...

Joshua D. Drake


>  
> -Kevin
> 
-- 
PostgreSQL - XMPP: jdrake@jabber.postgresql.org  Consulting, Development, Support, Training  503-667-4564 -
http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997
 



pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: pg_restore --multi-thread
Next
From: Merlin Moncure
Date:
Subject: return query/composite types