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

From Kevin Grittner
Subject Re: pg_restore --multi-thread
Date
Msg-id 499E9A9E.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: pg_restore --multi-thread  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pg_restore --multi-thread  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
>>> 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


pgsql-hackers by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: pg_restore --multi-thread
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_restore --multi-thread