Re: pg_restore --multi-thread

>>> Andrew Dunstan <andrew@dunslane.net> wrote: 
> Joshua D. Drake wrote:
>> the fastest restore time for
>> 220G was performed with 24 threads with an 8 core box.
 
>> It is important to point out that this was a machine with 50
spindles.
>> Which is where your bottleneck is going to be immediately after
solving
>> the CPU bound nature of the problem.
 
> 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.)
 
-Kevin